compare.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- #
- # 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;
- #
- # Check the following:
- # "a" == "a "
- # "a " < "a"
- # "a " < "a "
- SELECT 'a' = 'a ';
- SELECT 'a ' < 'a';
- SELECT 'a ' < 'a ';
- SELECT 'at' < 'a';
- SELECT 'at' < 'a ';
- CREATE TABLE t1 (a char(10) not null);
- INSERT INTO t1 VALUES ('a'),('a '),('at'),('a ');
- SELECT hex(a),STRCMP(a,'a'), STRCMP(a,'a ') FROM t1;
- DROP TABLE t1;
- # Bug #8134: Comparison against CHAR(31) at end of string
- SELECT CHAR(31) = '', '' = CHAR(31);
- # Extra test
- SELECT CHAR(30) = '', '' = CHAR(30);
- # End of 4.1 tests