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

OQGRAPH not works with tables which contain non latin symbols.

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.0.20, 10.1
    • 10.1
    • None
    • Linux

    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

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

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.