SET storage_engine = Falcon;
*** Bug #22939 ***
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a int, key (a));
INSERT INTO t1 VALUES (-1);
INSERT INTO t1 VALUES (1);
SELECT * FROM t1 WHERE a < 0;
a
-1
SELECT * FROM t1 WHERE a > 0;
a
1
ALTER TABLE t1 PARTITION BY RANGE (a) (
PARTITION p1 VALUES LESS THAN (0),
PARTITION p2 VALUES LESS THAN MAXVALUE
);
SELECT * FROM t1 WHERE a < 0;
a
-1
SELECT * FROM t1 WHERE a > 0;
a
1
DROP TABLE t1;
