diff options
Diffstat (limited to 'mysql-test/suite/gcol/inc/gcol_select.inc')
| -rw-r--r-- | mysql-test/suite/gcol/inc/gcol_select.inc | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/inc/gcol_select.inc b/mysql-test/suite/gcol/inc/gcol_select.inc index efaffd5168d..632a0cca922 100644 --- a/mysql-test/suite/gcol/inc/gcol_select.inc +++ b/mysql-test/suite/gcol/inc/gcol_select.inc @@ -852,15 +852,19 @@ DROP TABLE t2, t3; --disable_abort_on_error 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; ALTER TABLE t1 MODIFY c TINYINT AS(a) VIRTUAL; +SET sql_mode = DEFAULT; SELECT * FROM t1; DROP TABLE t1; CREATE TABLE t1(a INT); @@ -869,8 +873,10 @@ ALTER TABLE t1 ADD COLUMN h INT AS (a) VIRTUAL; ALTER TABLE t1 CHANGE h i INT AS (a) VIRTUAL, ALGORITHM=COPY; ALTER TABLE t1 ADD COLUMN b SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=NONE; ALTER TABLE t1 ADD COLUMN e SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=NONE; +SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; ALTER TABLE t1 ADD COLUMN f SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=SHARED; ALTER TABLE t1 ADD COLUMN g SMALLINT AS (a) VIRTUAL, ALGORITHM=COPY, LOCK=EXCLUSIVE; +SET sql_mode = DEFAULT; --enable_abort_on_error DROP TABLE t1; |