FreeTDS Development Group

[John Kendall <john AT capps.com>]

> 
>> The defncopy app has one bit of SQL in it that uses an ANSI join. This 
>> makes it fail on pre-ASE 12.0.  To get it to work with my old servers i 
>> need to patch it each time I download the latest FreeTDS.  
>> 
>> Since the SQL89 inner joins are still considered fine, I was wondering if 
>> this patch could be applied.  Then it will work for all servers 
>> out-of-the-box.
>> 
>> 
> 
> Why did you remove the 'as' keyword?
> 
> christos


The 'as' keyword doesn't work with my older servers; and leaving out the 'as' 
keyword works with current servers.

John



> 
>> *** defncopy.c-orig     Mon Feb 29 12:00:00 2016
>> --- defncopy.c  Wed Apr 13 16:14:57 2016
>> ***************
>> *** 211,220 ****
>>                  static const char query[] = " select    cast(c.text as 
>> text)"
>>  #endif /* MicrosoftsDbLib */
>>                                           ", number "
>> !                                          " from syscomments  as c"
>> !                                          " join         sysobjects as o"
>> !                                          " on           o.id = c.id"
>> !                                          " where        o.name = '%s'"
>>                                           " and  o.uid = user_id('%s')"
>>                                           " and          o.type not in 
>> ('U', 'S')" /* no user or system tables */
>>                                           " order by     c.number, c.colid"
>> --- 211,220 ----
>>                  static const char query[] = " select    cast(c.text as 
>> text)"
>>  #endif /* MicrosoftsDbLib */
>>                                           ", number "
>> !                                          " from syscomments c,"
>> !                                          "      sysobjects o"
>> !                                          " where        o.id = c.id"
>> !                                          " and  o.name = '%s'"
>>                                           " and  o.uid = user_id('%s')"
>>                                           " and          o.type not in 
>> ('U', 'S')" /* no user or system tables */
>>                                           " order by     c.number, c.colid"
>> 
>> 
>> 
>> 
>> 
>> Thanks for considering this.
>> 
>> John