innobackupex fails if SQL_MODE=ANSI_QUOTES
Bug #945161 reported by
Baron Schwartz
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Low
|
Alexey Kopytov | ||
2.0 |
Fix Released
|
Low
|
Alexey Kopytov | ||
2.1 |
Invalid
|
Low
|
Alexey Kopytov |
Bug Description
This code fails with ANSI quotes:
sub get_slave_
my @lines;
mysql_send 'SHOW STATUS LIKE "slave_
file_
It causes this error:
innobackupex: Error: mysql child process has died: ERROR 1064 (42000) at line 7: 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 '"slave_
while waiting for reply to MySQL request: 'SHOW STATUS LIKE "slave_
Related branches
lp:~akopytov/percona-xtrabackup/bug945161-2.0
- Sergei Glushchenko (community): Approve (g2)
-
Diff: 12 lines (+1/-1)1 file modifiedinnobackupex (+1/-1)
lp:~akopytov/percona-xtrabackup/bug945161-2.1
- Sergei Glushchenko (community): Approve (g2)
- Diff: 0 lines
To post a comment you must log in.
It looks like we should explicitly set SQL_MODE so that we don't run into this if SQL_MODE is set globally?