1
############# mysql-test\t\query_prealloc_size_func.test ######################
3
# Variable Name: query_prealloc_size #
4
# Scope: GLOBAL & SESSION #
5
# Access Type: Dynamic #
7
# Default Value: 8192 #
8
# Values: 8192-4294967295 #
11
# Creation Date: 2008-02-22 #
12
# Author: Sharique Abdullah #
14
# Description: Test Cases of Dynamic System Variable "query_prealloc_size" #
15
# that checks behavior of this variable in the following ways #
17
# * Valid & Invalid values #
18
# * Scope & Access method #
21
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
22
# server-system-variables.html#option_mysqld_query_prealloc_size #
24
###############################################################################
38
CREATE TABLE t1 (id int auto_increment primary key, val text(200));
40
INSERT INTO t1 values(NULL,'a');
41
INSERT INTO t1 values(NULL,'b');
42
INSERT INTO t1 values(NULL,'c');
43
INSERT INTO t1 values(NULL,'d');
45
SELECT * FROM t1 ORDER BY val;
47
SET SESSION query_prealloc_size = 8192;
50
--echo '#----------------------------FN_DYNVARS_137_05-----------------#'
52
# Session data integrity check & GLOBAL Value check
55
SET GLOBAL query_prealloc_size = 8192;
57
connect (con_int1,localhost,root,,);
60
SELECT @@SESSION.query_prealloc_size;
61
--echo Expected Value : 8192;
62
SET SESSION query_prealloc_size = 16384;
64
connect (con_int2,localhost,root,,);
67
SELECT @@SESSION.query_prealloc_size;
68
--echo Expected Value : 8192;
70
SET SESSION query_prealloc_size = 8192;
73
SELECT @@SESSION.query_prealloc_size;
74
--echo Expected Value : 16384;
77
SELECT @@SESSION.query_prealloc_size;
78
--echo Expected Value : 8192;
80
SELECT @@GLOBAL.query_prealloc_size;
81
--echo Expected Value : 8192;