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

          is caused by

          Task - A task that needs to be done. MDEV-19940 Clean up INFORMATION_SCHEMA.INNODB_ tables

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

            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:

                  Git Integration