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: matthew.green AT datamartcomputing.com
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] defncopy for old servers
  • Date: Fri, 15 Apr 2016 06:32:28 +0000

I can't see why we shouldn't make this change. This syntax works with ASE 16
and SQL Server 20114 and I'm not aware of any plans to remove support for it
in the future..... if nothing else there are too many programs out there
which use this syntax.

Cheers,

Matthew.

April 15 2016 1:24 AM, "John Kendall" <john AT capps.com> wrote:
>>> 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
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page