enterprise-support team mailing list archive

[Sveta Smirnova <sveta@xxxxxxxxxxxxx>]

Public bug reported:

Description:
If I run mysqldump with option WHERE, but put part of it on new line resulting output would be invalid SQL:

./bin/mysqldump -uroot -S /tmp/sveta56.sock --where="\
> user='root'" mysql user

...
--
-- Dumping data for table `user`
--
-- WHERE:  
user=root

How to repeat:
./bin/mysqldump -uroot -S /tmp/sveta56.sock --where="\
> user='root'" mysql user

Suggested fix:
Comment parts of WHERE clause even if they are on the new line

** Affects: mysql-server
     Importance: Unknown
         Status: Unknown

** Affects: percona-server
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.5
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.6
     Importance: Undecided
         Status: Confirmed

** Affects: percona-server/5.7
     Importance: Undecided
         Status: Confirmed


** Tags: i69109

** Also affects: percona-server/5.6
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.5
   Importance: Undecided
       Status: New

** Also affects: percona-server/5.7
   Importance: Undecided
       Status: Confirmed

** Changed in: percona-server/5.5
       Status: New => Confirmed

** Changed in: percona-server/5.6
       Status: New => Confirmed

** Bug watch added: MySQL Bug System #81517
   http://bugs.mysql.com/bug.php?id=81517

** Also affects: mysql-server via
   http://bugs.mysql.com/bug.php?id=81517
   Importance: Unknown
       Status: Unknown

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1584021

Title:
  Invalid syntax created if mysqldump run with option --where="NEWLINE
  condition"

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1584021/+subscriptions