dynamobi/dynamobi — Issue #727: [FRG-144] NOT (c IN ...) works but c NOT IN ... does not 
Author: dynamobi-build
Created: 2011-12-30 03:45:31+00:00
State: open
Labels: FRG, SQL Parser

[reporter="kvu", created="Tue, 6 Jun 2006 11:45:24 -0500 (GMT-05:00)"]
-- query 1: c NOT IN ... -> parser error

CREATE SCHEMA BUG3893;

CREATE TABLE BUG3893.T(c char(10));

INSERT INTO BUG3893.T VALUES ('abc');

SELECT * FROM (SELECT * FROM BUG3893.T) WHERE c IN ('abc');

-- the following query should return zero rows

SELECT * FROM BUG3893.T WHERE c NOT IN ('abc');

Error: org.eigenbase.sql.parser.SqlParseException: Encountered "IN" at line 1, column 37.

Was expecting one of:

"LIKE" ...

"SIMILAR" ...

"BETWEEN" ... (state=,code=0)

-- query 2: NOT (c IN ...) the last line of query is changed to

SELECT * FROM BUG3893.T WHERE NOT (c IN ('abc'));

result:

0: jdbc:luciddb:> SELECT * FROM BUG3893.T WHERE NOT (c IN ('abc'));

+----+

| C |

+----+

+----+

No rows selected (0.409 seconds)

Also,

"There are some other missing parser features in the same area such as

ANY/ALL." -- John