| 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: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.0 BK, 5.1 BK | OS: | Any |
| Assigned to: | Chad MILLER | CPU Architecture: | Any |
[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.
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.