| 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; |