[MDEV-29329] Some MTR tests fail with PS protocol (missing warnings) Created: 2022-08-18  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Dmitry Shulga
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-16708 Unsupported commands for prepared sta... Closed

 Description   

10.6 af552f29

perl ./mtr rocksdb.col_opt_null --ps-protocol
 
rocksdb.col_opt_null 'write_committed'   [ fail ]
        Test ended at 2022-08-18 21:11:19
 
CURRENT_TEST: rocksdb.col_opt_null
--- /mnt8t/bld/10.6-debug-nightly/mysql-test/plugin/rocksdb/rocksdb/r/col_opt_null.result	2022-02-10 06:05:03.000000000 +0200
+++ /mnt8t/bld/10.6-debug-nightly/mysql-test/plugin/rocksdb/rocksdb/r/col_opt_null.reject	2022-08-18 21:11:19.149535732 +0300
@@ -817,8 +817,6 @@
 y2 YEAR(2) NULL,
 pk DATETIME PRIMARY KEY
 ) ENGINE=rocksdb;
-Warnings:
-Note	1287	'YEAR(2)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
 SHOW COLUMNS IN t1;
 Field	Type	Null	Key	Default	Extra
 d	date	YES		NULL	
@@ -1002,10 +1000,6 @@
 c2 YEAR(2) NULL DEFAULT '12',
 pk INT AUTO_INCREMENT PRIMARY KEY
 ) ENGINE=rocksdb;
-Warnings:
-Note	1287	'YEAR(2)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
-Note	1287	'YEAR(2)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
-Note	1287	'YEAR(2)' is deprecated and will be removed in a future release. Please use YEAR(4) instead
 SHOW COLUMNS IN t1;
 Field	Type	Null	Key	Default	Extra
 c	year(2)	YES		NULL	
@@ -1539,7 +1533,6 @@
 6
 );
 Warnings:
-Warning	1916	Got overflow when converting '' to DECIMAL. Value truncated
 Warning	1264	Out of range value for column 'f' at row 1
 Warning	1264	Out of range value for column 'f0' at row 1
 Warning	1264	Out of range value for column 'r1_1' at row 1
 
mysqltest: Result length mismatch

Reproducible on 10.6+. Not reproducible on 10.3-10.5.

At least:
rocksdb.col_opt_not_null
rocksdb.col_opt_null
rocksdb.bloomfilter4
rocksdb.autoinc_vars_thread_2
rocksdb.col_opt_unsigned
rocksdb.no_merge_sort
rocksdb.select
rocksdb.type_date_time
rocksdb.type_float
engines/iuds.delete_year
engines/iuds.update_year
engines/iuds.insert_year

I guess it started happening after MDEV-16708.


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