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 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
9 --source include/no_protocol.inc
10
11 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
12
13 --disable_query_log
14
15 --error ER_NO_SUCH_TABLE
16 select 1 from expect_unary;
17 --error ER_NO_SUCH_TABLE
18 select +1 from expect_unary;
19 --error ER_NO_SUCH_TABLE
20 select -1 from expect_unary;
21 --error ER_NO_SUCH_TABLE
22 select ++++++++++++++++++++++++++++++++++++++++++++++++1 from expect_unary;
23 --error ER_NO_SUCH_TABLE
24 select ------------------------------------------------1 from expect_unary;
25
26 --error ER_NO_SUCH_TABLE
27 select 0+1 from expect_binary;
28 --error ER_NO_SUCH_TABLE
29 select 0-1 from expect_binary;
30 --error ER_NO_SUCH_TABLE
31 select 0 ++++++++++++++++++++++++++++++++++++++++++++++++1 from expect_binary;
32 --error ER_NO_SUCH_TABLE
33 select 0 ------------------------------------------------1 from expect_binary;
34
35 --error ER_NO_SUCH_TABLE
36 insert into expect_full_reduce values (0, 0, 0);
37 --error ER_NO_SUCH_TABLE
38 insert into expect_full_reduce values (0, 0, -1);
39 --error ER_NO_SUCH_TABLE
40 insert into expect_full_reduce values (0, 0, +1);
41 --error ER_NO_SUCH_TABLE
42 insert into expect_full_reduce values (0, -1, 0);
43 --error ER_NO_SUCH_TABLE
44 insert into expect_full_reduce values (0, -1, -1);
45 --error ER_NO_SUCH_TABLE
46 insert into expect_full_reduce values (0, -1, +1);
47 --error ER_NO_SUCH_TABLE
48 insert into expect_full_reduce values (0, +1, 0);
49 --error ER_NO_SUCH_TABLE
50 insert into expect_full_reduce values (0, +1, -1);
51 --error ER_NO_SUCH_TABLE
52 insert into expect_full_reduce values (0, +1, +1);
53 --error ER_NO_SUCH_TABLE
54 insert into expect_full_reduce values (-1, 0, 0);
55 --error ER_NO_SUCH_TABLE
56 insert into expect_full_reduce values (-1, 0, -1);
57 --error ER_NO_SUCH_TABLE
58 insert into expect_full_reduce values (-1, 0, +1);
59 --error ER_NO_SUCH_TABLE
60 insert into expect_full_reduce values (-1, -1, 0);
61 --error ER_NO_SUCH_TABLE
62 insert into expect_full_reduce values (-1, -1, -1);
63 --error ER_NO_SUCH_TABLE
64 insert into expect_full_reduce values (-1, -1, +1);
65 --error ER_NO_SUCH_TABLE
66 insert into expect_full_reduce values (-1, +1, 0);
67 --error ER_NO_SUCH_TABLE
68 insert into expect_full_reduce values (-1, +1, -1);
69 --error ER_NO_SUCH_TABLE
70 insert into expect_full_reduce values (-1, +1, +1);
71 --error ER_NO_SUCH_TABLE
72 insert into expect_full_reduce values (+1, 0, 0);
73 --error ER_NO_SUCH_TABLE
74 insert into expect_full_reduce values (+1, 0, -1);
75 --error ER_NO_SUCH_TABLE
76 insert into expect_full_reduce values (+1, 0, +1);
77 --error ER_NO_SUCH_TABLE
78 insert into expect_full_reduce values (+1, -1, 0);
79 --error ER_NO_SUCH_TABLE
80 insert into expect_full_reduce values (+1, -1, -1);
81 --error ER_NO_SUCH_TABLE
82 insert into expect_full_reduce values (+1, -1, +1);
83 --error ER_NO_SUCH_TABLE
84 insert into expect_full_reduce values (+1, +1, 0);
85 --error ER_NO_SUCH_TABLE
86 insert into expect_full_reduce values (+1, +1, -1);
87 --error ER_NO_SUCH_TABLE
88 insert into expect_full_reduce values (+1, +1, +1);
89
90 --error ER_NO_SUCH_TABLE
91 select a-b, a+b, -a, -b, +a, +b from expect_unchanged;
92
93 --enable_query_log
94
95 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
96 FROM performance_schema.events_statements_summary_by_digest;
97