diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_select_innodb.result')
| -rw-r--r-- | mysql-test/suite/gcol/r/gcol_select_innodb.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_select_innodb.result b/mysql-test/suite/gcol/r/gcol_select_innodb.result index 24daadb0d5b..61b86f55a96 100644 --- a/mysql-test/suite/gcol/r/gcol_select_innodb.result +++ b/mysql-test/suite/gcol/r/gcol_select_innodb.result @@ -512,19 +512,23 @@ DROP TABLE t2, t3; # CREATE TABLE t1(a INT); INSERT INTO t1 VALUES(2147483647); +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; ALTER TABLE t1 ADD COLUMN b SMALLINT AS (a) VIRTUAL; ALTER TABLE t1 DROP COLUMN b; ALTER TABLE t1 ADD COLUMN c SMALLINT AS (a) VIRTUAL; ALTER TABLE t1 DROP COLUMN c; ALTER TABLE t1 ADD COLUMN d SMALLINT AS (a) VIRTUAL; ALTER TABLE t1 DROP COLUMN d; +SET sql_mode = DEFAULT; ALTER TABLE t1 ADD COLUMN c INT AS(a) VIRTUAL; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; ALTER TABLE t1 CHANGE c c SMALLINT AS(a) VIRTUAL; Warnings: Warning 1264 Out of range value for column 'c' at row 1 ALTER TABLE t1 MODIFY c TINYINT AS(a) VIRTUAL; Warnings: Warning 1264 Out of range value for column 'c' at row 1 +SET sql_mode = DEFAULT; SELECT * FROM t1; a c 2147483647 127 @@ -537,6 +541,7 @@ ALTER TABLE t1 ADD COLUMN b SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=NONE; ERROR 0A000: LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try LOCK=SHARED ALTER TABLE t1 ADD COLUMN e SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=NONE; ERROR 0A000: LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try LOCK=SHARED +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; ALTER TABLE t1 ADD COLUMN f SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=SHARED; Warnings: Warning 1264 Out of range value for column 'f' at row 1 @@ -544,6 +549,7 @@ ALTER TABLE t1 ADD COLUMN g SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=EXCLUS Warnings: Warning 1264 Out of range value for column 'f' at row 1 Warning 1264 Out of range value for column 'g' at row 1 +SET sql_mode = DEFAULT; DROP TABLE t1; # # Bug#21980430 GCOLS: CRASHING |