Skip to Content.
Sympa Menu

freetds - Re: killer query

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: killer query
  • Date: Fri, 21 Jun 2002 15:39:40 -0400 (EDT)



Awesome job jim...I thought bits were solved too. Are these nullable or
non-nullable bits? (nullable bits are a TDS 7 invention).

I'm assuming this was run under TDS 7? we should test 4.2 as well.

Brian

On Fri, 21 Jun 2002, Lowden, James K wrote:

> All,
>
> The attached query tests FreeTDS's ability to talk to MS SQL Server 7. I've
> tested it with MS's isql (which handles all cases) and sqsh, which handles
> all but three.
>
> Of course, more exhaustive would be an NxN query, converting all types to
> all (available) others.
>
> In sqsh:
>
> * selecting a "bit" type in sqsh causes FreeTDS to hang after unknown
> markers.
>
> * selecting a "uniqueidentifier" type yields:
>
> Attempting to convert unknown source type 36
> Attempting to convert unknown source type -1
>
> ... and nothing.
>
> * selecting a "varbinary" type, at least on my Alpha box, yields OK
> data after this OS message:
>
> Unaligned access pid=27604 <sqsh> va=0x14002cd8e \
> pc=0x120044160 ra=0x120038ca0 inst=0xa2430000
>
> which may or may not be an artifact of my environment. YMMV.
>
> I thought bits were solved. I think we've seen uniqueidentifier problems on
> the list before. And I can't imagine how varbinary differs from image, but
> it clearly does.
>
> Your friendly QA department,
>
> --jkl
>
> <<all_types>>
>
>





Archive powered by MHonArc 2.6.24.

Top of Page