Edit File: multi_statement.test
# PS doesn't support multi-statements --disable_ps_protocol --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings select 1; delimiter ||||; select 2; select 3; select 4|||| delimiter 'abcd'|||| select 5; select 6; select 50, 'abc';'abcd' select "abcd'";'abcd'select "'abcd";'abcd' select 5'abcd' delimiter ;'abcd' select 'finish'; # Bug #8475: Make sure every statement that is a slow query in # a multi-statement query gets logged as a slow query. flush status; delimiter ||||; create table t1 (i int); insert into t1 values (1); select * from t1 where i = 1; insert into t1 values (2),(3),(4); select * from t1 where i = 2; select * from t1 where i = 3|||| show status like 'Slow_queries'|||| drop table t1|||| delimiter ;|||| # End of 4.1 tests
Back to File Manager