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

InnoDB INFORMATION_SCHEMA tables fail to define DEFAULT for ENUM NOT NULL

    XMLWordPrintable

    Details

      Description

      The recently added test innodb.innodb_wl6326_big fails because of a change that was introduced in MDEV-19940:

      CURRENT_TEST: innodb.innodb_wl6326_big
      mysqltest: At line 157: query 'CREATE TABLE my_metrics LIKE information_schema.innodb_metrics' failed: 1067: Invalid default value for 'TYPE'
      

      The column information_schema.innodb_metrics.type used to be declared VARCHAR…NOT NULL DEFAULT '', but now it is ENUM…NOT NULL DEFAULT ''. A proper default value should be declared.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: