Skip to Content.
Sympa Menu

freetds - Re: [freetds] defncopy for old servers

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Kendall <john AT capps.com>
  • To: FreeTDS Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] defncopy for old servers
  • Date: Thu, 14 Apr 2016 23:23:57 +0000

>
>> 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




Archive powered by MHonArc 2.6.24.

Top of Page