diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2012-09-05 13:14:37 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2012-09-05 13:14:37 +0200 |
| commit | 6af914f8b94b98a5aa648f69383398741dcd9754 (patch) | |
| tree | 899fb248b22fe3cf16cc940a80f867110d8f4ce7 /mysql-test | |
| parent | 1f92707978d411a051b2bfa46ed361f60861ff73 (diff) | |
| parent | 0352f09a2e3e17470ab75678265b98a275cb25a0 (diff) | |
| download | mariadb-git-6af914f8b94b98a5aa648f69383398741dcd9754.tar.gz | |
XtraDB from Percona-Server-5.5.27-rel28.1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_merge_sort_block_size_basic.result | 24 | ||||
| -rw-r--r-- | mysql-test/suite/sys_vars/t/innodb_merge_sort_block_size_basic.test | 19 |
2 files changed, 43 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_merge_sort_block_size_basic.result b/mysql-test/suite/sys_vars/r/innodb_merge_sort_block_size_basic.result new file mode 100644 index 00000000000..90c2954e43d --- /dev/null +++ b/mysql-test/suite/sys_vars/r/innodb_merge_sort_block_size_basic.result @@ -0,0 +1,24 @@ +SELECT @@global.innodb_merge_sort_block_size; +@@global.innodb_merge_sort_block_size +1048576 +SELECT @@session.innodb_merge_sort_block_size; +@@session.innodb_merge_sort_block_size +1048576 +SET @old_global=@@global.innodb_merge_sort_block_size; +SET @old_session=@@session.innodb_merge_sort_block_size; +SET @@global.innodb_merge_sort_block_size = 2*1024*1024; +SET @@session.innodb_merge_sort_block_size = 4*1024*1024; +SELECT @@global.innodb_merge_sort_block_size; +@@global.innodb_merge_sort_block_size +2097152 +SELECT @@session.innodb_merge_sort_block_size; +@@session.innodb_merge_sort_block_size +4194304 +SET @@global.innodb_merge_sort_block_size = 1024*1024*1024+1; +Warnings: +Warning 1292 Truncated incorrect innodb_merge_sort_block_size value: '1073741825' +SELECT @@global.innodb_merge_sort_block_size; +@@global.innodb_merge_sort_block_size +1073741824 +SET @@global.innodb_merge_sort_block_size=@old_global; +SET @@session.innodb_merge_sort_block_size=@old_session; diff --git a/mysql-test/suite/sys_vars/t/innodb_merge_sort_block_size_basic.test b/mysql-test/suite/sys_vars/t/innodb_merge_sort_block_size_basic.test new file mode 100644 index 00000000000..2ec4870f345 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_merge_sort_block_size_basic.test @@ -0,0 +1,19 @@ +--source include/have_xtradb.inc + +SELECT @@global.innodb_merge_sort_block_size; +SELECT @@session.innodb_merge_sort_block_size; + +SET @old_global=@@global.innodb_merge_sort_block_size; +SET @old_session=@@session.innodb_merge_sort_block_size; + +SET @@global.innodb_merge_sort_block_size = 2*1024*1024; +SET @@session.innodb_merge_sort_block_size = 4*1024*1024; + +SELECT @@global.innodb_merge_sort_block_size; +SELECT @@session.innodb_merge_sort_block_size; + +SET @@global.innodb_merge_sort_block_size = 1024*1024*1024+1; +SELECT @@global.innodb_merge_sort_block_size; + +SET @@global.innodb_merge_sort_block_size=@old_global; +SET @@session.innodb_merge_sort_block_size=@old_session; |