Debian Codegraph @

mysql-test/suite/innodb/r/innodb_too_many_columns.result

raw
1 CREATE PROCEDURE add_columns(table_name varchar(50), algorithm varchar(10))
2 BEGIN
3 DECLARE i INT DEFAULT 1;
4 SET @sql_text = CONCAT('ALTER TABLE ', table_name, ' ');
5 while (i < 1012) do
6 SET @sql_text = CONCAT(@sql_text, ' ADD COLUMN ', CONCAT('col_', i), ' INTEGER NULL DEFAULT NULL,');
7 set i = i + 1;
8 end while;
9 SET @sql_text = CONCAT(@sql_text, 'ALGORITHM=', algorithm);
10 PREPARE stmt FROM @sql_text;
11 EXECUTE stmt;
12 DEALLOCATE PREPARE stmt;
13 END|
14 CREATE PROCEDURE create_tables()
15 BEGIN
16 # Create a non-partitioned table
17 CREATE TABLE `test`.`TEST_TABLE` (
18 `TIMESTAMP` datetime NOT NULL,
19 `INTERVALL` int NOT NULL,
20 `IDENT_KEY` int NOT NULL,
21 `FIELD_1` double DEFAULT NULL,
22 `FIELD_2` double DEFAULT NULL,
23 `FIELD_3` double DEFAULT NULL
24 );
25 # Create a partitioned table
26 CREATE TABLE `test`.`TEST_TABLE_PARTITIONED` (
27 `TIMESTAMP` datetime NOT NULL,
28 `INTERVALL` int NOT NULL,
29 `IDENT_KEY` int NOT NULL,
30 `FIELD_1` double DEFAULT NULL,
31 `FIELD_2` double DEFAULT NULL,
32 `FIELD_3` double DEFAULT NULL
33 )
34 PARTITION BY RANGE COLUMNS(`TIMESTAMP`)
35 (
36 PARTITION p20210321 VALUES LESS THAN ('2021-03-22'),
37 PARTITION p20210322 VALUES LESS THAN ('2021-03-23'),
38 PARTITION p20210323 VALUES LESS THAN MAXVALUE
39 );
40 END |
41 call create_tables();
42 call add_columns('TEST_TABLE', 'INPLACE');
43 call add_columns('TEST_TABLE_PARTITIONED', 'INPLACE');
44 ALTER TABLE TEST_TABLE ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=INPLACE;
45 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Too many columns. Try ALGORITHM=COPY.
46 ALTER TABLE TEST_TABLE_PARTITIONED ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=INPLACE;
47 ERROR 0A000: ALGORITHM=INPLACE is not supported. Reason: Too many columns. Try ALGORITHM=COPY.
48 TRUNCATE TABLE TEST_TABLE;
49 TRUNCATE TABLE TEST_TABLE_PARTITIONED;
50 DROP TABLE TEST_TABLE;
51 DROP TABLE TEST_TABLE_PARTITIONED;
52 call create_tables();
53 call add_columns('TEST_TABLE', 'INSTANT');
54 call add_columns('TEST_TABLE_PARTITIONED', 'INSTANT');
55 ALTER TABLE TEST_TABLE ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=INSTANT;
56 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Too many columns. Try ALGORITHM=COPY/INPLACE.
57 ALTER TABLE TEST_TABLE_PARTITIONED ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=INSTANT;
58 ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Too many columns. Try ALGORITHM=COPY/INPLACE.
59 TRUNCATE TABLE TEST_TABLE;
60 TRUNCATE TABLE TEST_TABLE_PARTITIONED;
61 DROP TABLE TEST_TABLE;
62 DROP TABLE TEST_TABLE_PARTITIONED;
63 call create_tables();
64 call add_columns('TEST_TABLE', 'COPY');
65 call add_columns('TEST_TABLE_PARTITIONED', 'COPY');
66 ALTER TABLE TEST_TABLE ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=COPY;
67 ERROR HY000: Too many columns
68 ALTER TABLE TEST_TABLE_PARTITIONED ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=COPY;
69 ERROR HY000: Too many columns
70 TRUNCATE TABLE TEST_TABLE;
71 TRUNCATE TABLE TEST_TABLE_PARTITIONED;
72 DROP TABLE TEST_TABLE;
73 DROP TABLE TEST_TABLE_PARTITIONED;
74 call create_tables();
75 call add_columns('TEST_TABLE', 'DEFAULT');
76 call add_columns('TEST_TABLE_PARTITIONED', 'DEFAULT');
77 ALTER TABLE TEST_TABLE ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=DEFAULT;
78 ERROR HY000: Too many columns
79 ALTER TABLE TEST_TABLE_PARTITIONED ADD I_VJ278 INTEGER NULL DEFAULT NULL, ALGORITHM=DEFAULT;
80 ERROR HY000: Too many columns
81 TRUNCATE TABLE TEST_TABLE;
82 TRUNCATE TABLE TEST_TABLE_PARTITIONED;
83 DROP TABLE TEST_TABLE;
84 DROP TABLE TEST_TABLE_PARTITIONED;
85 DROP PROCEDURE create_tables;
86 DROP PROCEDURE add_columns;