innobackupex error with ANSI_QUOTES sql_mode
Bug #1248331 reported by
Trevor Meyer
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Alexey Kopytov | ||
| 2.1 |
Fix Released
|
High
|
Alexey Kopytov | ||
| 2.2 |
Fix Released
|
High
|
Alexey Kopytov | ||
Bug Description
In innobackupex script, line 4717 in version 2.1.5 (line 2945 in 2.1.3), we find this command:
This is using quotation marks as a string delimiter around the string INNODB_
This is incompatible with any mysql server with ANSI_QUOTES in the sql_mode configuration.
For those of us who use ANSI_QUOTES, I believe changing the quotes to \' (backslash apostrophe) would do the same thing, but be compatible with any sql mode configuration.
Thank you for your consideration.
Related branches
lp:~akopytov/percona-xtrabackup/bug1248331-2.1
- George Ormond Lorch III (community): Approve (g2)
-
Diff: 30 lines (+13/-2)2 files modifiedinnobackupex.pl (+2/-2)
test/t/bug1248331.sh (+11/-0)
lp:~akopytov/percona-xtrabackup/bug1248331-2.2
- George Ormond Lorch III (community): Approve (g2)
-
Diff: 30 lines (+13/-2)2 files modifiedstorage/innobase/xtrabackup/innobackupex.pl (+2/-2)
storage/innobase/xtrabackup/test/t/bug1248331.sh (+11/-0)
Revision history for this message
| Valerii Kravchuk (valerii-kravchuk) wrote | #1 |
| no longer affects: | percona-server |
Revision history for this message
| Miguel Angel Nieto (miguelangelnieto) wrote | #2 |
| Changed in percona-xtrabackup: | |
| status: | New → Confirmed |
| tags: | added: low-hanging-fruit |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
To post a comment you must log in.
It's a bug in Xtrabackup, not in Percona Server.