From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/perfschema/r/threads_insert_delayed.result | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 mysql-test/suite/perfschema/r/threads_insert_delayed.result (limited to 'mysql-test/suite/perfschema/r/threads_insert_delayed.result') diff --git a/mysql-test/suite/perfschema/r/threads_insert_delayed.result b/mysql-test/suite/perfschema/r/threads_insert_delayed.result new file mode 100644 index 00000000..b3bcdc49 --- /dev/null +++ b/mysql-test/suite/perfschema/r/threads_insert_delayed.result @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS t1; +DROP TEMPORARY TABLE IF EXISTS t2; +CREATE TABLE t1 (f1 BIGINT) ENGINE = MyISAM; +CREATE TEMPORARY TABLE t2 AS +SELECT thread_id FROM performance_schema.threads WHERE 1 = 2; +SELECT COUNT(*) = 0 AS expect_1 FROM performance_schema.threads +WHERE name = 'thread/sql/delayed_insert'; +expect_1 +1 +INSERT INTO t2 SELECT thread_id +FROM performance_schema.threads; +INSERT DELAYED INTO t1 SET f1 = SLEEP(3); +SELECT name, type, instrumented, processlist_user, processlist_host +FROM performance_schema.threads +WHERE thread_id NOT IN (SELECT thread_id FROM t2); +name type instrumented processlist_user processlist_host +thread/sql/delayed_insert FOREGROUND YES root localhost +DROP TABLE t1; +DROP TEMPORARY TABLE t2; -- cgit v1.2.3