diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2015-11-09 17:58:35 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2015-11-09 17:58:35 +0300 |
| commit | 9f862ce026c9102695f01aaa3090d5e99ffd80a1 (patch) | |
| tree | fcc061b69fd99f382ff5831eb54275ac4b7cd090 /scripts/mysql_system_tables_fix.sql | |
| parent | 1694d813997198e86f6a8aa6aefffb687c9992dd (diff) | |
| download | mariadb-git-9f862ce026c9102695f01aaa3090d5e99ffd80a1.tar.gz | |
MDEV#7383: engine-independent-stats column_stats has limited values for max/min values
Patch from Daniel Black:
- Change the charset of mysql.column_stats.{min_value, max_value} from
utf8_bin varchar to varbinary
- Adjust the code that saves/reads the data accordingly.
- Also provide upgrade statement in mysql_system_tables_fix.sql
Diffstat (limited to 'scripts/mysql_system_tables_fix.sql')
| -rw-r--r-- | scripts/mysql_system_tables_fix.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/scripts/mysql_system_tables_fix.sql b/scripts/mysql_system_tables_fix.sql index 33b4306b103..f034af4f898 100644 --- a/scripts/mysql_system_tables_fix.sql +++ b/scripts/mysql_system_tables_fix.sql @@ -711,3 +711,5 @@ flush privileges; ALTER TABLE help_category MODIFY url TEXT NOT NULL; ALTER TABLE help_topic MODIFY url TEXT NOT NULL; +# MDEV-7383 - varbinary on mix/max of column_stats +alter table column_stats modify min_value varbinary(255) DEFAULT NULL, modify max_value varbinary(255) DEFAULT NULL; |