diff options
Diffstat (limited to 'mysql-test/include/varchar.inc')
-rw-r--r-- | mysql-test/include/varchar.inc | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/include/varchar.inc b/mysql-test/include/varchar.inc index 646cc4cbdd4..060afbfb066 100644 --- a/mysql-test/include/varchar.inc +++ b/mysql-test/include/varchar.inc @@ -66,18 +66,26 @@ select count(*) from t1 where v like 'a%'; select count(*) from t1 where c like 'a%'; select count(*) from t1 where t like 'a%'; select count(*) from t1 where v like 'a %'; +# Test results differ for BDB, see comments in bdb.test +# and they are also different from MySAM test results. +--replace_column 9 # explain select count(*) from t1 where v='a '; +--replace_column 9 # explain select count(*) from t1 where c='a '; +--replace_column 9 # explain select count(*) from t1 where t='a '; +--replace_column 9 # explain select count(*) from t1 where v like 'a%'; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a '; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n'; --error 1062 alter table t1 add unique(v); alter table t1 add key(v); select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a'; ---replace_column 6 # +--replace_column 6 # 9 # explain select * from t1 where v='a'; # GROUP BY @@ -106,10 +114,15 @@ select count(*) from t1 where v between 'a' and 'a '; select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n'; select count(*) from t1 where v like 'a%'; select count(*) from t1 where v like 'a %'; +--replace_column 9 # explain select count(*) from t1 where v='a '; +--replace_column 9 # explain select count(*) from t1 where v like 'a%'; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a '; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n'; +--replace_column 9 # explain select * from t1 where v='a'; # GROUP BY @@ -130,10 +143,15 @@ select count(*) from t1 where v between 'a' and 'a '; select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n'; select count(*) from t1 where v like 'a%'; select count(*) from t1 where v like 'a %'; +--replace_column 9 # explain select count(*) from t1 where v='a '; +--replace_column 9 # explain select count(*) from t1 where v like 'a%'; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a '; +--replace_column 9 # explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n'; +--replace_column 9 # explain select * from t1 where v='a'; # GROUP BY |