Debian Codegraph @

mysql-test/suite/innodb/r/instant_alter_limit,8k.rdiff

raw
1 --- instant_alter_limit.result
2 +++ instant_alter_limit,8k.reject
3 @@ -6,6 +6,28 @@
4 ENGINE=InnoDB;
5 INSERT INTO t VALUES(1,2,3,4,5);
6 SET innodb_strict_mode = OFF;
7 +Warnings:
8 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
9 +Warnings:
10 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
11 +Warnings:
12 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
13 +Warnings:
14 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
15 +Warnings:
16 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
17 +Warnings:
18 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
19 +Warnings:
20 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
21 +Warnings:
22 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
23 +Warnings:
24 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
25 +Warnings:
26 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
27 +Warnings:
28 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
29 SELECT * FROM t;
30 b d a c e
31 NULL NULL 1 NULL NULL
32 @@ -13,11 +35,17 @@
33 ADD COLUMN b INT, ALGORITHM=INSTANT;
34 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
35 ALTER TABLE t CHANGE COLUMN b beta INT AFTER a, ALGORITHM=INSTANT;
36 +Warnings:
37 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
38 ALTER TABLE t DROP e, DROP c, DROP d, ALGORITHM=INSTANT;
39 +Warnings:
40 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
41 SELECT * FROM t;
42 a beta
43 1 NULL
44 ALTER TABLE t DROP COLUMN beta, ALGORITHM=INSTANT;
45 +Warnings:
46 +Warning 139 Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
47 ALTER TABLE t ADD COLUMN b INT NOT NULL, ALGORITHM=INSTANT;
48 ERROR 0A000: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=INPLACE
49 SELECT variable_value-@old_instant instants
50 @@ -44,6 +72,13 @@
51 FROM information_schema.global_status
52 WHERE variable_name = 'innodb_instant_alter_column';
53 instants
54 -502
55 +492
56 DROP TABLE t;
57 +#
58 +# MDEV-21787 Alter table failure tries to access uninitialized column
59 +#
60 +CREATE TABLE t1(f1 INT PRIMARY KEY, f2 TEXT GENERATED ALWAYS AS (SUBSTR(f4, 1, 400)), f3 VARCHAR(500), f4 TEXT)ENGINE=InnoDB ROW_FORMAT=Compact;
61 +ALTER TABLE t1 ADD UNIQUE KEY (f2(9));
62 +ALTER TABLE t1 ADD COLUMN f5 TEXT, ALGORITHM=INPLACE;
63 +DROP TABLE t1;
64 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;