#
# Mantis bug #224: Partitions: crash if expression
#
--echo #---- Bug 224 ----
SET STORAGE_ENGINE='Falcon';
--disable_warnings
DROP TABLE IF EXISTS t18;
--enable_warnings

CREATE TABLE t18 (
  s1 char(5), 
  PRIMARY KEY (s1)
) 
PARTITION BY LIST (ascii(s1)) (PARTITION p1 VALUES IN (1));
INSERT INTO t18 VALUES (0x01);
SELECT * FROM t18 WHERE s1 < 'a';
SELECT * FROM t18 WHERE s1 > 'a';

# Final cleanup
DROP TABLE t18;
