1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# Start server with MyISAM
--source include/force_myisam_default.inc
# Skip the test if MyISAM is not available
--source include/have_myisam.inc
# Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
--source include/no_protocol.inc
--source include/not_hypergraph.inc # Does not output the same optimizer trace.
# The main testing script
--source suite/opt_trace/include/range.inc
--echo
--echo # BUG#18023222 OPTIMIZER TRACE ERROR ON RANGE ANALYSIS OF
--echo # INDEX ON A BINARY COLUMN
--echo
CREATE TABLE t(i INT PRIMARY KEY, b BINARY(16), INDEX i_b(b));
INSERT INTO t VALUES (1, x'D95B94336A9946A39CF5B58CFE772D8C');
INSERT INTO t VALUES (2, NULL);
EXPLAIN SELECT * FROM t WHERE b IN (0xD95B94336A9946A39CF5B58CFE772D8C);
SELECT trace FROM information_schema.optimizer_trace;
EXPLAIN SELECT * FROM t WHERE b IS NULL;
SELECT trace FROM information_schema.optimizer_trace;
drop table t;
--source include/show_json_object.inc
--echo #
--echo # Test trace of geometry fields
--echo #
# Must be an engine that supports spatial indexes
CREATE TABLE t1(
pk INT AUTO_INCREMENT PRIMARY KEY,
col_geom GEOMETRY NOT NULL SRID 0
) ENGINE=MyISAM;
INSERT INTO t1 VALUES (1, ST_GeomFromText('POINT(10 10)'));
INSERT INTO t1 VALUES (2, ST_GeomFromText('POINT(11 11)'));
CREATE SPATIAL INDEX idx3 on t1(col_geom);
--echo # Show that geometry data is traced as "unprintable_geometry_value"
EXPLAIN
SELECT pk, ST_AsText(col_geom)
FROM t1
WHERE MBREquals(t1.col_geom, ST_GeomFromText('POINT(12 13)'));
SELECT show_json_object('"range_scan_alternatives": [', TRACE)
FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
DROP TABLE t1;
DROP FUNCTION show_json_object;
|
