Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
None
Description
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 |