Re: [opendbx] Problem with Union All querys and MSSQL with Free TDS from windows

[Guillermo P. <gui...@gm...>]

Hi! sorry for the delay.

I installed the dll with the patch and it didn't work :(.  On the other
hand, I tested the failing query with the tsql util from freetds, and it
worked:

1> select * from ((select t1.c1, null t3 from test t1 where t1.c1 is not
null) U
NION ALL (select NULL t3, t2.c2 from test t2 where t2.c2 is not null)) tt
2> go
c1      t3
1       NULL
NULL    3
(2 rows affected)
.
So I assume that the problem is not in freetds :(.

By now, I'll try to change the code to evade that kind of querys...

Thanks!
Guille

On Sat, Jul 16, 2011 at 4:20 PM, Mariano Martinez Peck <
mar...@gm...> wrote:

>
>
> On Fri, Jul 15, 2011 at 2:35 PM, Norbert Sendetzky <
> no...@li...> wrote:
>
>> Hi Guille
>>
>> > gives as result from sql server manager:
>> >
>> > 1     null
>> > null  3
>> >
>> > Digging into my code, the problem seems to be the 'odbx_field_value'
>> does
>> > not give me the right result..
>>
>> Any news on this? Did the patch fixed the problem?
>>
>>
> We are working on it :)
> We will let you know.
> Thanks
>
>
>>
>> Norbert
>>
>>
>> ------------------------------------------------------------------------------
>> AppSumo Presents a FREE Video for the SourceForge Community by Eric
>> Ries, the creator of the Lean Startup Methodology on "Lean Startup
>> Secrets Revealed." This video shows you how to validate your ideas,
>> optimize your ideas and identify your business strategy.
>> http://p.sf.net/sfu/appsumosfdev2dev
>> _______________________________________________
>> libopendbx-devel mailing list
>> lib...@li...
>> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
>> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>>
>
>
>
> --
> Mariano
> http://marianopeck.wordpress.com
>
>
>
> ------------------------------------------------------------------------------
> AppSumo Presents a FREE Video for the SourceForge Community by Eric
> Ries, the creator of the Lean Startup Methodology on "Lean Startup
> Secrets Revealed." This video shows you how to validate your ideas,
> optimize your ideas and identify your business strategy.
> http://p.sf.net/sfu/appsumosfdev2dev
> _______________________________________________
> libopendbx-devel mailing list
> lib...@li...
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>