summaryrefslogtreecommitdiff
path: root/scripts/mysql_system_tables.sql
diff options
context:
space:
mode:
authorEugene Kosov <claprix@yandex.ru>2017-09-01 12:41:46 +0300
committerGitHub <noreply@github.com>2017-09-01 12:41:46 +0300
commitc2a70c8050125f219b1942a800aa4c134cc8520d (patch)
treef9594b577caaf97e3e359aa1585293057a87155b /scripts/mysql_system_tables.sql
parenta6aaa4fefeaa515f0d13b426d1d3cb807a56bf59 (diff)
downloadmariadb-git-c2a70c8050125f219b1942a800aa4c134cc8520d.tar.gz
SQL, IB: option to drop historical rows on ALTER [closes #249]
Diffstat (limited to 'scripts/mysql_system_tables.sql')
-rw-r--r--scripts/mysql_system_tables.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/mysql_system_tables.sql b/scripts/mysql_system_tables.sql
index 28ca9292602..539b26cd176 100644
--- a/scripts/mysql_system_tables.sql
+++ b/scripts/mysql_system_tables.sql
@@ -23,7 +23,7 @@ set sql_mode='';
set @orig_storage_engine=@@storage_engine;
set storage_engine=myisam;
-set versioning_ddl_survival=off;
+set versioning_alter_history=keep;
set @have_innodb= (select count(engine) from information_schema.engines where engine='INNODB' and support != 'NO');
SET @innodb_or_myisam=IF(@have_innodb <> 0, 'InnoDB', 'MyISAM');