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

Cannot build OQGRAPH table on a table having special chars

    XMLWordPrintable

    Details

      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

        Attachments

          Activity

            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: