summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_str.result
diff options
context:
space:
mode:
authorVarun Gupta <varunraiko1803@gmail.com>2018-02-21 16:01:50 +0200
committerVarun Gupta <varunraiko1803@gmail.com>2018-02-21 16:01:50 +0200
commitdbbaaff0fbce203e8c785179b1c559f82f869a69 (patch)
tree7c2f7b683ecf5de051b53cf2bbc97560a4e63c9e /mysql-test/r/func_str.result
parent5df9e8de638bcb0c0c877a56e01ae5c59062249a (diff)
downloadmariadb-git-10.3-MDEV-7773.tar.gz
MDEV-15253:Default optimizer setting changes for MariaDB 10.310.3-MDEV-7773
Milestone 1: raising join_cache_level to 4 from 2
Diffstat (limited to 'mysql-test/r/func_str.result')
-rw-r--r--mysql-test/r/func_str.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index 2b376373f51..05c5e839004 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -1204,9 +1204,9 @@ SELECT t1.id, CONCAT_WS('->', t3.title, t2.title, t1.title) as col1
FROM t1 LEFT JOIN t1 AS t2 ON t1.pc=t2.id
LEFT JOIN t1 AS t3 ON t2.pc=t3.id;
id col1
-1 Main
2 Main->Toys
3 Main->Games
+1 Main
SELECT t1.id, CONCAT_WS('->', t3.title, t2.title, t1.title) as col1
FROM t1 LEFT JOIN t1 AS t2 ON t1.pc=t2.id
LEFT JOIN t1 AS t3 ON t2.pc=t3.id