innobackupex error with ANSI_QUOTES sql_mode

Bug #1248331 reported by Trevor Meyer on 2013-11-05
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to
Fix Released
Alexey Kopytov
Fix Released
Alexey Kopytov
Fix Released
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 '.

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.

Related branches

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

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers