Debian Codegraph @

mysql-test/suite/innodb_fts/r/fulltext_rollup.result

raw
1 #
2 # Bug#32996762: WRONG RESULT FOR FULL-TEXT MATCH FUNCTION ON ROLLUP COLUMN
3 #
4 CREATE TABLE t (a VARCHAR(10), FULLTEXT (a));
5 INSERT INTO t VALUES ('abc'), ('abc abc');
6 ANALYZE TABLE t;
7 Table Op Msg_type Msg_text
8 test.t analyze status OK
9 SELECT a, MATCH (a) AGAINST ('abc') FROM t GROUP BY a WITH ROLLUP;
10 ERROR HY000: MATCH does not support ROLLUP columns.
11 DROP TABLE t;
12 #
13 # Bug#32565923: WRONG RESULT WITH ROLLUP ON FULL-TEXT FUNCTION
14 #
15 CREATE TABLE t (a varchar(10), FULLTEXT (a));
16 INSERT INTO t VALUES ('abc'), ('xyz');
17 ANALYZE TABLE t;
18 Table Op Msg_type Msg_text
19 test.t analyze status OK
20 SELECT MATCH (a) AGAINST ('abc') AS score, a FROM t
21 GROUP BY score, a WITH ROLLUP;
22 ERROR HY000: MATCH does not support ROLLUP columns.
23 DROP TABLE t;
24 #
25 # WL#14697: Reject calls to MATCH with rollup column as argument
26 #
27 CREATE TABLE t (id INTEGER PRIMARY KEY, a VARCHAR(10), FULLTEXT (a));
28 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY a WITH ROLLUP;
29 ERROR HY000: MATCH does not support ROLLUP columns.
30 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY id, a WITH ROLLUP;
31 ERROR HY000: MATCH does not support ROLLUP columns.
32 SELECT MATCH (a) AGAINST ('abc') FROM t GROUP BY a, id WITH ROLLUP;
33 ERROR HY000: MATCH does not support ROLLUP columns.
34 SELECT 1 FROM t GROUP BY a, MATCH (a) AGAINST ('abc') WITH ROLLUP;
35 ERROR HY000: MATCH does not support ROLLUP columns.
36 SELECT 1 FROM t GROUP BY MATCH (a) AGAINST ('abc'), a WITH ROLLUP;
37 ERROR HY000: MATCH does not support ROLLUP columns.
38 SELECT 1 FROM t GROUP BY a WITH ROLLUP HAVING MATCH (a) AGAINST ('abc');
39 ERROR HY000: MATCH does not support ROLLUP columns.
40 SELECT 1 FROM t GROUP BY a WITH ROLLUP ORDER BY MATCH (a) AGAINST ('abc');
41 ERROR HY000: MATCH does not support ROLLUP columns.
42 SELECT 1 FROM t WHERE MATCH (a) AGAINST ('abc') GROUP BY a WITH ROLLUP;
43 1
44 DROP TABLE t;