| 1 |
|
| 2 |
--source include/have_binlog_format_row.inc |
| 3 |
|
| 4 |
####################################################################### |
| 5 |
# BUG#13799489: ROWS_QUERY_LOG_EVENTS CORRUPTED IF QUERY LONGER THAN 255 BYTES |
| 6 |
# |
| 7 |
# Check that queries with more than 255 characters are not truncated |
| 8 |
# when stored on Rows_query_log_events. |
| 9 |
SET @@SESSION.BINLOG_ROWS_QUERY_LOG_EVENTS = 1; |
| 10 |
CREATE TABLE t1 (a VARCHAR(256)); |
| 11 |
|
| 12 |
--let $as= `SELECT REPEAT('a', 256)` |
| 13 |
--let $query= INSERT INTO t1 VALUES ('$as') |
| 14 |
|
| 15 |
--let $assert_text= Logged query must match the one issued. |
| 16 |
--let $binlog_file= query_get_value("SHOW MASTER STATUS", File, 1) |
| 17 |
--let $binlog_position= query_get_value("SHOW MASTER STATUS", Position, 1) |
| 18 |
--eval $query |
| 19 |
|
| 20 |
--let $row_number= 3 |
| 21 |
if (`SELECT @@session.binlog_transaction_compression`) |
| 22 |
{ |
| 23 |
--let $row_number= 4 |
| 24 |
} |
| 25 |
--let $logged_query= query_get_value(SHOW BINLOG EVENTS IN "$binlog_file" FROM $binlog_position, Info, $row_number) |
| 26 |
--let $assert_cond= `SELECT "$logged_query" LIKE "%$query"` |
| 27 |
--source include/assert.inc |
| 28 |
|
| 29 |
# Clean up |
| 30 |
DROP TABLE t1; |