SET @@storage_engine = Falcon; *** Bug #23692 *** DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; DROP TABLE IF EXISTS t3; DROP TABLE IF EXISTS t4; CREATE TABLE t1 (a char(1), key (a)); INSERT INTO t1 VALUES (0x00); SELECT count(*) FROM t1 WHERE a < ''; count(*) 1 SELECT count(*) FROM t1 WHERE a = ''; count(*) 0 SELECT count(*) FROM t1 WHERE a > ''; count(*) 0 CREATE TABLE t2 (a varbinary(5)); CREATE INDEX i ON t2 (a); INSERT INTO t2 VALUES (0x02), (0x0202); SELECT count(*) FROM t2 WHERE a >= 0x02 OR a = 0x0202; count(*) 2 SELECT hex(a) FROM t2 WHERE a < 0x02; hex(a) SELECT hex(a) FROM t2 WHERE a = 0x02; hex(a) 02 SELECT hex(a) FROM t2 WHERE a > 0x02; hex(a) 0202 CREATE TABLE t3 (a char(5)); CREATE INDEX i ON t3 (a); INSERT INTO t3 VALUES (0x4200), (0x4209), (0x42), (0x4220), (0x4242); SELECT hex(a) FROM t3 WHERE a < 0x42; hex(a) 4200 4209 SELECT hex(a) FROM t3 WHERE a = 0x42; hex(a) 42 4220 SELECT hex(a) FROM t3 WHERE a > 0x42; hex(a) 4242 SELECT hex(a) FROM t3 WHERE a LIKE 'a%'; hex(a) 4200 4209 42 4220 4242 CREATE TABLE t4 (a varchar(5) character set ucs2, key(a)) engine=falcon; INSERT INTO t4 VALUES (0x00420000), (0x00420009), (0x0041001f), (0x0042), (0x00420020), (0x00420042); SELECT hex(a) FROM t4 WHERE a < 'a'; hex(a) 00420000 00420009 0042001f SELECT hex(a) FROM t4 WHERE a = 'a'; hex(a) 0042 00400220 SELECT hex(a) FROM t4 WHERE a > 'a'; hex(a) 00420042 SELECT hex(a) FROM t4 WHERE a LIKE 'a%'; hex(a) 00420000 00420009 0042001f 0042 00420020 00420042 DROP TABLE t1; DROP TABLE t2; DROP TABLE t3; DROP TABLE t4;