blob: e5a2e310866aade4b205f2c3c618ca5cbb1a863a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
#
# Bug when using comparions of strings and integers.
#
--disable_warnings
drop table if exists t1;
--enable_warnings
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;
|
