Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-5846

non-InnoDB: 3774 - 'Specified storage engine' is not supported for default value expressions.

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Reopened
    • 8.0.15-6, Not 5.7.x
    • 8.0.23-14 (Q1 2021)
    • MyRocks, TokuDB
    • None

    Description

      -- 
      -- innodb_version 8.0.15-6
      -- tokudb_backup_version tokubackup 1.2 $Revision: 56100 $
      -- tokudb_version 8.0.15-6
      -- version 8.0.15-6
      -- version_comment Percona Server (GPL), Release '6', Revision 'bc06a2b'
      
      -- # lsb_release -rdc
      -- Description:	Ubuntu 18.04.3 LTS
      -- Release:	18.04
      -- Codename:	bionic
      -- Package: percona-server-server
      -- Version: 8.0.15-6-2.bionic
      
      SET SESSION sql_mode='';
      
      DROP TABLE IF EXISTS test_innodb;
      CREATE TABLE `test_innodb` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `subject` text COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT (''),
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci  ;
      
      -- 3774 - 'Specified storage engine' is not supported for default value expressions.
      DROP TABLE IF EXISTS test_rocksdb;
      CREATE TABLE `test_rocksdb` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `subject` text COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT (''),
        PRIMARY KEY (`id`)
      ) ENGINE=ROCKSDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci  ;
      
      -- 3774 - 'Specified storage engine' is not supported for default value expressions.
      DROP TABLE IF EXISTS test_tokudb;
      CREATE TABLE `test_tokudb` (
        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `subject` text COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT (''),
        PRIMARY KEY (`id`)
      ) ENGINE=TokuDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci  ;
      

      Attachments

        Issue Links

          Activity

            People

              przemyslaw.skibinski Przemyslaw Skibinski
              denji Denis Denisov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 1 hour
                  1d 1h

                  Smart Checklist