Skipping 1,042 KB.. Full Log

time="2025-09-03T11:19:30+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=351
time="2025-09-03T11:19:30+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=358
time="2025-09-03T11:19:30+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=365
./t/json_schema.test: ok! 108 test cases passed, take time 1.98609808 s
./t/index_merge_delete.test: ok! 206 test cases passed, take time 2.879073359 s
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=69
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=70
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=73
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=74
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=82
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=83
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=85
time="2025-09-03T11:19:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=86
./t/json_type.test: ok! 42 test cases passed, take time 0.264344081 s
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.129038001 s
time="2025-09-03T11:19:32+08:00" level=warning msg="key:313 query failed with non expected error(s)! (ER_MULTIPLE_PRI_KEY != 1091) (err: Error 1068 (42000): Multiple primary key defined) (query: alter table t1 add primary key (c1, c2);)"
time="2025-09-03T11:19:32+08:00" level=warning msg="key:322 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1);)"
./t/filesort.test: ok! 54 test cases passed, take time 12.039575419 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.107194939 s
./t/key.test: ok! 192 test cases passed, take time 1.7191272020000001 s
./t/key_diff.test: ok! 10 test cases passed, take time 0.056326684 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.267783091 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.107850068 s
time="2025-09-03T11:19:33+08:00" level=warning msg="key_myisam:303 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: alter table t1 drop key k;)"
./t/key_myisam.test: ok! 115 test cases passed, take time 0.891652173 s
./t/key_primary.test: ok! 12 test cases passed, take time 0.034964638 s
./t/keywords.test: ok! 51 test cases passed, take time 0.194910556 s
time="2025-09-03T11:19:34+08:00" level=warning msg="lead_lag:49 query failed with non expected error(s)! (ErrWrongArguments != ER_PARSE_ERROR) (err: Error 1210 (HY000): Incorrect arguments to lead) (query: SELECT id, sex, LEAD(id, 1.2) RESPECT NULLS OVER () FROM t1;)"
./t/foreign_key.test: ok! 158 test cases passed, take time 1.515935626 s
./t/lead_lag.test: ok! 214 test cases passed, take time 0.508088313 s
./t/lead_lag_explain.test: ok! 81 test cases passed, take time 0.244056489 s
./t/like.test: ok! 8 test cases passed, take time 0.012866175 s
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:161 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:164 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:173 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:176 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2025-09-03T11:19:35+08:00" level=warning msg="limit:253 query failed with non expected error(s)! (ErrWrongArguments != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2025-09-03T11:19:35+08:00" level=warning msg="limit:256 query failed with non expected error(s)! (ErrWrongArguments != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2025-09-03T11:19:35+08:00" level=warning msg="limit:259 query failed with non expected error(s)! (ErrWrongArguments != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a, @a;)"
./t/limit.test: ok! 174 test cases passed, take time 0.611436776 s
./t/limit_myisam.test: ok! 5 test cases passed, take time 0.027871499 s
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:337 query failed with non expected error(s)! (ErrFkDupName != ER_DUP_KEYNAME) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fk') (query: ALTER TABLE t2 ADD CONSTRAINT fk FOREIGN KEY(b) REFERENCES t1(a);)"
time="2025-09-03T11:19:35+08:00" level=warning msg="foreign_key1:343 query succeeded, but expected error(s)! (expected errors: ER_FK_DUP_NAME) (query: ALTER TABLE t2 ADD FOREIGN KEY(b) REFERENCES t1(a);)"
./t/long_tmpdir.test: ok! 3 test cases passed, take time 0.036920905 s
time="2025-09-03T11:19:35+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=7
time="2025-09-03T11:19:35+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=8
time="2025-09-03T11:19:36+08:00" level=warning msg="lowercase_fs_off:27 query failed with non expected error(s)! (ER_DB_CREATE_EXISTS != ER_DBACCESS_DENIED_ERROR) (err: Error 1007 (HY000): Can't create database 'D1'; database exists) (query: create database D1;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=29
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=35
time="2025-09-03T11:19:36+08:00" level=warning msg="lowercase_fs_off:52 query succeeded, but expected error(s)! (expected errors: ER_TABLEACCESS_DENIED_ERROR) (query: select * from t1;)"
./t/lowercase_fs_off.test: ok! 22 test cases passed, take time 0.124068617 s
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=3
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase1.inc" command=source line=4
./t/lowercase_mixed_tmpdir.test: ok! 8 test cases passed, take time 0.032379299 s
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key1:437 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key1:439 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key1:446 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key1:448 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" UPDATE parent SET pf2= 2, sleep_dummy= SLEEP(2)" command=send line=511
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=98
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=108
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=115
time="2025-09-03T11:19:36+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=126
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key1:531 query succeeded, but expected error(s)! (expected errors: ER_LOCK_WAIT_TIMEOUT) (query: ALTER TABLE child ADD COLUMN (i INT);)"
./t/foreign_key1.test: ok! 207 test cases passed, take time 1.762986122 s
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:41 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:41 query failed with non expected error(s)! (ER_FK_DEPTH_EXCEEDED != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t1 where id=0;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:63 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:76 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:94 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:117 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="lowercase_table:144 query failed with non expected error(s)! (ErrNoSuchTable != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE mysql.general_log DISCARD TABLESPACE;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="lowercase_table:146 query failed with non expected error(s)! (ErrNoSuchTable != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE MYSQL.general_log DISCARD TABLESPACE;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="lowercase_table:148 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.GENERAL_LOG' doesn't exist) (query: ALTER TABLE mysql.GENERAL_LOG DISCARD TABLESPACE;)"
./t/lowercase_table.test: ok! 72 test cases passed, take time 0.477900305 s
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:136 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:136 query failed with non expected error(s)! (ER_FK_DEPTH_EXCEEDED != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t0 where id=0;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:158 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t1 where id = 2;)"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2025-09-03T11:19:36+08:00" level=warning msg="foreign_key_cascade_delete:160 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t2 where id = 2;)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:286 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:327 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:368 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:385 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
./t/lowercase_table2.test: ok! 86 test cases passed, take time 0.682078123 s
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE `Table2`;" command=query_vertical line=81
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=82
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:432 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:449 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:495 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:535 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product_Order;" command=query_vertical line=109
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product;" command=query_vertical line=110
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Customer;" command=query_vertical line=111
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=112
./t/lowercase_table4.test: ok! 31 test cases passed, take time 0.265868483 s
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=15
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=16
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:575 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2025-09-03T11:19:37+08:00" level=warning msg="foreign_key_cascade_delete:655 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=28
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=35
./t/lowercase_table5.test: ok! 12 test cases passed, take time 0.091774759 s
./t/lowercase_table_grant.test: ok! 15 test cases passed, take time 0.058069387 s
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1 --character-set-server=utf8" command=exec line=27
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --character-set-server=utf8 --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=30
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=31
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=32
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=44
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments= command=shutdown_server line=45
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=46
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" echo \"restart\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=50
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=51
time="2025-09-03T11:19:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=52
./t/lowercase_utf8.test: ok! 6 test cases passed, take time 0.033385649 s
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1" command=exec line=22
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=25
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=26
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=27
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:56 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v1Aa);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:58 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2Aa set col1 = (select max(col1) from t1Aa);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:60 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v2Aa);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:62 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v1aA) where v2aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:64 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v1Aa) where t1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:66 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:68 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from v1aA) where v2Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:70 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v1Aa) where t1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:72 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1aA set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:74 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from t1aA) where v2aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:76 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t1Aa,t2Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:78 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from t1Aa) where v1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:80 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from t1aA) where v2Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:82 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:84 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from t1Aa) where v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:86 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:88 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v2aA) where t1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:90 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v2Aa) where v1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:92 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2aA set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:94 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v2aA) where t1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:96 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from v2Aa) where v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:98 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v1aA);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:100 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from t1aA);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:102 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v2aA);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:104 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v3aA);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:106 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v1Aa);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:108 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete from v2aA where col1 = (select max(col1) from t1Aa);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:110 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v2aA);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:112 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v1aA) > 0 and v2Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:114 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from v1Aa) > 0 and t1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:116 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from v1aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:118 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete v2aA from v2Aa,t2Aa where (select max(col1) from t1Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:120 query succeeded, but expected error(s)! (expected errors: 1093) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from t1aA) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:122 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from t1aA) > 0 and v1aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:124 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v2Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:126 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1Aa from t1aA,t2Aa where (select max(col1) from v2Aa) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:128 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v1Aa is not supported now) (query: delete v1Aa from v1aA,t2Aa where (select max(col1) from v2aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:130 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v1aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:132 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1aA values ((select max(col1) from v1Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:134 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v1aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:136 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from t1Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:138 query succeeded, but expected error(s)! (expected errors: 1093) (query: insert into t1aA values ((select max(col1) from t1Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:140 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from t1aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:142 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v2aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:144 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1Aa values ((select max(col1) from v2Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:146 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v2Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:148 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v1Aa));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:150 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3aA (col1) values ((select max(col1) from t1aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="lowercase_view:152 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v2aA));)"
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=176
time="2025-09-03T11:19:38+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=190
./t/lowercase_view.test: ok! 83 test cases passed, take time 0.418304752 s
./t/lpad.test: ok! 26 test cases passed, take time 0.004355041 s
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:389 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:389 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect * from t2,t where t2.c=t.f1;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:397 Unknown named --error ER_DUP_QUERY_NAME"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:397 query failed with non expected error(s)! (ErrNonuniqTable != ER_DUP_QUERY_NAME) (err: Error 1066 (42000): Not unique table/alias: '%-.192s') (query: with t as (select * from t2 where c>3),\nt as (select a from t1 where a>2)\nselect * from t,t1 where t1.a=t.c;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:408 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:408 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive t as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:414 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:414 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:421 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:421 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from t1\nwhere a in (select c from s where b<='ccc') and  b>'b'),\ns as (select * from t1,t2\nwhere t1.a=t2.c and t1.c in (select a from t where a<5))\nselect * from s where s.b>'aaa';)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:429 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:429 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_UNION != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 3573 (HY000): Recursive Common Table Expression 's' should contain a UNION) (query: with recursive\nt as (select * from t1 where b>'aaa' and b <='d')\nselect t.b from t,t2\nwhere t.a=t2.c and\nt2.c in (with recursive\ns as (select t1.a from s,t1 where t1.a=s.a and t1.b<'c')\nselect * from s);)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:461 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:461 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2025-09-03T11:19:38+08:00" level=warning msg="mariadb_cte_nonrecursive:467 query succeeded, but expected error(s)! (expected errors: ER_DUP_FIELDNAME) (query: with t(f1,f1) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=741
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=742
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=769
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=770
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=800
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=817
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=834
time="2025-09-03T11:19:39+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=852
time="2025-09-03T11:19:40+08:00" level=warning msg="command not implemented" arguments=" |;" command=delimiter line=1297
time="2025-09-03T11:19:40+08:00" level=warning msg="command not implemented" arguments=" ;|\ndrop table t1,t2;" command=delimiter line=1299
./t/mariadb_cte_nonrecursive.test: ok! 382 test cases passed, take time 2.064018442 s
time="2025-09-03T11:19:40+08:00" level=warning msg="command not implemented" arguments=" include/default_optimizer_switch.inc" command=source line=2
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:11 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:11 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.r' doesn't exist) (query: with recursive\nt as\n(\nselect * from t1 where t1.b >= 'c'\nunion\nselect * from r\n),\nr as\n(\nselect * from t\nunion\nselect t1.* from t1,r where r.a+1 = t1.a\n)\nselect * from r;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:28 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:28 query failed with non expected error(s)! (ErrNoSuchTable != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.b1' doesn't exist) (query: with recursive\na1(a,b) as\n(select * from t1 where t1.a>3\nunion\nselect * from b1 where b1.a >3\nunion\nselect * from c1 where c1.a>3),\nb1(a,b) as\n(select * from a1 where a1.b > 'ccc'\nunion\nselect * from c1 where c1.b > 'ddd'),\nc1(a,b) as\n(select * from a1 where a1.a<6 and a1.b< 'zz'\nunion\nselect * from b1 where b1.b > 'auu')\nselect * from c1;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:284 query succeeded, but expected error(s)! (expected errors: 1112) (query: with recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me' and dob = '2000-01-01'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect *\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id);)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:304 query succeeded, but expected error(s)! (expected errors: 1112) (query: with\nancestor_couples(husband, h_dob, wife, w_dob)\nas\n(\nwith recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect t1.name, t1.dob, t2.name, t2.dob\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id)\n)\nselect * from ancestor_couples;)"
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 4.113888734 s
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:753 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:753 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me' and  father is not null\nunion all\nselect mother, 1 from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:772 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:772 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father from folks where name = 'Me' and  father is not null\nunion all\nselect mother from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:810 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:810 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'coupled_ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\ncoupled_ancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me' and father is not null\nunion\nselect mother from folks where name = 'Me' and mother is not null\nunion\nselect n.father\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\nunion\nselect n.mother\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\n)\nselect p.* from coupled_ancestor_ids a, folks p\nwhere a.id = p.id;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:858 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:858 query failed with non expected error(s)! (ErrCTERecursiveForbiddenJoinOrder != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3576 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints) (query: with recursive\nancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me'\nunion\nselect mother from folks where name = 'Me'\nunion\nselect father from folks left join ancestor_ids a on folks.id = a.id\nunion\nselect mother from folks left join ancestor_ids a on folks.id = a.id\n),\nancestors\nas\n(\nselect p.* from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:923 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-09-03T11:19:40+08:00" level=warning msg="mariadb_cte_recursive:923 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDS_AGGREGATION != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3575 (HY000): Recursive Common Table Expression 'ancestor_ids' can contain neither aggregation nor window functions in recursive query block) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me'\nunion\nselect mother, 1 from folks where name = 'Me'\nunion\nselect max(father), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\nunion\nselect max(mother), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\n),\nancestors\nas\n(\nselect generation, name from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2025-09-03T11:19:41+08:00" level=warning msg="mariadb_cte_recursive:1518 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 1064) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.applied_modules' doesn't exist) (query: with recursive\nreached_values as\n(\nselect v from value_nodes where v in ('v3','v7','v9')\nunion\nselect module_results.v from module_results, applied_modules\nwhere module_results.m = applied_modules.m\n),\napplied_modules as\n(\nselect module_nodes.m\nfrom\nmodule_nodes\nleft join\n(\nmodule_arguments\nleft join\nreached_values\non module_arguments.v = reached_values.v\n)\non reached_values.v is null and\nmodule_nodes.m = module_arguments.m\nwhere module_arguments.m is null\n)\nselect * from reached_values;)"
time="2025-09-03T11:19:41+08:00" level=warning msg="foreign_key_cascade_mysql:290 query succeeded, but expected error(s)! (expected errors: 1215) (query: alter table blobchild add constraint fkbad foreign key(a) references parent (a) on delete cascade on update restrict;)"
time="2025-09-03T11:19:41+08:00" level=warning msg="foreign_key_cascade_mysql:315 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (a) on delete cascade on update restrict;)"
time="2025-09-03T11:19:41+08:00" level=warning msg="foreign_key_cascade_mysql:343 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(a) references parent (b) on delete cascade on update restrict;)"
time="2025-09-03T11:19:41+08:00" level=warning msg="foreign_key_cascade_mysql:371 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (b) on delete cascade on update restrict;)"
time="2025-09-03T11:19:42+08:00" level=warning msg="foreign_key_cascade_mysql:402 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (a) on delete cascade on update restrict;)"
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q1;" command=eval line=1771
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=1772
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q2;" command=eval line=1774
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=1775
time="2025-09-03T11:19:42+08:00" level=warning msg="mariadb_cte_recursive:1814 query failed with non expected error(s)! (ErrCTERecursiveForbidsAggregation != 3577) (err: Error 3575 (HY000): Recursive Common Table Expression 'cte' can contain neither aggregation nor window functions in recursive query block) (query: WITH RECURSIVE cte(f) AS (\nSELECT i FROM t\nUNION\nSELECT i FROM t\nWHERE i NOT IN ( SELECT * FROM t\nWHERE i IN ( SELECT * FROM cte ) GROUP BY i )\n) SELECT * FROM cte;)"
time="2025-09-03T11:19:42+08:00" level=warning msg="mariadb_cte_recursive:1887 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-09-03T11:19:42+08:00" level=warning msg="mariadb_cte_recursive:1887 query failed with non expected error(s)! (ErrNoSuchTable != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.cte_2' doesn't exist) (query: set @var=\n(\nwith recursive\ncte_1 as (\nselect 1\nunion\nselect * from cte_2),\ncte_2 as (\nselect * from cte_1\nunion\nselect a from t1, cte_2\nwhere t1.a=cte_2.a)\nselect * from cte_2\nlimit 1\n);)"
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=1955
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=1956
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2032
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $q;" command=eval line=2033
time="2025-09-03T11:19:42+08:00" level=warning msg="foreign_key_cascade_mysql:430 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (b) on delete cascade on update restrict;)"
./t/foreign_key_cascade_mysql.test: ok! 274 test cases passed, take time 1.511623516 s
time="2025-09-03T11:19:42+08:00" level=warning msg="mariadb_cte_recursive:2118 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: WITH RECURSIVE qn AS\n(\nselect 1,0 as col from t1\nunion distinct\nselect 1,0 from t1\nunion all\nselect 3, 0*(@c:=@c+1) from qn where @c<1\nunion all\nselect 3, 0*(@d:=@d+1) from qn where @d<1\n)\nselect * from qn;)"
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2168
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2183
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=2195
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=2207
time="2025-09-03T11:19:42+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=2219
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from cte as t;" command=eval line=2342
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from cte as t;" command=eval line=2347
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from t1 as t;" command=eval line=2351
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from t1 as t;" command=eval line=2356
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2410
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2435
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2436
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" explain $q1;" command=eval line=2448
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2449
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2464
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2475
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2476
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 0.744180332 s

Great, All tests passed
mysqltest end
tidb-server(PID: 1651) stopped
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-qe-tidb-test-ghpr_mysql_test-461/mysql-test already exists)
[Pipeline] // cache
[Pipeline] }
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2535
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2564
time="2025-09-03T11:19:43+08:00" level=warning msg="mariadb_cte_recursive:2566 query succeeded, but expected error(s)! (expected errors: 1146) (query: drop table folks;)"
time="2025-09-03T11:19:43+08:00" level=warning msg="mariadb_cte_recursive:2751 query failed with non expected error(s)! (ErrNotSupportedYet != 1064) (err: Error 1235 (42000): This version of TiDB doesn't yet support 'INTERSECT between recursive part's selects, hint: The operator between recursive part's selects must bu UNION[DISTINCT] or UNION ALL') (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a, distances d\nwhere a.departure = 'Seattle' and\na.departure = d.city1 and a.arrival = d.city2 and\nd.dist < 4000\nunion\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nintersect\nselect city2 from destinations s, distances d\nwhere s.city = d.city1 and d.dist < 4000\n)\nselect * from destinations;)"
time="2025-09-03T11:19:43+08:00" level=warning msg="mariadb_cte_recursive:2767 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_SINGLE_REFERENCE != 1064) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'destinations', the recursive table must be referenced only once, and not in any subquery) (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a where a.departure = 'Seattle'\nunion\nselect * from\n(\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nexcept\nselect arrival from flights\nwhere arrival in\n('New York', 'London', 'Moscow', 'Dubai', 'Cairo', 'Tokyo')\n) t\n)\nselect * from destinations;)"
./t/mariadb_cte_recursive.test: ok! 313 test cases passed, take time 2.938241407 s
./t/math.test: ok! 6 test cases passed, take time 0.010870631 s
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2025-09-03T11:19:43+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=4
time="2025-09-03T11:19:43+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user01@% has exceeded the 'max_user_connections' resource"
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
time="2025-09-03T11:19:44+08:00" level=error msg="open db failed Error 1203 (42000): User user01@% has exceeded the 'max_user_connections' resource, take time 500.700692ms"
time="2025-09-03T11:19:44+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource"
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2025-09-03T11:19:44+08:00" level=error msg="open db failed Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource, take time 500.928111ms"
time="2025-09-03T11:19:44+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource"
time="2025-09-03T11:19:45+08:00" level=error msg="open db failed Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource, take time 500.714582ms"
./t/max_user_connections.test: ok! 20 test cases passed, take time 1.637574581 s
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=6
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=8
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=51
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments=" //\ncreate table t1 (i int)//\ninsert into t1 values (1),(2),(3)//\nselect * from t1 where i = 2//\ndrop table t1//\ndelimiter ;" command=delimiter line=57
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=269
./t/metadata.test: ok! 89 test cases passed, take time 0.593102946 s
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2025-09-03T11:19:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
time="2025-09-03T11:19:46+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=28
./t/metadata_myisam.test: ok! 14 test cases passed, take time 0.109407393 s
time="2025-09-03T11:19:46+08:00" level=warning msg="multi_update:23 query failed with non expected error(s)! (ErrUnknown not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.t1 from mysqltest_1@localhost;)"
time="2025-09-03T11:19:46+08:00" level=warning msg="multi_update:25 query failed with non expected error(s)! (ER_UNKNOWN_ERROR not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.* from mysqltest_1@localhost;)"
time="2025-09-03T11:19:46+08:00" level=warning msg="multi_update:245 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE t1,t2 SET t1.d=t2.d WHERE t1.n=t2.n;)"
time="2025-09-03T11:19:47+08:00" level=warning msg="multi_update:467 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: update t1,t2 set t1.col1 = (select max(col1) from t1) where t1.col1 = t2.col1;)"
time="2025-09-03T11:19:47+08:00" level=warning msg="multi_update:469 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2.col1;)"
time="2025-09-03T11:19:48+08:00" level=warning msg="multi_update:494 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete from t1,t2 using t1,t2 where t1.a=(select a from t1);)"
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" alter table t1 add column c int default 100 after a;" command=send line=555
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=563
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" update t1, v1 set t1.b=t1.a+t1.b+v1.b where t1.a=v1.a;" command=send line=564
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=574
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=578
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=581
time="2025-09-03T11:19:48+08:00" level=warning msg="multi_update:644 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: delete t3.* from t2,t3 where t2.a=t3.a;)"
time="2025-09-03T11:19:48+08:00" level=warning msg="multi_update:666 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1;)"
time="2025-09-03T11:19:48+08:00" level=warning msg="multi_update:768 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 ORDER BY a;)"
time="2025-09-03T11:19:48+08:00" level=warning msg="multi_update:770 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 LIMIT 3;)"
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=837
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=841
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=842
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=845
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=850
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=851
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=852
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=861
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=862
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=868
time="2025-09-03T11:19:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=869
./t/multi_update.test: ok! 358 test cases passed, take time 2.927444254 s
time="2025-09-03T11:19:49+08:00" level=warning msg="multi_update_innodb:24 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A, t1 AS B SET A.pk = 1, B.a = 2;)"
time="2025-09-03T11:19:49+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2025-09-03T11:19:49+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2025-09-03T11:19:49+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=113
./t/multi_update_innodb.test: ok! 62 test cases passed, take time 0.309825298 s
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.136510064 s
time="2025-09-03T11:19:51+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ErrDupEntry != 1176) (err: Error 1062 (23000): Duplicate entry '2-1850766141593485312-3' for key 't1.mv_idx_date') (query: INSERT INTO t1 SELECT * FROM t1 USE KEY FOR GROUP BY ( mv_idx_unsigned , mv_idx_signed ) GROUP BY j3 ORDER BY j1;)"
./t/multi_valued_index.test: ok! 659 test cases passed, take time 2.990421283 s
./t/index_merge_intersection_partition_tbl_simple.test: ok! 5865 test cases passed, take time 20.357565316 s
./t/multi_valued_index_cost_based.test: ok! 313 test cases passed, take time 0.513719761 s
time="2025-09-03T11:19:53+08:00" level=warning msg="mysql_replace:20 query succeeded, but expected error(s)! (expected errors: ErrUnsupportedDDLOperation) (query: alter table t1 engine=heap;)"
./t/mysql_replace.test: ok! 19 test cases passed, take time 0.089149945 s
time="2025-09-03T11:19:53+08:00" level=error msg="run test [negation_elimination] err: sql:explain format = 'brief' select * from t1 where not(not(a));: failed to run query \n\"explain format = 'brief' select * from t1 where not(not(a));\" \n around line 16, \nwe need(215):\nexplain format = 'brief' select * from t1 where not(not(a));\nid\testRows\ttask\taccess object\toperator info\nIndexReader\t19.40\troot\t\t#\n└─IndexRangeScan\t19.40\tcop[tikv]\ttable:t1, index:a(a)\t#\nselect * from t1 where n\nbut got(215):\nexplain format = 'brief' select * from t1 where not(not(a));\nid\testRows\ttask\taccess object\toperator info\nTableReader\t19.40\troot\t\t#\n└─Selection\t19.40\tcop[tikv]\t\t#\n  └─TableFullScan\t21.00\tcop[tikv]\ttable:t1\t#\n\n"
time="2025-09-03T11:19:53+08:00" level=warning msg="nth:39 query succeeded, but expected error(s)! (expected errors: ER_WRONG_ARGUMENTS) (query: SELECT id, sex, NTH_VALUE(id, NULL) OVER () FROM t1;)"
./t/nth.test: ok! 86 test cases passed, take time 0.11020685 s
./t/null_key_all_innodb.test: ok! 72 test cases passed, take time 0.712938397 s
./t/odbc.test: ok! 32 test cases passed, take time 0.13103555 s
./t/operator.test: ok! 28 test cases passed, take time 0.010525193 s
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.408687483 s
time="2025-09-03T11:19:54+08:00" level=warning msg="command not implemented" arguments=" include/not_hypergraph.inc  # Join order hints are not supported." command=source line=2
./t/opt_hints_join_order.test: ok! 83 test cases passed, take time 0.437205608 s
./t/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.297762944 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.122061536 s
time="2025-09-03T11:19:55+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=120
time="2025-09-03T11:19:55+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=169
time="2025-09-03T11:19:55+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=183
./t/order_by_limit.test: ok! 45 test cases passed, take time 0.409181036 s
./t/index_merge_intersection_single_tbl.test: ok! 3701 test cases passed, take time 5.141845292 s
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 1.342763258 s
./t/orderby.test: ok! 53 test cases passed, take time 0.075643759 s
time="2025-09-03T11:19:57+08:00" level=warning msg="overflow:9 query failed with non expected error(s)! (ErrDBDropExists not in ER_PARSE_ERROR,ER_TOO_LONG_IDENT,ER_WRONG_NAME_FOR_INDEX) (err: Error 1008 (HY000): Can't drop database 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'; database doesn't exist) (query: drop database AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA;)"
./t/overflow.test: ok! 2 test cases passed, take time 0.00380167 s
./t/packet.test: ok! 50 test cases passed, take time 0.095943687 s
time="2025-09-03T11:19:57+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2025-09-03T11:19:57+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2025-09-03T11:19:57+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2025-09-03T11:19:57+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
time="2025-09-03T11:19:58+08:00" level=warning msg="packet_myisam:43 query failed with non expected error(s)! (ErrEntryTooLarge != ER_WARN_ALLOWED_PACKET_OVERFLOWED) (err: Error 8025 (HY000): entry too large, the max entry size is 6291456, the size of data is 67108897) (query: UPDATE t3\nSET c32= CONCAT(c32,\nREPEAT('a', @max_allowed_packet-1));)"
./t/packet_myisam.test: ok! 11 test cases passed, take time 0.316909079 s
time="2025-09-03T11:19:59+08:00" level=warning msg="command not implemented" arguments=" $$\nselect \"non terminated\"$$\nselect \"terminated\";$$\nselect \"non terminated, space\"      $$\nselect \"terminated, space\";      $$\nselect \"non terminated, comment\" /* comment */$$\nselect \"terminated, comment\"; /* comment */$$\nselect \"stmt 1\";select \"stmt 2 non terminated\"$$\nselect \"stmt 1\";select \"stmt 2 terminated\";$$\nselect \"stmt 1\";select \"stmt 2 non terminated, space\"      $$\nselect \"stmt 1\";select \"stmt 2 terminated, space\";      $$\nselect \"stmt 1\";select \"stmt 2 non terminated, comment\" /* comment */$$\nselect \"stmt 1\";select \"stmt 2 terminated, comment\"; /* comment */$$\nselect \"stmt 1\";             select \"space, stmt 2\"$$\nselect \"stmt 1\";/* comment */select \"comment, stmt 2\"$$" command=delimiter line=423
time="2025-09-03T11:19:59+08:00" level=warning msg="command not implemented" arguments=" ;" command=delimiter line=448
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:556 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait();)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:558 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait(1);)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:562 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST not in 0,ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait('binlog.999999', 4, -1);)"
time="2025-09-03T11:19:59+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=915
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:923 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:932 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:941 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 ORDER BY 1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:959 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:968 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:977 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:986 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1061 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine=a.myisam;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1065 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.b.myisam' in '') (query: SET default_storage_engine = a.b.MyISAM;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1067 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.MyISAM;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1069 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.`MyISAM`;)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1071 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = \"a.MYISAM\";)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1073 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = 'a.MYISAM';)"
time="2025-09-03T11:19:59+08:00" level=warning msg="parser:1075 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = `a.MYISAM`;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1220 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: REPLACE INTO `` SELECT * FROM ``;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1265 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=NONE;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1267 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=SHARED;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1273 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITH VALIDATION;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1275 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITHOUT VALIDATION;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1277 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 LOCK=SHARED, WITH VALIDATION, ALGORITHM=COPY,\nLOCK=EXCLUSIVE, WITHOUT VALIDATION, ALGORITHM=INPLACE;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1317 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT a FROM t1 LIMIT 1 UNION ALL SELECT a FROM t1;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1320 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: (SELECT a FROM t1 LIMIT 1) UNION ALL (SELECT a FROM t1 ORDER BY a) LIMIT 2;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1371 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1 ORDER BY a UNION SELECT a FROM t1;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1377 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1\nUNION\nSELECT a FROM t1 ORDER BY a\nUNION\nSELECT a FROM t1;)"
time="2025-09-03T11:20:00+08:00" level=warning msg="parser:1538 query failed with non expected error(s)! (ErrNonUniq != ER_NONUNIQ_TABLE) (err: Error 1052 (23000): Column 'a' in field list is ambiguous) (query: SELECT * FROM ( t1 JOIN t2 ON TRUE, t1 JOIN t3 ON TRUE );)"
./t/index_merge_intersection_trs.test: ok! 4356 test cases passed, take time 4.026616685 s
./t/index_merge_mvindex_multiple_table.test: ok! 324 test cases passed, take time 0.432030736 s
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:1954 query failed with non expected error(s)! (ER_SYNTAX_ERROR != ER_PARSE_ERROR) (err: Error 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use) (query: CREATE TABLE t1 (a INT) PARTITION BY KEY ALGORITHM = 10 () PARTITIONS 3;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:1978 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: DROP INDEX idx1 ON ``;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2035 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET NAMES utf8 COLLATE DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2237 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE ROLE `RESOURCE`;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2245 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global') (query: SET GLOBAL = DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2247 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local') (query: SET LOCAL = DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2249 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist') (query: SET PERSIST = DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2251 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist_only') (query: SET PERSIST_ONLY = DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2253 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session') (query: SET SESSION = DEFAULT;)"
time="2025-09-03T11:20:01+08:00" level=warning msg="parser:2377 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t4 (\nx VARCHAR(10)\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
./t/parser.test: ok! 692 test cases passed, take time 3.71201923 s
./t/parser_precedence.test: ok! 138 test cases passed, take time 0.090425887 s
./t/index_merge_mvindex_single_table.test: ok! 1005 test cases passed, take time 1.000321698 s
./t/index_merge_sqlgen_exprs.test: ok! 456 test cases passed, take time 0.818753143 s

Great, All tests passed
mysqltest end
tidb-server(PID: 1703) stopped
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-qe-tidb-test-ghpr_mysql_test-461/mysql-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
time="2025-09-03T11:20:03+08:00" level=warning msg="partition:345 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: ALTER TABLE t1\nPARTITION BY HASH (a)\n(PARTITION p0 ENGINE=InnoDB,\nPARTITION p1 ENGINE=NonExistentEngine);)"
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2025-09-03T11:20:05+08:00" level=warning msg="partition:1357 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0) (subpartition sp0),\npartition p1 values less than (1));)"
time="2025-09-03T11:20:05+08:00" level=warning msg="partition:1364 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0),\npartition p1 values less than (1) (subpartition sp0));)"
time="2025-09-03T11:20:05+08:00" level=warning msg="partition:1374 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by list (a)\nsubpartition by hash(a)\n(partition p0 values in (0),\npartition p1 values in (1) (subpartition sp0));)"
time="2025-09-03T11:20:05+08:00" level=warning msg="partition:1463 Unknown named --error ErrGlobalIndexNotExplicitlySet"
time="2025-09-03T11:20:05+08:00" level=warning msg="partition:1463 query failed with non expected error(s)! (8264 != ErrGlobalIndexNotExplicitlySet) (err: Error 8264 (HY000): Global Index is needed for index 'PRIMARY', since the unique index is not including all partitioning columns, and GLOBAL is not given as IndexOption) (query: alter table t1 add primary key (b);)"
time="2025-09-03T11:20:06+08:00" level=warning msg="partition:1711 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != ER_NULL_IN_VALUES_LESS_THAN) (err: Error 1659 (HY000): Field 'NULL' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a int)\nPARTITION BY RANGE(a)\n(PARTITION p0 VALUES LESS THAN (NULL));)"
time="2025-09-03T11:20:06+08:00" level=warning msg="command not implemented" arguments=" ($cnt)\n{\nupdate t1 set s2 = 1;" command=while line=2063
time="2025-09-03T11:20:06+08:00" level=warning msg="command not implemented" arguments=" $cnt;" command=dec line=2067
time="2025-09-03T11:20:06+08:00" level=warning msg="command not implemented" arguments=" ($n)\n{\ninsert into t1 (user) values ('mysql');" command=while line=2192
time="2025-09-03T11:20:06+08:00" level=warning msg="command not implemented" arguments=" $n;" command=dec line=2195
time="2025-09-03T11:20:08+08:00" level=warning msg="partition:2435 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) (err: Error 8200 (HY000): unsupported add column 's3' constraint UNIQUE KEY when altering 'partition.t1') (query: ALTER TABLE t1 ADD COLUMN (s3 VARCHAR(5) UNIQUE);)"
time="2025-09-03T11:20:08+08:00" level=warning msg="partition:2486 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table B of the UPDATE is not updatable) (query: UPDATE t1_part AS A NATURAL JOIN v1 as B SET A.nokey = 2 , B.partkey = 3;)"
time="2025-09-03T11:20:08+08:00" level=warning msg="partition:2488 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A NATURAL JOIN t1_part as B SET A.nokey = 2 , B.partkey = 3;)"
time="2025-09-03T11:20:08+08:00" level=warning msg="partition:2728 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DROP TABLE IF EXISTS `example`;)"
time="2025-09-03T11:20:09+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=2939
time="2025-09-03T11:20:09+08:00" level=warning msg="partition:2945 query failed with non expected error(s)! (ER_DUP_FIELDNAME != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 CHANGE COLUMN i j INT, CHANGE COLUMN j i INT;)"
time="2025-09-03T11:20:09+08:00" level=warning msg="partition:2984 query failed with non expected error(s)! (ER_DUP_FIELDNAME != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 RENAME COLUMN i TO j, RENAME COLUMN j TO i;)"
./t/partition.test: ok! 725 test cases passed, take time 7.097499153 s
./t/partition_bug18198.test: ok! 45 test cases passed, take time 0.051124953 s
time="2025-09-03T11:20:09+08:00" level=warning msg="partition_column:49 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a BLOB)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2025-09-03T11:20:09+08:00" level=warning msg="partition_column:54 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a TEXT)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2025-09-03T11:20:10+08:00" level=warning msg="partition_column:477 query failed with non expected error(s)! (ER_PARTITION_COLUMN_LIST_ERROR != 1566) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: create table t1 (a int, b int)\npartition by range columns(a,b)\n(partition p0 values less than (10));)"
time="2025-09-03T11:20:10+08:00" level=warning msg="partition_column:530 query failed with non expected error(s)! (ER_RANGE_NOT_INCREASING_ERROR != ER_REORG_OUTSIDE_RANGE) (err: Error 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition) (query: alter table t1 reorganize partition p0 into\n(partition p01 values less than (0,3),\npartition p02 values less than (1,1));)"
./t/partition_column.test: ok! 152 test cases passed, take time 1.090182026 s
./t/partition_column_prune.test: ok! 27 test cases passed, take time 0.425125662 s
./t/partition_func.test: ok! 1341 test cases passed, take time 8.317164979 s
./t/partition_grant.test: ok! 20 test cases passed, take time 0.161072829 s

time="2025-09-03T11:20:19+08:00" level=error msg="4 tests failed\n"
time="2025-09-03T11:20:19+08:00" level=error msg="run test [join] err: sql:explain format=\"brief\"\nSELECT *\nFROM\nt1 JOIN t2 ON t1.a = t2.a\nLEFT JOIN\n(\n(\nt3 LEFT JOIN t4 ON t3.a = t4.a\n)\nLEFT JOIN\n(\nt5 LEFT JOIN t6 ON t5.a = t6.a\n)\nON t4.a = t5.a\n)\nON t1.a = t3.a;: failed to run query \n\"explain format=\"brief\"\nSELECT *\nFROM\nt1 JOIN t2 ON t1.a = t2.a\nLEFT JOIN\n(\n(\nt3 LEFT JOIN t4 ON t3.a = t4.a\n)\nLEFT JOIN\n(\nt5 LEFT JOIN t6 ON t5.a = t6.a\n)\nON t4.a = t5.a\n)\nON t1.a = t3.a;\" \n around line 835, \nwe need(1956):\nexplain format=\"brief\"\nSELECT *\nFROM\nt1 JOIN t2 ON t1.a = t2.a\nLEFT JOIN\n(\n(\nt3 LEFT JOIN t4 ON t3.a = t4.a\n)\nLEFT JOIN\n(\nt5 LEFT JOIN t6 ON t5.a = t6.a\n)\nON t4.a = t5.a\n)\nON t1.a = t3.a;\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t585.94\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join.t1.a, join.t3.a)]\n├─HashJoin(Build)\t19.53\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join.t4.a, join.t5.a)]\n│ ├─HashJoin(Build)\t12.50\troot\t\tleft outer join, left side:IndexReader, equal:[eq(join.t3.a, join.t4.a)]\n│ │ ├─IndexReader(Build)\t10.00\troot\t\tindex:IndexFullScan\n│ │ │ └─IndexFullScan\t10.00\tcop[tikv]\ttable:t3, index:a(a)\tkeep order:false\n│ │ └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n│ │   └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t4.a))\n│ │     └─TableFullScan\t10000.00\tcop[tikv]\ttable:t4\tkeep order:false, stats:pseudo\n│ └─HashJoin(Probe)\t12487.50\troot\t\tleft outer join, left side:TableReader, equal:[eq(join.t5.a, join.t6.a)]\n│   ├─TableReader(Build)\t9990.00\troot\t\tdata:Selection\n│   │ └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t6.a))\n│   │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:t6\tkeep order:false, stats:pseudo\n│   └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n│     └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t5.a))\n│       └─TableFullScan\t10000.00\tcop[tikv]\ttable:t5\tkeep order:false, stats:pseudo\n└─HashJoin(Probe)\t30.00\troot\t\tinner join, equal:[eq(join.t1.a, join.t2.a)]\n  ├─TableReader(Build)\t3.00\troot\t\tdata:Selection\n  │ └─Selection\t3.00\tcop[tikv]\t\tnot(isnull(join.t1.a))\n  │   └─TableFullScan\t3.00\tcop[tikv]\ttable:t1\tkeep order:false\n  └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(join.t2.a))\n      └─TableFullScan\t10.00\tcop[tikv]\ttable:t2\tkeep order:false\nSELECT *\nFROM\nt1 JOIN t2 ON t1.a = t2.a\nLEFT JOIN\n(\n(\nbut got(1956):\nexplain format=\"brief\"\nSELECT *\nFROM\nt1 JOIN t2 ON t1.a = t2.a\nLEFT JOIN\n(\n(\nt3 LEFT JOIN t4 ON t3.a = t4.a\n)\nLEFT JOIN\n(\nt5 LEFT JOIN t6 ON t5.a = t6.a\n)\nON t4.a = t5.a\n)\nON t1.a = t3.a;\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t585.94\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join.t1.a, join.t3.a)]\n├─HashJoin(Build)\t19.53\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join.t4.a, join.t5.a)]\n│ ├─HashJoin(Build)\t12.50\troot\t\tleft outer join, left side:TableReader, equal:[eq(join.t3.a, join.t4.a)]\n│ │ ├─TableReader(Build)\t10.00\troot\t\tdata:Selection\n│ │ │ └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(join.t3.a))\n│ │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:t3\tkeep order:false\n│ │ └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n│ │   └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t4.a))\n│ │     └─TableFullScan\t10000.00\tcop[tikv]\ttable:t4\tkeep order:false, stats:pseudo\n│ └─HashJoin(Probe)\t12487.50\troot\t\tleft outer join, left side:TableReader, equal:[eq(join.t5.a, join.t6.a)]\n│   ├─TableReader(Build)\t9990.00\troot\t\tdata:Selection\n│   │ └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t6.a))\n│   │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:t6\tkeep order:false, stats:pseudo\n│   └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n│     └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(join.t5.a))\n│       └─TableFullScan\t10000.00\tcop[tikv]\ttable:t5\tkeep order:false, stats:pseudo\n└─HashJoin(Probe)\t30.00\troot\t\tinner join, equal:[eq(join.t1.a, join.t2.a)]\n  ├─TableReader(Build)\t3.00\troot\t\tdata:Selection\n  │ └─Selection\t3.00\tcop[tikv]\t\tnot(isnull(join.t1.a))\n  │   └─TableFullScan\t3.00\tcop[tikv]\ttable:t1\tkeep order:false\n  └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(join.t2.a))\n      └─TableFullScan\t10.00\tcop[tikv]\ttable:t2\tkeep order:false\n\n"
time="2025-09-03T11:20:19+08:00" level=error msg="run test [join_nested_bka] err: sql:EXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);: failed to run query \n\"EXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\" \n around line 23, \nwe need(1382):\nEXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t3.20\troot\t\tleft outer join, left side:TableReader, equal:[eq(join_nested_bka.t5.b, join_nested_bka.t7.b)]\n├─Selection(Build)\t3.20\troot\t\tor(gt(join_nested_bka.t8.a, 0), isnull(join_nested_bka.t8.c))\n│ └─HashJoin\t4.00\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join_nested_bka.t7.b, join_nested_bka.t8.b)], left cond:[lt(join_nested_bka.t6.b, 10)]\n│   ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│   │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka.t8.b))\n│   │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t8\tkeep order:false\n│   └─HashJoin(Probe)\t4.00\troot\t\tCARTESIAN inner join\n│     ├─IndexReader(Build)\t2.00\troot\t\tindex:IndexFullScan\n│     │ └─IndexFullScan\t2.00\tcop[tikv]\ttable:t7, index:b_i(b)\tkeep order:false\n│     └─IndexReader(Probe)\t2.00\troot\t\tindex:IndexRangeScan\n│       └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t6, index:b_i(b)\trange:[2,+inf], keep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t3.00\tcop[tikv]\ttable:t5\tkeep order:false\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT J\nbut got(1382):\nEXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t3.20\troot\t\tleft outer join, left side:TableReader, equal:[eq(join_nested_bka.t5.b, join_nested_bka.t7.b)]\n├─Selection(Build)\t3.20\troot\t\tor(gt(join_nested_bka.t8.a, 0), isnull(join_nested_bka.t8.c))\n│ └─HashJoin\t4.00\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join_nested_bka.t7.b, join_nested_bka.t8.b)], left cond:[lt(join_nested_bka.t6.b, 10)]\n│   ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│   │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka.t8.b))\n│   │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t8\tkeep order:false\n│   └─HashJoin(Probe)\t4.00\troot\t\tCARTESIAN inner join\n│     ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│     │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka.t7.b))\n│     │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t7\tkeep order:false\n│     └─IndexReader(Probe)\t2.00\troot\t\tindex:IndexRangeScan\n│       └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t6, index:b_i(b)\trange:[2,+inf], keep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t3.00\tcop[tikv]\ttable:t5\tkeep order:false\n\n"
time="2025-09-03T11:20:19+08:00" level=error msg="run test [join_nested_bka_nobnl] err: sql:EXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);: failed to run query \n\"EXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\" \n around line 23, \nwe need(1436):\nEXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t3.20\troot\t\tleft outer join, left side:TableReader, equal:[eq(join_nested_bka_nobnl.t5.b, join_nested_bka_nobnl.t7.b)]\n├─Selection(Build)\t3.20\troot\t\tor(gt(join_nested_bka_nobnl.t8.a, 0), isnull(join_nested_bka_nobnl.t8.c))\n│ └─HashJoin\t4.00\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join_nested_bka_nobnl.t7.b, join_nested_bka_nobnl.t8.b)], left cond:[lt(join_nested_bka_nobnl.t6.b, 10)]\n│   ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│   │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka_nobnl.t8.b))\n│   │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t8\tkeep order:false\n│   └─HashJoin(Probe)\t4.00\troot\t\tCARTESIAN inner join\n│     ├─IndexReader(Build)\t2.00\troot\t\tindex:IndexFullScan\n│     │ └─IndexFullScan\t2.00\tcop[tikv]\ttable:t7, index:b_i(b)\tkeep order:false\n│     └─IndexReader(Probe)\t2.00\troot\t\tindex:IndexRangeScan\n│       └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t6, index:b_i(b)\trange:[2,+inf], keep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t3.00\tcop[tikv]\ttable:t5\tkeep order:false\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n\nbut got(1436):\nEXPLAIN FORMAT='brief'\nSELECT t5.a,t5.b,t6.a,t6.b,t7.a,t7.b,t8.a,t8.b\nFROM t5\nLEFT JOIN\n(\n(t6, t7)\nLEFT JOIN\nt8\nON t7.b=t8.b AND t6.b < 10\n)\nON t6.b >= 2 AND t5.b=t7.b AND\n(t8.a > 0 OR t8.c IS NULL);\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t3.20\troot\t\tleft outer join, left side:TableReader, equal:[eq(join_nested_bka_nobnl.t5.b, join_nested_bka_nobnl.t7.b)]\n├─Selection(Build)\t3.20\troot\t\tor(gt(join_nested_bka_nobnl.t8.a, 0), isnull(join_nested_bka_nobnl.t8.c))\n│ └─HashJoin\t4.00\troot\t\tleft outer join, left side:HashJoin, equal:[eq(join_nested_bka_nobnl.t7.b, join_nested_bka_nobnl.t8.b)], left cond:[lt(join_nested_bka_nobnl.t6.b, 10)]\n│   ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│   │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka_nobnl.t8.b))\n│   │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t8\tkeep order:false\n│   └─HashJoin(Probe)\t4.00\troot\t\tCARTESIAN inner join\n│     ├─TableReader(Build)\t2.00\troot\t\tdata:Selection\n│     │ └─Selection\t2.00\tcop[tikv]\t\tnot(isnull(join_nested_bka_nobnl.t7.b))\n│     │   └─TableFullScan\t2.00\tcop[tikv]\ttable:t7\tkeep order:false\n│     └─IndexReader(Probe)\t2.00\troot\t\tindex:IndexRangeScan\n│       └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t6, index:b_i(b)\trange:[2,+inf], keep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t3.00\tcop[tikv]\ttable:t5\tkeep order:false\n\n"
time="2025-09-03T11:20:19+08:00" level=error msg="run test [negation_elimination] err: sql:explain format = 'brief' select * from t1 where not(not(a));: failed to run query \n\"explain format = 'brief' select * from t1 where not(not(a));\" \n around line 16, \nwe need(215):\nexplain format = 'brief' select * from t1 where not(not(a));\nid\testRows\ttask\taccess object\toperator info\nIndexReader\t19.40\troot\t\t#\n└─IndexRangeScan\t19.40\tcop[tikv]\ttable:t1, index:a(a)\t#\nselect * from t1 where n\nbut got(215):\nexplain format = 'brief' select * from t1 where not(not(a));\nid\testRows\ttask\taccess object\toperator info\nTableReader\t19.40\troot\t\t#\n└─Selection\t19.40\tcop[tikv]\t\t#\n  └─TableFullScan\t21.00\tcop[tikv]\ttable:t1\t#\n\n"
tidb-server(PID: 1542) stopped
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '3'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE