Debian Codegraph @

mysql-test/suite/opt_trace/t/range_no_prot.test

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