Skip to Content.
Sympa Menu

freetds - [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: [freetds] defncopy for old servers
  • Date: Thu, 14 Apr 2016 00:01:38 +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.


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