multi-lines queries don't work
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| MOVED - Percona Playback | Status tracked in 1.0 | |||||
| 1.0 |
Fix Released
|
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/
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=
select * from article78
order by id desc limit 11;
$ sudo /usr/local/
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 | #1 |
| Changed in percona-playback: | |
| importance: | Undecided → High |
| status: | New → Triaged |
| assignee: | nobody → Stewart Smith (stewart) |
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