null literal in 9.3
Hi,
I tried to do a select NULL as... for an not existing column in an Union
select statement.
I have a problem with my solution in 9.3 when I try to turn the select
into a view and work with the view.
Select and create view work (below is a simplified version)
select cast(null as integer) nilcol from informix.systables
-> works
create view niltab(nilcol) asselect cast(null as integer) nilcol from informix.systables
-> works
But the select fails:
select * from niltab201: A syntax error has occurred.
It works in 9.4 but I would need it in 9.3. Can anybody give me an hint
or workaround how I can make this work in 9.3?
Regards,
Michael
I can't reproduce this on 9.20.F, 9.30.UC7 or 9.40.FC1, so I'm not convinced the
problem isn't elsewhere. However, try '':INTEGER as an alternative both to NULL
and CAST.
--
Regards,
Doug Lawry
www.douglawry.webhop.org
"Michael Wimmer" <newsgroup1@ecom.at> wrote in message
news:433bb0fb$0$4084$91cee783@newsreader01.highway.telekom.at...
> Hi,
>
> I tried to do a select NULL as... for an not existing column in
> an Union select statement.
>
> I have a problem with my solution in 9.3 when I try to turn the
> select into a view and work with the view.
>
> Select and create view work (below is a simplified version)
>
> select cast(null as integer) nilcol from informix.systables
> -> works
>
> create view niltab(nilcol) as> select cast(null as integer) nilcol from informix.systables
> -> works
>
> But the select fails:
>
> select * from niltab> 201: A syntax error has occurred.>
> It works in 9.4 but I would need it in 9.3. Can anybody give me
> an hint or workaround how I can make this work in 9.3?
>
> Regards,
>
> Michael
Doug Lawry wrote:
> I can't reproduce this on 9.20.F, 9.30.UC7 or 9.40.FC1, so I'm not convinced the
> problem isn't elsewhere. However, try '':INTEGER as an alternative both to NULL
> and CAST.
Hi Doug,
thanks a lot, '' did the trick.
create view niltab (a)
as select cast('' as INTEGER),
from informix.systables
Funny that you can not reproduce the problem. Did you try to create a
view and select from the view? Only the select on the view fails,
selecting from a table and creating the view works...
If I change the '' to NULL inside the cast function, the select on the
view fails....
Regards,
Michael