| 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; |