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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.