diff options
author | Igor Babaev <igor@askmonty.org> | 2019-02-24 01:55:51 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2019-02-24 01:55:51 -0800 |
commit | 31deef0953a5cf7259e1d064ae7f2e0dde922436 (patch) | |
tree | 48fdd67b2ca3cf88b6a2343a78cc732e2beb5c71 /mysql-test/main/having.result | |
parent | 793f27a046e2c2753dcad8793c75e27f445938fc (diff) | |
download | mariadb-git-31deef0953a5cf7259e1d064ae7f2e0dde922436.tar.gz |
MDEV-18681 Server crashes in embedding_sjm
Do not do substitution for best equal field in HAVING conditions.
It's not needed.
Diffstat (limited to 'mysql-test/main/having.result')
-rw-r--r-- | mysql-test/main/having.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/having.result b/mysql-test/main/having.result index b1cd7765104..dd710db715a 100644 --- a/mysql-test/main/having.result +++ b/mysql-test/main/having.result @@ -847,3 +847,21 @@ t r DROP TABLE t1; DROP FUNCTION next_seq_value; DROP TABLE series; +# End of 10.3 tests +# +# MDEV-18681: AND formula in HAVING with several occurances +# of the same field f in different conjuncts + f=constant +# +CREATE TABLE t1 (pk int, f varchar(1)); +INSERT INTO t1 VALUES (2,'x'), (7,'y'); +CREATE TABLE t2 (pk int); +INSERT INTO t2 VALUES (2), (3); +SELECT t.f +FROM (SELECT t1.* FROM (t1 JOIN t2 ON (t2.pk = t1.pk))) t +HAVING t.f != 112 AND t.f = 'x' AND t.f != 'a'; +f +x +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +DROP TABLE t1,t2; +# End of 10.4 tests |