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

    • Type: Improvement
    • Status: On Hold
    • Priority: Medium
    • Resolution: Reopened
    • Affects Version/s: 8.0.15-6
    • Fix Version/s: None
    • Component/s: MyRocks, TokuDB
    • Labels:
      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  ;
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  denji Denis Denisov
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: