diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-03-26 11:37:18 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-03-26 11:37:18 +0400 |
| commit | 6fbbb0853e7e58621f73f0afc600cd95995413ed (patch) | |
| tree | 5206eecee6f4a398db8a24f7273c08f7d1e7afaa /mysql-test/r/func_group.result | |
| parent | ed643f4bb31d8e5a9c0bc161583b8c9b2a08c26b (diff) | |
| download | mariadb-git-6fbbb0853e7e58621f73f0afc600cd95995413ed.tar.gz | |
MDEV-18968 Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index e0e870d1573..b9875faacb6 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -1979,8 +1979,8 @@ FROM t2); MIN(t2.pk) NULL Warnings: -Warning 1292 Truncated incorrect INTEGER value: 'j' -Warning 1292 Truncated incorrect INTEGER value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' EXPLAIN SELECT MIN(t2.pk) @@ -1993,8 +1993,8 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE 2 MATERIALIZED t2 ALL NULL NULL NULL NULL 2 Warnings: -Warning 1292 Truncated incorrect INTEGER value: 'j' -Warning 1292 Truncated incorrect INTEGER value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' +Warning 1292 Truncated incorrect DOUBLE value: 'j' # # 2) Test that subquery materialization is setup for query with |