On Sun, May 6, 2012 at 5:02 PM, Norbert Sendetzky
wrote:
> Hi Guille
>
> > 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
> > NULL3
>
Hi Guille
> 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
> NULL3
> (2 rows affected)
I think I've found the problem in the MSSQL code (the NU
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 t
On Fri, Jul 15, 2011 at 2:35 PM, Norbert Sendetzky 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 pa
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?
Norbert
--
Hi Guille
I was testing doing some tests with mssql from windows using tds and odbc,
and I found a bug very similar to what happened not long ago with sqlite.
Executing the following queries:
Create table test (c1 int NULL, c2 int NULL)
insert into test values(1, NULL)
insert into test values(
Hi Norbert!
I was testing doing some tests with mssql from windows using tds and odbc,
and I found a bug very similar to what happened not long ago with sqlite.
Executing the following queries:
Create table test (c1 int NULL, c2 int NULL)
insert into test values(1, NULL)
insert into test values(
