| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysql-test/t/ |
Upload File : |
# 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