--source include/have_innodb.inc
|
|
CREATE TABLE t1 (entityKey INT PRIMARY KEY) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1),(2),(3);
|
|
CREATE TABLE t2 (entityKey INT, xhtmltext TEXT, FULLTEXT(xhtmltext)) ENGINE=InnoDB;
|
INSERT INTO t2 VALUES (1,"silver"),(2,"gold"),(3,"gold");
|
|
SET optimizer_switch='materialization=off,semijoin=off';
|
|
SELECT t1.entityKey FROM t1
|
WHERE t1.entityKey IN (
|
SELECT t2.entityKey FROM t2
|
WHERE MATCH (t2.xhtmltext) AGAINST ('gold')
|
)
|
ORDER BY t1.entityKey DESC;
|
|
# Cleanup
|
DROP TABLE t1, t2;
|