Bug #30563 Is not possible to create rpl_ or innodb test if needed to use ANSI_QUOTES

Description:
Files include/have_innodb.inc and include/have_log_bin.inc contains queries:

show variables like "have_innodb"; and show variables like "log_bin";

So if one needs to start server with sql_mode=ANSI_QUOTES option, she will get error "[ skipped ]   Query 'show variables like "log_bin"' failed, required functionality not supported"

How to repeat:
Create test like below and run it.

$cat rpl_bug27552-master.opt
--sql-mode="PIPES_AS_CONCAT,ANSI_QUOTES,NO_BACKSLASH_ESCAPES"

$cat rpl_bug27552-slave.opt
--sql-mode="PIPES_AS_CONCAT,ANSI_QUOTES,NO_BACKSLASH_ESCAPES"

$cat rpl_bug27552.test
--source include/master-slave.inc
--source include/have_innodb.inc

--disable_warinigs
drop table if exists t1;
--enable_warnings

create table t1(f1 varchar(100)) engine=innodb;

insert into t1 values('abcd''efgh');

select * from t1;

sleep 5;

connection slave;

select * from t1;

--vertical_results
show slave status;

Suggested fix:
Replace " with ' or make this syntax dependant from ANSI_QUOTE sql mode.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49028

2645 Chad MILLER	2008-07-04
      Bug#30563: Is not possible to create rpl_ or innodb test if needed \
      	to use ANSI_QUOTES
      
      Make all have_* tests universally safe by using ANSI quotes.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49128

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/49129

Pushed into 5.0.66

Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080715152926-s5kgnqhtu93b3c8v) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)

Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 5.1.x/6.0.x.

Pushed into 5.1.28  (revid:joerg@mysql.com-20080714105031-88hmr2baz5di9xej) (version source revid:joerg@mysql.com-20080714105031-88hmr2baz5di9xej) (pib:3)

Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 6.0.x.

Pushed in 6.0.7-alpha

Closed without further action per comment from Paul.