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.


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