Debian Codegraph @

mysql-test/suite/json/t/array_index_debug.test

raw
1 --source include/have_debug.inc
2
3 --echo #
4 --echo # Bug#30292605: ASSERTION WHEN READING A HIDDEN ARRAY COLUMN
5 --echo # Bug#30302208: ASSERTION FAILURE WITH CREATE TABLE AS SELECT AND
6 --echo # SHOW_HIDDEN_COLUMNS
7 --echo #
8 CREATE TABLE t(j JSON, KEY k ((CAST(j->'$[*]' AS SIGNED ARRAY))));
9 INSERT INTO t VALUES ('[1,2,3]');
10 SET debug = '+d,show_hidden_columns';
11 SELECT * FROM t;
12 --error ER_NOT_SUPPORTED_YET
13 CREATE TABLE t_copy AS SELECT * FROM t;
14 SET debug = '-d,show_hidden_columns';
15 DROP TABLE t;
16
17 --echo #
18 --echo # Bug#30263373: INCORRECT OUTPUT FROM TABLE_FUNCTION_JSON::PRINT()
19 --echo #
20 CREATE TABLE t(j JSON,
21 KEY k1 ((CAST(j->'$.a[*]' AS DATETIME(3) ARRAY))),
22 KEY k2 ((CAST(j->'$.b[*]' AS UNSIGNED INT ARRAY))));
23 SET debug = '+d,show_hidden_columns';
24 # Used to show the hidden column for k1 as a DATETIME with unspecified
25 # precision, and the hidden column for k2 as BIGINT without the
26 # UNSIGNED modifier.
27 SHOW CREATE TABLE t;
28 SET debug = '-d,show_hidden_columns';
29 DROP TABLE t;