diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2012-06-23 20:12:54 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2012-06-23 20:12:54 +0400 |
| commit | f8f65accf99821386ad2cffdf0c3f473e8f33064 (patch) | |
| tree | 2d471c06242e08df95c86136ebb0a838594a80f2 /mysql-test/r/func_in.result | |
| parent | 048cc420521b9187adcb89026c72601db0a07d01 (diff) | |
| download | mariadb-git-f8f65accf99821386ad2cffdf0c3f473e8f33064.tar.gz | |
Add back testcase for lp:817966 (was lost in the merge)
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 800b9a976b4..fc56660ac62 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -789,6 +789,19 @@ DROP TABLE t1; # End of test BUG#13012483 # End of 5.1 tests +create table t1 (a bigint, b int); +insert t1 values (1,1),(2,2),(3,3); +select * from t1 where a in ('2.1'); +a b +select * from t1 where b in ('2.1'); +a b +select * from t1 where a='2.1'; +a b +select * from t1 where b='2.1'; +a b +select * from t1 where IF(1,a,a)='2.1'; +a b +drop table t1; # # LP bug#992380 Crash when creating PS for a query with # subquery in WHERE (see also mysql bug#13012483) |