EVOLUTION-MANAGER

Edit File: index_primary_varchar_null_character.result

DROP TABLE IF EXISTS ids; CREATE TABLE ids ( id varchar(7) CHARACTER SET latin1 COLLATE latin1_bin PRIMARY KEY ); INSERT INTO ids VALUES("\0abcdef"); INSERT INTO ids VALUES("ab\0cdef"); INSERT INTO ids VALUES("abcd\0ef"); SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; id �abcdef ab�cdef abcd�ef SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = "ab\0cdef"; id ab�cdef DROP TABLE ids;