MySQL Bugs: #21412: mysql cmdline client allows backslash(es) as delimiter but can't recognize them

Bug #21412	mysql cmdline client allows backslash(es) as delimiter but can't recognize them
Submitted:	2 Aug 2006 15:16	Modified:	14 Dec 2006 5:38
Reporter:	Andrey Hristov
Status:	Closed
Category:	Client	Severity:	S3 (Non-critical)
Version:	5.1\5.0	OS:	Linux (Linux\Windows)
Assigned to:	Bugs System	Target Version:

Description:
Setting of a delimiter like 
- /
- //
- ///
... is allowed but later unusable when sending query to the server.

How to repeat:
mysql> select version();
+------------------------------------+
| version()                          |
+------------------------------------+
| 5.1.12-beta-valgrind-max-debug-log |
+------------------------------------+
1 row in set (0.01 sec)

mysql> delimiter /
mysql> select 1/
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.01 sec)

mysql> delimiter \
mysql> select 1\
    -> \c
mysql> delimiter \\
mysql> select 1 \\
ERROR:
Unknown command '\\'.
    -> \c
mysql> select 1 \\\
ERROR:
Unknown command '\\'.
    -> \c
mysql> select 1 \\\\
ERROR:
Unknown command '\\'.
ERROR:
Unknown command '\\'.
    -> \c
mysql> delimiter \
mysql> select 1\\
ERROR:
Unknown command '\\'.
    -> \c

Suggested fix:
If not possible to use them, then disable any number of backslashes in the delimiter

Thank you for the bug report.

mysql> select version();
+--------------+
| version()    |
+--------------+
| 5.0.25-debug | 
+--------------+
1 row in set (0.02 sec)

mysql> delimiter /
mysql> select 1/
+---+
| 1 |
+---+
| 1 | 
+---+
1 row in set (0.00 sec)

mysql> delimiter \
mysql> select 1\
    -> \c
mysql> delimiter \\
mysql> select 1 \\
ERROR: 
Unknown command '\\'.
    -> \c
mysql>

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12951

ChangeSet@1.2288, 2006-10-02 11:45:48-04:00, jpipes@shakedown.(none) +4 -0
  Fix for Bug #21412 (client allows DELIMITER with backslash character)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13098

ChangeSet@1.2323, 2006-10-04 19:45:31-04:00, jpipes@shakedown.(none) +3 -0
  Bug #21412: mysql cmdline client allows backslashes 
  as delimiter but can't recognize them
  
  Added checks in client/mysql.cc for get_one_option() and com_delimiter() to ensure
  a backslash could not be used in the delimiter string.

Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix for 5.0.32 and 5.1.15.