Debian Codegraph @

mysql-test/suite/perfschema/include/digest_execution.inc

raw
1 --echo ####################################
2 --echo # EXECUTION
3 --echo ####################################
4
5 # -----------------------------------
6 # SQL Queries to test normalizations.
7 # -----------------------------------
8 SELECT 1 FROM t1;
9 SELECT 1 FROM `t1`;
10 SELECT 1,2 FROM t1;
11 SELECT 1, 2, 3, 4 FROM t1;
12 SELECT 1 FROM t2;
13 SELECT 1,2 FROM t2;
14 SELECT 1, 2, 3, 4 FROM t2;
15
16 # (NUM) => (#)
17 INSERT INTO t1 VALUES (1);
18 INSERT INTO t2 VALUES (1);
19
20 # (NUM,NUM) => (#,#)
21 INSERT INTO t3 VALUES (1, 2);
22 INSERT INTO t4 VALUES (1, 2);
23 # (NUM,NUM,NUM) => (#,#)
24 INSERT INTO t5 VALUES (1, 2, 3);
25
26 # (NUM),(NUM) => (#),(#)
27 INSERT INTO t1 VALUES (1), (2), (3);
28 # (NUM),(NUM),(NUM) => (#),(#)
29 INSERT INTO t1 VALUES (1), (2), (3), (4);
30
31 # (NUM,NUM),(NUM,NUM) => (#,#),(#,#)
32 INSERT INTO t3 VALUES (1, 2), (3, 4), (5, 6);
33 # (NUM,NUM,NUM),(NUM,NUM,NUM),(NUM,NUM,NUM) => (#,#),(#,#)
34 INSERT INTO t5 VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9);
35
36 # IN_SYM TOK_ROW_SINGLE_VALUE => TOK_IN_GENERIC_VALUE_EXPRESSION
37 SELECT * FROM t1 WHERE a IN (1);
38 # IN_SYM TOK_ROW_MULTIPLE_VALUE => TOK_IN_GENERIC_VALUE_EXPRESSION
39 SELECT * FROM t1 WHERE a IN (1, 2, 3);
40
41 # -----------------------------------------------------------------------
42 # Test case to handle NULL. If alone, not normalized otherwise normalized.
43 # -----------------------------------------------------------------------
44 INSERT INTO t1 VALUES (NULL);
45 INSERT INTO t3 VALUES (NULL,NULL);
46 INSERT INTO t3 VALUES (1,NULL);
47 INSERT INTO t3 VALUES (NULL,1);
48 INSERT INTO t6 VALUES (NULL, NULL, NULL, NULL);
49 INSERT INTO t6 VALUES (1, NULL, NULL, NULL);
50 INSERT INTO t6 VALUES (NULL, 2, NULL, NULL);
51 INSERT INTO t6 VALUES (1, 2, 3, NULL);
52 INSERT INTO t6 VALUES (1, 2, NULL, 4);
53
54 # -----------------------------------------------------------------------
55 # Test case for handling spaces in statement.
56 # -----------------------------------------------------------------------
57
58 SELECT 1 + 1;
59
60 # -----------------------------------------------------------------------
61 # Test case for handling comments.
62 # -----------------------------------------------------------------------
63
64 # comment starting with "--"
65 # TODO : SELECT 1; -- This comment continues to the end of line
66 # comment starting from "#"
67 SELECT 1; # This comment continues to the end of line
68
69 # Inline comment
70 SELECT 1 /* This is an inline comment */ + 1;
71
72 # Multiple line comments
73 SELECT 1+
74 /*
75 this is a
76 multiple-line comment
77 */
78 1;
79
80 # -----------------------------------------------------------------------
81 # Tests to show how the digest behaves with tokens that can have multiple
82 # names (such as DATABASE = "DATABASE" or "SCHEMA", SUBSTRING, STD_SYM,
83 # VARIANCE_SYM ... )
84 # -----------------------------------------------------------------------
85
86 --disable_warnings
87 CREATE SCHEMA statements_digest_temp;
88 DROP SCHEMA statements_digest_temp;
89 CREATE DATABASE statements_digest_temp;
90 DROP DATABASE statements_digest_temp;
91 # TODO : add more
92 --enable_warnings
93
94 # -----------------------------------------------------------------------
95 # Test case to show stats for statements giving ERRORS/WARNINGS, are also
96 # captured.
97 # -----------------------------------------------------------------------
98 --ERROR ER_NO_SUCH_TABLE
99 SELECT 1 FROM no_such_table;
100 CREATE TABLE dup_table (c char(4));
101 --ERROR ER_TABLE_EXISTS_ERROR
102 CREATE TABLE dup_table (c char(4));
103 DROP TABLE dup_table;
104 INSERT IGNORE INTO t11 VALUES("MySQL");
105
106 # -----------------------------------------------------------------------
107 # Tests to show sub-statements for following statements are not
108 # instrumented.
109 # - Prepared Statements
110 # - Stored Procedures/Functions.
111 # - Table Triggers
112 # -----------------------------------------------------------------------
113 PREPARE stmt FROM "SELECT * FROM t12";
114 EXECUTE stmt;
115 EXECUTE stmt;
116 DEALLOCATE PREPARE stmt;
117
118 DELIMITER //;
119 CREATE PROCEDURE p1() BEGIN SELECT * FROM t12; END//
120 DELIMITER ;//
121 CALL p1();
122 CALL p1();
123 DROP PROCEDURE p1;
124
125 DELIMITER //;
126 CREATE FUNCTION `func`(a INT, b INT) RETURNS int(11) RETURN a+b //
127 DELIMITER ;//
128 select func(3,4);
129 select func(13,42);
130 DROP FUNCTION func;
131
132 CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @a:=1;
133 INSERT INTO t12 VALUES ("abc");
134 INSERT INTO t12 VALUES ("def");
135 DROP TRIGGER trg;
136
137 # Tests to show more complex SELECT syntaxes
138
139 DELETE FROM t1;
140 INSERT INTO t1 VALUES (1),(2);
141
142 # Each pair of queries should go into one single class of digest:
143 SELECT * FROM (SELECT a,1,1 FROM t1) AS dt (x,y,z);
144 SELECT * FROM (SELECT a,2,2 FROM t1) AS dt (x,y,z);
145
146 WITH cte (x,y,z)AS (SELECT a,1,1 FROM t1) SELECT 1, cte.* FROM cte;
147 WITH cte (x,y,z)AS (SELECT a,2,2 FROM t1) SELECT 2, cte.* FROM cte;
148
149 --sorted_result
150 WITH cte (x,y,z)AS (SELECT a,1,1 FROM t1) SELECT 1, cte.*, cte2.* FROM cte, cte AS cte2;
151 --sorted_result
152 WITH cte (x,y,z)AS (SELECT a,2,2 FROM t1) SELECT 2, cte.*, cte2.* FROM cte, cte AS cte2;
153
154 --sorted_result
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
159 --sorted_result
160 WITH RECURSIVE cte (x,y,z) AS
161 (SELECT a,2,2 FROM t1 UNION ALL SELECT a+2,a*2,22 FROM t1 WHERE 0)
162 SELECT 2, cte.*, cte2.* FROM cte, cte AS cte2;