summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2018-09-16 10:22:32 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2018-09-16 10:22:32 +0400
commite89b611dc9535183d617391c4d1229f0bca66d31 (patch)
treea1cfac73b56fd51e901fd9e58ecc203e0cd31e22 /mysql-test
parent7419f72b7183e40a24cd53a139b78aeaf41503d2 (diff)
downloadmariadb-git-e89b611dc9535183d617391c4d1229f0bca66d31.tar.gz
MDEV-16050 cte + geometry functions lead to crash.
Structures based on Gcalc_dyn_list need to be treated properly when copied in Item::get_copy().
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/gis-precise.result3
-rw-r--r--mysql-test/t/gis-precise.test4
2 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/gis-precise.result b/mysql-test/r/gis-precise.result
index 89e5c237413..56c9472bd73 100644
--- a/mysql-test/r/gis-precise.result
+++ b/mysql-test/r/gis-precise.result
@@ -505,6 +505,9 @@ GEOMETRYFROMTEXT('POINT(4599 60359)'),
) as relate_res;
relate_res
0
+with cte1 as( select (st_symdifference(point(1,1),point(1,1))) as a1 ), cte2 as(select 1 as a2) select 1 from cte1 where cte1.a1 < '1';
+1
+1
DROP TABLE IF EXISTS p1;
CREATE PROCEDURE p1(dist DOUBLE, geom TEXT)
BEGIN
diff --git a/mysql-test/t/gis-precise.test b/mysql-test/t/gis-precise.test
index 7391b2114f3..39a35e1c9cf 100644
--- a/mysql-test/t/gis-precise.test
+++ b/mysql-test/t/gis-precise.test
@@ -381,5 +381,9 @@ SELECT ST_RELATE(
'F*FFFF**F'
) as relate_res;
+# MDEV- 16050 cte + geometry functions lead to crash.
+
+with cte1 as( select (st_symdifference(point(1,1),point(1,1))) as a1 ), cte2 as(select 1 as a2) select 1 from cte1 where cte1.a1 < '1';
+
--source include/gis_debug.inc