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

Frediano Ziglio freddy77 at gmail.com
Thu Aug 18 01:40:19 EDT 2016


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
>


More information about the FreeTDS mailing list