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

MyRocks doesn't issue error if I try to create encrypted table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: 5.7.19-17
    • Fix Version/s: 5.7.20-18
    • Component/s: MyRocks
    • Labels:
      None

      Description

      My understanding is that MyRocks doesn't support encryption (and I see this open: https://jira.percona.com/browse/MYR-132) but when trying to create encrypted table it just ignores it - but it is visible as option in show create table (IIRC when this was the issue before with foreign keys they weren't even visible in show create table).

      mysql> CREATE TABLE t2 (c1 INT) ENCRYPTION='Y' engine=rocksdb;
      Query OK, 0 rows affected (0.02 sec)
      
      mysql> show create table t2; 
      +-------+--------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                           |   
      +-------+--------------------------------------------------------------------------------------------------------+
      | t2    | CREATE TABLE `t2` (
        `c1` int(11) DEFAULT NULL
      ) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 ENCRYPTION='Y' |
      +-------+--------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  george.lorch George Lorch
                  Reporter:
                  tomislav.plavcic@percona.com Tomislav Plavcic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: