diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-11-29 14:51:22 +0100 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-11-29 14:51:22 +0100 |
| commit | 50c5e11258dcfbbd88beac97d9732145a5e5023f (patch) | |
| tree | a3cdfefeb01968bd2c10d22790bb528b5fea6469 /mysql-test/r/func_in.result | |
| parent | 3e0d5bc27aa88da7539d996efc3a15636d5c4bda (diff) | |
| download | mariadb-git-50c5e11258dcfbbd88beac97d9732145a5e5023f.tar.gz | |
func_in.result, group_min_max.result:
merged 5.0 testcases
mysql-test/r/func_in.result:
merged 5.0 testcases
mysql-test/r/group_min_max.result:
merged 5.0 testcases
Diffstat (limited to 'mysql-test/r/func_in.result')
| -rw-r--r-- | mysql-test/r/func_in.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_in.result b/mysql-test/r/func_in.result index b88e5a66f96..e056e3f589e 100644 --- a/mysql-test/r/func_in.result +++ b/mysql-test/r/func_in.result @@ -349,16 +349,22 @@ select f1 from t1 where f1 in ('a',1); f1 a 1 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'b' select f1, case f1 when 'a' then '+' when 1 then '-' end from t1; f1 case f1 when 'a' then '+' when 1 then '-' end a + b NULL 1 - +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'b' create index t1f1_idx on t1(f1); select f1 from t1 where f1 in ('a',1); f1 1 a +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'b' explain select f1 from t1 where f1 in ('a',1); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL t1f1_idx 2 NULL 3 Using where; Using index @@ -372,6 +378,9 @@ id select_type table type possible_keys key key_len ref rows Extra select f1 from t1 where f1 in (2,1); f1 1 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'a' +Warning 1292 Truncated incorrect DOUBLE value: 'b' explain select f1 from t1 where f1 in (2,1); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index t1f1_idx t1f1_idx 2 NULL 3 Using where; Using index |