Bug #30563 Is not possible to create rpl_ or innodb test if needed to use ANSI_QUOTES
Submitted: 22 Aug 2007 12:50 Modified: 29 Jul 2008 9:58
Reporter: Sveta Smirnova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.0 BK, 5.1 BK OS:Any
Assigned to: Chad MILLER CPU Architecture:Any
Triage: D3 (Medium)

[22 Aug 2007 12:50] Sveta Smirnova
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.
[4 Jul 2008 17:05] Bugs System
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.
[7 Jul 2008 19:59] Bugs System
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
[7 Jul 2008 20:00] Bugs System
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
[9 Jul 2008 13:41] Georgi Kodinov
Pushed into 5.0.66
[28 Jul 2008 13:47] Bugs System
Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080715152926-s5kgnqhtu93b3c8v) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)
[28 Jul 2008 15:36] Paul Dubois
Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 5.1.x/6.0.x.
[28 Jul 2008 16:46] Bugs System
Pushed into 5.1.28  (revid:joerg@mysql.com-20080714105031-88hmr2baz5di9xej) (version source revid:joerg@mysql.com-20080714105031-88hmr2baz5di9xej) (pib:3)
[28 Jul 2008 17:06] Paul Dubois
Test case changes. No changelog entry needed.

Setting report to Patch Queued pending push of fix into 6.0.x.
[29 Jul 2008 9:03] Georgi Kodinov
Pushed in 6.0.7-alpha
[29 Jul 2008 9:58] Jon Stephens
Closed without further action per comment from Paul.