diff options
author | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-18 11:44:47 -0500 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2017-01-18 11:44:47 -0500 |
commit | a3a91332d006fd39a32e1f6d4663e11515ea944b (patch) | |
tree | 560c152c9f8146a4c1bcd52ad2a2fa454be48aec /mysql-test/suite/gcol/r/gcol_select_innodb.result | |
parent | 2805baf06c31dac21604148ec089300461790e3d (diff) | |
download | mariadb-git-bb-10.2-mdev7635.saved.tar.gz |
MDEV-7635: Update tests to adapt to the new default sql_modebb-10.2-mdev7635.savedbb-10.2-mdev7635.final
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 |