diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-01-22 12:31:32 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-03-13 12:07:47 +0100 |
| commit | 7aa09a5ed2480f2459d52833772bb5b7677c2add (patch) | |
| tree | 5e80c81104489f93296871be0225028000a823b5 /mysql-test/suite/archive | |
| parent | a4652c3b1a2a366065dbac3a7570e3cac09870ad (diff) | |
| download | mariadb-git-7aa09a5ed2480f2459d52833772bb5b7677c2add.tar.gz | |
MDEV-10141: Add support for INTERSECT (and common parts for EXCEPT)
MDEV-10140: Add support for EXCEPT
Diffstat (limited to 'mysql-test/suite/archive')
| -rw-r--r-- | mysql-test/suite/archive/archive_gis.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/archive/archive_gis.result b/mysql-test/suite/archive/archive_gis.result index 6ee50fd3b85..71cdb72e4ce 100644 --- a/mysql-test/suite/archive/archive_gis.result +++ b/mysql-test/suite/archive/archive_gis.result @@ -507,8 +507,8 @@ down3,left3,right3,up3 SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS equals FROM t1 a1 JOIN t1 a2 ON Equals( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; equals center -SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS intersect FROM t1 a1 JOIN t1 a2 ON Intersects( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; -intersect +SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS intersects FROM t1 a1 JOIN t1 a2 ON Intersects( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; +intersects big,center,down,down2,left,left2,right,right2,small,up,up2 SELECT GROUP_CONCAT(a2.name ORDER BY a2.name) AS overlaps FROM t1 a1 JOIN t1 a2 ON Overlaps( a1.square, a2.square) WHERE a1.name = "center" GROUP BY a1.name; overlaps |