innobackupex error with ANSI_QUOTES sql_mode

Bug #1248331 reported by Trevor Meyer on 2013-11-05
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup
High
Alexey Kopytov
2.1
High
Alexey Kopytov
2.2
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:

        mysql_query($_[0], 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS '.
                    'WHERE PLUGIN_NAME LIKE "INNODB_CHANGED_PAGES"')

This is using quotation marks as a string delimiter around the string INNODB_CHANGED_PAGES.

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.

It's a bug in Xtrabackup, not in Percona Server.

no longer affects: percona-server

Confirmed, the query fails with ANSI_QUOTES enabled.

Changed in percona-xtrabackup:
status: New → Confirmed
tags: added: low-hanging-fruit
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers