diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/r/index_primary_char_exact_length.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/r/index_primary_char_exact_length.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/index_primary_char_exact_length.result b/storage/mroonga/mysql-test/mroonga/storage/r/index_primary_char_exact_length.result new file mode 100644 index 00000000000..95d7c78bbb6 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/storage/r/index_primary_char_exact_length.result @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS ids; +CREATE TABLE ids ( +id char(10) CHARACTER SET latin1 PRIMARY KEY +); +INSERT INTO ids VALUES('abcdefghij'); +INSERT INTO ids VALUES('klmnopqrst'); +INSERT INTO ids VALUES('uvwxyz0123'); +SELECT * FROM ids FORCE INDEX(PRIMARY) ORDER BY id; +id +abcdefghij +klmnopqrst +uvwxyz0123 +SELECT * FROM ids FORCE INDEX(PRIMARY) WHERE id = 'abcdefghij'; +id +abcdefghij +DROP TABLE ids; |