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

OQGRAPH not works with tables which contain non latin symbols.

    XMLWordPrintable

    Details

      Description

      CREATE TABLE `#departments` (
        `id_depart` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
        `id_parent` INT(10) UNSIGNED DEFAULT NULL,
        PRIMARY KEY (`id_depart`)
      ) ENGINE=INNODB
       
      CREATE TABLE `departments_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='#departments' origid='id_parent' destid='id_depart'
       
      SELECT * FROM `departments_graph` WHERE latch='breadth_first' AND origid=1 AND destid=2;

      Error Code: 1146
      Table 'test1.#departments' doesn't exist

        Attachments

          Activity

            People

            Assignee:
            andymc73 Andrew McDonnell
            Reporter:
            mikhail Mikhail Gavrilov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: