Simple Query
From: Bhalchandra Ghatate <bhala_at_cs.utexas.edu>
Date: 5 Feb 1995 23:05:25 -0600
Message-ID: <3h4aml$k9a_at_peaches.cs.utexas.edu>
1
2
3
4
Date: 5 Feb 1995 23:05:25 -0600
Message-ID: <3h4aml$k9a_at_peaches.cs.utexas.edu>
Now is this a bug: ?
junk is a table with one column of type varchar(2).
ORACLE: SQL> select * from junk;
NAME
1
2
3
4
SQL> select * from junk where name not in ('1','2','');
no rows selected
Same Query with sybase.
SYBASE:
1> select * from junk
2> go
name
1 3 4 2
1> select * from junk where name not in ('1','2','')
2> go
name
3 4