Debian Codegraph @

mysql-test/suite/secondary_engine/r/query_preparation_debug.result

raw
1 CREATE TABLE t(x INT) SECONDARY_ENGINE MOCK;
2 INSERT INTO t VALUES (1);
3 ALTER TABLE t SECONDARY_LOAD;
4 FLUSH STATUS;
5 PREPARE ps FROM 'SELECT * FROM t';
6 EXECUTE ps;
7 x
8 SHOW SESSION STATUS LIKE 'Secondary_engine_execution_count';
9 Variable_name Value
10 Secondary_engine_execution_count 1
11 FLUSH STATUS;
12 SET DEBUG = '+d,secondary_engine_mock_prepare_error';
13 EXECUTE ps;
14 x
15 1
16 SET DEBUG = '-d,secondary_engine_mock_prepare_error';
17 SHOW SESSION STATUS LIKE 'Secondary_engine_execution_count';
18 Variable_name Value
19 Secondary_engine_execution_count 0
20 FLUSH STATUS;
21 EXECUTE ps;
22 x
23 1
24 SHOW SESSION STATUS LIKE 'Secondary_engine_execution_count';
25 Variable_name Value
26 Secondary_engine_execution_count 0
27 DROP TABLE t;
28 #
29 # WL#12389: Add interface for optimizing queries in secondary engines
30 #
31 CREATE TABLE t1(x INT) SECONDARY_ENGINE MOCK;
32 INSERT INTO t1 VALUES (1), (2), (3);
33 CREATE TABLE t2(y INT) SECONDARY_ENGINE MOCK;
34 INSERT INTO t2 VALUES (3), (4), (5);
35 ALTER TABLE t1 SECONDARY_LOAD;
36 ALTER TABLE t2 SECONDARY_LOAD;
37 ANALYZE TABLE t1, t2;
38 Table Op Msg_type Msg_text
39 test.t1 analyze status OK
40 test.t2 analyze status OK
41 SET DEBUG = "+d,secondary_engine_mock_optimize_error";
42 FLUSH STATUS;
43 SELECT * FROM t1;
44 x
45 1
46 2
47 3
48 SELECT /*+ SET_VAR(use_secondary_engine = FORCED) */ x FROM t1;
49 ERROR HY000: Secondary engine operation failed. use_secondary_engine is FORCED but query could not be executed in secondary engine.
50 SELECT (SELECT y FROM t2 WHERE y = 1) FROM t1;
51 (SELECT y FROM t2 WHERE y = 1)
52 NULL
53 NULL
54 NULL
55 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
56 x
57 1
58 2
59 3
60 3
61 4
62 5
63 SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2;
64 x
65 1
66 2
67 3
68 4
69 5
70 SET DEBUG = "-d,secondary_engine_mock_optimize_error";
71 SHOW STATUS LIKE 'Secondary_engine_execution_count';
72 Variable_name Value
73 Secondary_engine_execution_count 0
74 FLUSH STATUS;
75 SELECT * FROM t1;
76 x
77 SELECT (SELECT y FROM t2 WHERE y = 1) FROM t1;
78 (SELECT y FROM t2 WHERE y = 1)
79 SELECT * FROM t1 UNION ALL SELECT * FROM t2;
80 x
81 SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2;
82 x
83 SHOW STATUS LIKE 'Secondary_engine_execution_count';
84 Variable_name Value
85 Secondary_engine_execution_count 4
86 DROP TABLE t1, t2;
87 CREATE TABLE t(x int) SECONDARY_ENGINE MOCK;
88 INSERT INTO t VALUES (1), (2), (3);
89 ALTER TABLE t SECONDARY_LOAD;
90 SET DEBUG_SYNC = 'before_mock_optimize SIGNAL mock WAIT_FOR continue';
91 SELECT * FROM t;
92 SET DEBUG_SYNC = 'now WAIT_FOR mock';
93 SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST
94 WHERE INFO = 'SELECT * FROM t' INTO @thread_id;
95 Warnings:
96 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
97 KILL QUERY @thread_id;
98 SET DEBUG_SYNC = 'now SIGNAL continue';
99 ERROR 70100: Query execution was interrupted
100 DROP TABLE t;
101 #
102 # Bug#29615190: SELECTS ON TABLES OFFLOADED TO SECONDARY ENGINE ARE
103 # WRITTEN TWICE TO THE MYSQLD GENERAL LOG
104 #
105 CREATE TABLE t(x INT) SECONDARY_ENGINE MOCK;
106 ALTER TABLE t SECONDARY_LOAD;
107 SET @saved_general_log = @@global.general_log;
108 SET @saved_log_output = @@global.log_output;
109 SET GLOBAL general_log = 1;
110 SET GLOBAL log_output = 'table';
111 SET DEBUG = '+d,secondary_engine_mock_optimize_error';
112 TRUNCATE TABLE mysql.general_log;
113 SELECT * FROM t;
114 x
115 statement_count
116 1
117 TRUNCATE TABLE mysql.general_log;
118 PREPARE ps FROM 'SELECT * FROM t';
119 SELECT COUNT(*) FROM mysql.general_log WHERE argument = 'SELECT * FROM t';
120 COUNT(*)
121 1
122 EXECUTE ps;
123 x
124 SELECT COUNT(*) FROM mysql.general_log WHERE argument = 'SELECT * FROM t';
125 COUNT(*)
126 2
127 DROP PREPARE ps;
128 SET GLOBAL general_log = @saved_general_log;
129 SET GLOBAL log_output = @saved_log_output;
130 SET DEBUG = '-d,secondary_engine_mock_optimize_error';
131 TRUNCATE TABLE mysql.general_log;
132 DROP TABLE t;