Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
-
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
- includes
-
MDEV-13665 EXCHANGE PARTITION does not work with compressed columns
- Closed
- is blocked by
-
MDEV-13539 Latest revision of bb-10.3-svoj (big column compressed) does not compile
- Closed
- relates to
-
MDEV-13378 Mysqld crashes with COMPRESSED data types, when using partitions
- Closed
-
MDEV-13540 Server crashes in copy or Assertion `0' failed in virtual Field* Field_varstring_compressed::new_key_field
- Closed
-
MDEV-13541 Server crashes in next_breadth_first_tab or Assertion `0' failed in Field_varstring_compressed::new_key_field
- Closed