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
42
43
44
45
46
47
48
|
--echo #
--echo # Bug #32695103 ASSERTION `RC == TYPE_OK'
--echo # FAILED|SQL/DD/IMPL/RAW/RAW_RECORD.CC
--echo #
# Put test case in separate file, since we use non-ascii characters.
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;
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;
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;
DROP VIEW v1;
DROP VIEW v2;
DROP TABLE t1;
|
