Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14619

VIEW and GROUP_CONCAT

    XMLWordPrintable

    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: