summaryrefslogtreecommitdiff
path: root/mysql-test/r/userstat.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/userstat.result')
-rw-r--r--mysql-test/r/userstat.result15
1 files changed, 14 insertions, 1 deletions
diff --git a/mysql-test/r/userstat.result b/mysql-test/r/userstat.result
index 01a66aa78ec..8aad76c3750 100644
--- a/mysql-test/r/userstat.result
+++ b/mysql-test/r/userstat.result
@@ -1,4 +1,3 @@
-DROP TABLE IF EXISTS t1;
select variable_value from information_schema.global_status where variable_name="handler_read_key" into @global_read_key;
show columns from information_schema.client_statistics;
Field Type Null Key Default Extra
@@ -234,3 +233,17 @@ select @@in_transaction;
0
drop table t1;
set @@global.general_log=@save_general_log;
+#
+# MDEV-25242 Server crashes in check_grant upon invoking function with userstat enabled
+#
+create function f() returns int return (select 1 from performance_schema.threads);
+set global userstat= 1;
+select f() from information_schema.table_statistics;
+ERROR 21000: Subquery returns more than 1 row
+select f() from information_schema.index_statistics;
+ERROR 21000: Subquery returns more than 1 row
+set global userstat= 0;
+drop function f;
+#
+# End of 10.2 tests
+#