diff options
| author | Igor Babaev <igor@askmonty.org> | 2019-02-08 01:07:27 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2019-02-08 01:07:27 -0800 |
| commit | 651347b6c1133e8b666703b75f478a2fb565c73d (patch) | |
| tree | e4b654861d2fd96a763a11813c9cdc11269235ae /mysql-test/main/func_in.result | |
| parent | 6cb2ab53284a64e0f2aba48f458cd4a6028a4639 (diff) | |
| download | mariadb-git-651347b6c1133e8b666703b75f478a2fb565c73d.tar.gz | |
MDEV-16188 Post merge fixes fot TokuDB
Diffstat (limited to 'mysql-test/main/func_in.result')
| -rw-r--r-- | mysql-test/main/func_in.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_in.result b/mysql-test/main/func_in.result index 9a3c1dba045..79f5f555681 100644 --- a/mysql-test/main/func_in.result +++ b/mysql-test/main/func_in.result @@ -717,11 +717,11 @@ id select_type table type possible_keys key key_len ref rows Extra EXPLAIN SELECT * FROM t1 WHERE c_timestamp IN ('2009-09-01 00:00:01', '2009-09-01 00:00:02', '2009-09-01 00:00:03'); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c_timestamp c_timestamp 4 NULL 3 Using index condition +1 SIMPLE t1 ALL c_timestamp NULL NULL NULL 20 Using where EXPLAIN SELECT * FROM t1 WHERE c_timestamp IN (NULL, '2009-09-01 00:00:01', '2009-09-01 00:00:02', '2009-09-01 00:00:03'); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range c_timestamp c_timestamp 4 NULL 3 Using index condition +1 SIMPLE t1 ALL c_timestamp NULL NULL NULL 20 Using where EXPLAIN SELECT * FROM t1 WHERE c_timestamp IN (NULL); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables |