From 273591df0c9917a93bc2d695f61d9f35fa7b1f5c Mon Sep 17 00:00:00 2001
From: Oleksandr Byelkin <sanja@sanjaLaptopT>
Date: Sun, 17 Dec 2017 00:01:55 +0100
Subject: MDEV-14619: VIEW and GROUP_CONCAT

Correctly print separator string in single quotes.
---
 mysql-test/t/view.test | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/t')

diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 79991f89683..0fc7cb6adf7 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -5578,6 +5578,18 @@ PREPARE stmt FROM 'REPLACE INTO v2 SELECT a FROM t3';
 drop view v1,v2;
 drop table t3;
 
+--echo #
+--echo # MDEV-14619: VIEW and GROUP_CONCAT
+--echo #
+
+CREATE TABLE t1 (str text);
+INSERT INTO t1 VALUES ("My"),("SQL");
+CREATE VIEW v1 AS SELECT GROUP_CONCAT(str  SEPARATOR  '\\') FROM t1;
+SELECT * FROM v1;
+SHOW CREATE VIEW v1;
+drop view v1;
+drop table t1;
+
 --echo # -----------------------------------------------------------------
 --echo # -- End of 5.5 tests.
 --echo # -----------------------------------------------------------------
-- 
cgit v1.2.1