[freetds] select bug...

Spyros Ioakim sioakim at atlas.ace-hellas.gr
Sun May 11 17:04:28 EDT 2003


I'm also posting the following two differences:
On 0.61 the query doesn't seem to work while it works for 0.62dev but
replies with one result instead of two.
I'm posting screen output and logs:

0.61:

./tsql -S aceoffice -U sa
locale is "C"
charset is "ANSI_X3.4-1968"
Password: 
Msg 5703, Level 0, State 1, Server ACEOFFICE, Line 0
Changed language setting to us_english.
1> use office
2> SELECT Company.CompId FROM COMPANY, INSTALLS WHERE Company.CompId =
186 and (NoDownloads is null OR NoDownloads=0) AND Installs.CompID =
Company.CompID AND Installs.ProdId IN (SELECT ProdId FROM Products WHERE
Products.Code LIKE 'N%3%') AND ( (Installs.InstDate >= '11/06/02') OR
(Installs.CompId IN (SELECT Installs.CompId FROM Installs, Products
WHERE Installs.ProdId = Products.ProdId AND ( (Products.Code LIKE
'N%3%') ) AND Installs.InstlId IN (SELECT InstlId FROM Cntrcts WHERE
CntrctType LIKE 'pS%' AND ToDate >= '05/06/03') ) ) )
3> go
Msg 105, Level 15, State 1, Server ACEOFFICE, Line 2
Unclosed quotation mark before the character string 'Products.ProdId AND
( (Products.Code '.
Msg 170, Level 15, State 1, Server ACEOFFICE, Line 2
Line 2: Incorrect syntax near 'Products.ProdId AND ( (Products.Code '.
1>


0.62dev:

./tsql -S aceoffice -U sa            
locale is "en_US"
charset is "ISO-8859-1"
Password: 
Msg 5703, Level 0, State 1, Server ACEOFFICE, Line 0
Changed language setting to us_english.
1> use office
2> SELECT Company.CompId FROM COMPANY, INSTALLS WHERE Company.CompId =
186 and (NoDownloads is null OR NoDownloads=0) AND Installs.CompID =
Company.CompID AND Installs.ProdId IN (SELECT ProdId FROM Products WHERE
Products.Code LIKE 'N%3%') AND ( (Installs.InstDate >= '11/06/02') OR
(Installs.CompId IN (SELECT Installs.CompId FROM Installs, Products
WHERE Installs.ProdId = Products.ProdId AND ( (Products.Code LIKE
'N%3%') ) AND Installs.InstlId IN (SELECT InstlId FROM Cntrcts WHERE
CntrctType LIKE 'pS%' AND ToDate >= '05/06/03') ) ) )
3> go
CompId
186
1> 

Maybe the locale has to do something with it? Can I change it within
tsql to Greek and try again?

Thanks,
Spyros


-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Spyros Ioakim
Sent: Sunday, May 11, 2003 11:45 PM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] select bug...


OK found the old post...
I have compiled freetds with these options:
./configure --with-tdsver=7.0 --enable-msdblib --with-unixodbc
--prefix=/usr/local/freetds/

I recompiled freetds with the nightly build I just downloaded but still
no luck.

Anything else I could try to solve this problem?
Is there something I'm describing wrong and you can't understand maybe?

Thanks,
Spyros

-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Spyros Ioakim
Sent: Wednesday, May 07, 2003 6:16 PM
To: FreeTDS Development Group
Subject: Re: [freetds] select bug...


The client I got these off are from tsql.
The platform is RH Linux 9.
In a previous post I had posted my compile options of freetds. Sorry but
I can't provide you right now with that information cause I'm in Denmark
till Sunday and have limited access to my emails (I can see only new
ones)
So if you could please check my older post.

Thanks,
Spyros

----- Original Message -----
From: "Frediano Ziglio" <freddyz77 at tin.it>
To: "FreeTDS Development Group" <freetds at lists.ibiblio.org>
Sent: Tuesday, May 06, 2003 9:24 PM
Subject: RE: [freetds] select bug...


> Il mar, 2003-05-06 alle 15:06, Spyros Ioakim ha scritto:
> > Yes Enterprise manager does reply correctly...
> > 2 results for compid 186 and 1 result for 258 with the new date
> > format.
> >
> > Unfortunately freetds has the same behaviour (1 and 0 results)
> >
> > I have attached the new log file.
> >
> > Thanks,
> > Spyros
> >
>
> This is very strange...
> >From dump
> 2003-05-06 16:03:35.380833 inside tds_process_result_tokens() state is

> COMPLETED 2003-05-06 16:03:48.320304 tds_put_string converting 552
> bytes of "use office
> SELECT Company.CompId FROM COMPANY, INSTALLS WHERE Company.CompId =
186
> and (NoDownloads is null OR NoDownloads=0) AND Installs.CompID = 
> Company.CompID AND Installs.ProdId IN (SELECT ProdId FROM Products
WHERE
> Products.Code LIKE 'N%3%') AND ( (Installs.InstDate >= '2002-11-06')
OR
> (Installs.CompId IN (SELECT Installs.CompId FROM Installs, Products 
> WHERE Installs.ProdId = Products.ProdId AND ( (Products.Code LIKE
> 'N%3%') ) AND Installs.InstlId IN (SELECT InstlId FROM Cntrcts WHERE 
> CntrctType LIKE 'ðÓ%' AND ToDate >= '2003-05-06') ) ) ) "
>                  ^^  where came this buffer corruption ??
>
> It seem near byte 512...
>
> Below
>
> 2003-05-06 16:03:48.321326 tds_put_string wrote 80 bytes Sending
> packet @ 2003-05-06 16:03:48.321342 0000 01 01 00 68 00 00 01 00-70 00

> 65 00 20 00 4c 00 |...h.... p.e. .L.| 0010 49 00 4b 00 45 00 20 00-27
> 00 f0 00 d3 00 25 00 |I.K.E. . '.ð.Ó.%.|
>                                    ^^^   ^^^ same ...
> 0020 27 00 20 00 41 00 4e 00-44 00 20 00 54 00 6f 00 |'. .A.N. D. 
> .T.o.| 0030 44 00 61 00 74 00 65 00-20 00 3e 00 3d 00 20 00 |D.a.t.e.

> .>.=. .| 0040 27 00 32 00 30 00 30 00-33 00 2d 00 30 00 35 00
> |'.2.0.0. 3.-.0.5.| 0050 2d 00 30 00 36 00 27 00-29 00 20 00 29 00 20
00 |-.0.6.'. ). .). .|
> 0060 29 00 20 00 29 00 0a 00-                        |). .)...|
>
> Somewhere a buffer corruption occur...
> What library are you using ? dblib ctlib or odbc ? What client ? PHP,
> other ?
>
> What platform are you using ?
>
> freddy77
>
>
> _______________________________________________
> 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

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetds061.log
Type: application/octet-stream
Size: 13216 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20030512/6a67a6be/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: freetds062dev.log
Type: application/octet-stream
Size: 14847 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20030512/6a67a6be/attachment-0001.obj 


More information about the FreeTDS mailing list