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

Attempt to create temporary OQGraph table fails with unexpected ER_NO_SUCH_TABLE

    XMLWordPrintable

    Details

      Description

      Creation of a temporary OQGraph table fails with an error complaining about a missing backing table.
      It wouldn't be surprised if temporary OQGraph tables were forbidden, but the specific error is wrong.

      --source include/have_innodb.inc
       
      INSTALL SONAME 'ha_oqgraph';
       
      CREATE TABLE oq_backing (
        origid INT UNSIGNED NOT NULL, 
        destid INT UNSIGNED NOT NULL,  
        PRIMARY KEY (origid, destid), 
        KEY (destid)
      ) ENGINE=InnoDB;
       
      CREATE TEMPORARY TABLE oq_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='oq_backing' origid='origid' destid='destid';
      

      10.3 3814b04d6

      mysqltest: At line 12: query 'CREATE TEMPORARY TABLE oq_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='oq_backing' origid='origid' destid='destid'' failed: 1146: Table 'test.oq_backing' doesn't exist
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            elenst Elena Stepanova
            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.