summaryrefslogtreecommitdiff
path: root/mysql-test/suite/vcol/r/alter_inplace-9045.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/vcol/r/alter_inplace-9045.result')
-rw-r--r--mysql-test/suite/vcol/r/alter_inplace-9045.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/alter_inplace-9045.result b/mysql-test/suite/vcol/r/alter_inplace-9045.result
index 114fb3e3c06..10e6e2c15e3 100644
--- a/mysql-test/suite/vcol/r/alter_inplace-9045.result
+++ b/mysql-test/suite/vcol/r/alter_inplace-9045.result
@@ -26,9 +26,11 @@ id handle data hash
3 NULL 0 NULL
alter table t1 modify column handle int not null, algorithm=inplace;
ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY
+SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
alter table t1 modify column handle int not null, algorithm=copy;
Warnings:
Warning 1265 Data truncated for column 'handle' at row 3
+SET sql_mode = DEFAULT;
select * from t1;
id handle data hash
1 12 0 c51ce410c124a10e0db5e4b97fc2af39