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

Server crash with particular SQL sequence

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.4.22, 10.6.5, 10.3.34, 10.4.24
    • N/A
    • Virtual Columns
    • None
    • Linux 64, Linux ARM, Windows server

    Description

      Both of these sql sequences cause server crashes:

      first:
      DROP TABLE IF EXISTS t1;

      CREATE TABLE t1 (
      `ID` VARCHAR(1) NOT NULL,
      `f1` VARCHAR(1),
      `f2` VARCHAR(1),
      `f3` DATE,
      `f4` VARCHAR(1) AS (`f1` IN ('1','2') AND `f3`<CURDATE()) VIRTUAL,
      PRIMARY KEY (`ID`)
      )
      ENGINE=Aria;

      SELECT ID, f4 FROM t1;

      ALTER TABLE t1 CHANGE COLUMN `ID` `ID` VARCHAR(2);

      second:
      DROP TABLE IF EXISTS t1;

      CREATE TABLE t1 (
      `ID` VARCHAR(1) NOT NULL,
      `f1` VARCHAR(1),
      `f2` VARCHAR(1),
      `f3` DATE,
      `f4` VARCHAR(1) AS (`f1` IN ('1','2') AND `f3`<CURDATE()) VIRTUAL
      )
      ENGINE=Aria;

      SELECT ID, f4 FROM t1;

      INSERT INTO t1 (ID,f1,f2,f3) VALUES (1,'','',CURDATE());

      SELECT ID, f4 FROM t1;

      In both cases the problem occurs if I make a select before modifying the data or the structure. Both with Aria and InnoDB engines.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              steris Risato Stefano
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.