mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
9608773f75
This essentially reverts commit 4e89ec6692
and only disables InnoDB persistent statistics for tests where it is
desirable. By design, InnoDB persistent statistics will not be updated
except by ANALYZE TABLE or by STATS_AUTO_RECALC.
The internal transactions that update persistent InnoDB statistics
in background tasks (with innodb_stats_auto_recalc=ON) may cause
nondeterministic query plans or interfere with some tests that deal
with other InnoDB internals, such as the purge of transaction history.
86 lines
3.4 KiB
Text
86 lines
3.4 KiB
Text
################################################################################
|
|
# t/partition_alter3_innodb.test #
|
|
# #
|
|
# Purpose: #
|
|
# Tests around Alter column used in partitioning function #
|
|
# InnoDB branch #
|
|
# #
|
|
#------------------------------------------------------------------------------#
|
|
# Original Author: mleich #
|
|
# Original Date: 2006-04-24 #
|
|
# Change Author: #
|
|
# Change Date: #
|
|
# Change: #
|
|
################################################################################
|
|
|
|
#
|
|
# NOTE: PLEASE DO NOT ADD NOT INNODB SPECIFIC TESTCASES HERE !
|
|
# TESTCASES WHICH MUST BE APPLIED TO ALL STORAGE ENGINES MUST BE ADDED IN
|
|
# THE SOURCED FILES ONLY.
|
|
#
|
|
# Please read the README at the end of inc/partition.pre before changing
|
|
# any of the variables.
|
|
#
|
|
|
|
#------------------------------------------------------------------------------#
|
|
# General not engine specific settings and requirements
|
|
|
|
##### Options, for debugging support #####
|
|
let $debug= 0;
|
|
|
|
##### Option, for displaying files #####
|
|
let $ls= 1;
|
|
|
|
##### Number of rows for the INSERT/UPDATE/DELETE/SELECT experiments #####
|
|
# on partioned tables
|
|
SET @max_row = 20;
|
|
|
|
##### Execute more tests #####
|
|
let $more_trigger_tests= 0;
|
|
let $more_pk_ui_tests= 0;
|
|
|
|
# This test relies on --list_files, which doesn't work correctly in embedded.
|
|
--source include/not_embedded.inc
|
|
# The server must support partitioning.
|
|
--source include/have_partition.inc
|
|
|
|
#------------------------------------------------------------------------------#
|
|
# Engine specific settings and requirements
|
|
|
|
##### Storage engine to be tested
|
|
--source include/have_innodb.inc
|
|
let $engine= 'InnoDB';
|
|
|
|
##### Execute the test of "table" files
|
|
# InnoDB has no files per PK, UI, ...
|
|
let $do_file_tests= 0;
|
|
|
|
##### Execute PRIMARY KEY tests #####
|
|
# AFAIK InnoDB clusters the table around PRIMARY KEYs.
|
|
let $do_pk_tests= 1;
|
|
|
|
##### Assign a big number smaller than the maximum value for partitions #####
|
|
# and smaller than the maximum value of SIGNED INTEGER
|
|
let $MAX_VALUE= (2147483646);
|
|
|
|
SET @save_stats_persistent=@@GLOBAL.innodb_stats_persistent;
|
|
SET GLOBAL innodb_stats_persistent=0;
|
|
|
|
# Generate the prerequisites ($variables, @variables, tables) needed
|
|
--source suite/parts/inc/partition.pre
|
|
|
|
##### Workarounds for known open engine specific bugs
|
|
# none
|
|
|
|
#------------------------------------------------------------------------------#
|
|
# Execute the tests to be applied to all storage engines
|
|
--source suite/parts/inc/partition_alter3.inc
|
|
|
|
#------------------------------------------------------------------------------#
|
|
# Execute storage engine specific tests
|
|
|
|
#------------------------------------------------------------------------------#
|
|
# Cleanup
|
|
--source suite/parts/inc/partition_cleanup.inc
|
|
|
|
SET GLOBAL innodb_stats_persistent=@save_stats_persistent;
|