From 1dacd5f299be63b8dea8f6ff802739abba96b4e1 Mon Sep 17 00:00:00 2001 From: Thirunarayanan Balathandayuthapani Date: Tue, 16 Oct 2018 13:02:50 +0530 Subject: MDEV-12547: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit - Backported the MYSQL_SYSVAR_SIZE_T to 10.0 - The parameter innodb_ft_result_cache_limit was only 32 bits wide also on 64-bit systems. Make it size_t, so that it will be 64 bits on 64-bit systems. - Added a test case that show how innodb_ft_result_cache_limit variables behaves in 32bit and 64 bit system. --- mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test (limited to 'mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test') diff --git a/mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test b/mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test new file mode 100644 index 00000000000..2606d2b5ca8 --- /dev/null +++ b/mysql-test/suite/sys_vars/t/innodb_ft_result_cache_limit_64.test @@ -0,0 +1,9 @@ +--source include/have_64bit.inc +--source include/have_innodb.inc + +let $innodb_ft_result_cache_limit_orig=`select @@innodb_ft_result_cache_limit`; + +set global innodb_ft_result_cache_limit=5000000000; +select @@innodb_ft_result_cache_limit; + +eval set global innodb_ft_result_cache_limit=$innodb_ft_result_cache_limit_orig; -- cgit v1.2.1