diff options
Diffstat (limited to 'mysql-test/main/type_blob.test')
| -rw-r--r-- | mysql-test/main/type_blob.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/main/type_blob.test b/mysql-test/main/type_blob.test index df565b187b4..7801280a8d2 100644 --- a/mysql-test/main/type_blob.test +++ b/mysql-test/main/type_blob.test @@ -362,6 +362,7 @@ insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL), ('Honda'), ('Subaru'), ('Honda'); select * from t1 where txt='Chevy' or txt is NULL; explain select * from t1 where txt='Chevy' or txt is NULL; +explain select * from t1 FORCE INDEX (`txt_index`) where txt='Chevy' or txt is NULL; select * from t1 where txt='Chevy '; select * from t1 where txt='Chevy ' or txt='Chevy'; select * from t1 where txt='Chevy' or txt='Chevy '; |