defncopy query "order by" different for ASE
John Kendall <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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