Gecko [ www.jdcpatala.org ]

Name	Size	Permission
autocommit_func2.inc	643 B	-rw-r--r--
bin_relay_log_basename_index.i...	1.41 KB	-rw-r--r--
binlog_cache_size_basic.inc	7.18 KB	-rw-r--r--
binlog_stmt_cache_size_basic.i...	7.38 KB	-rw-r--r--
bulk_insert_buffer_size_basic....	9.13 KB	-rw-r--r--
charset_basic.inc	2.59 KB	-rw-r--r--
collation_basic.inc	10.36 KB	-rw-r--r--
delayed_insert_limit_basic.inc	7.56 KB	-rw-r--r--
delayed_queue_size_basic.inc	7.45 KB	-rw-r--r--
global_boolean_var_basic.inc	968 B	-rw-r--r--
have_open_file_limit_more_than...	391 B	-rw-r--r--
join_buffer_size_basic.inc	8.27 KB	-rw-r--r--
key_cache_age_threshold_basic....	7.95 KB	-rw-r--r--
log_warnings_basic.inc	5.81 KB	-rw-r--r--
max_connect_errors_basic.inc	7.71 KB	-rw-r--r--
max_seeks_for_key_basic.inc	9.06 KB	-rw-r--r--
max_tmp_tables_basic.inc	9.13 KB	-rw-r--r--
max_write_lock_count_basic.inc	6.77 KB	-rw-r--r--
min_examined_row_limit_basic.i...	9.75 KB	-rw-r--r--
multi_range_count_basic.inc	9.34 KB	-rw-r--r--
myisam_max_sort_file_size_basi...	8.25 KB	-rw-r--r--
myisam_repair_threads_basic.in...	9.61 KB	-rw-r--r--
myisam_sort_buffer_size_basic....	9.9 KB	-rw-r--r--
net_retry_count_basic.inc	8.99 KB	-rw-r--r--
parser_max_mem_size_basic.inc	2.65 KB	-rw-r--r--
query_cache_limit_basic.inc	7.68 KB	-rw-r--r--
query_cache_min_res_unit_basic...	8.42 KB	-rw-r--r--
query_cache_size_basic.inc	7.86 KB	-rw-r--r--
slave_transaction_retries_basi...	8.3 KB	-rw-r--r--
sort_buffer_size_basic.inc	9.18 KB	-rw-r--r--

Code Editor : parser_max_mem_size_basic.inc

#
# Basic test for parser_max_mem_size
#
# There are separate tests for 32bit and 64bit systems.
#
# There are separate tests for command line options
#   --parser-max-mem-size
#   --maximum-parser-max-mem-size
#

--source include/not_embedded.inc
--source include/load_sysvars.inc

--echo # Display the DEFAULT value of parser_max_mem_size
--echo # The DEFAULT is determined by --maximum-parser-max-mem-size

SELECT @@session.parser_max_mem_size;
SELECT @@global.parser_max_mem_size;

SET @@session.parser_max_mem_size = DEFAULT;
SELECT @@session.parser_max_mem_size;

--echo # Change the value of parser_max_mem_size to a valid
--echo # value for SESSION Scope

SET @@session.parser_max_mem_size = 500 * 1000 * 100;
SELECT @@session.parser_max_mem_size;

--echo # Change the value of the session parser_max_mem_size to a
--echo # value greater than --maximum-parser-max-mem-size
SET session parser_max_mem_size = 1000 * 1000 * 100;
SELECT @@session.parser_max_mem_size;

--echo # Change the value of the global parser_max_mem_size to a
--echo # value greater than --maximum-parser-max-mem-size
SET @@global.parser_max_mem_size = 1000 * 1000 * 100;
SELECT @@global.parser_max_mem_size;

--echo # Change the value of parser_max_mem_size to an invalid value

--Error ER_WRONG_TYPE_FOR_VAR
SET @@session.parser_max_mem_size= 'NOT_CHAR_TYPE';

SET @@session.parser_max_mem_size = -10;

--Error ER_WRONG_TYPE_FOR_VAR
SET @@session.parser_max_mem_size = 0.5;

--echo # Check if TRUE and FALSE values can be used on variable

SET @@session.parser_max_mem_size = TRUE;
SELECT @@session.parser_max_mem_size;

SET @@session.parser_max_mem_size = FALSE;
SELECT @@session.parser_max_mem_size;

--echo # Restore initial value

SET @@session.parser_max_mem_size = DEFAULT;
SELECT @@session.parser_max_mem_size;

--echo # Creating a new user
CREATE USER example;
connect(conn_example, localhost, example,,);

--echo # example user sets 45000000
SET @@session.parser_max_mem_size = 45000000;

--connection default

--echo # default sets global 40000000
SET @@global.parser_max_mem_size = 40000000;

-- connection conn_example

--echo # example user sets 45000000
SET @@session.parser_max_mem_size = 45000000;
SELECT @@session.parser_max_mem_size;

--echo # example user sets DEFAULT, which is now 40000000
SET @@session.parser_max_mem_size = DEFAULT;
SELECT @@session.parser_max_mem_size;

--echo # disconnect
disconnect conn_example;
--source include/wait_until_disconnected.inc
-- connection default

--echo # default sets sesion 45000000
SET @@session.parser_max_mem_size = 45000000;
SELECT @@session.parser_max_mem_size;

DROP USER example;

SET @@global.parser_max_mem_size = DEFAULT;

--echo # END OF parser_max_mem_size TESTS

${this.title}

Code Editor : parser_max_mem_size_basic.inc