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
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
