Debian Codegraph @

mysql-test/suite/perfschema/t/unary_digest.test

raw
1 # ----------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # ----------------------------------------------------
4
5 # Test case to show behavior of statements digest when
6 # statement-digest-size is 0
7
8 --source include/not_embedded.inc
9 --source include/have_perfschema.inc
10 --source include/no_protocol.inc
11
12 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
13
14 --disable_query_log
15
16 --error ER_NO_SUCH_TABLE
17 select 1 from expect_unary;
18 --error ER_NO_SUCH_TABLE
19 select +1 from expect_unary;
20 --error ER_NO_SUCH_TABLE
21 select -1 from expect_unary;
22 --error ER_NO_SUCH_TABLE
23 select ++++++++++++++++++++++++++++++++++++++++++++++++1 from expect_unary;
24 --error ER_NO_SUCH_TABLE
25 select ------------------------------------------------1 from expect_unary;
26
27 --error ER_NO_SUCH_TABLE
28 select 0+1 from expect_binary;
29 --error ER_NO_SUCH_TABLE
30 select 0-1 from expect_binary;
31 --error ER_NO_SUCH_TABLE
32 select 0 ++++++++++++++++++++++++++++++++++++++++++++++++1 from expect_binary;
33 --error ER_NO_SUCH_TABLE
34 select 0 ------------------------------------------------1 from expect_binary;
35
36 --error ER_NO_SUCH_TABLE
37 insert into expect_full_reduce values (0, 0, 0);
38 --error ER_NO_SUCH_TABLE
39 insert into expect_full_reduce values (0, 0, -1);
40 --error ER_NO_SUCH_TABLE
41 insert into expect_full_reduce values (0, 0, +1);
42 --error ER_NO_SUCH_TABLE
43 insert into expect_full_reduce values (0, -1, 0);
44 --error ER_NO_SUCH_TABLE
45 insert into expect_full_reduce values (0, -1, -1);
46 --error ER_NO_SUCH_TABLE
47 insert into expect_full_reduce values (0, -1, +1);
48 --error ER_NO_SUCH_TABLE
49 insert into expect_full_reduce values (0, +1, 0);
50 --error ER_NO_SUCH_TABLE
51 insert into expect_full_reduce values (0, +1, -1);
52 --error ER_NO_SUCH_TABLE
53 insert into expect_full_reduce values (0, +1, +1);
54 --error ER_NO_SUCH_TABLE
55 insert into expect_full_reduce values (-1, 0, 0);
56 --error ER_NO_SUCH_TABLE
57 insert into expect_full_reduce values (-1, 0, -1);
58 --error ER_NO_SUCH_TABLE
59 insert into expect_full_reduce values (-1, 0, +1);
60 --error ER_NO_SUCH_TABLE
61 insert into expect_full_reduce values (-1, -1, 0);
62 --error ER_NO_SUCH_TABLE
63 insert into expect_full_reduce values (-1, -1, -1);
64 --error ER_NO_SUCH_TABLE
65 insert into expect_full_reduce values (-1, -1, +1);
66 --error ER_NO_SUCH_TABLE
67 insert into expect_full_reduce values (-1, +1, 0);
68 --error ER_NO_SUCH_TABLE
69 insert into expect_full_reduce values (-1, +1, -1);
70 --error ER_NO_SUCH_TABLE
71 insert into expect_full_reduce values (-1, +1, +1);
72 --error ER_NO_SUCH_TABLE
73 insert into expect_full_reduce values (+1, 0, 0);
74 --error ER_NO_SUCH_TABLE
75 insert into expect_full_reduce values (+1, 0, -1);
76 --error ER_NO_SUCH_TABLE
77 insert into expect_full_reduce values (+1, 0, +1);
78 --error ER_NO_SUCH_TABLE
79 insert into expect_full_reduce values (+1, -1, 0);
80 --error ER_NO_SUCH_TABLE
81 insert into expect_full_reduce values (+1, -1, -1);
82 --error ER_NO_SUCH_TABLE
83 insert into expect_full_reduce values (+1, -1, +1);
84 --error ER_NO_SUCH_TABLE
85 insert into expect_full_reduce values (+1, +1, 0);
86 --error ER_NO_SUCH_TABLE
87 insert into expect_full_reduce values (+1, +1, -1);
88 --error ER_NO_SUCH_TABLE
89 insert into expect_full_reduce values (+1, +1, +1);
90
91 --error ER_NO_SUCH_TABLE
92 select a-b, a+b, -a, -b, +a, +b from expect_unchanged;
93
94 --enable_query_log
95
96 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
97 FROM performance_schema.events_statements_summary_by_digest;
98