Re: [GRAYMAIL] defncopy query "order by" different for ASE
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Aug 17, 2016, at 10:40 PM, Frediano Ziglio <[email protected]> wrote: > A query like select 1 from syscomments where colid2 = 0 and 0=1 could help. MS SQL server does not have a colid2 column in syscomments, so this produces an error. I'm not sure how to make it work. > > On 18 Aug 2016 01:55, "John Kendall" <[email protected]> wrote: > >> Hi, all. >> Line 224 of defncopy.c is: >> >> >> " order by c.number, c.colid" >> >> This is the correct for MS SQL, but not for ASE. For ASE it should be: >> >> >> " order by c.number, c.colid2, c.colid" >> >> >> Since most objects stored in syscomments are small, leaving out colid2 is >> not a problem. But very large objects will display incorrectly. As you >> might expect, I recently ran into this problem. :) >> >> It should be a quick patch, but I'm not sure the best way to determine if >> the server is ASE and MS SQL. >> >> Thanks, >> John >> >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds