We're updating the issue view to help you get more done. 

LP:802400 - mysql help sends unchecked contents to mysqld

Description

Oracle Bug: #12615411
MySQL Bug: #61352

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 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
1 2 3 4 5 6 7 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

Environment

None

Status

Assignee

Sergei Golubchik

Reporter

Daniël van Eeden

Labels

Fix versions

Priority

Minor