[MDEV-28717] spider.variable_deprecation fails on centos73-ppc64 in buildbot Created: 2022-05-31  Updated: 2022-06-17  Resolved: 2022-06-17

Status: Closed
Project: MariaDB Server
Component/s: Platform Power, Storage Engine - Spider, Tests
Affects Version/s: 10.7, 10.8, 10.9
Fix Version/s: 10.7.5, 10.8.4

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


 Description   

10.7 52be05be

spider.variable_deprecation              w3 [ fail ]
        Test ended at 2022-05-31 19:15:52
 
CURRENT_TEST: spider.variable_deprecation
--- /usr/share/mysql-test/plugin/spider/spider/r/variable_deprecation.result	2022-05-31 15:25:01.000000000 +0000
+++ /dev/shm/var/3/log/variable_deprecation.reject	2022-05-31 19:15:52.450006994 +0000
@@ -34,7 +34,7 @@
 Warning	1287	'@@spider_internal_offset' is deprecated and will be removed in a future release
 SHOW VARIABLES LIKE "spider_internal_offset";
 Variable_name	Value
-spider_internal_offset	1
+spider_internal_offset	0
 CREATE TABLE tbl_a (a INT) ENGINE=Spider COMMENT='ios "1"';
 Warnings:
 Warning	1287	The table parameter 'ios' is deprecated and will be removed in a future release
@@ -80,7 +80,7 @@
 Warning	1287	'@@spider_internal_limit' is deprecated and will be removed in a future release
 SHOW VARIABLES LIKE "spider_internal_limit";
 Variable_name	Value
-spider_internal_limit	9223372032559808513
+spider_internal_limit	4294967295
 CREATE TABLE tbl_a (a INT) ENGINE=Spider COMMENT='ilm "1"';
 Warnings:
 Warning	1287	The table parameter 'ilm' is deprecated and will be removed in a future release
 
mysqltest: Result length mismatch

The test fails seemingly reliably on 10.7+ on this platform (only there).


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