Details

      Description

      GROUP_CONCAT with backslash separator doesn't work consistently inside VIEW
      How to repeat:

      mysql> CREATE TABLE test_1 (str text);
      mysql> INSERT INTO `test_1` VALUES ("My"),("SQL");
      mysql> 
      CREATE VIEW my_view AS SELECT GROUP_CONCAT(str  SEPARATOR  '\\') FROM `test_1`
      ;
      Query OK, 0 rows affected (0.01 sec)
       
      mysql> SELECT * FROM my_view;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\\')` from `data`.`test_1`' at line 1
      mysql> SHOW CREATE VIEW my_view;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\\')` from `data`.`test_1`' at line 1
      

      No bug MySql 5.7.19.

        Attachments

          Activity

            People

            • Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              Sergey_W Sergii Volikov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: