Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.15
-
None
Description
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