engines/iuds and engines/funcs suites fail with ps-protocol

engines/iuds.insert_year 'myisam'        w4 [ fail ]

        Test ended at 2025-08-04 17:32:37

CURRENT_TEST: engines/iuds.insert_year

--- /share8t/bld/10.6-asan-ubsan/mysql-test/suite/engines/iuds/r/insert_year.result	2025-08-04 04:18:51.106343469 +0300

+++ /share8t/bld/10.6-asan-ubsan/mysql-test/suite/engines/iuds/r/insert_year.reject	2025-08-04 17:32:37.512416660 +0300

@@ -3249,21 +3249,9 @@

 1999	1999	1998-12-30	1998-12-30 11:30:45

 DROP TABLE t1,t2,t3,t4;

 CREATE TABLE t1(c1 YEAR(2) NOT NULL, c2 YEAR(2) NULL, c3 DATE, c4 DATETIME, PRIMARY KEY(c1), UNIQUE INDEX(c2));

-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

 CREATE TABLE t2(c1 YEAR(2) NOT NULL, c2 YEAR(2) NULL, c3 DATE, c4 DATETIME, PRIMARY KEY(c1,c2));

-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

 CREATE TABLE t3(c1 YEAR(2) NOT NULL, c2 YEAR(2) NULL, c3 DATE, c4 DATETIME, UNIQUE INDEX idx(c1,c2));

-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

 CREATE TABLE t4(c1 YEAR(2) NOT NULL, c2 YEAR(2) NULL, c3 DATE, c4 DATETIME);

-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

 INSERT INTO t1 VALUES('1901','1901','98-12-31','98.12.31 11:30:45'),('1999','1999','98-12-30','98.12.30 11:30:45'),('2000','2000','98-12-29','98.12.29 11:30:45'),('2001','2001','98-12-28','98.12.28 11:30:45'),('2099','2099','98-12-27','98.12.27 11:30:45'),('2100','2100','98-12-26','98.12.26 11:30:45'),('2155','2155','98-12-26','98.12.26 11:30:45');

 INSERT INTO t2 VALUES('1901','1901','98-12-31','98.12.31 11:30:45'),('1999','1999','98-12-30','98.12.30 11:30:45'),('2000','2000','98-12-29','98.12.29 11:30:45'),('2001','2001','98-12-28','98.12.28 11:30:45'),('2099','2099','98-12-27','98.12.27 11:30:45'),('2100','2100','98-12-26','98.12.26 11:30:45'),('2155','2155','98-12-26','98.12.26 11:30:45');

 INSERT INTO t3 VALUES('1901','1901','98-12-31','98.12.31 11:30:45'),('1999','1999','98-12-30','98.12.30 11:30:45'),('2000','2000','98-12-29','98.12.29 11:30:45'),('2001','2001','98-12-28','98.12.28 11:30:45'),('2099','2099','98-12-27','98.12.27 11:30:45'),('2100','2100','98-12-26','98.12.26 11:30:45'),('2155','2155','98-12-26','98.12.26 11:30:45');

Result length mismatch

 - saving '/share8t/bld/10.6-asan-ubsan/mysql-test/var/4/log/engines/iuds.insert_year-myisam/' to '/share8t/bld/10.6-asan-ubsan/mysql-test/var/log/iuds.insert_year-myisam/'

engines/iuds.update_decimal 'innodb'     w7 [ pass ]    295

engines/iuds.strings_charsets_update_delete 'myisam' w4 [ pass ]    113

engines/iuds.update_delete_number 'myisam' w5 [ pass ]   3581

engines/iuds.insert_number 'innodb'      w2 [ pass ]   4973

engines/iuds.insert_number 'myisam'      w8 [ pass ]   3700

engines/iuds.strings_update_delete 'innodb' w3 [ pass ]   4972

engines/iuds.update_time 'myisam'        w5 [ pass ]     47

engines/iuds.update_decimal 'myisam'     w8 [ pass ]     97

engines/iuds.strings_update_delete 'myisam' w4 [ pass ]   3417

engines/iuds.insert_time 'myisam'        w2 [ fail ]

        Test ended at 2025-08-04 17:32:41

CURRENT_TEST: engines/iuds.insert_time

mysqltest: At line 1026: query 'INSERT IGNORE INTO t1(c1,c2) VALUES('10:22:33','10:22:34') /* doesn't throw error */;

INSERT IGNORE INTO t2(c1,c2) VALUES('12:34:56.78','12:34:56.78') /*doesn't throw error */' failed: ER_PARSE_ERROR (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INSERT IGNORE INTO t2(c1,c2) VALUES('12:34:56.78','12:34:56.78') /*doesn't th...' at line 2

The result from queries just before the failure was:

< snip >

1

select cast('300:55:50' as time) > cast('240:00:00' as time);

cast('300:55:50' as time) > cast('240:00:00' as time)

1

create table t5 (f1 time);

insert into t5 values ('24:00:00');

select cast('24:00:00' as time) = (select f1 from t5);

cast('24:00:00' as time) = (select f1 from t5)

1

drop table t5;

INSERT INTO t1(c1,c2) VALUES('10:22:33','10:22:34') /* throws error as row exists with c1='10:22:33' */;

ERROR 23000: Duplicate entry '10:22:33' for key 'PRIMARY'

INSERT INTO t2(c1,c2) VALUES('12:34:56.78','12:34:56.78') /* throws error as row exists with c1='12:34:56.78',c2='12:34:56.78' */;

ERROR 23000: Duplicate entry '12:34:56-12:34:56' for key 'PRIMARY'

INSERT INTO t1(c1,c2) VALUES('10:22:34','34 9:23') /* throws error as row exists with c2='34 9:23' */;

ERROR 23000: Duplicate entry '825:23:00' for key 'c2'

INSERT INTO t3(c1,c2) VALUES('34 9:23','34 9:23') /* throws error as row exists with c1='34 9:23',c2='34 9:23' */;

ERROR 23000: Duplicate entry '825:23:00-825:23:00' for key 'idx'

INSERT IGNORE INTO t1(c1,c2) VALUES('10:22:33','10:22:34') /* doesn't throw error */;

INSERT IGNORE INTO t2(c1,c2) VALUES('12:34:56.78','12:34:56.78') /*doesn't throw error */;

More results from queries before failure can be found in /share8t/bld/10.6-asan-ubsan/mysql-test/var/2/log/insert_time.log

engines/funcs.ld_simple 'myisam'         w2 [ fail ]

        Test ended at 2025-08-04 17:34:28

CURRENT_TEST: engines/funcs.ld_simple

mysqltest: At line 6: query 'SELECT * INTO OUTFILE '../../tmp/t1.dat' FROM t1' failed: ER_FILE_EXISTS_ERROR (1086): File '../../tmp/t1.dat' already exists

The result from queries just before the failure was:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 VARCHAR(10), c3 DATETIME);

LOAD DATA LOCAL INFILE 'suite/engines/funcs/t/load_simple.inc' INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

SELECT * INTO OUTFILE '../../tmp/t1.dat' FROM t1;

 - saving '/share8t/bld/10.6-asan-ubsan/mysql-test/var/2/log/engines/funcs.ld_simple-myisam/' to '/share8t/bld/10.6-asan-ubsan/mysql-test/var/log/funcs.ld_simple-myisam/'