Debian Codegraph @

storage/myisam/mysql-test/storage_engine/alter_table_online.rdiff

raw
1 --- suite/storage_engine/alter_table_online.result
2 +++ suite/storage_engine/alter_table_online.reject
3 @@ -23,12 +50,30 @@
4 CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
5 INSERT INTO t1 (a,b,c) VALUES (1,100,'a'),(2,200,'b'),(3,300,'c');
6 ALTER ONLINE TABLE t1 DROP COLUMN b, ADD b <INT_COLUMN>;
7 +ERROR 0A000: LOCK=NONE is not supported for this operation. Try LOCK=SHARED.
8 +# ERROR: Statement ended with errno 1845, errname ER_ALTER_OPERATION_NOT_SUPPORTED (expected to succeed)
9 +# ------------ UNEXPECTED RESULT ------------
10 +# The statement|command finished with ER_ALTER_OPERATION_NOT_SUPPORTED.
11 +# Functionality or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors.
12 +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
13 +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
14 +# Also, this problem may cause a chain effect (more errors of different kinds in the test).
15 +# -------------------------------------------
16 ALTER ONLINE TABLE t1 MODIFY b BIGINT <CUSTOM_COL_OPTIONS>;
17 -ERROR 0A000: LOCK=NONE is not supported. Reason: Cannot change column type. Try LOCK=SHARED.
18 +ERROR 0A000: LOCK=NONE is not supported for this operation. Try LOCK=SHARED.
19 +# ERROR: Statement ended with errno 1845, errname ER_ALTER_OPERATION_NOT_SUPPORTED (expected results: ER_ALTER_OPERATION_NOT_SUPPORTED_REASON)
20 ALTER ONLINE TABLE t1 ENGINE=MEMORY;
21 ERROR 0A000: LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try LOCK=SHARED.
22 DROP TABLE t1;
23 CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN>, c <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
24 ALTER ONLINE TABLE t1 ADD INDEX (b);
25 -ALTER ONLINE TABLE t1 DROP INDEX b;
26 +ERROR 0A000: LOCK=NONE is not supported for this operation. Try LOCK=SHARED.
27 +# ERROR: Statement ended with errno 1845, errname ER_ALTER_OPERATION_NOT_SUPPORTED (expected to succeed)
28 +# ------------ UNEXPECTED RESULT ------------
29 +# The statement|command finished with ER_ALTER_OPERATION_NOT_SUPPORTED.
30 +# Adding an index or ALTER ONLINE or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors.
31 +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.
32 +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.
33 +# Also, this problem may cause a chain effect (more errors of different kinds in the test).
34 +# -------------------------------------------
35 DROP TABLE t1;