diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/sql_mode.result | 13 | ||||
| -rw-r--r-- | mysql-test/t/sql_mode.test | 17 |
2 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index d71748bd9b1..3aeb59d0eac 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -737,3 +737,16 @@ DROP FUNCTION test_function; SET @@sql_mode= @org_mode; #End of Test for Bug#12601974 +# +# 10.1 TEST +# +# MDEV-23209: Assertion `!is_set() || (m_status == DA_OK_BULK && +# is_bulk_op())' failed in Diagnostics_area::set_ok_status on INSERT +# +set @old_mode= @@sql_mode; +SET SQL_MODE='STRICT_TRANS_TABLES'; +CREATE TABLE t (a DOUBLE PRIMARY KEY AUTO_INCREMENT); +INSERT INTO t VALUES (18446744073709551601); +ERROR 22007: Truncated incorrect INTEGER value: '1.8446744073709552e19' +SET @@sql_mode=@old_mode; +DROP TABLE t; diff --git a/mysql-test/t/sql_mode.test b/mysql-test/t/sql_mode.test index 869bf45dbf3..44a5f0a74d5 100644 --- a/mysql-test/t/sql_mode.test +++ b/mysql-test/t/sql_mode.test @@ -513,3 +513,20 @@ SET @@sql_mode= @org_mode; --echo --echo #End of Test for Bug#12601974 + +--echo # +--echo # 10.1 TEST +--echo # +--echo # MDEV-23209: Assertion `!is_set() || (m_status == DA_OK_BULK && +--echo # is_bulk_op())' failed in Diagnostics_area::set_ok_status on INSERT +--echo # +set @old_mode= @@sql_mode; + +SET SQL_MODE='STRICT_TRANS_TABLES'; +CREATE TABLE t (a DOUBLE PRIMARY KEY AUTO_INCREMENT); + +--error ER_TRUNCATED_WRONG_VALUE +INSERT INTO t VALUES (18446744073709551601); + +SET @@sql_mode=@old_mode; +DROP TABLE t; |