diff options
| author | sergefp@mysql.com <> | 2004-12-31 14:48:11 +0300 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2004-12-31 14:48:11 +0300 |
| commit | 034c59ed59684b3ef9cb12a848ea76739d2db149 (patch) | |
| tree | 2e329b2f6aeb70fd94304f044ac22a0a26a20d05 /mysql-test/include | |
| parent | a09df7488d97851c07e72ff89d17d941bb5e4688 (diff) | |
| download | mariadb-git-034c59ed59684b3ef9cb12a848ea76739d2db149.tar.gz | |
Fix test results to account for difference between release BDB, debug BDB and MyISAM.
Diffstat (limited to 'mysql-test/include')
| -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 |