Merge lp:~akopytov/percona-xtrabackup/bug1248331-2.1 into lp:percona-xtrabackup/2.1

[Alexey Kopytov]

    Bug #1248331: innobackupex error with ANSI_QUOTES sql_mode

    Replaced double quotes with single ones in the SQL statement issued by
    detect_mysql_capabilities_for_backup().

http://jenkins.percona.com/view/PXB%202.1/job/percona-xtrabackup-2.1-param/507/

[George Ormond Lorch III (gl-az)]

review: Approve (g2)

=== modified file 'innobackupex.pl'
--- innobackupex.pl	2013-11-21 10:08:38 +0000
+++ innobackupex.pl	2013-12-29 19:11:28 +0000
@@ -4807,8 +4807,8 @@
 #
 sub detect_mysql_capabilities_for_backup {
     $have_changed_page_bitmaps =
-        mysql_query($_[0], 'SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS '.
-                    'WHERE PLUGIN_NAME LIKE "INNODB_CHANGED_PAGES"')
+        mysql_query($_[0], "SELECT COUNT(*) FROM INFORMATION_SCHEMA.PLUGINS ".
+                    "WHERE PLUGIN_NAME LIKE 'INNODB_CHANGED_PAGES'");
 }
 
 =pod

=== added file 'test/t/bug1248331.sh'
--- test/t/bug1248331.sh	1970-01-01 00:00:00 +0000
+++ test/t/bug1248331.sh	2013-12-29 19:11:28 +0000
@@ -0,0 +1,11 @@
+########################################################################
+# Bug #1248331: innobackupex error with ANSI_QUOTES sql_mode
+########################################################################
+
+ib_inc_extra_args=
+
+MYSQLD_EXTRA_MY_CNF_OPTS="
+sql_mode=\"ANSI_QUOTES\"
+"
+
+. inc/ib_incremental_common.sh