Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11371 Big column compressed
  3. MDEV-13342

Testing for MDEV-11371 (Big column compressed)

    XMLWordPrintable

    Details

    • Type: Technical task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: N/A
    • Component/s: Tests
    • Labels:
      None
    • Sprint:
      10.3.1-2

      Description

      Development tasks: MDEV-11371, MDEV-11381
      Development tree (as of July 18th): bb-10.3-svoj
      Tentative patch (as of July 18th): https://github.com/MariaDB/server/commit/79e055f407d34f195e3fde20401f39033dfce51d

      Request before the second round of review (received by email):

      On Thu, Jun 29, 2017 at 12:22:15PM +0400, Sergey Vojtovich wrote:

      Elena: I added decent test for this feature, but it would be great if you could
      extend it, especially replication testing is missing.

      Note: Since there is no documentation for the feature, need to explore first.
      Note: Make sure it's documented before the release.
      Note: Have 'innodb' removed from MDEV-11371 subject.

      Initial exploration:

      • server restart
      • base for virt col
      • storage for dyncol
      • 2nd part of index
      • change column, alter column
      • views
      • analyze, optimize, check
      • create table .. select with unsupported engine haven't found an unsupported engine yet
      • partitions, partition by compressed col
      • timestamps, sets, enums (N/A)
      • zerofill, unsigned (N/A)
      • null/not null
      • default
      • charsets
      • compressed column + row_format=compressed
      • + table compressed
      • + encryption
      • aria, tokudb, rocksdb, connect, heap, federated
      • binary log, replication
      • mysqldump


      here does not mean "tested", it just means it appears to be supported and does not fail right away

      Extra MTR tests needed:

      • with partitions
        • PARTITION BY KEY + SELECT .. WHERE col = 'something' etc. – crashes
      • with binlog in row format (easy to check with replication)
        • some strange '\x00foo' shows up, length increases

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              alice Alice Sherepa
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: