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

LP:802400 - mysql help sends unchecked contents to mysqld

    XMLWordPrintable

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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.