|
The use of special chars in a table/column name seems to be fully supported in MariaDB, so one would expect that an OQGRAPH table can be built on a table having, say, a space in its name. Unfortunately, this doesn't seem to work.
CREATE TABLE `x tab` (
|
a INT UNSIGNED NOT NULL,
|
b INT UNSIGNED NOT NULL,
|
PRIMARY KEY (a, b),
|
KEY (b)
|
)
|
ENGINE = InnoDB;
|
INSERT INTO `x tab` (a, b) VALUES (1, 2), (2, 3), (3, 4), (2, 10), (10, 11);
|
SELECT * FROM `x tab`;
|
CREATE TABLE xoq (
|
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 = 'x tab'
|
ORIGID = 'a'
|
DESTID = 'b';
|
SELECT *
|
FROM xoq
|
WHERE latch = 'breadth_first'
|
AND origid = 1
|
AND destid = 3;
|
Last query returns:
ERROR 1146 (42S02): Table 'test.x tab' doesn't exist
|