Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.31
-
Ubuntu 16.04
mariadb-server - 10.0.31-0ubuntu0.16.04.2
OQGraph - mariadb-plugin-oqgraph 10.0.24-7
Description
The creation of the graph table does not work as described:
CREATE 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'; |
Using the workaround does not work either:
SET GLOBAL oqgraph_allow_create_integer_latch=1; |
 |
CREATE TABLE oq_old ( |
latch SMALLINT UNSIGNED 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'; |