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

LP:802400 - mysql help sends unchecked contents to mysqld

    Details

      Description

      Oracle Bug: #12615411
      MySQL Bug: #61352

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 1
      Server version: 5.2.7-MariaDB (MariaDB - http://mariadb.com/)
       
      mysql> create table t1 (`id` int(11) auto_increment, `name` varchar(255), primary key (`id`));
      Query OK, 0 rows affected (0.00 sec)
       
      mysql> INSERT INTO t1(`name`) VALUES ('test1'),('test2'),('test3'),('test4');
      Query OK, 4 rows affected (0.00 sec)
      Records: 4  Duplicates: 0  Warnings: 0
       
      mysql> SELECT * FORM t1;
      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 'FORM t1' at line 1
      mysql> SELECT * FROM t1;
      +----+-------+
      | id | name  |
      +----+-------+
      |  1 | test1 |
      |  2 | test2 |
      |  3 | test3 |
      |  4 | test4 |
      +----+-------+
      4 rows in set (0.00 sec)
       
      mysql> DELETE FROM t1 LIMIT 1;
      Query OK, 1 row affected (0.00 sec)
       
      mysql> help 'contents'
      mysql> SELECT * FROM t1;
      +----+-------+
      | id | name  |
      +----+-------+
      |  3 | test3 |
      |  4 | test4 |
      +----+-------+
      2 rows in set (0.00 sec)
       
      mysql> \q
      Bye

      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 2
      Server version: 5.2.7-MariaDB (MariaDB - http://mariadb.com/)
       
      mysql> help 'contents'
      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 'Your MariaDB connection id is 2
      Server version: 5.2.7-MariaDB (MariaDB - http://' at line 1

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                daniëlvaneeden Daniël van Eeden (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: