Debian Codegraph @

mysql-test/suite/perfschema/r/digest_table_full.result

raw
1 ####################################
2 # SETUP
3 ####################################
4 CREATE DATABASE statements_digest;
5 USE statements_digest;
6 CREATE TABLE t1(a int);
7 CREATE TABLE t2(a int);
8 CREATE TABLE t3(a int, b int);
9 CREATE TABLE t4(a int, b int);
10 CREATE TABLE t5(a int, b int, c int);
11 CREATE TABLE t6(a int, b int, c int, d int);
12 CREATE TABLE t11 (c CHAR(4));
13 CREATE TABLE t12 (c CHAR(4));
14 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
15 ####################################
16 # EXECUTION
17 ####################################
18 SELECT 1 FROM t1;
19 1
20 SELECT 1 FROM `t1`;
21 1
22 SELECT 1,2 FROM t1;
23 1 2
24 SELECT 1, 2, 3, 4 FROM t1;
25 1 2 3 4
26 SELECT 1 FROM t2;
27 1
28 SELECT 1,2 FROM t2;
29 1 2
30 SELECT 1, 2, 3, 4 FROM t2;
31 1 2 3 4
32 INSERT INTO t1 VALUES (1);
33 INSERT INTO t2 VALUES (1);
34 INSERT INTO t3 VALUES (1, 2);
35 INSERT INTO t4 VALUES (1, 2);
36 INSERT INTO t5 VALUES (1, 2, 3);
37 INSERT INTO t1 VALUES (1), (2), (3);
38 INSERT INTO t1 VALUES (1), (2), (3), (4);
39 INSERT INTO t3 VALUES (1, 2), (3, 4), (5, 6);
40 INSERT INTO t5 VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9);
41 SELECT * FROM t1 WHERE a IN (1);
42 a
43 1
44 1
45 1
46 SELECT * FROM t1 WHERE a IN (1, 2, 3);
47 a
48 1
49 1
50 2
51 3
52 1
53 2
54 3
55 INSERT INTO t1 VALUES (NULL);
56 INSERT INTO t3 VALUES (NULL,NULL);
57 INSERT INTO t3 VALUES (1,NULL);
58 INSERT INTO t3 VALUES (NULL,1);
59 INSERT INTO t6 VALUES (NULL, NULL, NULL, NULL);
60 INSERT INTO t6 VALUES (1, NULL, NULL, NULL);
61 INSERT INTO t6 VALUES (NULL, 2, NULL, NULL);
62 INSERT INTO t6 VALUES (1, 2, 3, NULL);
63 INSERT INTO t6 VALUES (1, 2, NULL, 4);
64 SELECT 1 + 1;
65 1 + 1
66 2
67 SELECT 1;
68 1
69 1
70 SELECT 1 /* This is an inline comment */ + 1;
71 1 /* This is an inline comment */ + 1
72 2
73 SELECT 1+
74 /*
75 this is a
76 multiple-line comment
77 */
78 1;
79 1+
80 /*
81 this is a
82 multiple-line comment
83 */
84 1
85 2
86 CREATE SCHEMA statements_digest_temp;
87 DROP SCHEMA statements_digest_temp;
88 CREATE DATABASE statements_digest_temp;
89 DROP DATABASE statements_digest_temp;
90 SELECT 1 FROM no_such_table;
91 ERROR 42S02: Table 'statements_digest.no_such_table' doesn't exist
92 CREATE TABLE dup_table (c char(4));
93 CREATE TABLE dup_table (c char(4));
94 ERROR 42S01: Table 'dup_table' already exists
95 DROP TABLE dup_table;
96 INSERT IGNORE INTO t11 VALUES("MySQL");
97 Warnings:
98 Warning 1265 Data truncated for column 'c' at row 1
99 PREPARE stmt FROM "SELECT * FROM t12";
100 EXECUTE stmt;
101 c
102 EXECUTE stmt;
103 c
104 DEALLOCATE PREPARE stmt;
105 CREATE PROCEDURE p1() BEGIN SELECT * FROM t12; END//
106 CALL p1();
107 c
108 CALL p1();
109 c
110 DROP PROCEDURE p1;
111 CREATE FUNCTION `func`(a INT, b INT) RETURNS int(11) RETURN a+b //
112 Warnings:
113 Warning 1681 Integer display width is deprecated and will be removed in a future release.
114 select func(3,4);
115 func(3,4)
116 7
117 select func(13,42);
118 func(13,42)
119 55
120 DROP FUNCTION func;
121 CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @a:=1;
122 INSERT INTO t12 VALUES ("abc");
123 INSERT INTO t12 VALUES ("def");
124 DROP TRIGGER trg;
125 DELETE FROM t1;
126 INSERT INTO t1 VALUES (1),(2);
127 SELECT * FROM (SELECT a,1,1 FROM t1) AS dt (x,y,z);
128 x y z
129 1 1 1
130 2 1 1
131 SELECT * FROM (SELECT a,2,2 FROM t1) AS dt (x,y,z);
132 x y z
133 1 2 2
134 2 2 2
135 WITH cte (x,y,z)AS (SELECT a,1,1 FROM t1) SELECT 1, cte.* FROM cte;
136 1 x y z
137 1 1 1 1
138 1 2 1 1
139 WITH cte (x,y,z)AS (SELECT a,2,2 FROM t1) SELECT 2, cte.* FROM cte;
140 2 x y z
141 2 1 2 2
142 2 2 2 2
143 WITH cte (x,y,z)AS (SELECT a,1,1 FROM t1) SELECT 1, cte.*, cte2.* FROM cte, cte AS cte2;
144 1 x y z x y z
145 1 1 1 1 1 1 1
146 1 1 1 1 2 1 1
147 1 2 1 1 1 1 1
148 1 2 1 1 2 1 1
149 WITH cte (x,y,z)AS (SELECT a,2,2 FROM t1) SELECT 2, cte.*, cte2.* FROM cte, cte AS cte2;
150 2 x y z x y z
151 2 1 2 2 1 2 2
152 2 1 2 2 2 2 2
153 2 2 2 2 1 2 2
154 2 2 2 2 2 2 2
155 WITH RECURSIVE cte (x,y,z) AS
156 (SELECT a,1,1 FROM t1 UNION ALL SELECT a+1,a*1,11 FROM t1 WHERE 0)
157 SELECT 1, cte.*, cte2.* FROM cte, cte AS cte2;
158 1 x y z x y z
159 1 1 1 1 1 1 1
160 1 1 1 1 2 1 1
161 1 2 1 1 1 1 1
162 1 2 1 1 2 1 1
163 WITH RECURSIVE cte (x,y,z) AS
164 (SELECT a,2,2 FROM t1 UNION ALL SELECT a+2,a*2,22 FROM t1 WHERE 0)
165 SELECT 2, cte.*, cte2.* FROM cte, cte AS cte2;
166 2 x y z x y z
167 2 1 2 2 1 2 2
168 2 1 2 2 2 2 2
169 2 2 2 2 1 2 2
170 2 2 2 2 2 2 2
171 ####################################
172 # QUERYING PS STATEMENT DIGEST
173 ####################################
174 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
175 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
176 SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_ROWS_AFFECTED SUM_WARNINGS SUM_ERRORS
177 NULL NULL NULL 68 43 2 2
178 statements_digest 5e18b503343466373cc0ce1922b04a77902f0cce5386ce599cb95b682d29415e TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest` 1 0 0 0
179 SHOW GLOBAL VARIABLES LIKE "performance_schema_digests_size";
180 Variable_name Value
181 performance_schema_digests_size 2
182 SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest;
183 COUNT(*)
184 2
185 select count(*)
186 from performance_schema.events_statements_histogram_by_digest;
187 count(*)
188 900
189 select SCHEMA_NAME, DIGEST IS NULL, BUCKET_NUMBER
190 from performance_schema.events_statements_histogram_by_digest
191 where BUCKET_NUMBER= 1;
192 SCHEMA_NAME DIGEST IS NULL BUCKET_NUMBER
193 NULL 1 1
194 statements_digest 0 1
195 ####################################
196 # CLEANUP
197 ####################################
198 DROP TABLE IF EXISTS t1;
199 DROP TABLE IF EXISTS t2;
200 DROP TABLE IF EXISTS t3;
201 DROP TABLE IF EXISTS t4;
202 DROP TABLE IF EXISTS t5;
203 DROP TABLE IF EXISTS t6;
204 DROP TABLE IF EXISTS t11;
205 DROP TABLE IF EXISTS t12;
206 DROP DATABASE IF EXISTS statements_digest;