30 lines
937 B
Plaintext
30 lines
937 B
Plaintext
# 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/have_optimizer_trace.inc
|
|
|
|
LET $DEFAULT_TRACE_MEM_SIZE=1048576; # 1MB
|
|
EVAL SET optimizer_trace_max_mem_size=$DEFAULT_TRACE_MEM_SIZE;
|
|
SET @@session.optimizer_trace="enabled=on";
|
|
|
|
--echo #
|
|
--echo # BUG#18195373: OPTIMIZER TRACE SHOULD PRINT NAME OF
|
|
--echo # INDEX FOR RANGE ACCESS
|
|
|
|
CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));
|
|
INSERT INTO t1 VALUES('Testing how', 'full-text search'),
|
|
('is printed to the', 'optimizer trace.'),
|
|
('We need test coverage','of that too');
|
|
|
|
SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("coverage");
|
|
|
|
SELECT * FROM information_schema.OPTIMIZER_TRACE;
|
|
|
|
DROP TABLE t1;
|