Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Kendall <john AT capps.com>
  • To: FreeTDS Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] [GRAYMAIL] defncopy query "order by" different for ASE
  • Date: Thu, 18 Aug 2016 16:38:57 +0000


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





Archive powered by MHonArc 2.6.24.

Top of Page