Hi Massimo, I did run a test directly using the mysqltcl package, and I did get the correct data.
So the same sql statement returns data directly, and nothing via DIO, so I am guessing the problem lies somewhere in DIO. Any sql statement with parenthesis inside makes DIO not returning data, for example (select * from .. where ..) union (select * from .. where ....) That is what I used for my test. Please let me know if you need me to conduct more tests. Thank you B. On Sat, Aug 31, 2013 at 7:19 PM, Brice Hamon <normandvik...@gmail.com>wrote: > OK I will do the test and let you know. > > Thanks, > B. > > > On Sat, Aug 31, 2013 at 7:17 PM, Massimo Manghi > <massimo.man...@unipr.it>wrote: > >> >> yes, strange, >> >> I haven't looked at the code for exec yet but I don't recall this method >> mangling with the statement passed by the caller. I will check it out but >> in the meanwhile you may put up a test script loading libmysqltcl and >> passing your SQL statement directly to that... >> >> I see only TDBC as alternative for a different (abstraction >> layer,database connectivity) pair. >> >> -- Massimo >> >> On 01-09-2013 1:11, Brice Hamon wrote: >> >>> Hi Massimo, >>> >>> I havent tried to call directly the TCL mysql module. >>> >>> >>> I am using mysqltcl-3.052 with a native 5.5.28-3.14.1 mysql >>> installation. >>> >>> I was doing (select ...) union (select ...) when I got that problem. >>> The query runs fine in MySql WorkBench. >>> >>> Strange isnt it. >>> >>> B. >>> >>> >> >
