diff options
| author | Rucha Deodhar <rucha.deodhar@mariadb.com> | 2020-08-04 13:21:54 +0530 |
|---|---|---|
| committer | Rucha Deodhar <rucha.deodhar@mariadb.com> | 2020-08-04 14:45:23 +0530 |
| commit | 28b3e0b2c5feec80f81403ff90b58f15a5d49e48 (patch) | |
| tree | 8760924b2cc2bd8bc2583a0f0dfb7b12f82e4765 /mysql-test/t/sql_mode.test | |
| parent | e6cb263ef3ecc59510b62f7c7dd5dfcd78a613c7 (diff) | |
| download | mariadb-git-bb-10.1-MDEV-23209.tar.gz | |
MDEV-23209: Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'bb-10.1-MDEV-23209
failed in Diagnostics_area::set_ok_status on INSERT
Analysis: Error is not returned when strict mode is enabled and value is
truncated because double is outside range.
Fix: Return HA_ERR_AUTOINC_ERANGE if the error was reported when double is
outside range.
Diffstat (limited to 'mysql-test/t/sql_mode.test')
| -rw-r--r-- | mysql-test/t/sql_mode.test | 17 |
1 files changed, 17 insertions, 0 deletions
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; |