|
Creation of a temporary OQGraph table fails with an error complaining about a missing backing table.
It wouldn't be surprised if temporary OQGraph tables were forbidden, but the specific error is wrong.
--source include/have_innodb.inc
|
|
INSTALL SONAME 'ha_oqgraph';
|
|
CREATE TABLE oq_backing (
|
origid INT UNSIGNED NOT NULL,
|
destid INT UNSIGNED NOT NULL,
|
PRIMARY KEY (origid, destid),
|
KEY (destid)
|
) ENGINE=InnoDB;
|
|
CREATE TEMPORARY TABLE oq_graph (
|
latch VARCHAR(32) NULL,
|
origid BIGINT UNSIGNED NULL,
|
destid BIGINT UNSIGNED NULL,
|
weight DOUBLE NULL,
|
seq BIGINT UNSIGNED NULL,
|
linkid BIGINT UNSIGNED NULL,
|
KEY (latch, origid, destid) USING HASH,
|
KEY (latch, destid, origid) USING HASH
|
)
|
ENGINE=OQGRAPH
|
data_table='oq_backing' origid='origid' destid='destid';
|
|
10.3 3814b04d6
|
mysqltest: At line 12: query 'CREATE TEMPORARY TABLE oq_graph (
|
latch VARCHAR(32) NULL,
|
origid BIGINT UNSIGNED NULL,
|
destid BIGINT UNSIGNED NULL,
|
weight DOUBLE NULL,
|
seq BIGINT UNSIGNED NULL,
|
linkid BIGINT UNSIGNED NULL,
|
KEY (latch, origid, destid) USING HASH,
|
KEY (latch, destid, origid) USING HASH
|
)
|
ENGINE=OQGRAPH
|
data_table='oq_backing' origid='origid' destid='destid'' failed: 1146: Table 'test.oq_backing' doesn't exist
|
|