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 | 15 |
1 files changed, 5 insertions, 10 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..bc9bddad690 100644 --- a/mysql-test/suite/gcol/r/gcol_select_innodb.result +++ b/mysql-test/suite/gcol/r/gcol_select_innodb.result @@ -520,14 +520,12 @@ ALTER TABLE t1 ADD COLUMN d SMALLINT AS (a) VIRTUAL; ALTER TABLE t1 DROP COLUMN d; ALTER TABLE t1 ADD COLUMN c INT AS(a) VIRTUAL; ALTER TABLE t1 CHANGE c c SMALLINT AS(a) VIRTUAL; -Warnings: -Warning 1264 Out of range value for column 'c' at row 1 +ERROR 22003: 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 +ERROR 22003: Out of range value for column 'c' at row 1 SELECT * FROM t1; a c -2147483647 127 +2147483647 2147483647 DROP TABLE t1; CREATE TABLE t1(a INT); INSERT INTO t1 VALUES(2147483647); @@ -538,12 +536,9 @@ ERROR 0A000: LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. 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 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 +ERROR 22003: Out of range value for column 'f' at row 1 ALTER TABLE t1 ADD COLUMN g SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=EXCLUSIVE; -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 +ERROR 22003: Out of range value for column 'g' at row 1 DROP TABLE t1; # # Bug#21980430 GCOLS: CRASHING |