diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/plugins/r/test_sql_service.result | 10 | ||||
| -rw-r--r-- | mysql-test/suite/plugins/t/test_sql_service.test | 7 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/plugins/r/test_sql_service.result b/mysql-test/suite/plugins/r/test_sql_service.result index 00f0411b665..4d81152659f 100644 --- a/mysql-test/suite/plugins/r/test_sql_service.result +++ b/mysql-test/suite/plugins/r/test_sql_service.result @@ -65,6 +65,16 @@ show status like 'test_sql_query_result'; Variable_name Value Test_sql_query_result Query returned 5 rows. drop table t1; +set global test_sql_service_execute_sql_global= 'create table test.t1 select current_user()'; +select * from t1; +current_user() +test_sql_service_gl@ +drop table t1; +set global test_sql_service_execute_sql_local= 'create table test.t1 select current_user()'; +select * from t1; +current_user() +test_sql_service@ +drop table t1; uninstall plugin test_sql_service; Warnings: Warning 1620 Plugin is busy and will be uninstalled on shutdown diff --git a/mysql-test/suite/plugins/t/test_sql_service.test b/mysql-test/suite/plugins/t/test_sql_service.test index b80d78fe6e5..f924f06dfc6 100644 --- a/mysql-test/suite/plugins/t/test_sql_service.test +++ b/mysql-test/suite/plugins/t/test_sql_service.test @@ -56,5 +56,12 @@ set global test_sql_service_execute_sql_local= 'select * FROM test.t1 WHERE time show status like 'test_sql_query_result'; drop table t1; +set global test_sql_service_execute_sql_global= 'create table test.t1 select current_user()'; +select * from t1; +drop table t1; +set global test_sql_service_execute_sql_local= 'create table test.t1 select current_user()'; +select * from t1; +drop table t1; + uninstall plugin test_sql_service; |