From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/engines/rr_trx/check_consistency.sql | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 mysql-test/suite/engines/rr_trx/check_consistency.sql (limited to 'mysql-test/suite/engines/rr_trx/check_consistency.sql') diff --git a/mysql-test/suite/engines/rr_trx/check_consistency.sql b/mysql-test/suite/engines/rr_trx/check_consistency.sql new file mode 100644 index 00000000..2f88e87c --- /dev/null +++ b/mysql-test/suite/engines/rr_trx/check_consistency.sql @@ -0,0 +1,31 @@ +USE test; +-- This file contains queries that can be used to check table consistency after running the stress_tx_rr test suite. +-- Contains a mix of queries used throughout the actual test suite. +-- When server is running, run this script e.g. like this: +-- ./bin/mysql -v -u root -h 127.0.0.1 < mysql-test/suite/engines/rr_trx/check_consistency.sql + +CHECK TABLE t1; +ANALYZE TABLE t1; + +-- Sum of all integers that are part of the test data should be 0 +SELECT SUM(`int1` + `int1_key` + `int1_unique` + + `int2` + `int2_key` + `int2_unique`) + AS TotalSum + FROM t1; + +-- No uncommitted data should be visible to a REPEATABLE-READ transaction +SELECT * FROM t1 WHERE `is_uncommitted` = 1; + +-- No rows marked as consistent should have row-sum not equal to 0 +SELECT * FROM t1 WHERE @sum:=`int1` + `int1_key` + `int1_unique` + `int2` + `int2_key` + `int2_unique` <> 0 AND `is_consistent` = 1; + +-- Check the table count. SHOULD NOT BE 0. +SELECT COUNT(*) FROM t1; + +-- The count of rows with pk divisible by 5 should be constant. +-- (less useful when there is no concurrency, though) +SELECT COUNT(*) FROM t1 WHERE `pk` MOD 5 = 0 AND `pk` BETWEEN 1 AND 1000; + +-- Check statistics (any number is OK, we are only looking for an impractical amount of errors +SELECT * FROM statistics; + -- cgit v1.2.3