diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-11 23:26:02 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-11 23:26:02 +0400 |
| commit | 96f4a906cea4f11a70b1f8ffa30f27bfa397095d (patch) | |
| tree | cb2529837402d74243b675a970e1f8ec47b9a049 /mysql-test/t/gis.test | |
| parent | aaf6334b6492ff915070378a61ed6e97881abfda (diff) | |
| download | mariadb-git-96f4a906cea4f11a70b1f8ffa30f27bfa397095d.tar.gz | |
MDEV-8675 Different results of GIS functions on NULL vs NOT NULL columns
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 7 |
1 files changed, 7 insertions, 0 deletions
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; |