diff options
| author | evgen@moonbone.local <> | 2006-06-17 02:11:12 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2006-06-17 02:11:12 +0400 |
| commit | 7f246675981a5d2c00f3e22917d8f655d573c98e (patch) | |
| tree | 586c558b02a4bc7c19f63d3308824c8913e618d2 /mysql-test/r/func_in.result | |
| parent | 26fa98a2cbed5413ff3e4899700523ddf5d81274 (diff) | |
| parent | b8b9738e0baabc5c299eb0363b9f1d61d2985021 (diff) | |
| download | mariadb-git-7f246675981a5d2c00f3e22917d8f655d573c98e.tar.gz | |
Manually merged
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index 3cf2afc83d1..0632dddb87e 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -202,3 +202,24 @@ select count(*) from t1 where id not in (1,2); count(*) 1 drop table t1; +create table t1 (f1 char(1), f2 int); +insert into t1 values (1,0),('a',1),('z',2); +select f1 from t1 where f1 in (1,'z'); +f1 +1 +z +select f2 from t1 where f2 in (1,'z'); +f2 +0 +1 +select f1 from t1 where 'z' in (1,f1); +f1 +z +select * from t1 where 'z' in (f2,f1); +f1 f2 +z 2 +select * from t1 where 1 in (f2,f1); +f1 f2 +1 0 +a 1 +drop table t1; |