diff options
Diffstat (limited to 'mysql-test/t/compare.test')
| -rw-r--r-- | mysql-test/t/compare.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/compare.test b/mysql-test/t/compare.test new file mode 100644 index 00000000000..b5596784f35 --- /dev/null +++ b/mysql-test/t/compare.test @@ -0,0 +1,11 @@ +# +# Bug when using comparions of strings and integers. +# + +CREATE TABLE t1 (id CHAR(12) not null, PRIMARY KEY (id)); +insert into t1 values ('000000000001'),('000000000002'); +explain select * from t1 where id=000000000001; +select * from t1 where id=000000000001; +delete from t1 where id=000000000002; +select * from t1; +drop table t1; |