Merge lp:~laurynas-biveinis/percona-server/bug1280875-5.5 into lp:percona-server/5.5
- bug1280875-5.5
- Merge into 5.5
Proposed by
Laurynas Biveinis
| Status: | Merged |
|---|---|
| Approved by: | Laurynas Biveinis |
| Approved revision: | no longer in the source branch. |
| Merged at revision: | 686 |
| Proposed branch: | lp:~laurynas-biveinis/percona-server/bug1280875-5.5 |
| Merge into: | lp:percona-server/5.5 |
| Diff against target: |
342 lines (+58/-58) 2 files modified
mysql-test/suite/rpl/r/rpl_mdev382.result (+41/-41) mysql-test/suite/rpl/t/rpl_mdev382.test (+17/-17) |
| To merge this branch: | bzr merge lp:~laurynas-biveinis/percona-server/bug1280875-5.5 |
| Related bugs: |
| Reviewer | Review Type | Date Requested | Status |
|---|---|---|---|
| Laurynas Biveinis (community) | Approve | ||
|
Review via email:
|
|||
Commit message
Description of the change
To post a comment you must log in.
Revision history for this message
| Laurynas Biveinis (laurynas-biveinis) : | # |
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
| 1 | === modified file 'mysql-test/suite/rpl/r/rpl_mdev382.result' | |||
| 2 | --- mysql-test/suite/rpl/r/rpl_mdev382.result 2013-06-26 07:01:13 +0000 | |||
| 3 | +++ mysql-test/suite/rpl/r/rpl_mdev382.result 2014-07-29 07:39:09 +0000 | |||
| 4 | @@ -77,8 +77,8 @@ | |||
| 5 | 77 | master-bin.000001 # Xid # # COMMIT /* XID */ | 77 | master-bin.000001 # Xid # # COMMIT /* XID */ |
| 6 | 78 | *** Test correct USE statement in SHOW BINLOG EVENTS *** | 78 | *** Test correct USE statement in SHOW BINLOG EVENTS *** |
| 7 | 79 | set sql_mode = 'ANSI_QUOTES'; | 79 | set sql_mode = 'ANSI_QUOTES'; |
| 10 | 80 | CREATE DATABASE "db1`; SELECT 'oops!'"; | 80 | CREATE DATABASE "db1`; select 'oops!'"; |
| 11 | 81 | use "db1`; SELECT 'oops!'"; | 81 | use "db1`; select 'oops!'"; |
| 12 | 82 | CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM; | 82 | CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM; |
| 13 | 83 | INSERT INTO t1 VALUES (1); | 83 | INSERT INTO t1 VALUES (1); |
| 14 | 84 | set sql_mode = ''; | 84 | set sql_mode = ''; |
| 15 | @@ -86,41 +86,41 @@ | |||
| 16 | 86 | set sql_mode = 'ANSI_QUOTES'; | 86 | set sql_mode = 'ANSI_QUOTES'; |
| 17 | 87 | show binlog events from <binlog_start>; | 87 | show binlog events from <binlog_start>; |
| 18 | 88 | Log_name Pos Event_type Server_id End_log_pos Info | 88 | Log_name Pos Event_type Server_id End_log_pos Info |
| 21 | 89 | master-bin.000001 # Query # # CREATE DATABASE "db1`; SELECT 'oops!'" | 89 | master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" |
| 22 | 90 | master-bin.000001 # Query # # use "db1`; SELECT 'oops!'"; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM | 90 | master-bin.000001 # Query # # use "db1`; select 'oops!'"; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM |
| 23 | 91 | master-bin.000001 # Query # # BEGIN | 91 | master-bin.000001 # Query # # BEGIN |
| 25 | 92 | master-bin.000001 # Query # # use "db1`; SELECT 'oops!'"; INSERT INTO t1 VALUES (1) | 92 | master-bin.000001 # Query # # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (1) |
| 26 | 93 | master-bin.000001 # Query # # COMMIT | 93 | master-bin.000001 # Query # # COMMIT |
| 27 | 94 | master-bin.000001 # Query # # BEGIN | 94 | master-bin.000001 # Query # # BEGIN |
| 29 | 95 | master-bin.000001 # Query # # use "db1`; SELECT 'oops!'"; INSERT INTO t1 VALUES (2) | 95 | master-bin.000001 # Query # # use "db1`; select 'oops!'"; INSERT INTO t1 VALUES (2) |
| 30 | 96 | master-bin.000001 # Query # # COMMIT | 96 | master-bin.000001 # Query # # COMMIT |
| 31 | 97 | set sql_mode = ''; | 97 | set sql_mode = ''; |
| 32 | 98 | set sql_quote_show_create = 0; | 98 | set sql_quote_show_create = 0; |
| 33 | 99 | show binlog events from <binlog_start>; | 99 | show binlog events from <binlog_start>; |
| 34 | 100 | Log_name Pos Event_type Server_id End_log_pos Info | 100 | Log_name Pos Event_type Server_id End_log_pos Info |
| 37 | 101 | master-bin.000001 # Query # # CREATE DATABASE "db1`; SELECT 'oops!'" | 101 | master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" |
| 38 | 102 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM | 102 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM |
| 39 | 103 | master-bin.000001 # Query # # BEGIN | 103 | master-bin.000001 # Query # # BEGIN |
| 41 | 104 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (1) | 104 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) |
| 42 | 105 | master-bin.000001 # Query # # COMMIT | 105 | master-bin.000001 # Query # # COMMIT |
| 43 | 106 | master-bin.000001 # Query # # BEGIN | 106 | master-bin.000001 # Query # # BEGIN |
| 45 | 107 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (2) | 107 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) |
| 46 | 108 | master-bin.000001 # Query # # COMMIT | 108 | master-bin.000001 # Query # # COMMIT |
| 47 | 109 | set sql_quote_show_create = 1; | 109 | set sql_quote_show_create = 1; |
| 48 | 110 | show binlog events from <binlog_start>; | 110 | show binlog events from <binlog_start>; |
| 49 | 111 | Log_name Pos Event_type Server_id End_log_pos Info | 111 | Log_name Pos Event_type Server_id End_log_pos Info |
| 52 | 112 | master-bin.000001 # Query # # CREATE DATABASE "db1`; SELECT 'oops!'" | 112 | master-bin.000001 # Query # # CREATE DATABASE "db1`; select 'oops!'" |
| 53 | 113 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM | 113 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM |
| 54 | 114 | master-bin.000001 # Query # # BEGIN | 114 | master-bin.000001 # Query # # BEGIN |
| 56 | 115 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (1) | 115 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (1) |
| 57 | 116 | master-bin.000001 # Query # # COMMIT | 116 | master-bin.000001 # Query # # COMMIT |
| 58 | 117 | master-bin.000001 # Query # # BEGIN | 117 | master-bin.000001 # Query # # BEGIN |
| 60 | 118 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (2) | 118 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (2) |
| 61 | 119 | master-bin.000001 # Query # # COMMIT | 119 | master-bin.000001 # Query # # COMMIT |
| 62 | 120 | DROP TABLE t1; | 120 | DROP TABLE t1; |
| 63 | 121 | use test; | 121 | use test; |
| 64 | 122 | ***Test LOAD DATA INFILE with various identifiers that need correct quoting *** | 122 | ***Test LOAD DATA INFILE with various identifiers that need correct quoting *** |
| 66 | 123 | use `db1``; SELECT 'oops!'`; | 123 | use `db1``; select 'oops!'`; |
| 67 | 124 | set timestamp=1000000000; | 124 | set timestamp=1000000000; |
| 68 | 125 | CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), | 125 | CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), |
| 69 | 126 | `c``3` VARCHAR(7)); | 126 | `c``3` VARCHAR(7)); |
| 70 | @@ -134,32 +134,32 @@ | |||
| 71 | 134 | truncate `t``1`; | 134 | truncate `t``1`; |
| 72 | 135 | use test; | 135 | use test; |
| 73 | 136 | LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f''le.txt' | 136 | LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f''le.txt' |
| 75 | 137 | INTO TABLE `db1``; SELECT 'oops!'`.`t``1` | 137 | INTO TABLE `db1``; select 'oops!'`.`t``1` |
| 76 | 138 | FIELDS TERMINATED BY ',' ESCAPED BY '\\' ENCLOSED BY '''' | 138 | FIELDS TERMINATED BY ',' ESCAPED BY '\\' ENCLOSED BY '''' |
| 77 | 139 | LINES TERMINATED BY '\n' | 139 | LINES TERMINATED BY '\n' |
| 78 | 140 | (`a``1`, `b``2`) SET `c``3` = concat('|', "b""a'z", "!"); | 140 | (`a``1`, `b``2`) SET `c``3` = concat('|', "b""a'z", "!"); |
| 80 | 141 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 141 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 81 | 142 | a`1 b`2 c`3 | 142 | a`1 b`2 c`3 |
| 82 | 143 | fo\o bar |b"a'z! | 143 | fo\o bar |b"a'z! |
| 83 | 144 | show binlog events from <binlog_start>; | 144 | show binlog events from <binlog_start>; |
| 84 | 145 | Log_name Pos Event_type Server_id End_log_pos Info | 145 | Log_name Pos Event_type Server_id End_log_pos Info |
| 86 | 146 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), | 146 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), |
| 87 | 147 | `c``3` VARCHAR(7)) | 147 | `c``3` VARCHAR(7)) |
| 88 | 148 | master-bin.000001 # Query # # BEGIN | 148 | master-bin.000001 # Query # # BEGIN |
| 89 | 149 | master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# | 149 | master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# |
| 91 | 150 | master-bin.000001 # Execute_load_query # # use `db1``; SELECT 'oops!'`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, @`b```) SET `b``2`= @`b```, `c``3`= concat('|', "b""a'z", "!") ;file_id=# | 150 | master-bin.000001 # Execute_load_query # # use `db1``; select 'oops!'`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, @`b```) SET `b``2`= @`b```, `c``3`= concat('|', "b""a'z", "!") ;file_id=# |
| 92 | 151 | master-bin.000001 # Xid # # COMMIT /* XID */ | 151 | master-bin.000001 # Xid # # COMMIT /* XID */ |
| 94 | 152 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; truncate `t``1` | 152 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; truncate `t``1` |
| 95 | 153 | master-bin.000001 # Query # # BEGIN | 153 | master-bin.000001 # Query # # BEGIN |
| 96 | 154 | master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# | 154 | master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=# |
| 98 | 155 | master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `db1``; SELECT 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") ;file_id=# | 155 | master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/tmp/f\'le.txt' INTO TABLE `db1``; select 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") ;file_id=# |
| 99 | 156 | master-bin.000001 # Xid # # COMMIT /* XID */ | 156 | master-bin.000001 # Xid # # COMMIT /* XID */ |
| 100 | 157 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; | 157 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 101 | 158 | /*!40019 SET @@session.max_insert_delayed_threads=0*/; | 158 | /*!40019 SET @@session.max_insert_delayed_threads=0*/; |
| 102 | 159 | /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; | 159 | /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 103 | 160 | DELIMITER /*!*/; | 160 | DELIMITER /*!*/; |
| 104 | 161 | ROLLBACK/*!*/; | 161 | ROLLBACK/*!*/; |
| 106 | 162 | use `db1``; SELECT 'oops!'`/*!*/; | 162 | use `db1``; select 'oops!'`/*!*/; |
| 107 | 163 | SET TIMESTAMP=1000000000/*!*/; | 163 | SET TIMESTAMP=1000000000/*!*/; |
| 108 | 164 | SET @@session.pseudo_thread_id=999999999/*!*/; | 164 | SET @@session.pseudo_thread_id=999999999/*!*/; |
| 109 | 165 | SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; | 165 | SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; |
| 110 | @@ -187,7 +187,7 @@ | |||
| 111 | 187 | /*!*/; | 187 | /*!*/; |
| 112 | 188 | use `test`/*!*/; | 188 | use `test`/*!*/; |
| 113 | 189 | SET TIMESTAMP=1000000000/*!*/; | 189 | SET TIMESTAMP=1000000000/*!*/; |
| 115 | 190 | LOAD DATA LOCAL INFILE '<name>' INTO TABLE `db1``; SELECT 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") | 190 | LOAD DATA LOCAL INFILE '<name>' INTO TABLE `db1``; select 'oops!'`.`t``1` FIELDS TERMINATED BY ',' ENCLOSED BY '\'' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a``1`, `b``2`) SET `c``3`= concat('|', "b""a'z", "!") |
| 116 | 191 | /*!*/; | 191 | /*!*/; |
| 117 | 192 | COMMIT/*!*/; | 192 | COMMIT/*!*/; |
| 118 | 193 | DELIMITER ; | 193 | DELIMITER ; |
| 119 | @@ -195,10 +195,10 @@ | |||
| 120 | 195 | ROLLBACK /* added by mysqlbinlog */; | 195 | ROLLBACK /* added by mysqlbinlog */; |
| 121 | 196 | /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; | 196 | /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
| 122 | 197 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; | 197 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 124 | 198 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 198 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 125 | 199 | a`1 b`2 c`3 | 199 | a`1 b`2 c`3 |
| 126 | 200 | fo\o bar |b"a'z! | 200 | fo\o bar |b"a'z! |
| 128 | 201 | DROP TABLE `db1``; SELECT 'oops!'`.`t``1`; | 201 | DROP TABLE `db1``; select 'oops!'`.`t``1`; |
| 129 | 202 | drop table t1,t2; | 202 | drop table t1,t2; |
| 130 | 203 | *** Test truncation of long SET expression in LOAD DATA *** | 203 | *** Test truncation of long SET expression in LOAD DATA *** |
| 131 | 204 | CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(1000)); | 204 | CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(1000)); |
| 132 | @@ -221,7 +221,7 @@ | |||
| 133 | 221 | 2 A| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|A | 221 | 2 A| 123456789A123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M123456789N123456789O123456789P123456789Q123456789R123456789123456789T123456789U123456789V123456789W123456789X123456789Y123456789Z123456789|A |
| 134 | 222 | DROP TABLE t1; | 222 | DROP TABLE t1; |
| 135 | 223 | *** Test user variables whose names require correct quoting *** | 223 | *** Test user variables whose names require correct quoting *** |
| 137 | 224 | use `db1``; SELECT 'oops!'`; | 224 | use `db1``; select 'oops!'`; |
| 138 | 225 | CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)); | 225 | CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)); |
| 139 | 226 | INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)); | 226 | INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)); |
| 140 | 227 | SELECT @`a``1`:=a1, @`a``2`:=a2, @`a``3`:=a3, @`a``4`:=a4, @`b```:=b, @```c`:=c, @```d```:=d FROM t1; | 227 | SELECT @`a``1`:=a1, @`a``2`:=a2, @`a``3`:=a3, @`a``4`:=a4, @`b```:=b, @```c`:=c, @```d```:=d FROM t1; |
| 141 | @@ -230,9 +230,9 @@ | |||
| 142 | 230 | INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)); | 230 | INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)); |
| 143 | 231 | show binlog events from <binlog_start>; | 231 | show binlog events from <binlog_start>; |
| 144 | 232 | Log_name Pos Event_type Server_id End_log_pos Info | 232 | Log_name Pos Event_type Server_id End_log_pos Info |
| 146 | 233 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)) | 233 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)) |
| 147 | 234 | master-bin.000001 # Query # # BEGIN | 234 | master-bin.000001 # Query # # BEGIN |
| 149 | 235 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)) | 235 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)) |
| 150 | 236 | master-bin.000001 # Xid # # COMMIT /* XID */ | 236 | master-bin.000001 # Xid # # COMMIT /* XID */ |
| 151 | 237 | master-bin.000001 # Query # # BEGIN | 237 | master-bin.000001 # Query # # BEGIN |
| 152 | 238 | master-bin.000001 # User var # # @`a``1`=-9223372036854775808 | 238 | master-bin.000001 # User var # # @`a``1`=-9223372036854775808 |
| 153 | @@ -242,14 +242,14 @@ | |||
| 154 | 242 | master-bin.000001 # User var # # @`b```=-1.234560123456789e125 | 242 | master-bin.000001 # User var # # @`b```=-1.234560123456789e125 |
| 155 | 243 | master-bin.000001 # User var # # @```c`=-1234501234567890123456789012345678901234567890123456789.0123456789 | 243 | master-bin.000001 # User var # # @```c`=-1234501234567890123456789012345678901234567890123456789.0123456789 |
| 156 | 244 | master-bin.000001 # User var # # @```d```=_latin1 0x78787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878 COLLATE latin1_swedish_ci | 244 | master-bin.000001 # User var # # @```d```=_latin1 0x78787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878787878 COLLATE latin1_swedish_ci |
| 158 | 245 | master-bin.000001 # Query # # use `db1``; SELECT 'oops!'`; INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)) | 245 | master-bin.000001 # Query # # use `db1``; select 'oops!'`; INSERT INTO t1 VALUES (@`a``1`+1, @`a``2`*100, @`a``3`-1, @`a``4`-1, @`b```/2, @```c`, substr(@```d```, 2, 98)) |
| 159 | 246 | master-bin.000001 # Xid # # COMMIT /* XID */ | 246 | master-bin.000001 # Xid # # COMMIT /* XID */ |
| 160 | 247 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; | 247 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
| 161 | 248 | /*!40019 SET @@session.max_insert_delayed_threads=0*/; | 248 | /*!40019 SET @@session.max_insert_delayed_threads=0*/; |
| 162 | 249 | /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; | 249 | /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
| 163 | 250 | DELIMITER /*!*/; | 250 | DELIMITER /*!*/; |
| 164 | 251 | ROLLBACK/*!*/; | 251 | ROLLBACK/*!*/; |
| 166 | 252 | use `db1``; SELECT 'oops!'`/*!*/; | 252 | use `db1``; select 'oops!'`/*!*/; |
| 167 | 253 | SET TIMESTAMP=1000000000/*!*/; | 253 | SET TIMESTAMP=1000000000/*!*/; |
| 168 | 254 | SET @@session.pseudo_thread_id=999999999/*!*/; | 254 | SET @@session.pseudo_thread_id=999999999/*!*/; |
| 169 | 255 | SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; | 255 | SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; |
| 170 | @@ -287,44 +287,44 @@ | |||
| 171 | 287 | ROLLBACK /* added by mysqlbinlog */; | 287 | ROLLBACK /* added by mysqlbinlog */; |
| 172 | 288 | /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; | 288 | /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
| 173 | 289 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; | 289 | /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
| 175 | 290 | SELECT * FROM `db1``; SELECT 'oops!'`.t1 ORDER BY a1; | 290 | SELECT * FROM `db1``; select 'oops!'`.t1 ORDER BY a1; |
| 176 | 291 | a1 a2 a3 a4 b c d | 291 | a1 a2 a3 a4 b c d |
| 177 | 292 | -9223372036854775808 42 9223372036854775807 18446744073709551615 -1.234560123456789e125 -1234501234567890123456789012345678901234567890123456789.0123456789 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | 292 | -9223372036854775808 42 9223372036854775807 18446744073709551615 -1.234560123456789e125 -1234501234567890123456789012345678901234567890123456789.0123456789 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| 178 | 293 | -9223372036854775807 4200 9223372036854775806 18446744073709551614 -6.172800617283945e124 -1234501234567890123456789012345678901234567890123456789.0123456789 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | 293 | -9223372036854775807 4200 9223372036854775806 18446744073709551614 -6.172800617283945e124 -1234501234567890123456789012345678901234567890123456789.0123456789 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |
| 179 | 294 | DROP TABLE t1; | 294 | DROP TABLE t1; |
| 180 | 295 | *** Test correct quoting in foreign key error message *** | 295 | *** Test correct quoting in foreign key error message *** |
| 182 | 296 | use `db1``; SELECT 'oops!'`; | 296 | use `db1``; select 'oops!'`; |
| 183 | 297 | CREATE TABLE `t``1` ( `a``` INT PRIMARY KEY) ENGINE=innodb; | 297 | CREATE TABLE `t``1` ( `a``` INT PRIMARY KEY) ENGINE=innodb; |
| 184 | 298 | CREATE TABLE `t``2` ( `b``` INT PRIMARY KEY, `c``` INT NOT NULL, | 298 | CREATE TABLE `t``2` ( `b``` INT PRIMARY KEY, `c``` INT NOT NULL, |
| 185 | 299 | FOREIGN KEY fk (`c```) REFERENCES `t``1`(`a```)) ENGINE=innodb; | 299 | FOREIGN KEY fk (`c```) REFERENCES `t``1`(`a```)) ENGINE=innodb; |
| 186 | 300 | TRUNCATE `t``1`; | 300 | TRUNCATE `t``1`; |
| 188 | 301 | ERROR 42000: Cannot truncate a table referenced in a foreign key constraint (`db1``; SELECT 'oops!'`.`t``2`, CONSTRAINT `t``INNODB_FOREIGN_KEY_NAME` FOREIGN KEY (`c```) REFERENCES `db1``; SELECT 'oops!'`.`t``1` (`a```)) | 301 | ERROR 42000: Cannot truncate a table referenced in a foreign key constraint (`db1``; select 'oops!'`.`t``2`, CONSTRAINT `t``INNODB_FOREIGN_KEY_NAME` FOREIGN KEY (`c```) REFERENCES `db1``; select 'oops!'`.`t``1` (`a```)) |
| 189 | 302 | DROP TABLE `t``2`; | 302 | DROP TABLE `t``2`; |
| 190 | 303 | DROP TABLE `t``1`; | 303 | DROP TABLE `t``1`; |
| 191 | 304 | *** Test correct quoting of DELETE FROM statement binlogged for HEAP table that is emptied due to server restart | 304 | *** Test correct quoting of DELETE FROM statement binlogged for HEAP table that is emptied due to server restart |
| 192 | 305 | include/stop_slave.inc | 305 | include/stop_slave.inc |
| 196 | 306 | CREATE TABLE `db1``; SELECT 'oops!'`.`t``1` (`a``` INT PRIMARY KEY) ENGINE=heap; | 306 | CREATE TABLE `db1``; select 'oops!'`.`t``1` (`a``` INT PRIMARY KEY) ENGINE=heap; |
| 197 | 307 | INSERT INTO `db1``; SELECT 'oops!'`.`t``1` VALUES (1), (2), (5); | 307 | INSERT INTO `db1``; select 'oops!'`.`t``1` VALUES (1), (2), (5); |
| 198 | 308 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1` ORDER BY 1; | 308 | SELECT * FROM `db1``; select 'oops!'`.`t``1` ORDER BY 1; |
| 199 | 309 | a` | 309 | a` |
| 200 | 310 | 1 | 310 | 1 |
| 201 | 311 | 2 | 311 | 2 |
| 202 | 312 | 5 | 312 | 5 |
| 203 | 313 | set timestamp=1000000000; | 313 | set timestamp=1000000000; |
| 204 | 314 | # The table should be empty on the master. | 314 | # The table should be empty on the master. |
| 206 | 315 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 315 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 207 | 316 | a` | 316 | a` |
| 208 | 317 | # The DELETE statement should be correctly quoted | 317 | # The DELETE statement should be correctly quoted |
| 209 | 318 | show binlog events in 'master-bin.000002' from <binlog_start>; | 318 | show binlog events in 'master-bin.000002' from <binlog_start>; |
| 210 | 319 | Log_name Pos Event_type Server_id End_log_pos Info | 319 | Log_name Pos Event_type Server_id End_log_pos Info |
| 211 | 320 | master-bin.000002 # Query # # BEGIN | 320 | master-bin.000002 # Query # # BEGIN |
| 213 | 321 | master-bin.000002 # Query # # use `test`; DELETE FROM `db1``; SELECT 'oops!'`.`t``1` | 321 | master-bin.000002 # Query # # use `test`; DELETE FROM `db1``; select 'oops!'`.`t``1` |
| 214 | 322 | master-bin.000002 # Query # # COMMIT | 322 | master-bin.000002 # Query # # COMMIT |
| 215 | 323 | include/start_slave.inc | 323 | include/start_slave.inc |
| 216 | 324 | # The table should be empty on the slave also. | 324 | # The table should be empty on the slave also. |
| 218 | 325 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 325 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 219 | 326 | a` | 326 | a` |
| 221 | 327 | DROP TABLE `db1``; SELECT 'oops!'`.`t``1`; | 327 | DROP TABLE `db1``; select 'oops!'`.`t``1`; |
| 222 | 328 | use test; | 328 | use test; |
| 224 | 329 | DROP DATABASE `db1``; SELECT 'oops!'`; | 329 | DROP DATABASE `db1``; select 'oops!'`; |
| 225 | 330 | include/rpl_end.inc | 330 | include/rpl_end.inc |
| 226 | 331 | 331 | ||
| 227 | === modified file 'mysql-test/suite/rpl/t/rpl_mdev382.test' | |||
| 228 | --- mysql-test/suite/rpl/t/rpl_mdev382.test 2013-06-26 07:01:13 +0000 | |||
| 229 | +++ mysql-test/suite/rpl/t/rpl_mdev382.test 2014-07-29 07:39:09 +0000 | |||
| 230 | @@ -64,8 +64,8 @@ | |||
| 231 | 64 | connection master; | 64 | connection master; |
| 232 | 65 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); | 65 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); |
| 233 | 66 | set sql_mode = 'ANSI_QUOTES'; | 66 | set sql_mode = 'ANSI_QUOTES'; |
| 236 | 67 | CREATE DATABASE "db1`; SELECT 'oops!'"; | 67 | CREATE DATABASE "db1`; select 'oops!'"; |
| 237 | 68 | use "db1`; SELECT 'oops!'"; | 68 | use "db1`; select 'oops!'"; |
| 238 | 69 | CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM; | 69 | CREATE TABLE t1 (a INT PRIMARY KEY) engine=MyISAM; |
| 239 | 70 | INSERT INTO t1 VALUES (1); | 70 | INSERT INTO t1 VALUES (1); |
| 240 | 71 | set sql_mode = ''; | 71 | set sql_mode = ''; |
| 241 | @@ -88,7 +88,7 @@ | |||
| 242 | 88 | 'fo\\o','bar' | 88 | 'fo\\o','bar' |
| 243 | 89 | EOF | 89 | EOF |
| 244 | 90 | 90 | ||
| 246 | 91 | use `db1``; SELECT 'oops!'`; | 91 | use `db1``; select 'oops!'`; |
| 247 | 92 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); | 92 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); |
| 248 | 93 | set timestamp=1000000000; | 93 | set timestamp=1000000000; |
| 249 | 94 | CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), | 94 | CREATE TABLE `t``1` (`a``1` VARCHAR(4) PRIMARY KEY, `b``2` VARCHAR(3), |
| 250 | @@ -105,11 +105,11 @@ | |||
| 251 | 105 | use test; | 105 | use test; |
| 252 | 106 | --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR | 106 | --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR |
| 253 | 107 | eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/f''le.txt' | 107 | eval LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/f''le.txt' |
| 255 | 108 | INTO TABLE `db1``; SELECT 'oops!'`.`t``1` | 108 | INTO TABLE `db1``; select 'oops!'`.`t``1` |
| 256 | 109 | FIELDS TERMINATED BY ',' ESCAPED BY '\\\\' ENCLOSED BY '''' | 109 | FIELDS TERMINATED BY ',' ESCAPED BY '\\\\' ENCLOSED BY '''' |
| 257 | 110 | LINES TERMINATED BY '\\n' | 110 | LINES TERMINATED BY '\\n' |
| 258 | 111 | (`a``1`, `b``2`) SET `c``3` = concat('|', "b""a'z", "!"); | 111 | (`a``1`, `b``2`) SET `c``3` = concat('|', "b""a'z", "!"); |
| 260 | 112 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 112 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 261 | 113 | let $pos2= query_get_value(SHOW MASTER STATUS, Position, 1); | 113 | let $pos2= query_get_value(SHOW MASTER STATUS, Position, 1); |
| 262 | 114 | 114 | ||
| 263 | 115 | --source include/show_binlog_events.inc | 115 | --source include/show_binlog_events.inc |
| 264 | @@ -119,10 +119,10 @@ | |||
| 265 | 119 | 119 | ||
| 266 | 120 | sync_slave_with_master; | 120 | sync_slave_with_master; |
| 267 | 121 | connection slave; | 121 | connection slave; |
| 269 | 122 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 122 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 270 | 123 | connection master; | 123 | connection master; |
| 271 | 124 | 124 | ||
| 273 | 125 | DROP TABLE `db1``; SELECT 'oops!'`.`t``1`; | 125 | DROP TABLE `db1``; select 'oops!'`.`t``1`; |
| 274 | 126 | --remove_file $load_file | 126 | --remove_file $load_file |
| 275 | 127 | 127 | ||
| 276 | 128 | connection master; | 128 | connection master; |
| 277 | @@ -158,7 +158,7 @@ | |||
| 278 | 158 | 158 | ||
| 279 | 159 | 159 | ||
| 280 | 160 | --echo *** Test user variables whose names require correct quoting *** | 160 | --echo *** Test user variables whose names require correct quoting *** |
| 282 | 161 | use `db1``; SELECT 'oops!'`; | 161 | use `db1``; select 'oops!'`; |
| 283 | 162 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); | 162 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); |
| 284 | 163 | CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)); | 163 | CREATE TABLE t1 (a1 BIGINT PRIMARY KEY, a2 BIGINT, a3 BIGINT, a4 BIGINT UNSIGNED, b DOUBLE, c DECIMAL(65,10), d VARCHAR(100)); |
| 285 | 164 | INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)); | 164 | INSERT INTO t1 VALUES (-9223372036854775808,42,9223372036854775807,18446744073709551615,-1234560123456789e110, -1234501234567890123456789012345678901234567890123456789.0123456789, REPEAT("x", 100)); |
| 286 | @@ -172,13 +172,13 @@ | |||
| 287 | 172 | 172 | ||
| 288 | 173 | sync_slave_with_master; | 173 | sync_slave_with_master; |
| 289 | 174 | connection slave; | 174 | connection slave; |
| 291 | 175 | SELECT * FROM `db1``; SELECT 'oops!'`.t1 ORDER BY a1; | 175 | SELECT * FROM `db1``; select 'oops!'`.t1 ORDER BY a1; |
| 292 | 176 | 176 | ||
| 293 | 177 | connection master; | 177 | connection master; |
| 294 | 178 | DROP TABLE t1; | 178 | DROP TABLE t1; |
| 295 | 179 | 179 | ||
| 296 | 180 | --echo *** Test correct quoting in foreign key error message *** | 180 | --echo *** Test correct quoting in foreign key error message *** |
| 298 | 181 | use `db1``; SELECT 'oops!'`; | 181 | use `db1``; select 'oops!'`; |
| 299 | 182 | CREATE TABLE `t``1` ( `a``` INT PRIMARY KEY) ENGINE=innodb; | 182 | CREATE TABLE `t``1` ( `a``` INT PRIMARY KEY) ENGINE=innodb; |
| 300 | 183 | CREATE TABLE `t``2` ( `b``` INT PRIMARY KEY, `c``` INT NOT NULL, | 183 | CREATE TABLE `t``2` ( `b``` INT PRIMARY KEY, `c``` INT NOT NULL, |
| 301 | 184 | FOREIGN KEY fk (`c```) REFERENCES `t``1`(`a```)) ENGINE=innodb; | 184 | FOREIGN KEY fk (`c```) REFERENCES `t``1`(`a```)) ENGINE=innodb; |
| 302 | @@ -197,9 +197,9 @@ | |||
| 303 | 197 | --source include/stop_slave.inc | 197 | --source include/stop_slave.inc |
| 304 | 198 | 198 | ||
| 305 | 199 | connection master; | 199 | connection master; |
| 309 | 200 | CREATE TABLE `db1``; SELECT 'oops!'`.`t``1` (`a``` INT PRIMARY KEY) ENGINE=heap; | 200 | CREATE TABLE `db1``; select 'oops!'`.`t``1` (`a``` INT PRIMARY KEY) ENGINE=heap; |
| 310 | 201 | INSERT INTO `db1``; SELECT 'oops!'`.`t``1` VALUES (1), (2), (5); | 201 | INSERT INTO `db1``; select 'oops!'`.`t``1` VALUES (1), (2), (5); |
| 311 | 202 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1` ORDER BY 1; | 202 | SELECT * FROM `db1``; select 'oops!'`.`t``1` ORDER BY 1; |
| 312 | 203 | 203 | ||
| 313 | 204 | # Restart the master mysqld. | 204 | # Restart the master mysqld. |
| 314 | 205 | # This will cause an implicit truncation of the memory-based table, which will | 205 | # This will cause an implicit truncation of the memory-based table, which will |
| 315 | @@ -230,7 +230,7 @@ | |||
| 316 | 230 | --echo # The table should be empty on the master. | 230 | --echo # The table should be empty on the master. |
| 317 | 231 | let $binlog_file= master-bin.000002; | 231 | let $binlog_file= master-bin.000002; |
| 318 | 232 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); | 232 | let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); |
| 320 | 233 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 233 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 321 | 234 | 234 | ||
| 322 | 235 | --echo # The DELETE statement should be correctly quoted | 235 | --echo # The DELETE statement should be correctly quoted |
| 323 | 236 | --source include/show_binlog_events.inc | 236 | --source include/show_binlog_events.inc |
| 324 | @@ -242,15 +242,15 @@ | |||
| 325 | 242 | sync_slave_with_master; | 242 | sync_slave_with_master; |
| 326 | 243 | connection slave; | 243 | connection slave; |
| 327 | 244 | --echo # The table should be empty on the slave also. | 244 | --echo # The table should be empty on the slave also. |
| 329 | 245 | SELECT * FROM `db1``; SELECT 'oops!'`.`t``1`; | 245 | SELECT * FROM `db1``; select 'oops!'`.`t``1`; |
| 330 | 246 | 246 | ||
| 331 | 247 | connection master; | 247 | connection master; |
| 333 | 248 | DROP TABLE `db1``; SELECT 'oops!'`.`t``1`; | 248 | DROP TABLE `db1``; select 'oops!'`.`t``1`; |
| 334 | 249 | sync_slave_with_master; | 249 | sync_slave_with_master; |
| 335 | 250 | 250 | ||
| 336 | 251 | 251 | ||
| 337 | 252 | connection master; | 252 | connection master; |
| 338 | 253 | use test; | 253 | use test; |
| 340 | 254 | DROP DATABASE `db1``; SELECT 'oops!'`; | 254 | DROP DATABASE `db1``; select 'oops!'`; |
| 341 | 255 | 255 | ||
| 342 | 256 | --source include/rpl_end.inc | 256 | --source include/rpl_end.inc |
