Debian Codegraph @

mysql-test/suite/gcol/t/gcol_insert_ignore.test

raw
1 --source include/big_test.inc
2 --source include/not_valgrind.inc
3
4 --echo #
5 --echo # Bug #30664660 GCOLS, CRASH AND CORRUPTIONS WITH DELETE IGNORE + JSON
6 --echo #
7
8 SET @@session.timestamp = 1100000000;
9
10 CREATE TABLE data_examples (
11 id INT PRIMARY KEY AUTO_INCREMENT,
12 type_name TEXT,
13 value_sql TEXT
14 );
15 INSERT INTO data_examples (type_name,value_sql) VALUES
16 ('JSON', '"{}"'),
17 ('JSON', '''["hello beautiful world"]'''),
18 ('JSON', '"-1"'),
19 ('TINYINT', '-1'),
20 ('SMALLINT', '-1'),
21 ('MEDIUMINT', '-1'),
22 ('INT', '2000000000'),
23 ('INT', '-2000000000'),
24 ('INT UNSIGNED', '4000000000'),
25 ('BIGINT', '2000000000000000000'),
26 ('BIGINT', '-2000000000000000000'),
27 ('FLOAT', '-1.23456'),
28 ('FLOAT', '-1e38'),
29 ('FLOAT', '1e38'),
30 ('DOUBLE', '-1.23456789012345'),
31 ('DOUBLE', '1.23456789012345'),
32 ('DOUBLE', '-1e300'),
33 ('DOUBLE', '1e300'),
34 ('DECIMAL(4,2)', '-10.99'),
35 ('DECIMAL(34,4)', '20000000000000000000000000000.0001'),
36 ('DECIMAL(34,4)', '-20000000000000000000000000000.0001'),
37 ('BIT(64)', '0xDEADBEEFC0FEBABE'),
38 ('BIT(4)', '0b1000'),
39 ('YEAR', '2020'),
40 ('DATE', '"2030-04-05"'),
41 ('TIME', '"11:12:13"'),
42 ('DATETIME', '"2030-04-05 11:12:13"'),
43 ('TIMESTAMP', '"2030-04-05 11:12:13"'),
44 ('CHAR(40)', '"2000000000000000000000000000000000000"'),
45 ('BINARY(45)', '"200000000000000000000000000000000000000000"'),
46 ('VARCHAR(50)', '"2000000000000000000000000000000000000000000000000"'),
47 ('CHAR(24)', '"hello beautiful world"'),
48 ('BINARY(12)', '"hello world"'),
49 ('VARCHAR(6)', '"hello"'),
50 ('ENUM("up","down")', '"up"'),
51 ('SET("up","down")', '"up,down"'),
52 ('GEOMETRY', 'ST_GeomFromText("POINT(1 1)")'),
53 ('POINT', 'ST_GeomFromText("POINT(1 1)")'),
54 ('LINESTRING', 'ST_GeomFromText("LINESTRING(0 0,1 1,2 2)")'),
55 (
56 'POLYGON',
57 'ST_GeomFromText("POLYGON((0 0,1 0,1 1,0 1,0 0),(5 5,7 5,7 7,5 7,5 5))")'
58 );
59 # TODO:
60 #('MULTIPOINT',''),
61 #('MULTILINESTRING',''),
62 #('MULTIPOLYGON',''),
63 #('GEOMETRYCOLLECTION',''),
64
65 CREATE TABLE data_types (
66 id INT PRIMARY KEY AUTO_INCREMENT,
67 name TEXT
68 );
69 INSERT INTO data_types (name)
70 SELECT type_name FROM data_examples GROUP BY type_name ORDER BY MIN(id);
71
72 --let $types_cnt = `SELECT COUNT(1) FROM data_types`
73 --let $examples_cnt = `SELECT COUNT(1) FROM data_examples`
74
75 --let $virtual_column_type_i = 1
76 while($virtual_column_type_i <= $types_cnt)
77 {
78 let $virtual_column_type =
79 `SELECT name FROM data_types WHERE id=$virtual_column_type_i`;
80 --echo #
81 --echo # Testing virtual column of type $virtual_column_type
82 --echo #
83
84 --let $example_i = 1
85 while($example_i <= $examples_cnt)
86 {
87 --let $type_name = `SELECT type_name FROM data_examples WHERE id=$example_i`
88 --let $value_sql = `SELECT value_sql FROM data_examples WHERE id=$example_i`
89 --echo # Testing example of type $type_name and value $value_sql
90 --disable_query_log
91 eval
92 CREATE TABLE t (
93 a $type_name NOT NULL,
94 b $virtual_column_type GENERATED ALWAYS as (a) VIRTUAL NOT NULL
95 ) ENGINE=INNODB;
96
97 # We can't have an index on virtual:
98 # - spatial types,
99 # - JSON
100 error 0
101 ,ER_BLOB_KEY_WITHOUT_LENGTH
102 ,ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
103 ,ER_JSON_USED_AS_KEY
104 ;
105 CREATE INDEX on_b ON t(b);
106 error 0
107 ,ER_WRONG_SUB_KEY
108 ,ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
109 ,ER_JSON_USED_AS_KEY
110 ;
111 CREATE INDEX on_b_prefix ON t(b(10));
112
113 --enable_query_log
114 SHOW CREATE TABLE t;
115
116 error 0
117 ,ER_INVALID_JSON_TEXT
118 ,ER_INVALID_JSON_CHARSET
119 ,ER_CANT_CREATE_GEOMETRY_OBJECT
120 ;
121 --eval INSERT IGNORE INTO t (a) VALUES ($value_sql)
122
123 SELECT * FROM t;
124
125 error 0
126 ,ER_INVALID_JSON_VALUE_FOR_CAST
127 ,ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
128 ,ER_TRUNCATED_WRONG_VALUE
129 ;
130 DELETE FROM t;
131
132 DELETE IGNORE FROM t;
133
134 CHECK TABLE t;
135 DROP TABLE t;
136
137 --inc $example_i
138 }
139
140 --inc $virtual_column_type_i
141 }
142
143 DROP TABLE data_types;
144 DROP TABLE data_examples;
145 SET timestamp=DEFAULT;