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

[PS8QA] Cannot add encrypted tables in to encrypted tablespace.

    XMLWordPrintable

    Details

      Description

      Testcase

      8.0.13>CREATE TABLESPACE `ts1` ADD DATAFILE 'ts1.ibd' ENCRYPTION='Y';
      Query OK, 0 rows affected (0.07 sec)
      
      8.0.13>CREATE TABLE `sbtest1` (
          ->  `id` int(11) DEFAULT NULL,
          ->  `k` int(11) NOT NULL DEFAULT '0',
          ->  `c` char(120) NOT NULL DEFAULT '',
          ->  `pad` char(60) NOT NULL DEFAULT '',
          ->  KEY `k_1` (`k`)
          -> ) ;
      Query OK, 0 rows affected (0.06 sec)
      
      8.0.13>show create table sbtest1\G
      *************************** 1. row ***************************
             Table: sbtest1
      Create Table: CREATE TABLE `sbtest1` (
        `id` int(11) DEFAULT NULL,
        `k` int(11) NOT NULL DEFAULT '0',
        `c` char(120) NOT NULL DEFAULT '',
        `pad` char(60) NOT NULL DEFAULT '',
        KEY `k_1` (`k`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'
      1 row in set (0.02 sec)
      
      8.0.13>alter table sbtest1 tablespace=ts1;
      ERROR 1478 (HY000): InnoDB: Tablespace `ts1` can contain only an ENCRYPTED tables.
      8.0.13>
      
      8.0.13>select name,encryption from information_schema.INNODB_TABLESPACES where name like '%ts%';
      +------+------------+
      | name | encryption |
      +------+------------+
      | ts1  | Y          |
      +------+------------+
      1 row in set (0.00 sec)
      
      8.0.13>
      

      Could not reproduce this issue with upstream build.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                satya.bodapati Satya Bodapati
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 minutes
                  4m