diff options
author | unknown <sergefp@mysql.com> | 2004-12-31 14:48:11 +0300 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2004-12-31 14:48:11 +0300 |
commit | 3cbfd4d93124f221b37d54cb9ae6f74ba3a58b67 (patch) | |
tree | 2e329b2f6aeb70fd94304f044ac22a0a26a20d05 /mysql-test/include/varchar.inc | |
parent | 21189edb45f739b0eed1abb3243cbbefad6e57ff (diff) | |
download | mariadb-git-3cbfd4d93124f221b37d54cb9ae6f74ba3a58b67.tar.gz |
Fix test results to account for difference between release BDB, debug BDB and MyISAM.
mysql-test/t/bdb.test:
Fix test results to account for difference in results caused by different FP calculation results
between release BDB and debug BDB
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 |