multi-lines queries don't work

Bug #1035217 reported by Aurimas Mikalauskas
This bug affects 6 people
Affects Status Importance Assigned to Milestone
MOVED - Percona Playback
Status tracked in 1.0
Fix Released
Stewart Smith

Bug Description

$ cat log_test
/usr/sbin/mysqld, Version: 5.5.24-55-log (Percona Server (GPL), Release rel26.0, Revision 256). started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 120810 2:52:44.0000084924
# User@Host: root[root] @ localhost []
# Thread_id: 410242 Schema: art78 Last_errno: 0 Killed: 0
# Query_time: 0.030684 Lock_time: 0.000108 Rows_sent: 11 Rows_examined: 11 Rows_affected: 0 Rows_read: 11
# Bytes_sent: 10111 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# InnoDB_trx_id: A70C819B7
SET timestamp=1344581564;
select * from article78
order by id desc limit 11;

$ sudo /usr/local/bin/percona-playback --query-log-file=log_test --query-log-preserve-query-time
Database Plugin: libmysqlclient
Error query: select * from article78

Connection 410242 Rows Sent: 0 != expected 11 for query: select * from article78

Error query: order by id desc limit 11;

Connection 410242 Rows Sent: 0 != expected 11 for query: order by id desc limit 11;

Related branches

Revision history for this message
Frederic Descamps (lefred) wrote :

This is patch seems to solves this issue (at least it does work for me). The patch was initially written by mushu, but it wasn't handling entries like :

; (query with only semicolon)
select * from blah; # comment
select * form blah; /* other comment */

It's the first time I write C++ so please review and comment gently ;-)



Stewart Smith (stewart)
Changed in percona-playback:
importance: Undecided → High
status: New → Triaged
assignee: nobody → Stewart Smith (stewart)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.