Re: Bug in mysqldumpslow - Sinisa Milivojevic - com.mysql.lists.bugs

3 messages in com.mysql.lists.bugsRe: Bug in mysqldumpslow

From	Sent On	Attachments
Steven Roussey	26 Jul 2001 12:56
Sinisa Milivojevic	27 Jul 2001 07:17
Michael Widenius	10 Aug 2001 15:41

Subject:	Re: Bug in mysqldumpslow
From:	Sinisa Milivojevic (sin...@mysql.com)
Date:	07/27/2001 07:17:25 AM
List:	com.mysql.lists.bugs

Steven Roussey writes:

If a query in the slow log has a \' in a ' quoted string, it will get confused.

# mysqldumpslow test-slow Reading mysql slow query log from test-slow Count: 1 Time=3.00s (3s) Lock=0.00s (0s) Rows=0.0 (0), apache[apache]@mouse.i insert into testtb ( col_n, col_s ) values (N, 'S' )

Count: 1 Time=3.00s (3s) Lock=0.00s (0s) Rows=0.0 (0), apache[apache]@mouse.i insert into testtb ( col_n, col_s ) values (N, 'S't OK' )

test-slow: # Time: 010725 12:50:25 # User@Host: apache[apache] @ mouse.i [10.1.1.7] # Time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 insert into testtb ( col_n, col_s ) values (118656, 'Test is OK' ); # Time: 010725 12:50:26 # User@Host: apache[apache] @ mouse.i [10.1.1.7] # Time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 insert into testtb ( col_n, col_s ) values (118656, 'Test isn\'t OK' );

Sincerely,

Thank you for your bug report.