[freetds] [GRAYMAIL] defncopy query "order by" different for ASE

John Kendall john at capps.com
Thu Aug 18 12:38:57 EDT 2016


On Aug 17, 2016, at 10:40 PM, Frediano Ziglio <freddy77 at gmail.com> 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" <john at capps.com> 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
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list