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

HeidiSQL does not recognize system-versioned or application-time period tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.3, 10.4, 10.5
    • N/A
    • Platform Windows
    • None

    Description

      CREATE OR REPLACE TABLE t1 (a INT) WITH system versioning;
      CREATE OR REPLACE TABLE t2 (a INT, s DATE, e DATE, period FOR p(s,e));
      

      (can be executed either via command-line client or via HeidiSQL query).

      Table t1:CREATE code - MariaDB 10.5.3 / HeidiSQL 11.0.0.5919

      CREATE TABLE `t1` (
      	`a` INT(11) NULL DEFAULT NULL
      )
      COLLATE='latin1_swedish_ci'
      ENGINE=InnoDB
      ;
      

      Talbe t2:CREATE code

      CREATE TABLE `t2` (
      	`a` INT(11) NULL DEFAULT NULL,
      	`s` DATE NOT NULL,
      	`e` DATE NOT NULL
      )
      COLLATE='latin1_swedish_ci'
      ENGINE=InnoDB
      ;
      

      Screenshots are attached.

      I suppose we need to request an update from upstream and then include it into our releases.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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