multi_statement.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- # PS doesn't support multi-statements
- --disable_ps_protocol
- 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