use test;
--disable_abort_on_error

# simplified test case
SELECT *
FROM t1
WHERE EMPNUM NOT BETWEEN 'E2' AND 'E3';


# Original test case from NIST
--disable_warnings
DROP TABLE IF EXISTS t1;
DROP VIEW IF EXISTS v1;
--enable_warnings

CREATE TABLE t1
(EMPNUM   CHAR(3) NOT NULL,
PNUM     CHAR(3) NOT NULL,
HOURS    DECIMAL(5),
UNIQUE(EMPNUM,PNUM));

CREATE VIEW v1  
AS SELECT *
FROM t1
WHERE PNUM BETWEEN 'P2' AND 'P4'
AND EMPNUM NOT BETWEEN 'E2' AND 'E3';