diff options
| author | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2017-06-27 16:34:36 +0300 |
|---|---|---|
| committer | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2017-06-27 16:34:36 +0300 |
| commit | 330792f3c3c5007dd92912b9d1d32da178b5b9fd (patch) | |
| tree | 2137a9bab3d0cf21d771c298379694e504745288 /mysql-test/t/gis.test | |
| parent | 3125ba891292ff16186c105b6780fbadc74421e9 (diff) | |
| parent | 32659db8644504940f8d34835fde8f7b6535f1ee (diff) | |
| download | mariadb-git-330792f3c3c5007dd92912b9d1d32da178b5b9fd.tar.gz | |
Merge branch 'bb-10.1-vicentiu' into 10.1
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index b109b8f6b0c..b7a45418706 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1465,6 +1465,21 @@ DROP VIEW v1; SELECT AsText(g) FROM (SELECT NULL AS g UNION SELECT Point(1,1)) AS t1; --echo # +--echo # MDEV-10306 Wrong results with combination of CONCAT, SUBSTR and CONVERT in subquery +--echo # + +SET @save_optimizer_switch=@@optimizer_switch; +SET optimizer_switch='derived_merge=on'; +CREATE TABLE t1 (x INT, y INT); +INSERT INTO t1 VALUES(0,0); +SELECT LENGTH(t2) c2 FROM (SELECT ST_BUFFER(POINT(x,y), 0) t2 FROM t1) sub; +SELECT LENGTH(CONCAT(t2,'-',t2)) c2 FROM (SELECT ST_BUFFER(POINT(x,y), 0) t2 FROM t1) sub; +SELECT LENGTH(CONCAT(t2,'--',t2)) c2 FROM (SELECT ST_BUFFER(POINT(x,y), 0) t2 FROM t1) sub; +DROP TABLE t1; +SET optimizer_switch=@save_optimizer_switch; + + +--echo # --echo # End 10.0 tests --echo # |