multi-lines queries don't work

Reported by Aurimas Mikalauskas on 2012-08-10
36
This bug affects 6 people
Affects Status Importance Assigned to Milestone
Percona Playback
Status tracked in 1.0
1.0
High
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
Running...
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

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 ;-)

Cheers,

lefred

Stewart Smith (stewart) on 2012-09-17
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  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers