Debian Codegraph @

mysql-test/suite/opt_trace/t/fulltext.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/have_optimizer_trace.inc
11 --source include/not_hypergraph.inc # Does not output the same optimizer trace.
12
13 LET $DEFAULT_TRACE_MEM_SIZE=1048576; # 1MB
14 EVAL SET optimizer_trace_max_mem_size=$DEFAULT_TRACE_MEM_SIZE;
15 SET @@session.optimizer_trace="enabled=on";
16
17 --echo #
18 --echo # BUG#18195373: OPTIMIZER TRACE SHOULD PRINT NAME OF
19 --echo # INDEX FOR RANGE ACCESS
20
21 CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b));
22 INSERT INTO t1 VALUES('Testing how', 'full-text search'),
23 ('is printed to the', 'optimizer trace.'),
24 ('We need test coverage','of that too');
25
26 SELECT * FROM t1 WHERE MATCH(a,b) AGAINST ("coverage");
27
28 SELECT * FROM information_schema.OPTIMIZER_TRACE;
29
30 DROP TABLE t1;