Dragos Hilbert schrieb:

> This is a bug:
>
> This select do not work:
>
> select 1 from rdb$database where null not in ('1')
>
> Firebird 1.5.0.3744
> WinXP

Dragos,

the funny thing is that in your subject you say "Bug?" and in your email
you state "This is a bug:".

So what is it?

But you know what?
There are even more bugs:

select 1 from rdb$database where '1'
not in ( SELECT NULL FROM RDB$DATABASE )

doesn't work either!

;-)
(sorry, couldn't resist)


Null is a state and neither a value nor a column.
So you can't put a state in the where clause: you have to put a a
columnname or value (where 'Hello' = 'Hello') in there.

What do you want to achieve with this statement?

Luc.