From 96f4a906cea4f11a70b1f8ffa30f27bfa397095d Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Fri, 11 Sep 2015 23:26:02 +0400 Subject: MDEV-8675 Different results of GIS functions on NULL vs NOT NULL columns --- mysql-test/t/gis.test | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'mysql-test/t/gis.test') diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 60f12a355b4..18cfe95b749 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1518,3 +1518,10 @@ select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'),' select ST_IsRing(NULL); +--echo # +--echo # MDEV-8675 Different results of GIS functions on NULL vs NOT NULL columns +--echo # +CREATE TABLE t1 (g1 GEOMETRY NOT NULL,g2 GEOMETRY NULL); +CREATE TABLE t2 AS SELECT WITHIN(g1,g1) as w1,WITHIN(g2,g2) AS w2 FROM t1; +SHOW CREATE TABLE t2; +DROP TABLE t1,t2; -- cgit v1.2.1