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

CREATE OR REPLACE with MyISAM + OQGRAPH

    XMLWordPrintable

    Details

      Description

      I don't know if this should be a new bug or a new comment in MDEV-7354.

      1) create & populate MyISAM table
      2) create an OQGRAPH table based on the first table
      3) select from OQGRAPH
      4) CREATE OR REPLACE MyISAM
      5) select from the new MyISAM

      Result: error. (This doesn't happen if you don't have an OQGRAPH table)

      CREATE TABLE ttt (
      	a INT NOT NULL,
      	b INT NOT NULL
      ) ENGINE = MyISAM;
       
      INSERT INTO ttt (a, b) VALUES (1, 10), (2, 10), (3, 10);
       
      CREATE TABLE oq (
        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 = 'ttt'
      	ORIGID = 'a'
      	DESTID = 'b';
       
      SELECT *
      	FROM oq
      	WHERE latch = 'dijkstras'
      		AND origid = 1
      		AND destid = 10;
       
      SELECT * FROM ttt;
       
      CREATE OR REPLACE TABLE ttt (
      	a INT,
      	b INT
      ) ENGINE = MyISAM;
       
      SELECT * FROM ttt;

        Attachments

          Issue Links

            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: