Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] defncopy query "order by" different for ASE
  • Date: Thu, 18 Aug 2016 06:40:19 +0100

A query like select 1 from syscomments where colid2 = 0 and 0=1 could help.

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
>




Archive powered by MHonArc 2.6.24.

Top of Page