diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2023-01-13 10:18:30 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2023-01-13 10:18:30 +0200 |
| commit | 73ecab3d26c055928673a2629f4513aa7008dbf0 (patch) | |
| tree | b04760b3369cd1d8fc03c7dec204f5a371335b29 /mysql-test/main/create.test | |
| parent | 7d1df207c4ded0ac8aa61f0d35bcae7eda974c54 (diff) | |
| parent | 71e8e4934db06c02db1b51716e9d4b3992505161 (diff) | |
| download | mariadb-git-73ecab3d26c055928673a2629f4513aa7008dbf0.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/create.test')
| -rw-r--r-- | mysql-test/main/create.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/create.test b/mysql-test/main/create.test index 074195a331d..db8638ebe54 100644 --- a/mysql-test/main/create.test +++ b/mysql-test/main/create.test @@ -1893,6 +1893,19 @@ CREATE TABLE t1 ( id1 INT, id2 INT, CONSTRAINT `foo` PRIMARY KEY (id1), CONSTRAI DROP TABLE t1; --echo # +--echo # MDEV-30342 Wrong "Truncated incorrect DECIMAL value" warning/error +--echo # + +create table t1(c1 varchar(1)); +insert into t1(c1) values('#'); + +select @@sql_mode like '%strict_all_tables%'; +--error ER_TRUNCATED_WRONG_VALUE +create table t2 as select if(c1 = '#', c1 = 0, c1) as c1 from t1; + +drop table t1; + +--echo # --echo # End of 10.3 tests --echo # |