Created
April 13, 2015 07:38
-
-
Save yoku0825/0cd9e32979944baba59c to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--source ../../include/mroonga/have_mroonga.inc | |
--disable_warnings | |
DROP TABLE IF EXISTS t1; | |
--enable_warnings | |
CREATE TABLE t1 (num int, val varchar(32), PRIMARY KEY(num), FULLTEXT KEY(val)) Engine= Mroonga; | |
INSERT INTO t1 VALUES (1, 'one'); | |
SELECT * FROM t1 WHERE match(val) against('one') ORDER BY val, val; # This doesn't crash. | |
SELECT * FROM t1 WHERE match(val) against('one') ORDER BY val, val LIMIT 1; # This doesn't crash. | |
SELECT * FROM t1 WHERE match(val) against('one') ORDER BY num, num; # This doesn't crash. | |
SELECT * FROM t1 WHERE match(val) against('one') ORDER BY num, num LIMIT 1; # This makes crash. | |
SELECT * FROM t1 WHERE match(val) against('two') ORDER BY num, num LIMIT 1; # This makes crash. | |
DROP TABLE t1; | |
--source ../../include/mroonga/have_mroonga_deinit.inc |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment