diff options
Diffstat (limited to 'mysql-test/t/check.test')
-rw-r--r-- | mysql-test/t/check.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/check.test b/mysql-test/t/check.test index 29587a9f623..9cefdee8418 100644 --- a/mysql-test/t/check.test +++ b/mysql-test/t/check.test @@ -124,3 +124,24 @@ alter table t1 drop constraint if exists non_existing_constraint; --error ER_CONSTRAINT_FAILED insert into t1 () values (); drop table t1; + +--echo # +--echo # MDEV-25638: Assertion `!result' failed in convert_const_to_int +--echo # + +CREATE TABLE v0 ( v1 bigint CHECK ( v1 NOT IN ( 'x' , 'x111' ) ) ) ; +select * from v0; +select v1 from v0; +select * from v0; +prepare stmt from "select * from v0"; +execute stmt; +execute stmt; +flush tables; +select * from v0; +select * from v0; +deallocate prepare stmt; +drop table v0; + +--echo # +--echo # End of 10.2 test +--echo # |