Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7361

Cannot build OQGRAPH table on a table having special chars

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.0.15
        • Fix Version/s: 10.0
        • Component/s: Storage Engine - OQGRAPH
        • Labels:
          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

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                andymc73 Andrew McDonnell added a comment -

                We are planning to start looking at this soon

                Show
                andymc73 Andrew McDonnell added a comment - We are planning to start looking at this soon

                  People

                  • Assignee:
                    andymc73 Andrew McDonnell
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated: