1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
#
# Bug #32695103 ASSERTION `RC == TYPE_OK'
# FAILED|SQL/DD/IMPL/RAW/RAW_RECORD.CC
#
CREATE TABLE t1 (a INT);
CREATE VIEW v1 AS
SELECT
GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a),
GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a),
GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a)
FROM t1 AS `߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`
GROUP BY a WITH ROLLUP;
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select grouping(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.`a`) AS `GROUPING(``߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789``.a)`,grouping(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.`a`) AS `Name_exp_GROUPING(``߸߸߸߸߸߸߸߸߸߸01234567890123456789012345678901234`,grouping(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.`a`) AS `Name_exp_1_GROUPING(``߸߸߸߸߸߸߸߸߸߸012345678901234567890123456789012` from `t1` `߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789` group by `߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.`a` with rollup utf8mb4 utf8mb4_0900_ai_ci
DROP VIEW v1;
DROP TABLE t1;
CREATE TABLE t1 (a int);
CREATE VIEW v1 AS
SELECT
GROUPING(a2345678901234567890123456789012345678901234.a),
GROUPING(a2345678901234567890123456789012345678901234.a),
GROUPING(a2345678901234567890123456789012345678901234.a)
FROM t1 AS a2345678901234567890123456789012345678901234
GROUP BY a WITH ROLLUP;
SHOW CREATE VIEW v1;
View Create View character_set_client collation_connection
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select grouping(`a2345678901234567890123456789012345678901234`.`a`) AS `GROUPING(a2345678901234567890123456789012345678901234.a)`,grouping(`a2345678901234567890123456789012345678901234`.`a`) AS `Name_exp_GROUPING(a2345678901234567890123456789012345678901234.a`,grouping(`a2345678901234567890123456789012345678901234`.`a`) AS `Name_exp_1_GROUPING(a2345678901234567890123456789012345678901234` from `t1` `a2345678901234567890123456789012345678901234` group by `a2345678901234567890123456789012345678901234`.`a` with rollup utf8mb4 utf8mb4_0900_ai_ci
CREATE VIEW v2 AS
SELECT
GROUPING(a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx.a),
GROUPING(a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx.a),
GROUPING(a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx.a)
FROM t1 AS a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx
GROUP BY a WITH ROLLUP;
SHOW CREATE VIEW v2;
View Create View character_set_client collation_connection
v2 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS select grouping(`a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx`.`a`) AS `Name_exp_1`,grouping(`a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx`.`a`) AS `Name_exp_2`,grouping(`a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx`.`a`) AS `Name_exp_3` from `t1` `a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx` group by `a2345678901234567890123456789012345678901234xxxxxxxxxxxxxxxx`.`a` with rollup utf8mb4 utf8mb4_0900_ai_ci
DROP VIEW v1;
DROP VIEW v2;
DROP TABLE t1;
|
