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/r | |
| 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/r')
| -rw-r--r-- | mysql-test/r/gis.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 0d8f30d125f..9e337f6b5aa 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -1816,3 +1816,15 @@ disjoint select ST_IsRing(NULL); ST_IsRing(NULL) -1 +# +# MDEV-8675 Different results of GIS functions on NULL vs NOT NULL columns +# +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; +Table Create Table +t2 CREATE TABLE `t2` ( + `w1` int(1) DEFAULT NULL, + `w2` int(1) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1,t2; |