diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-11-06 22:25:39 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-12-12 20:27:23 +0100 |
| commit | 75925f8fc1f395f23965afa0395356c87aeb9139 (patch) | |
| tree | 81586feebeabff933fe760c49ccf52c60e2268f2 /mysql-test/r/gis.result | |
| parent | 75fb3213d3f53dabbcf5399d0ffdf4d9ec79794f (diff) | |
| download | mariadb-git-75925f8fc1f395f23965afa0395356c87aeb9139.tar.gz | |
bugfix: Item_func_spatial_collection::print()
Diffstat (limited to 'mysql-test/r/gis.result')
| -rw-r--r-- | mysql-test/r/gis.result | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index d10cfec6003..04d169c84b6 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -488,7 +488,7 @@ explain extended select issimple(MultiPoint(Point(3, 6), Point(4, 10))), issimpl id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: -Note 1003 select st_issimple(st_multipoint(point(3,6),point(4,10))) AS `issimple(MultiPoint(Point(3, 6), Point(4, 10)))`,st_issimple(point(3,6)) AS `issimple(Point(3, 6))` +Note 1003 select st_issimple(geometrycollection(point(3,6),point(4,10))) AS `issimple(MultiPoint(Point(3, 6), Point(4, 10)))`,st_issimple(point(3,6)) AS `issimple(Point(3, 6))` create table t1 (a geometry not null); insert into t1 values (GeomFromText('Point(1 2)')); insert into t1 values ('Garbage'); @@ -1832,6 +1832,14 @@ DROP TABLE t1,t2; # # Start of 10.2 tests # +create view v1 as select AsWKT(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))); +show create view v1; +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select st_astext(geometrycollection(point(44,6),geometrycollection(point(3,6),point(7,9)))) AS `Name_exp_1` latin1 latin1_swedish_ci +select * from v1; +Name_exp_1 +GEOMETRYCOLLECTION(POINT(44 6),GEOMETRYCOLLECTION(POINT(3 6),POINT(7 9))) +drop view v1; # # MDEV-10134 Add full support for DEFAULT # |