Skipping 914 KB.. Full Log

time="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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/json_functions.test: ok! 784 test cases passed, take time 1.010166955 s
time="2024-05-07T10:05:02+08:00" level=warning msg="json_gcol:23 query failed with non expected error(s)! (ErrTruncatedWrongValueForField != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{}');)"
time="2024-05-07T10:05:02+08:00" level=warning msg="json_gcol:25 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{\"a\": 1}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{\"a\":1}');)"
time="2024-05-07T10:05:02+08:00" level=warning msg="json_gcol:27 query failed with non expected error(s)! (ErrTruncatedWrongValueForField != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '\"abc\"' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('\"abc\"');)"
time="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+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="2024-05-07T10:05:02+08:00" level=warning msg="foreign_key_cascade_delete:449 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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+08:00" level=warning msg="foreign_key_cascade_delete:495 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/json_gcol.test: ok! 94 test cases passed, take time 0.337785815 s
time="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+08:00" level=warning msg="foreign_key_cascade_delete:535 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');)"
./t/json_group_concat_innodb.test: ok! 40 test cases passed, take time 0.120994446 s
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:19 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:19 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:26 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:26 query failed with non expected error(s)! (ErrInvalidJSONText != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-07T10:05:03+08:00" level=warning msg="type_ranges:151 query failed with non expected error(s)! (ErrWrongValueCountOnRow != 1060) (err: Error 1136 (21S01): Column count doesn't match value count at row 1) (query: insert into t3 select * from t1, t2;)"
./t/type_ranges.test: ok! 82 test cases passed, take time 1.427560578 s
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=12
time="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+08:00" level=warning msg="foreign_key_cascade_delete:575 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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+08:00" level=warning msg="json_type:43 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:43 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_CONSTRAINT_FAILED) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: create table t2 (t json) select t from t1;)"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:51 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:51 query failed with non expected error(s)! (ErrInvalidJSONText != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert into t1 values (\"xxx\");)"
time="2024-05-07T10:05:03+08:00" level=warning msg="json_type:59 query failed with non expected error(s)! (ErrInvalidJSONText != ER_PARSE_ERROR) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select cast('{a:1}' as json);)"
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=76
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=77
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=80
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=81
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=89
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=90
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=92
time="2024-05-07T10:05:03+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=93
./t/json_type.test: ok! 45 test cases passed, take time 0.305403405 s
time="2024-05-07T10:05:03+08:00" level=error msg="run test [type_set] err: sql:create table t1 (a set (' ','a','b ') not null default 'b ');: run \"create table t1 (a set (' ','a','b ') not null default 'b ');\" at line 15 err Error 1067 (42000): Invalid default value for 'a'"
time="2024-05-07T10:05:03+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="2024-05-07T10:05:03+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="2024-05-07T10:05:03+08:00" level=warning msg="foreign_key_cascade_delete:655 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`) 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');)"
./t/gcol_column_def_options.test: ok! 177 test cases passed, take time 2.6963222460000003 s
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_dependenies_on_vcol:25 query failed with non expected error(s)! (ER_DEPENDENT_BY_GENERATED_COLUMN != 1054) (err: Error 3108 (HY000): Column 'a' has a generated column dependency.) (query: alter table t1 drop column a;)"
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_dependenies_on_vcol:27 query failed with non expected error(s)! (ER_DEPENDENT_BY_GENERATED_COLUMN != 1054) (err: Error 3108 (HY000): Column 'a' has a generated column dependency.) (query: alter table t1 change a c int;)"
./t/gcol_dependenies_on_vcol.test: ok! 8 test cases passed, take time 0.088940044 s
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_illegal_expression:7 Unknown named --error "
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_illegal_expression:7 query failed with non expected error(s)! (ErrDivisionByZero != ) (err: Error 1365 (22012): Division by 0) (query: insert into t (a) value (10);)"
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_illegal_expression:12 Unknown named --error "
time="2024-05-07T10:05:03+08:00" level=warning msg="gcol_illegal_expression:12 query failed with non expected error(s)! (ER_WARN_DATA_OUT_OF_RANGE != ) (err: Error 1264 (22003): Out of range value for column 'a' at row 1) (query: insert into t value (default);)"
time="2024-05-07T10:05:04+08:00" level=warning msg="gcol_illegal_expression:18 query succeeded, but expected error(s)! (expected errors: ) (query: insert into t value (default);)"
time="2024-05-07T10:05:04+08:00" level=warning msg="gcol_illegal_expression:24 Unknown named --error "
time="2024-05-07T10:05:04+08:00" level=warning msg="gcol_illegal_expression:24 query failed with non expected error(s)! (ErrDatetimeFunctionOverflow != ) (err: Error 1441 (22008): Datetime function: datetime field overflow) (query: insert into t value (default);)"
./t/type_time.test: ok! 144 test cases passed, take time 0.730291022 s
time="2024-05-07T10:05:04+08:00" level=warning msg="gcol_illegal_expression:29 Unknown named --error "
time="2024-05-07T10:05:04+08:00" level=warning msg="gcol_illegal_expression:29 query failed with non expected error(s)! (ER_DATA_OUT_OF_RANGE != ) (err: Error 1690 (22003): BIGINT UNSIGNED value is out of range in '(9223372036854775806 + -9223372036854775807)') (query: insert into t value (default);)"
./t/gcol_illegal_expression.test: ok! 20 test cases passed, take time 0.339048948 s
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=104
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=117
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=132
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=148
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=164
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=180
time="2024-05-07T10:05:04+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=199
time="2024-05-07T10:05:04+08:00" level=warning msg="key:313 query failed with non expected error(s)! (ErrMultiplePriKey != 1091) (err: Error 1068 (42000): Multiple primary key defined) (query: alter table t1 add primary key (c1, c2);)"
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=259
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=271
time="2024-05-07T10:05:05+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);)"
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=286
./t/type_timestamp.test: ok! 279 test cases passed, take time 1.283576998 s
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" type_timestamp.test" command=source line=7
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=23
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=33
time="2024-05-07T10:05:05+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=51
./t/gcol_ins_upd.test: ok! 204 test cases passed, take time 1.6820069 s
./t/type_timestamp_explicit.test: ok! 48 test cases passed, take time 0.544873257 s
time="2024-05-07T10:05:06+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-07T10:05:06+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/type_timestamp_myisam.test: ok! 6 test cases passed, take time 0.035937672 s
./t/type_uint.test: ok! 9 test cases passed, take time 0.034403033 s
./t/type_unit.test: ok! 9 test cases passed, take time 0.034507545 s
time="2024-05-07T10:05:06+08:00" level=error msg="run test [type_varchar] err: sql:select v='a' from t1;: failed to run query \n\"select v='a' from t1;\" \n around line 18, \nwe need(30):\nselect v='a' from t1;\nv='a'\n1\n\nbut got(30):\nselect v='a' from t1;\nv='a'\n0\n\n"
./t/key.test: ok! 192 test cases passed, take time 2.735444923 s
./t/key_diff.test: ok! 10 test cases passed, take time 0.068722195 s
./t/type_year.test: ok! 101 test cases passed, take time 0.454943681 s
time="2024-05-07T10:05:07+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=4
./t/gcol_non_stored_columns.test: ok! 85 test cases passed, take time 1.02186599 s
time="2024-05-07T10:05:07+08:00" level=warning msg="gcol_partition:66 Unknown named --error "
time="2024-05-07T10:05:07+08:00" level=warning msg="gcol_partition:66 query failed with non expected error(s)! (ER_NO_PARTITION_FOR_GIVEN_VALUE != ) (err: Error 1526 (HY000): Table has no partition for value 1) (query: alter table t1 reorganize partition p1 into (partition p1 values in (3));)"
./t/gcol_partition.test: ok! 45 test cases passed, take time 0.659286587 s
time="2024-05-07T10:05:07+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! 123 test cases passed, take time 1.386303649 s
./t/key_primary.test: ok! 12 test cases passed, take time 0.039364755 s
time="2024-05-07T10:05:08+08:00" level=warning msg="update:425 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: SET SESSION sql_safe_updates = DEFAULT;)"
time="2024-05-07T10:05:08+08:00" level=warning msg="update:448 query succeeded, but expected error(s)! (expected errors: ER_VIEW_INVALID) (query: SET sql_mode = default;)"
./t/keywords.test: ok! 51 test cases passed, take time 0.213814602 s
time="2024-05-07T10:05:08+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;)"
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=559
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=560
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=572
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=573
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=583
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=584
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=600
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=601
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=607
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=608
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=614
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=615
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=634
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=635
time="2024-05-07T10:05:08+08:00" level=warning msg="update:648 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET b= NULL WHERE a < '00:38:47.008761';)"
./t/lead_lag.test: ok! 214 test cases passed, take time 0.48949093 s
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=675
time="2024-05-07T10:05:08+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=676
time="2024-05-07T10:05:08+08:00" level=warning msg="update:694 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET a=1 ORDER BY CAST('invalid' AS DATETIME);)"
time="2024-05-07T10:05:08+08:00" level=warning msg="update:756 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: DROP TABLE t1, t2;)"
./t/lead_lag_explain.test: ok! 81 test cases passed, take time 0.249630053 s
./t/like.test: ok! 8 test cases passed, take time 0.013149888 s
./t/update.test: ok! 246 test cases passed, take time 1.985046992 s
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=4
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=5
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=6
./t/update_myisam.test: ok! 36 test cases passed, take time 0.296538866 s
./t/update_stmt.test: ok! 17 test cases passed, take time 0.027162437 s
time="2024-05-07T10:05:09+08:00" level=warning msg="limit:253 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-07T10:05:09+08:00" level=warning msg="limit:256 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-07T10:05:09+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/upgrade.test: ok! 34 test cases passed, take time 0.17797187 s
./t/limit.test: ok! 174 test cases passed, take time 0.64200024 s
./t/limit_myisam.test: ok! 5 test cases passed, take time 0.02745186 s
./t/long_tmpdir.test: ok! 3 test cases passed, take time 0.032222325 s
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=7
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=8
time="2024-05-07T10:05:09+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="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=29
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=104
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=109
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=116
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $expect_file" command=exec line=146
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments= command=send_shutdown line=149
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=152
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" echo \"restart:--log-raw=ON \" > $expect_file" command=exec line=155
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=158
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=161
./t/user_if_exists.test: ok! 79 test cases passed, take time 0.337210124 s
time="2024-05-07T10:05:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=35
time="2024-05-07T10:05:10+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.146777008 s
time="2024-05-07T10:05:10+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=3
time="2024-05-07T10:05:10+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.041202615 s
./t/gcol_select.test: ok! 123 test cases passed, take time 1.965613191 s
./t/gcol_stored_fk_cascade.test: ok! 15 test cases passed, take time 0.133452405 s
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 9.243992154 s
time="2024-05-07T10:05:10+08:00" level=warning msg="user_password_history:217 query succeeded, but expected error(s)! (expected errors: ER_NO_SUCH_TABLE) (query: CREATE USER no_pwd_history_err@localhost IDENTIFIED BY 'haha'\nPASSWORD HISTORY 0 PASSWORD REUSE INTERVAL 0 DAY;)"
time="2024-05-07T10:05:10+08:00" level=warning msg="user_password_history:230 query failed with non expected error(s)! (ErrCannotUser != ER_NO_SUCH_TABLE) (err: Error 1396 (HY000): Operation DROP USER failed for no_pwd_history@localhost) (query: DROP USER no_pwd_history@localhost;)"
time="2024-05-07T10:05:10+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=98
time="2024-05-07T10:05:10+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=108
time="2024-05-07T10:05:10+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=115
time="2024-05-07T10:05:10+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=126
time="2024-05-07T10:05:10+08:00" level=warning msg="lowercase_table:144 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;)"
time="2024-05-07T10:05:10+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="2024-05-07T10:05:10+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.566787405 s
./t/user_password_history.test: ok! 141 test cases passed, take time 0.709121515 s
time="2024-05-07T10:05:10+08:00" level=warning msg="user_var:10 query succeeded, but expected error(s)! (expected errors: 1054) (query: set @a := foo;)"
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=342
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=348
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=479
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=483
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:533 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set    @X2345678901234567890123456789012345678901234567890123456789012345 = 12;)"
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:537 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @``= \"illegal\";)"
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:541 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @`endswithspace `= \"illegal\";)"
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:593 query succeeded, but expected error(s)! (expected errors: ER_TOO_MANY_ROWS) (query: SET @x= 2;)"
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=602
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:609 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: SELECT * FROM t1 WHERE a = (SELECT (@x:=_utf8mb4 0x1023) FROM t1) OR b = @x;)"
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=611
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:701 query failed with non expected error(s)! (ErrCantAggregate2collations != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (latin1_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_latin1;)"
time="2024-05-07T10:05:11+08:00" level=warning msg="user_var:703 query failed with non expected error(s)! (ER_CANT_AGGREGATE_2COLLATIONS != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8mb4_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_utf8mb4;)"
./t/user_var.test: ok! 309 test cases passed, take time 1.351704767 s
./t/lowercase_table2.test: ok! 86 test cases passed, take time 0.969938669 s
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE `Table2`;" command=query_vertical line=81
time="2024-05-07T10:05:11+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="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product_Order;" command=query_vertical line=109
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product;" command=query_vertical line=110
time="2024-05-07T10:05:11+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Customer;" command=query_vertical line=111
time="2024-05-07T10:05:11+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.289657862 s
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=15
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=16
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=28
time="2024-05-07T10:05:12+08:00" level=warning msg="validate_password:76 query failed with non expected error(s)! (ErrCannotUser != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'aedSWEhjui';)"
time="2024-05-07T10:05:12+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.084622093 s
./t/lowercase_table_grant.test: ok! 15 test cases passed, take time 0.069933095 s
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=31
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=32
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=44
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments= command=shutdown_server line=45
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=46
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" echo \"restart\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=50
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=51
time="2024-05-07T10:05:12+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.027648106 s
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=26
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=27
time="2024-05-07T10:05:12+08:00" level=warning msg="validate_password:118 query failed with non expected error(s)! (ErrCannotUser != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';)"
time="2024-05-07T10:05:12+08:00" level=warning msg="validate_password:129 query failed with non expected error(s)! (ErrWrongParamcountToNativeFct != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH('password', 0);)"
time="2024-05-07T10:05:12+08:00" level=warning msg="validate_password:131 query failed with non expected error(s)! (ErrWrongParamcountToNativeFct != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH();)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:58 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 t1Aa);)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:62 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 v1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:74 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 t1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:92 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 v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:106 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v1Aa);)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:116 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:118 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:124 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:130 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v1aA));)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:142 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v2aA));)"
time="2024-05-07T10:05:12+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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:148 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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="2024-05-07T10:05:12+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="2024-05-07T10:05:12+08:00" level=warning msg="lowercase_view:152 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v2aA));)"
./t/validate_password.test: ok! 155 test cases passed, take time 0.521675837 s
./t/validate_password_check_user.test: ok! 34 test cases passed, take time 0.105247685 s
time="2024-05-07T10:05:12+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=176
time="2024-05-07T10:05:12+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.498238587 s
./t/lpad.test: ok! 26 test cases passed, take time 0.004124131 s
time="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:389 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T10:05:13+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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:397 Unknown named --error ER_DUP_QUERY_NAME"
time="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:397 query failed with non expected error(s)! (ER_NONUNIQ_TABLE != 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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:408 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:408 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 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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:414 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T10:05:13+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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:421 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:421 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 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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:429 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T10:05:13+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="2024-05-07T10:05:13+08:00" level=warning msg="mariadb_cte_nonrecursive:461 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T10:05:13+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="2024-05-07T10:05:13+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="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=254
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=255
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=281
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=282
./t/varbinary.test: ok! 149 test cases passed, take time 0.420862577 s
./t/variable.test: ok! 16 test cases passed, take time 0.005651765 s
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" include/have_log_bin.inc" command=source line=5
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 1e-010 1e-10" command=replace_result line=59
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=121
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=124
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=172
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=175
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:304 query succeeded, but expected error(s)! (expected errors: ER_WRONG_TYPE_FOR_VAR) (query: set max_join_size=\"hello\";)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:306 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine=UNKNOWN_TABLE_TYPE;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:311 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset UNKNOWN_CHARACTER_SET) (query: set character_set_client=UNKNOWN_CHARACTER_SET;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:317 query failed with non expected error(s)! (ErrUnknownCollation != ER_WRONG_VALUE_FOR_VAR) (err: Error 1273 (HY000): Unknown collation: '') (query: set collation_connection=NULL;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:458 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:465 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=472
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=475
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:500 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set @@global.global.key_buffer_size= 1;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:502 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set GLOBAL global.key_buffer_size= 1;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:504 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: SELECT @@global.global.key_buffer_size;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:506 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session.key_buffer_size') (query: SELECT @@global.session.key_buffer_size;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:508 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local.key_buffer_size') (query: SELECT @@global.local.key_buffer_size;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:646 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1105 (HY000): ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA') (query: set global sql_mode=repeat('a',80);)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:808 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable '') (query: select @@\"\";)"
time="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:292 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="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:317 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="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:345 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="2024-05-07T10:05:13+08:00" level=warning msg="variables:906 query failed with non expected error(s)! (ER_INCORRECT_GLOBAL_LOCAL_VAR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1238 (HY000): Variable 'log_output' is a read only variable) (query: SET GLOBAL log_output = '';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:909 query failed with non expected error(s)! (ErrIncorrectGlobalLocalVar != ER_WRONG_VALUE_FOR_VAR) (err: Error 1238 (HY000): Variable 'log_output' is a read only variable) (query: SET GLOBAL log_output = 0;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:921 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_max_word_len;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:931 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_min_word_len;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:941 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_query_expansion_limit;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:951 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_stopword_file;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:963 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.back_log;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:974 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_files_support;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:986 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.character_sets_dir;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:998 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SELECT @@session.init_file;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1002 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@session.init_file= 'x';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1004 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@global.init_file= 'x';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1010 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lc_messages_dir;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1022 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_page_size;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1034 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_pages;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1046 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_bin;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1058 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_error;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1070 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_file_system;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1082 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_table_names;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1093 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.myisam_recover_options;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1104 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.open_files_limit;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1116 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.pid_file;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1141 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.port;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1152 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.protocol_version;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1162 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_external_locking;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1172 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_networking;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1182 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_show_database;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1193 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.thread_stack;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1223 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SELECT @@global.expire_logs_days;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1249
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1251
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1324 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1331 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET SQL_MODE=DEFAULT;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1338 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1410 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET GLOBAL delay_key_write = OFF;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1454 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET @@foreign_key_checks = OFF;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1558 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_results = 2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1560 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_client=2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1562 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_connection=2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1564 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_server=2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1568 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_filesystem=2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1570 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_database=2048;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1596 query failed with non expected error(s)! (ErrUnknown != ER_WRONG_VALUE_FOR_VAR) (err: Error 1105 (HY000): ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of '8589934592') (query: SET @@sql_mode= 8589934592;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1722
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1725 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SELECT @@session.relay_log_index;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1726
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1729 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@session.relay_log_index= 'x';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1731 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@global.relay_log_index= 'x';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1748 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_info_file;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1758 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_space_limit;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1769 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SELECT @@session.replica_load_tmpdir;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1773 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SET @@session.replica_load_tmpdir= 'x';)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1780 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SELECT @@session.replica_skip_errors;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1785 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SET @@global.replica_skip_errors= 7;)"
time="2024-05-07T10:05:13+08:00" level=warning msg="variables:1802 query failed with non expected error(s)! (ER_NO_DB_ERROR not in ER_NET_PACKET_TOO_LARGE,2013) (err: Error 1046 (3D000): No database selected) (query: INSERT INTO t1 VALUES ('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');)"
time="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:373 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="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:404 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="2024-05-07T10:05:13+08:00" level=warning msg="foreign_key_cascade_mysql:432 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/variables.test: ok! 559 test cases passed, take time 0.640431858 s
./t/variables_dynamic_privs.test: ok! 14 test cases passed, take time 0.08304951 s
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=741
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=742
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=769
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=770
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=800
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=817
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=834
time="2024-05-07T10:05:14+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=852
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 4.270826645 s
time="2024-05-07T10:05:15+08:00" level=warning msg="command not implemented" arguments=" |;" command=delimiter line=1297
time="2024-05-07T10:05:15+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.174322493 s
time="2024-05-07T10:05:15+08:00" level=warning msg="command not implemented" arguments=" include/default_optimizer_switch.inc" command=source line=2
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:11 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T10:05:15+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="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:28 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:28 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 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="2024-05-07T10:05:15+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="2024-05-07T10:05:15+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;)"
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:753 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T10:05:15+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="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:772 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T10:05:15+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="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:810 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:810 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_SINGLE_REFERENCE != 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="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:858 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:858 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDDEN_JOIN_ORDER != 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="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:923 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T10:05:15+08:00" level=warning msg="mariadb_cte_recursive:923 query failed with non expected error(s)! (ErrCTERecursiveForbidsAggregation != 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="2024-05-07T10:05:15+08:00" level=warning msg="view:521 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_INVALID) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 values('a','aa');)"
time="2024-05-07T10:05:15+08:00" level=warning msg="view:602 query failed with non expected error(s)! (ErrBadTable != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: CREATE VIEW v02 AS SELECT * FROM DUAL;)"
time="2024-05-07T10:05:15+08:00" level=warning msg="view:618 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_OBJECT) (err: Error 1105 (HY000): Unknown charset ) (query: create index i1 on v1 (col1);)"
time="2024-05-07T10:05:16+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="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q1;" command=eval line=1771
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=1772
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q2;" command=eval line=1774
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=1775
time="2024-05-07T10:05:16+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;)"
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 1.67429353 s

time="2024-05-07T10:05:16+08:00" level=error msg="5 tests failed\n"
time="2024-05-07T10:05:16+08:00" level=error msg="run test [binary] err: sql:select concat(\"-\",a,\"-\",b,\"-\") from t1 ignore index (a) where a=\"hello \";: failed to run query \n\"select concat(\"-\",a,\"-\",b,\"-\") from t1 ignore index (a) where a=\"hello \";\" \n around line 42, \nwe need(98):\n-hello-hello-\nselect concat(\"-\",a,\"-\",b,\"-\") from t1 ignore index (a) where a=\"hello \";\nconcat(\"-\"\nbut got(98):\nselect concat(\"-\",a,\"-\",b,\"-\") from t1 ignore index (a) where a=\"hello \";\nconcat(\"-\",a,\"-\",b,\"-\")\n\n"
time="2024-05-07T10:05:16+08:00" level=error msg="run test [compare] err: sql:SELECT 'a' = 'a ';: failed to run query \n\"SELECT 'a' = 'a ';\" \n around line 28, \nwe need(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n1\n\nbut got(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n0\n\n"
time="2024-05-07T10:05:16+08:00" level=error msg="run test [ctype_utf8] err: sql:SELECT 'a' = 'a ';: failed to run query \n\"SELECT 'a' = 'a ';\" \n around line 57, \nwe need(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n1\n\nbut got(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n0\n\n"
time="2024-05-07T10:05:16+08:00" level=error msg="run test [ctype_utf8mb4] err: sql:SELECT 'a' = 'a ';: failed to run query \n\"SELECT 'a' = 'a ';\" \n around line 65, \nwe need(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n1\n\nbut got(32):\nSELECT 'a' = 'a ';\n'a' = 'a '\n0\n\n"
time="2024-05-07T10:05:16+08:00" level=error msg="run test [endspace] err: sql:select concat('|', text1, '|') from t1 order by text1;: failed to run query \n\"select concat('|', text1, '|') from t1 order by text1;\" \n around line 48, \nwe need(130):\nselect concat('|', text1, '|') from t1 order by text1;\nconcat('|', text1, '|')\n|nothing|\n|teststring|\n|teststring |\n|teststring\t|\n\nbut got(130):\nselect concat('|', text1, '|') from t1 order by text1;\nconcat('|', text1, '|')\n|nothing|\n|teststring|\n|teststring\t|\n|teststring |\n\n"
tidb-server(PID: 2309) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
time="2024-05-07T10:05:16+08:00" level=warning msg="mariadb_cte_recursive:1887 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T10:05:16+08:00" level=warning msg="mariadb_cte_recursive:1887 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 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="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=1955
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=1956
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2032
time="2024-05-07T10:05:16+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $q;" command=eval line=2033
[Pipeline] junit
Recording test results
time="2024-05-07T10:05:16+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="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2168
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2183
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=2195
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=2207
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=2219
[Checks API] No suitable checks publisher found.
[Pipeline] archiveArtifacts
Archiving artifacts
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from cte as t;" command=eval line=2342
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from cte as t;" command=eval line=2347
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from t1 as t;" command=eval line=2351
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from t1 as t;" command=eval line=2356
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2410
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2435
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2436
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" explain $q1;" command=eval line=2448
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2449
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2464
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2475
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2476
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2535
time="2024-05-07T10:05:17+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2564
time="2024-05-07T10:05:17+08:00" level=warning msg="mariadb_cte_recursive:2566 query succeeded, but expected error(s)! (expected errors: 1146) (query: drop table folks;)"
time="2024-05-07T10:05:18+08:00" level=warning msg="mariadb_cte_recursive:2751 query failed with non expected error(s)! (ER_NOT_SUPPORTED_YET != 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="2024-05-07T10:05:18+08:00" level=warning msg="mariadb_cte_recursive:2767 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != 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 3.000581088 s
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/math.test: ok! 6 test cases passed, take time 0.013545879 s
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=6
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=8
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=51
time="2024-05-07T10:05:18+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="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '1'
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
Sending interrupt signal to process
Killing processes
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2024-05-07T10:05:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2024-05-07T10:05:19+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2024-05-07T10:05:19+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.87513195 s
time="2024-05-07T10:05:19+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2024-05-07T10:05:19+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
time="2024-05-07T10:05:19+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.158795753 s
time="2024-05-07T10:05:19+08:00" level=warning msg="multi_update:23 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.t1 from mysqltest_1@localhost;)"
time="2024-05-07T10:05:19+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;)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
tidb-server(PID: 2258) stopped
script returned exit code 143
kill finished with exit code 0
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
tidb-server(PID: 2287) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
tidb-server(PID: 2377) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
[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] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // podTemplate
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '3'
[Pipeline] }
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh FAILURE result.json
http://fileserver.pingcap.net
--2024-05-07 02:05:23--  http://fileserver.pingcap.net/download/rd-atom-agent/agent_upload_verifyci_metadata.py
Resolving fileserver.pingcap.net (fileserver.pingcap.net)... 10.2.12.82
Connecting to fileserver.pingcap.net (fileserver.pingcap.net)|10.2.12.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4181 (4.1K) [application/octet-stream]
Saving to: ‘agent_upload_verifyci_metadata.py’

     0K ....                                                  100%  712M=0s

2024-05-07 02:05:24 (712 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[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