Column Compression with Predefined Dictionary; it is possible to create an empty dictionary
Bug #1628231 reported by
Shahriyar Rzayev
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Low
|
Yura Sorokin | ||
| 5.6 |
Invalid
|
Low
|
Yura Sorokin | ||
Bug Description
It is possible to create an empty dictionary:
mysql> CREATE COMPRESSION_
Query OK, 0 rows affected (0.01 sec)
Which in turn will be equal to not to specifying dictionary, in term of table size:
mysql> alter table t2 modify `a` blob column_format compressed;
Query OK, 100000 rows affected (13.62 sec)
Records: 100000 Duplicates: 0 Warnings: 0
mysql> alter table t2 modify `a` blob column_format compressed WITH COMPRESSION_
Query OK, 100000 rows affected (13.15 sec)
Records: 100000 Duplicates: 0 Warnings: 0
To be more strict and clear it should be prevented to create an empty dictionary
| Changed in percona-server: | |
| assignee: | nobody → Yura Sorokin (yura-sorokin) |
| tags: | added: column-compression |
| Changed in percona-server: | |
| status: | Confirmed → New |
| importance: | Medium → Undecided |
| assignee: | Yura Sorokin (yura-sorokin) → nobody |
Revision history for this message
| Yura Sorokin (yura-sorokin) wrote | #1 |
| Changed in percona-server: | |
| status: | New → Invalid |
| Changed in percona-server: | |
| importance: | Undecided → Low |
| assignee: | nobody → Yura Sorokin (yura-sorokin) |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
Not a bug.
Implemented by design. Can be useful for debug purposes.