diff options
author | monty@mysql.com <> | 2005-10-12 00:58:22 +0300 |
---|---|---|
committer | monty@mysql.com <> | 2005-10-12 00:58:22 +0300 |
commit | f5fdf3e87a5f60fdb6442912ae5741a24b2461c8 (patch) | |
tree | ce0e98ba05247bbe755ac299d0ceaa8c42d63b7a /mysql-test/t/range.test | |
parent | 17d7ba931d2293f1db89cbd1107a4bc71bc4fcdf (diff) | |
download | mariadb-git-f5fdf3e87a5f60fdb6442912ae5741a24b2461c8.tar.gz |
Reviewing new pushed code
- CHAR() now returns binary string as default
- CHAR(X*65536+Y*256+Z) is now equal to CHAR(X,Y,Z) independent of the character set for CHAR()
- Test for both ETIMEDOUT and ETIME from pthread_cond_timedwait()
(Some old systems returns ETIME and it's safer to test for both values
than to try to write a wrapper for each old system)
- Fixed new introduced bug in NOT BETWEEN X and X
- Ensure we call commit_by_xid or rollback_by_xid for all engines, even if one engine has failed
- Use octet2hex() for all conversion of string to hex
- Simplify and optimize code
Diffstat (limited to 'mysql-test/t/range.test')
-rw-r--r-- | mysql-test/t/range.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index 11c5e8d7bc5..89376d33f61 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -625,4 +625,9 @@ explain select * from t2 where a between 'a' and 'a '; --replace_column 9 # explain select * from t2 where a = 'a' or a='a '; +update t1 set a='b' where a<>'a'; +--replace_column 9 # +explain select * from t1 where a not between 'b' and 'b'; +select * from t1 where a not between 'b' and 'b'; + drop table t1,t2,t3; |