[MDEV-29594] sys_vars tests fail on 32-bit with wrong data types / max values Created: 2022-09-21  Updated: 2022-10-04  Resolved: 2022-10-04

Status: Closed
Project: MariaDB Server
Component/s: Tests, Variables
Affects Version/s: N/A
Fix Version/s: 10.11.1

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-7567 rename slow queries variables Closed
Relates

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/37418/steps/mtr_nm/logs/stdio

3b3ce1fbca32cae713fd15b6199b4fe420b42701

sys_vars.sysvars_server_notembedded '32bit,unix' w2 [ fail ]
        Test ended at 2022-09-12 15:52:37
 
CURRENT_TEST: sys_vars.sysvars_server_notembedded
--- /mnt/buildbot/build/mariadb-10.11.0/mysql-test/suite/sys_vars/r/sysvars_server_notembedded,32bit.result~	2022-09-12 15:52:36.587663767 -0400
+++ /mnt/buildbot/build/mariadb-10.11.0/mysql-test/suite/sys_vars/r/sysvars_server_notembedded,32bit.reject	2022-09-12 15:52:36.995664139 -0400
@@ -1844,7 +1844,7 @@
 COMMAND_LINE_ARGUMENT	REQUIRED
 VARIABLE_NAME	LOG_SLOW_MIN_EXAMINED_ROW_LIMIT
 VARIABLE_SCOPE	SESSION
-VARIABLE_TYPE	BIGINT UNSIGNED
+VARIABLE_TYPE	INT UNSIGNED
 VARIABLE_COMMENT	Don't write queries to slow log that examine fewer rows than that
 NUMERIC_MIN_VALUE	0
 NUMERIC_MAX_VALUE	4294967295
@@ -2067,14 +2067,14 @@
 VARIABLE_TYPE	BIGINT UNSIGNED
 VARIABLE_COMMENT	Don't allow creation of heap tables bigger than this
 NUMERIC_MIN_VALUE	16384
-NUMERIC_MAX_VALUE	18446744073709551615
+NUMERIC_MAX_VALUE	4294967295
 NUMERIC_BLOCK_SIZE	1024
 ENUM_VALUE_LIST	NULL
 READ_ONLY	NO
 COMMAND_LINE_ARGUMENT	REQUIRED
 VARIABLE_NAME	MAX_INSERT_DELAYED_THREADS
 VARIABLE_SCOPE	SESSION
-VARIABLE_TYPE	BIGINT UNSIGNED
+VARIABLE_TYPE	INT UNSIGNED
 VARIABLE_COMMENT	Alias for max_delayed_threads. Don't start more than this number of threads to handle INSERT DELAYED statements. If set to zero INSERT DELAYED will be not used
 NUMERIC_MIN_VALUE	0
 NUMERIC_MAX_VALUE	16384
@@ -2254,7 +2254,7 @@
 COMMAND_LINE_ARGUMENT	REQUIRED
 VARIABLE_NAME	MIN_EXAMINED_ROW_LIMIT
 VARIABLE_SCOPE	SESSION
-VARIABLE_TYPE	BIGINT UNSIGNED
+VARIABLE_TYPE	INT UNSIGNED
 VARIABLE_COMMENT	Alias for log_slow_min_examined_row_limit. Don't write queries to slow log that examine fewer rows than that
 NUMERIC_MIN_VALUE	0
 NUMERIC_MAX_VALUE	4294967295
 
mysqltest: Result length mismatch


Generated at Thu Feb 08 10:09:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.