Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created April 13, 2015 07:38
Show Gist options
  • Save yoku0825/0cd9e32979944baba59c to your computer and use it in GitHub Desktop.
Save yoku0825/0cd9e32979944baba59c to your computer and use it in GitHub Desktop.
--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