Debian Codegraph @

mysql-test/suite/innodb_fts/t/fulltext_rollup.test

raw
1 --echo #
2 --echo # Bug#32996762: WRONG RESULT FOR FULL-TEXT MATCH FUNCTION ON ROLLUP COLUMN
3 --echo #
4
5 CREATE TABLE t (a VARCHAR(10), FULLTEXT (a));
6 INSERT INTO t VALUES ('abc'), ('abc abc');
7 ANALYZE TABLE t;
8 # Used to return wrong results. Now raises an error.
9 --error ER_FULLTEXT_WITH_ROLLUP
10 SELECT a, MATCH (a) AGAINST ('abc') FROM t GROUP BY a WITH ROLLUP;
11 DROP TABLE t;
12
13 --echo #
14 --echo # Bug#32565923: WRONG RESULT WITH ROLLUP ON FULL-TEXT FUNCTION
15 --echo #
16
17 CREATE TABLE t (a varchar(10), FULLTEXT (a));
18 INSERT INTO t VALUES ('abc'), ('xyz');
19 ANALYZE TABLE t;
20 # Used to return wrong results with the old optimizer. Now raises an error.
21 --error ER_FULLTEXT_WITH_ROLLUP
22 SELECT MATCH (a) AGAINST ('abc') AS score, a FROM t
23 GROUP BY score, a WITH ROLLUP;
24 DROP TABLE t;
25
26 --echo #
27 --echo # WL#14697: Reject calls to MATCH with rollup column as argument
28 --echo #
29
30 CREATE TABLE t (id INTEGER PRIMARY KEY, a VARCHAR(10), FULLTEXT (a));
31
32 # Disallow use of rollup columns in the SELECT list.
33 --error ER_FULLTEXT_WITH_ROLLUP
34 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY a WITH ROLLUP;
35 --error ER_FULLTEXT_WITH_ROLLUP
36 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY id, a WITH ROLLUP;
37 --error ER_FULLTEXT_WITH_ROLLUP
38 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY a, id WITH ROLLUP;
39
40 # Disallow use of rollup columns in GROUP BY, HAVING and ORDER BY.
41 --error ER_FULLTEXT_WITH_ROLLUP
42 SELECT 1 FROM t GROUP BY a, MATCH (a) AGAINST ('abc') WITH ROLLUP;
43 --error ER_FULLTEXT_WITH_ROLLUP
44 SELECT 1 FROM t GROUP BY MATCH (a) AGAINST ('abc'), a WITH ROLLUP;
45 --error ER_FULLTEXT_WITH_ROLLUP
46 SELECT 1 FROM t GROUP BY a WITH ROLLUP HAVING MATCH (a) AGAINST ('abc');
47 --error ER_FULLTEXT_WITH_ROLLUP
48 SELECT 1 FROM t GROUP BY a WITH ROLLUP ORDER BY MATCH (a) AGAINST ('abc');
49
50 # Allow use of rollup columns in WHERE (since they are only accessed
51 # before aggregation/rollup).
52 SELECT 1 FROM t WHERE MATCH (a) AGAINST ('abc') GROUP BY a WITH ROLLUP;
53
54 DROP TABLE t;