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

MyRocks: Documented the generated columns limitation.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.x
    • Fix Version/s: 8.0.19-10
    • Component/s: Documentation
    • Labels:

      Description

      While adding checks to pt-online-schema-change I tried to create a table as follows:

      CREATE TABLE `test`.`t1` (
      `ID` int(11) NOT NULL,
      `Column2` int(11) DEFAULT NULL,
      `Column3` int(11) GENERATED ALWAYS AS ((`Column2` + 1)) STORED,
      PRIMARY KEY (`ID`)
      ) ENGINE=RocksDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

      and I am getting this error:

      ERROR 3106 (HY000): 'Specified storage engine' is not supported for generated columns.
      

      Even if generated columns is a MySQL 5.7+/InnoDB specific feature, I think it worth mentioning it in the MyRocks limitations page at https://www.percona.com/doc/percona-server/LATEST/myrocks/limitations.html

        Attachments

          Activity

            People

            Assignee:
            patrick.birch Patrick Birch
            Reporter:
            carlos.salguero Carlos Salguero
            Votes:
            0 Vote for this issue
            Watchers:
            2 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 hour, 15 minutes
                1h 15m

                  Smart Checklist