Skipping 928 KB.. Full Log

time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
./t/expression_index.test: ok! 166 test cases passed, take time 2.083633688 s
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_blocked_sql_funcs:303 query failed with non expected error(s)! (ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED != ER_GENERATED_COLUMN_NAMED_FUNCTION_IS_NOT_ALLOWED) (err: Error 3102 (HY000): Expression of generated column 'b' contains a disallowed function.) (query: create table t1 (a varchar(1024), b varchar(1024) generated always as (UpdateXML(a,'/a','<e>fff</e>')) virtual);)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_blocked_sql_funcs:334 query succeeded, but expected error(s)! (expected errors: ER_GENERATED_COLUMN_NAMED_FUNCTION_IS_NOT_ALLOWED,ER_PARSE_ERROR) (query: alter table t1 add column r blob generated always\nas (match(a) against ('' in boolean mode)) virtual;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_blocked_sql_funcs:345 query failed with non expected error(s)! (ErrGeneratedColumnFunctionIsNotAllowed != ER_GENERATED_COLUMN_NAMED_FUNCTION_IS_NOT_ALLOWED) (err: Error 3102 (HY000): Expression of generated column 'c' contains a disallowed function.) (query: CREATE TABLE t2(a JSON, b JSON, c JSON  GENERATED ALWAYS AS  (JSON_MERGE(a,b)));)"
./t/gcol_blocked_sql_funcs.test: ok! 144 test cases passed, take time 0.216534369 s
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2024-05-06T15:40:07+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.48395606 s
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2024-05-06T15:40:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
./t/field_length.test: ok! 10 test cases passed, take time 0.070304001 s
time="2024-05-06T15:40:07+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.100238334 s
time="2024-05-06T15:40:07+08:00" level=warning msg="multi_update:23 query failed with non expected error(s)! (ErrUnknown not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.t1 from mysqltest_1@localhost;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="multi_update:25 query failed with non expected error(s)! (ER_UNKNOWN_ERROR not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.* from mysqltest_1@localhost;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_column_def_options:102 query succeeded, but expected error(s)! (expected errors: 1105) (query: create table t1 (a int, b int generated always as (a+1) stored primary key);)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_column_def_options:108 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN) (err: Error 8200 (HY000): unsupported add column 'b' constraint PRIMARY KEY when altering 'gcol_column_def_options.t1') (query: alter table t1 add column b int generated always as (a+1) virtual key;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_column_def_options:110 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != 1105) (err: Error 8200 (HY000): unsupported add column 'b' constraint PRIMARY KEY when altering 'gcol_column_def_options.t1') (query: alter table t1 add column b int generated always as (a+1) stored key;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_column_def_options:112 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_MULTIPLE_PRI_KEY) (err: Error 8200 (HY000): unsupported add column 'c' constraint PRIMARY KEY when altering 'gcol_column_def_options.t1') (query: alter table t1 add column c int generated always as (a+2) virtual primary key;)"
time="2024-05-06T15:40:07+08:00" level=warning msg="gcol_column_def_options:115 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_MULTIPLE_PRI_KEY) (err: Error 8200 (HY000): unsupported add column 'c' constraint PRIMARY KEY when altering 'gcol_column_def_options.t1') (query: alter table t1 add column c int generated always as (a+2) stored primary key;)"
time="2024-05-06T15:40:08+08:00" level=warning msg="gcol_column_def_options:161 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != 1064) (err: Error 8200 (HY000): Unsupported modify column: can't modify with references) (query: alter table t1 modify b int generated always as (a % 2) stored references t2(a);)"
time="2024-05-06T15:40:08+08:00" level=warning msg="multi_update:243 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE t1,t2 SET t1.d=t2.d WHERE t1.n=t2.n;)"
time="2024-05-06T15:40:08+08:00" level=warning msg="subquery_all:1644 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx ;)"
time="2024-05-06T15:40:08+08:00" level=warning msg="subquery_all:1646 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T15:40:08+08:00" level=warning msg="subquery_all:1649 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T15:40:08+08:00" level=warning msg="subquery_all:1651 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx from DUAL;)"
./t/gcol_column_def_options.test: ok! 177 test cases passed, take time 1.36918251 s
time="2024-05-06T15:40:08+08:00" level=warning msg="gcol_dependenies_on_vcol:25 query failed with non expected error(s)! (ErrDependentByGeneratedColumn != 1054) (err: Error 3108 (HY000): Column 'a' has a generated column dependency.) (query: alter table t1 drop column a;)"
time="2024-05-06T15:40:08+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.07016308 s
time="2024-05-06T15:40:08+08:00" level=warning msg="gcol_illegal_expression:7 Unknown named --error "
time="2024-05-06T15:40:08+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-06T15:40:08+08:00" level=warning msg="gcol_illegal_expression:12 Unknown named --error "
time="2024-05-06T15:40:08+08:00" level=warning msg="gcol_illegal_expression:12 query failed with non expected error(s)! (ErrWarnDataOutOfRange != ) (err: Error 1264 (22003): Out of range value for column 'a' at row 1) (query: insert into t value (default);)"
time="2024-05-06T15:40:09+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-06T15:40:09+08:00" level=warning msg="gcol_illegal_expression:24 Unknown named --error "
time="2024-05-06T15:40:09+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);)"
time="2024-05-06T15:40:09+08:00" level=warning msg="gcol_illegal_expression:29 Unknown named --error "
time="2024-05-06T15:40:09+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.13886049 s
time="2024-05-06T15:40:09+08:00" level=warning msg="multi_update:465 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: update t1,t2 set t1.col1 = (select max(col1) from t1) where t1.col1 = t2.col1;)"
time="2024-05-06T15:40:09+08:00" level=warning msg="multi_update:467 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2.col1;)"
time="2024-05-06T15:40:09+08:00" level=warning msg="multi_update:492 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete from t1,t2 using t1,t2 where t1.a=(select a from t1);)"
./t/gcol_ins_upd.test: ok! 204 test cases passed, take time 0.874150119 s
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" alter table t1 add column c int default 100 after a;" command=send line=553
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=561
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" update t1, v1 set t1.b=t1.a+t1.b+v1.b where t1.a=v1.a;" command=send line=562
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=572
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=576
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=579
time="2024-05-06T15:40:10+08:00" level=warning msg="multi_update:642 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: delete t3.* from t2,t3 where t2.a=t3.a;)"
time="2024-05-06T15:40:10+08:00" level=warning msg="multi_update:664 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1;)"
time="2024-05-06T15:40:10+08:00" level=warning msg="multi_update:766 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 ORDER BY a;)"
time="2024-05-06T15:40:10+08:00" level=warning msg="multi_update:768 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 LIMIT 3;)"
./t/gcol_non_stored_columns.test: ok! 85 test cases passed, take time 0.493363833 s
time="2024-05-06T15:40:10+08:00" level=warning msg="gcol_partition:66 Unknown named --error "
time="2024-05-06T15:40:10+08:00" level=warning msg="gcol_partition:66 query failed with non expected error(s)! (ErrNoPartitionForGivenValue != ) (err: Error 1526 (HY000): Table has no partition for value 1) (query: alter table t1 reorganize partition p1 into (partition p1 values in (3));)"
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=835
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=839
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=840
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=843
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=848
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=849
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=850
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=859
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=860
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=866
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=867
./t/multi_update.test: ok! 356 test cases passed, take time 2.900837007 s
time="2024-05-06T15:40:10+08:00" level=warning msg="multi_update_innodb:24 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A, t1 AS B SET A.pk = 1, B.a = 2;)"
./t/gcol_partition.test: ok! 45 test cases passed, take time 0.321989877 s
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2024-05-06T15:40:10+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=113
./t/multi_update_innodb.test: ok! 62 test cases passed, take time 0.297527001 s
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.154352252 s
./t/gcol_select.test: ok! 123 test cases passed, take time 1.063935954 s
./t/gcol_stored_fk_cascade.test: ok! 15 test cases passed, take time 0.063064617 s
time="2024-05-06T15:40:13+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ErrDupEntry != 1176) (err: Error 1062 (23000): Duplicate entry '2-1850766141593485312-3' for key 't1.mv_idx_date') (query: INSERT INTO t1 SELECT * FROM t1 USE KEY FOR GROUP BY ( mv_idx_unsigned , mv_idx_signed ) GROUP BY j3 ORDER BY j1;)"
./t/multi_valued_index.test: ok! 659 test cases passed, take time 3.733120774 s
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 0.559108024 s
time="2024-05-06T15:40:15+08:00" level=warning msg="mysql_replace:20 query succeeded, but expected error(s)! (expected errors: ErrUnsupportedDDLOperation) (query: alter table t1 engine=heap;)"
./t/mysql_replace.test: ok! 19 test cases passed, take time 0.137252289 s
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.097062796 s
time="2024-05-06T15:40:15+08:00" level=warning msg="nth:39 query succeeded, but expected error(s)! (expected errors: ER_WRONG_ARGUMENTS) (query: SELECT id, sex, NTH_VALUE(id, NULL) OVER () FROM t1;)"
./t/nth.test: ok! 86 test cases passed, take time 0.097908056 s
time="2024-05-06T15:40:16+08:00" level=warning msg="subquery_all:4221 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: EXPLAIN FORMAT= 'BRIEF'\nSELECT cc FROM\n( SELECT\n(SELECT COUNT(a) FROM\n(SELECT COUNT(b) FROM t1) AS x GROUP BY c\n) AS cc FROM t1 GROUP BY b\n) AS y;)"
./t/null_key_all_innodb.test: ok! 71 test cases passed, take time 0.99237376 s
./t/odbc.test: ok! 32 test cases passed, take time 0.1201166 s
./t/operator.test: ok! 28 test cases passed, take time 0.005766643 s
time="2024-05-06T15:40:17+08:00" level=warning msg="subquery_all:4724 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_VIEW_CHECK_FAILED) (err: Error 1146 (42S02): Table 'subquery_all.v3' doesn't exist) (query: DELETE FROM v3;)"
./t/gcol_supported_sql_funcs.test: ok! 1292 test cases passed, take time 5.439133747 s
time="2024-05-06T15:40:17+08:00" level=warning msg="subquery_all:4947 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( SELECT 1 UNION ( SELECT 1 UNION SELECT 1 ) );)"
time="2024-05-06T15:40:17+08:00" level=warning msg="subquery_all:4949 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( ( SELECT 1 UNION SELECT 1 ) UNION SELECT 1 );)"
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.463172078 s
time="2024-05-06T15:40:17+08:00" level=warning msg="command not implemented" arguments=" include/not_hypergraph.inc  # Join order hints are not supported." command=source line=2
time="2024-05-06T15:40:17+08:00" level=warning msg="subquery_all:4995 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_ORDER_NON_AGG_QUERY) (query: SELECT 1 FROM t1 GROUP BY\n(SELECT LAST_INSERT_ID() FROM t1 ORDER BY MIN(a) ASC LIMIT 1);)"
./t/gcol_view.test: ok! 61 test cases passed, take time 0.486793152 s
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" include/have_log_bin.inc" command=source line=5
./t/opt_hints_join_order.test: ok! 83 test cases passed, take time 0.397812562 s
time="2024-05-06T15:40:18+08:00" level=warning msg="grant_dynamic:123 query succeeded, but expected error(s)! (expected errors: ER_NONEXISTING_GRANT) (query: SHOW GRANTS FOR `u1`@`%`;)"
time="2024-05-06T15:40:18+08:00" level=warning msg="grant_dynamic:129 query succeeded, but expected error(s)! (expected errors: ER_NONEXISTING_GRANT) (query: SHOW GRANTS FOR `u1`@`%`;)"
./t/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.258397582 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.105234633 s
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=120
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=169
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=183
./t/grant_dynamic.test: ok! 138 test cases passed, take time 0.563953406 s
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" include/have_case_insensitive_file_system.inc" command=source line=2
./t/grant_lowercase_fs.test: ok! 14 test cases passed, take time 0.096139605 s
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" include/not_embedded.inc" command=source line=7
time="2024-05-06T15:40:18+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=10
time="2024-05-06T15:40:18+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked."
./t/order_by_limit.test: ok! 45 test cases passed, take time 0.389421572 s
time="2024-05-06T15:40:19+08:00" level=error msg="open db failed Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked., take time 501.159555ms"
time="2024-05-06T15:40:19+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked."
time="2024-05-06T15:40:19+08:00" level=error msg="open db failed Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked., take time 501.274207ms"
time="2024-05-06T15:40:19+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT" command=replace_result line=71
time="2024-05-06T15:40:19+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked."
time="2024-05-06T15:40:20+08:00" level=error msg="open db failed Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked., take time 501.137043ms"
./t/grant_user_lock.test: ok! 27 test cases passed, take time 1.6059716480000001 s
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 1.793962433 s
./t/orderby.test: ok! 53 test cases passed, take time 0.06550426 s
time="2024-05-06T15:40:21+08:00" level=warning msg="overflow:9 query failed with non expected error(s)! (ErrDBDropExists not in ER_PARSE_ERROR,ER_TOO_LONG_IDENT,ER_WRONG_NAME_FOR_INDEX) (err: Error 1008 (HY000): Can't drop database 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'; database doesn't exist) (query: drop database AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA;)"
./t/overflow.test: ok! 2 test cases passed, take time 0.003660306 s
./t/packet.test: ok! 50 test cases passed, take time 0.087182792 s
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
time="2024-05-06T15:40:21+08:00" level=warning msg="packet_myisam:43 query failed with non expected error(s)! (ErrEntryTooLarge != ER_WARN_ALLOWED_PACKET_OVERFLOWED) (err: Error 8025 (HY000): entry too large, the max entry size is 6291456, the size of data is 67108897) (query: UPDATE t3\nSET c32= CONCAT(c32,\nREPEAT('a', @max_allowed_packet-1));)"
./t/packet_myisam.test: ok! 11 test cases passed, take time 0.383411832 s
./t/group_min_max_innodb.test: ok! 132 test cases passed, take time 1.140669776 s
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments=" include/have_ps_protocol.inc" command=source line=8
./t/group_min_max_ps_protocol.test: ok! 22 test cases passed, take time 0.098594561 s
time="2024-05-06T15:40:21+08:00" level=warning msg="groupby:32 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_BAD_FIELD_ERROR) (err: Error 1105 (HY000): Unknown column '3' in 'group statement') (query: select * from t group by 3 order by c1;)"
time="2024-05-06T15:40:21+08:00" level=warning msg="groupby:36 query failed with non expected error(s)! (ER_WRONG_GROUP_FIELD != ER_INVALID_GROUP_FUNC_USE) (err: Error 1056 (42000): Can't group on 'count(c1)') (query: select count(c1) from t group by 1 order by c1;)"
time="2024-05-06T15:40:21+08:00" level=warning msg="groupby:54 query succeeded, but expected error(s)! (expected errors: ER_NON_UNIQ_ERROR) (query: select c1 as c2, c2 from t group by c2 + 1 order by c1;)"
./t/groupby.test: ok! 99 test cases passed, take time 0.102355106 s
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6574
time="2024-05-06T15:40:21+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=6581
time="2024-05-06T15:40:21+08:00" level=warning msg="subquery_all:6766 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT 1 as col FROM t1 WHERE a IN (SELECT a FROM DUAL LIMIT 0);)"
./t/subquery_all.test: ok! 2358 test cases passed, take time 18.834143304 s
time="2024-05-06T15:40:22+08:00" level=warning msg="having:258 query succeeded, but expected error(s)! (expected errors: 1064) (query: select sum(col1) as co2, count(col2) as cc from t1 group by col1 having col1 =10;)"
time="2024-05-06T15:40:22+08:00" level=warning msg="having:268 query succeeded, but expected error(s)! (expected errors: 1054) (query: select t1.col1 from t1\nwhere t1.col2 in\n(select t2.col2 from t2\ngroup by t2.col1, t2.col2 having t2.col1 <= 10);)"
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=313
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=320
time="2024-05-06T15:40:22+08:00" level=warning msg="having:359 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != 1052) (err: Error 1054 (42S22): Unknown column 'col1' in 'having clause') (query: select t1.col1*10+t2.col1 from t1,t2 where t1.col1=t2.col1\ngroup by t1.col1, t2.col1 having col1 = 2;)"
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=371
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=373
./t/filesort.test: ok! 54 test cases passed, take time 13.769191259 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.113865332 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.507493078 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.128848933 s
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=467
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=469
time="2024-05-06T15:40:22+08:00" level=warning msg="having:473 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'f1'; this is incompatible with sql_mode=only_full_group_by) (query: select f1 from t1 having max(f1)=f1;)"
./t/subquery_antijoin.test: ok! 116 test cases passed, take time 0.734750787 s
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:157 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:167 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:226 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX',\nSUM(k)\nFROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:236 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'k'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:246 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=252
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" $$\nselect \"non terminated\"$$\nselect \"terminated\";$$\nselect \"non terminated, space\"      $$\nselect \"terminated, space\";      $$\nselect \"non terminated, comment\" /* comment */$$\nselect \"terminated, comment\"; /* comment */$$\nselect \"stmt 1\";select \"stmt 2 non terminated\"$$\nselect \"stmt 1\";select \"stmt 2 terminated\";$$\nselect \"stmt 1\";select \"stmt 2 non terminated, space\"      $$\nselect \"stmt 1\";select \"stmt 2 terminated, space\";      $$\nselect \"stmt 1\";select \"stmt 2 non terminated, comment\" /* comment */$$\nselect \"stmt 1\";select \"stmt 2 terminated, comment\"; /* comment */$$\nselect \"stmt 1\";             select \"space, stmt 2\"$$\nselect \"stmt 1\";/* comment */select \"comment, stmt 2\"$$" command=delimiter line=423
time="2024-05-06T15:40:22+08:00" level=warning msg="command not implemented" arguments=" ;" command=delimiter line=448
time="2024-05-06T15:40:22+08:00" level=warning msg="parser:556 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait();)"
time="2024-05-06T15:40:22+08:00" level=warning msg="parser:558 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait(1);)"
time="2024-05-06T15:40:22+08:00" level=warning msg="parser:562 query failed with non expected error(s)! (ErrSpDoesNotExist not in 0,ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait('binlog.999999', 4, -1);)"
time="2024-05-06T15:40:23+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=915
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:923 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:932 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:941 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 ORDER BY 1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:959 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:968 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:977 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:986 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1061 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine=a.myisam;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1065 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.b.myisam' in '') (query: SET default_storage_engine = a.b.MyISAM;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1067 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.MyISAM;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1069 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.`MyISAM`;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1071 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = \"a.MYISAM\";)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1073 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = 'a.MYISAM';)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1075 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = `a.MYISAM`;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1220 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: REPLACE INTO `` SELECT * FROM ``;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1265 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=NONE;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1267 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=SHARED;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1273 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITH VALIDATION;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1275 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITHOUT VALIDATION;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1277 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 LOCK=SHARED, WITH VALIDATION, ALGORITHM=COPY,\nLOCK=EXCLUSIVE, WITHOUT VALIDATION, ALGORITHM=INPLACE;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1317 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT a FROM t1 LIMIT 1 UNION ALL SELECT a FROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1320 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: (SELECT a FROM t1 LIMIT 1) UNION ALL (SELECT a FROM t1 ORDER BY a) LIMIT 2;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1371 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1 ORDER BY a UNION SELECT a FROM t1;)"
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1377 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1\nUNION\nSELECT a FROM t1 ORDER BY a\nUNION\nSELECT a FROM t1;)"
./t/having.test: ok! 273 test cases passed, take time 1.709094376 s
time="2024-05-06T15:40:23+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T15:40:23+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/foreign_key.test: ok! 158 test cases passed, take time 1.641636189 s
time="2024-05-06T15:40:23+08:00" level=warning msg="parser:1538 query failed with non expected error(s)! (ErrNonUniq != ER_NONUNIQ_TABLE) (err: Error 1052 (23000): Column 'a' in field list is ambiguous) (query: SELECT * FROM ( t1 JOIN t2 ON TRUE, t1 JOIN t3 ON TRUE );)"
./t/having_myisam.test: ok! 17 test cases passed, take time 0.158033238 s
time="2024-05-06T15:40:24+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=53
time="2024-05-06T15:40:24+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=55
time="2024-05-06T15:40:24+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=58
time="2024-05-06T15:40:23+08:00" level=warning msg="subquery_bugs:676 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: SELECT DISTINCT * FROM t1\nORDER BY UUID_TO_BIN(\nST_ISEMPTY(\nST_POINTFROMTEXT(\nST_ASWKT(\nNOT EXISTS(\nSELECT 1 FROM t1\nWHERE IS_UUID(CAST(SHA(a>>0xA7FE1B22)AS JSON)) WINDOW w1 AS()\n),'AXIS-ORDER=SRID-DEFINED'\n),1,'AXIS-ORDER=LONG-LAT'\n)\n)\n);)"
time="2024-05-06T15:40:24+08:00" level=warning msg="foreign_key1:161 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-06T15:40:24+08:00" level=warning msg="foreign_key1:164 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-06T15:40:24+08:00" level=warning msg="foreign_key1:173 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-06T15:40:24+08:00" level=warning msg="foreign_key1:176 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
./t/heap_btree.test: ok! 147 test cases passed, take time 0.951228337 s
time="2024-05-06T15:40:24+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=brief $query;" command=eval line=946
./t/heap_btree_myisam.test: ok! 12 test cases passed, take time 0.089796583 s
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:337 query failed with non expected error(s)! (ER_FK_DUP_NAME != ER_DUP_KEYNAME) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fk') (query: ALTER TABLE t2 ADD CONSTRAINT fk FOREIGN KEY(b) REFERENCES t1(a);)"
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:343 query succeeded, but expected error(s)! (expected errors: ER_FK_DUP_NAME) (query: ALTER TABLE t2 ADD FOREIGN KEY(b) REFERENCES t1(a);)"
./t/histogram_singleton.test: ok! 266 test cases passed, take time 0.557101269 s
time="2024-05-06T15:40:25+08:00" level=warning msg="ignore_strict:103 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:437 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:439 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:446 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="foreign_key1:448 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="ignore_strict:346 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_NO_DEFAULT_FOR_VIEW_FIELD) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: INSERT INTO v1 (vcol1) VALUES(12);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:391 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00') (query: INSERT INTO t1 VALUES(STR_TO_DATE('32.10.2004 15.30','%D.%D.%Y %H.%I'));)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:412 query failed with non expected error(s)! (ErrDataTooLong != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:417 query failed with non expected error(s)! (ErrDataTooLong != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:439 query failed with non expected error(s)! (ErrTruncatedWrongValueForField != 1265) (err: Error 1366 (HY000): Incorrect tinyint value: '1a' for column 'a' at row 1) (query: INSERT INTO t1 VALUES ('1a');)"
time="2024-05-06T15:40:25+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2024-05-06T15:40:25+08:00" level=warning msg="command not implemented" arguments=" UPDATE parent SET pf2= 2, sleep_dummy= SLEEP(2)" command=send line=511
time="2024-05-06T15:40:25+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2024-05-06T15:40:25+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2024-05-06T15:40:25+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key1:531 query succeeded, but expected error(s)! (expected errors: ER_LOCK_WAIT_TIMEOUT) (query: ALTER TABLE child ADD COLUMN (i INT);)"
./t/foreign_key1.test: ok! 207 test cases passed, take time 2.198984175 s
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:41 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:41 query failed with non expected error(s)! (ER_FK_DEPTH_EXCEEDED != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t1 where id=0;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:460 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_WARN_NULL_TO_NOTNULL) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/wl6030_2.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/wl6030_2.dat' INTO TABLE t1 FIELDS TERMINATED BY ',' ENCLOSED BY '\"';)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:486 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="ignore_strict:624 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_DUP_ENTRY) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/rpl_loaddata.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t2 (a, @b) SET b= @b + 2;)"
./t/ignore_strict.test: ok! 157 test cases passed, take time 0.887417219 s
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:1954 query failed with non expected error(s)! (ER_SYNTAX_ERROR != ER_PARSE_ERROR) (err: Error 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use) (query: CREATE TABLE t1 (a INT) PARTITION BY KEY ALGORITHM = 10 () PARTITIONS 3;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:1978 query failed with non expected error(s)! (ErrNoSuchTable != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: DROP INDEX idx1 ON ``;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2035 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET NAMES utf8 COLLATE DEFAULT;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2237 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE ROLE `RESOURCE`;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2245 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global') (query: SET GLOBAL = DEFAULT;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2247 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local') (query: SET LOCAL = DEFAULT;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2249 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist') (query: SET PERSIST = DEFAULT;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2251 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist_only') (query: SET PERSIST_ONLY = DEFAULT;)"
time="2024-05-06T15:40:25+08:00" level=warning msg="parser:2253 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session') (query: SET SESSION = DEFAULT;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="parser:2339 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t1 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="parser:2348 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t2 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="parser:2357 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t3 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nNOT NULL\nCOLLATE ascii_bin\n);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="parser:2368 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t3 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\n);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="parser:2378 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t4 (\nx VARCHAR(10)\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:63 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:76 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:94 query failed with non expected error(s)! (ER_ROW_IS_REFERENCED_2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:117 query failed with non expected error(s)! (ER_ROW_IS_REFERENCED_2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:136 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:136 query failed with non expected error(s)! (ER_FK_DEPTH_EXCEEDED != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t0 where id=0;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=25
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=44
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=61
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=76
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=91
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=106
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=121
./t/subquery_bugs.test: ok! 287 test cases passed, take time 3.1722699739999998 s
./t/parser.test: ok! 693 test cases passed, take time 4.908845495 s
./t/parser_precedence.test: ok! 138 test cases passed, take time 0.082149527 s
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:158 query failed with non expected error(s)! (ER_ROW_IS_REFERENCED_2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t1 where id = 2;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:160 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t2 where id = 2;)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:286 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-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=136
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=151
time="2024-05-06T15:40:26+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=166
./t/implicit_char_to_num_conversion.test: ok! 110 test cases passed, take time 0.37347544 s
./t/in.test: ok! 13 test cases passed, take time 0.019255726 s
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:327 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-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:368 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:385 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/index.test: ok! 33 test cases passed, take time 0.149607664 s
time="2024-05-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+08:00" level=warning msg="foreign_key_cascade_delete:432 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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:26+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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');)"
time="2024-05-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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');)"
time="2024-05-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+08:00" level=warning msg="foreign_key_cascade_delete:575 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+08:00" level=warning msg="foreign_key_cascade_delete:615 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-06T15:40:27+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-06T15:40:27+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-06T15:40:27+08:00" level=warning msg="foreign_key_cascade_delete:655 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T15:40:27+08:00" level=warning msg="subquery_mat:135 query succeeded, but expected error(s)! (expected errors: 1235) (query: select * from t1 where (a1, a2) in (select b1, min(b2) from t2i limit 1,1);)"
time="2024-05-06T15:40:28+08:00" level=warning msg="partition:345 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: ALTER TABLE t1\nPARTITION BY HASH (a)\n(PARTITION p0 ENGINE=InnoDB,\nPARTITION p1 ENGINE=NonExistentEngine);)"
time="2024-05-06T15:40:29+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=841
time="2024-05-06T15:40:29+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=848
time="2024-05-06T15:40:30+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1171
time="2024-05-06T15:40:30+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1308
time="2024-05-06T15:40:30+08:00" level=warning msg="subquery_mat:1391 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief UPDATE t2,t3 SET t2.a=10 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T15:40:30+08:00" level=warning msg="subquery_mat:1393 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief DELETE t2.* FROM t2,t3 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T15:40:30+08:00" level=warning msg="partition:1357 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0) (subpartition sp0),\npartition p1 values less than (1));)"
time="2024-05-06T15:40:30+08:00" level=warning msg="partition:1364 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0),\npartition p1 values less than (1) (subpartition sp0));)"
time="2024-05-06T15:40:30+08:00" level=warning msg="partition:1374 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by list (a)\nsubpartition by hash(a)\n(partition p0 values in (0),\npartition p1 values in (1) (subpartition sp0));)"
time="2024-05-06T15:40:31+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=1680
time="2024-05-06T15:40:31+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1681
./t/subquery_mat.test: ok! 502 test cases passed, take time 5.172501864 s
time="2024-05-06T15:40:31+08:00" level=warning msg="partition:1711 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_NULL_IN_VALUES_LESS_THAN) (err: Error 1659 (HY000): Field 'NULL' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a int)\nPARTITION BY RANGE(a)\n(PARTITION p0 VALUES LESS THAN (NULL));)"
./t/subquery_sj_innodb_all.test: ok! 68 test cases passed, take time 0.563996307 s
time="2024-05-06T15:40:32+08:00" level=warning msg="command not implemented" arguments=" ($cnt)\n{\nupdate t1 set s2 = 1;" command=while line=2063
time="2024-05-06T15:40:32+08:00" level=warning msg="command not implemented" arguments=" $cnt;" command=dec line=2067
time="2024-05-06T15:40:32+08:00" level=warning msg="command not implemented" arguments=" ($n)\n{\ninsert into t1 (user) values ('mysql');" command=while line=2192
time="2024-05-06T15:40:32+08:00" level=warning msg="command not implemented" arguments=" $n;" command=dec line=2195
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 6.447267439 s
time="2024-05-06T15:40:34+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-06T15:40:34+08:00" level=warning msg="foreign_key_cascade_mysql:317 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(b) references parent (a) on delete cascade on update restrict;)"
time="2024-05-06T15:40:34+08:00" level=warning msg="foreign_key_cascade_mysql:345 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(a) references parent (b) on delete cascade on update restrict;)"
time="2024-05-06T15:40:34+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-06T15:40:34+08:00" level=warning msg="foreign_key_cascade_mysql:404 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 (a) on delete cascade on update restrict;)"
time="2024-05-06T15:40:34+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/subselect_innodb.test: ok! 175 test cases passed, take time 2.163461582 s
time="2024-05-06T15:40:34+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=6
time="2024-05-06T15:40:34+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=7
time="2024-05-06T15:40:34+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=8
./t/sum_distinct-big.test: ok! 24 test cases passed, take time 0.27349506 s
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 2.125600569 s
time="2024-05-06T15:40:34+08:00" level=warning msg="partition:2435 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) (err: Error 8200 (HY000): unsupported add column 's3' constraint UNIQUE KEY when altering 'partition.t1') (query: ALTER TABLE t1 ADD COLUMN (s3 VARCHAR(5) UNIQUE);)"
time="2024-05-06T15:40:34+08:00" level=warning msg="partition:2486 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table B of the UPDATE is not updatable) (query: UPDATE t1_part AS A NATURAL JOIN v1 as B SET A.nokey = 2 , B.partkey = 3;)"
time="2024-05-06T15:40:34+08:00" level=warning msg="partition:2488 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A NATURAL JOIN t1_part as B SET A.nokey = 2 , B.partkey = 3;)"
time="2024-05-06T15:40:35+08:00" level=warning msg="partition:2728 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DROP TABLE IF EXISTS `example`;)"
./t/sum_distinct.test: ok! 32 test cases passed, take time 0.59014736 s
time="2024-05-06T15:40:35+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=2939
time="2024-05-06T15:40:35+08:00" level=warning msg="partition:2945 query failed with non expected error(s)! (ErrDupFieldName != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 CHANGE COLUMN i j INT, CHANGE COLUMN j i INT;)"
time="2024-05-06T15:40:35+08:00" level=warning msg="partition:2984 query failed with non expected error(s)! (ErrDupFieldName != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 RENAME COLUMN i TO j, RENAME COLUMN j TO i;)"
./t/partition.test: ok! 725 test cases passed, take time 8.669204438 s
time="2024-05-06T15:40:35+08:00" level=warning msg="temp_table:82 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_DUP_ENTRY) (err: Error 8200 (HY000): TiDB doesn't support ALTER TABLE for local temporary table) (query: alter table t1 add primary key (a);)"
./t/partition_bug18198.test: ok! 45 test cases passed, take time 0.041507268 s
time="2024-05-06T15:40:35+08:00" level=warning msg="partition_column:49 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a BLOB)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2024-05-06T15:40:35+08:00" level=warning msg="partition_column:54 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a TEXT)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 0.833689885 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2372) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-8628/tidb-test already exists)
[Pipeline] // cache
./t/temp_table.test: ok! 137 test cases passed, take time 0.762979031 s
./t/temptable_256_fields.test: ok! 5 test cases passed, take time 0.03198521 s
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-06T15:40:36+08:00" level=warning msg="partition_column:477 query failed with non expected error(s)! (ErrPartitionColumnList != 1566) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: create table t1 (a int, b int)\npartition by range columns(a,b)\n(partition p0 values less than (10));)"
./t/temptable_disk.test: ok! 14 test cases passed, take time 0.132862071 s
time="2024-05-06T15:40:36+08:00" level=warning msg="time:61 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:40:36+08:00" level=warning msg="time:61 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect date value: '-1' for column 'c1' at row 1) (query: INSERT INTO t (c1) values (-1);)"
time="2024-05-06T15:40:36+08:00" level=warning msg="time:63 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:40:36+08:00" level=warning msg="time:63 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect datetime value: '-1' for column 'c2' at row 1) (query: INSERT INTO t (c2) values (-1);)"
time="2024-05-06T15:40:36+08:00" level=warning msg="time:65 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:40:36+08:00" level=warning msg="time:65 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect timestamp value: '-1' for column 'c3' at row 1) (query: INSERT INTO t (c3) values (-1);)"
time="2024-05-06T15:40:36+08:00" level=warning msg="partition_column:530 query failed with non expected error(s)! (ErrRangeNotIncreasing != ER_REORG_OUTSIDE_RANGE) (err: Error 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition) (query: alter table t1 reorganize partition p0 into\n(partition p01 values less than (0,3),\npartition p02 values less than (1,1));)"
./t/partition_column.test: ok! 152 test cases passed, take time 0.995284718 s
time="2024-05-06T15:40:36+08:00" level=warning msg="time:90 Unknown named --error "
time="2024-05-06T15:40:36+08:00" level=warning msg="time:90 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ) (err: Error 1292 (22007): Incorrect datetime value: '2004-04-31' for column 'col' at row 1) (query: insert into t values ('2004-04-31');)"
./t/time.test: ok! 71 test cases passed, take time 0.178487532 s
./t/time_zone_grant.test: ok! 58 test cases passed, take time 0.286631761 s
./t/partition_column_prune.test: ok! 27 test cases passed, take time 0.419851079 s
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/time_zone_with_dst.test: ok! 28 test cases passed, take time 0.312053117 s
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:56 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:56 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default '12345678');)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:70 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:70 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011111);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:92 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:92 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011);)"
[Pipeline] // container
[Pipeline] }
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:114 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:114 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:136 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:136 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:150 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:150 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 20);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:156 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:156 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:170 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:170 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default -1);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:176 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:176 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 99999999999999);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:182 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:182 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 100000000000000);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:188 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:188 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 10000101000000);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:194 query succeeded, but expected error(s)! (expected errors: ER_DEFAULT_VALUE) (query: create table t (id int, c1 timestamp default null);)"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:200 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:40:37+08:00" level=warning msg="timestamp_insert:200 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp not null default null);)"
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/timestamp_insert.test: ok! 199 test cases passed, take time 0.780099508 s
./t/timestamp_update.test: ok! 75 test cases passed, take time 0.254458915 s
./t/tpcc.test: ok! 35 test cases passed, take time 0.550842222 s
time="2024-05-06T15:40:38+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=8
time="2024-05-06T15:40:37+08:00" level=warning msg="command not implemented" arguments=" ($merge_table_support)\n{" command=if line=486
./t/index_merge1.test: ok! 160 test cases passed, take time 11.149343283 s
time="2024-05-06T15:40:39+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
./t/index_merge2.test: ok! 328 test cases passed, take time 1.749505627 s
time="2024-05-06T15:40:40+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-06T15:40:40+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=10
./t/index_merge_bug29952775.test: ok! 7 test cases passed, take time 0.028430497 s
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.063252413 s
time="2024-05-06T15:40:42+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=107
time="2024-05-06T15:40:42+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-06T15:40:42+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
time="2024-05-06T15:40:42+08:00" level=warning msg="command not implemented" arguments= command=disable_connect_log line=162
./t/transaction_isolation_func.test: ok! 62 test cases passed, take time 4.066737135 s
./t/truth_value_transform.test: ok! 19 test cases passed, take time 0.054603686 s
./t/type.test: ok! 16 test cases passed, take time 0.057690566 s
time="2024-05-06T15:40:43+08:00" level=warning msg="type_binary:122 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: create table t1\nselect convert(0x9999999999999999999999999999999999999999999,unsigned);)"
./t/type_binary.test: ok! 93 test cases passed, take time 0.446557227 s
time="2024-05-06T15:40:44+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=153
time="2024-05-06T15:40:44+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=155
./t/type_bit_innodb.test: ok! 89 test cases passed, take time 0.803225269 s
time="2024-05-06T15:40:45+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=255
time="2024-05-06T15:40:45+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=257
./t/type_bit_myisam.test: ok! 168 test cases passed, take time 1.293917457 s
time="2024-05-06T15:40:45+08:00" level=warning msg="type_blob:38 query failed with non expected error(s)! (ErrBlobCantHaveDefault != 1074) (err: Error 1101 (42000): BLOB/TEXT/JSON column 'a' can't have a default value) (query: CREATE TABLE t1 (a varchar(70000) default \"hello\");)"
time="2024-05-06T15:40:46+08:00" level=warning msg="type_blob:345 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: insert into t1 (txt) values ('Chevy'), ('CHEVY');)"
./t/partition_func.test: ok! 1341 test cases passed, take time 8.963015909 s
./t/partition_grant.test: ok! 21 test cases passed, take time 0.155543255 s
time="2024-05-06T15:40:46+08:00" level=warning msg="command not implemented" arguments=" include/no_valgrind_without_big.inc" command=source line=9
time="2024-05-06T15:40:46+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=359
time="2024-05-06T15:40:46+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-06T15:40:46+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
./t/index_merge_delete.test: ok! 214 test cases passed, take time 6.628214193 s
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.137033761 s
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:521 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: CREATE TABLE b15776 (a int(256));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:578 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: explain select cast(1 as char(4294967295));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:584 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select cast(1 as char(4294967296));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:588 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select cast(1 as binary(4294967296));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:606 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: explain select convert(1, char(4294967295));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:608 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select convert(1, char(4294967296));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:619 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select convert(1, binary(4294967296));)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:636 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: UPDATE t2 SET c = REPEAT('1', 70000);)"
time="2024-05-06T15:40:47+08:00" level=warning msg="type_blob:640 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1;)"
./t/type_blob.test: ok! 296 test cases passed, take time 2.281069054 s
time="2024-05-06T15:40:48+08:00" level=warning msg="type_datetime:151 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_INVALID_DEFAULT) (err: Error 1292 (22007): Truncated incorrect time value: '916:00:00 a') (query: create table t1 (t time default '916:00:00 a');)"
./t/partition_hash.test: ok! 306 test cases passed, take time 2.865172977 s
time="2024-05-06T15:40:48+08:00" level=warning msg="command not implemented" arguments=" include/not_embedded.inc" command=source line=2
time="2024-05-06T15:40:48+08:00" level=warning msg="command not implemented" arguments=" include/have_partition.inc" command=source line=3
time="2024-05-06T15:40:48+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=4
time="2024-05-06T15:40:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=73
time="2024-05-06T15:40:48+08:00" level=warning msg="command not implemented" arguments= command=reap line=79
time="2024-05-06T15:40:49+08:00" level=warning msg="command not implemented" arguments=" (`select locate('semijoin', @@optimizer_switch) > 0`)\n{\nset optimizer_switch='semijoin=off';" command=if line=395
time="2024-05-06T15:40:49+08:00" level=warning msg="type_datetime:466 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != 1067) (err: Error 1292 (22007): Truncated incorrect time value: '916:00:00 a') (query: create table t1 (t time default '916:00:00 a');)"
time="2024-05-06T15:40:49+08:00" level=warning msg="type_datetime:494 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DELETE IGNORE  FROM t1 WHERE dt1 = '0000-00-01 00:00:01';)"
time="2024-05-06T15:40:49+08:00" level=warning msg="command not implemented" arguments= command=enable_parsing line=444
./t/partition_innodb.test: ok! 114 test cases passed, take time 0.698092403 s
time="2024-05-06T15:40:49+08:00" level=warning msg="partition_list:81 query failed with non expected error(s)! (ErrPartitionColumnList != ER_PARSE_ERROR) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: ALTER TABLE t1 ADD PARTITION\n(PARTITION p3_a VALUES IN ((1 + 1 + 1), \"a0\"));)"
time="2024-05-06T15:40:49+08:00" level=warning msg="partition_list:96 query failed with non expected error(s)! (ErrPartitionColumnList != ER_PARSE_ERROR) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: ALTER TABLE t1 ADD PARTITION\n(PARTITION part_2 VALUES IN ((21 ,22, 23, 24, 25, 26, 27, 28, 29, 30,\n31 ,32, 33, 34, 35, 36, 37, 38, 39, 40),\n(41 ,42, 43, 44, 45, 46, 47, 48, 49, 50,\n51 ,52, 53, 54, 55, 56, 57, 58, 59, 60)));)"
time="2024-05-06T15:40:50+08:00" level=warning msg="type_datetime:679 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: DELETE FROM type_datetime.t WHERE `col_int_nokey` > `col_int_nokey`\nAND TIMESTAMP( '18:16:35.025453' ) IS  NULL;)"
time="2024-05-06T15:40:50+08:00" level=warning msg="type_datetime:682 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE type_datetime.t SET `col_varchar_nokey` = TIMESTAMP(`col_time_nokey`,'00:00:00')\nWHERE `col_int_nokey` > `col_int_nokey`\nAND TIMESTAMP('18:16:35.025453') IS  NULL;)"
time="2024-05-06T15:40:50+08:00" level=warning msg="type_datetime:706 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1305 (42000): FUNCTION type_datetime.st_longfromgeohash does not exist) (query: do ucase(insert(maketime(9.565398e+307 ,'',\nst_longfromgeohash(('4358-04-12 03:45:08.727399'))),\n0xdc0823,6756,release_all_locks()));)"
time="2024-05-06T15:40:50+08:00" level=warning msg="type_datetime:711 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION type_datetime.soundex does not exist) (query: do soundex(maketime(cast((2530967061762658367) as decimal),\nexp(repeat('1',32)),((period_add(579349005,27636))xor (sha(current_user)))));)"
time="2024-05-06T15:40:50+08:00" level=warning msg="type_datetime:715 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION type_datetime.st_mlinefromtext does not exist) (query: do st_mlinefromtext(\nmaketime(\nnow(),\ninstr(1,pow(15270551309908264860,100)),\n31\n)\n);)"
./t/type_datetime.test: ok! 334 test cases passed, take time 2.186228001 s
time="2024-05-06T15:40:50+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=25
time="2024-05-06T15:40:50+08:00" level=warning msg="command not implemented" arguments=" utf8mb4" command=character_set line=171
./t/partition_list.test: ok! 107 test cases passed, take time 0.604878861 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2226) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-8628/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-06T15:40:50+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=344
time="2024-05-06T15:40:50+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=350
time="2024-05-06T15:40:51+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=529
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
./t/type_decimal.test: ok! 361 test cases passed, take time 1.5794533689999999 s
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2024-05-06T15:40:52+08:00" level=warning msg="command not implemented" arguments=" utf8mb4" command=character_set line=107
time="2024-05-06T15:40:52+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=114
time="2024-05-06T15:40:52+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=129
time="2024-05-06T15:40:52+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=131
time="2024-05-06T15:40:52+08:00" level=warning msg="command not implemented" arguments=" 5 4 3 4" command=replace_result line=263
time="2024-05-06T15:40:53+08:00" level=warning msg="type_enum:288 query succeeded, but expected error(s)! (expected errors: ER_TOO_LONG_SET_ENUM_VALUE) (query: CREATE TABLE t1(exhausting_charset enum(\n'zz\nzz'))\nCHARSET=utf8mb4;)"
./t/type_enum.test: ok! 122 test cases passed, take time 1.403015788 s
time="2024-05-06T15:40:53+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=146
time="2024-05-06T15:40:54+08:00" level=warning msg="type_float:251 query failed with non expected error(s)! (ER_TOO_BIG_DISPLAYWIDTH != 1427) (err: Error 1439 (42000): Display width out of range for column 's1' (max = 255)) (query: create table t1 (s1 float(0,2));)"
time="2024-05-06T15:40:54+08:00" level=warning msg="command not implemented" arguments=" select concat((truncate((-1.7976931348623157E+307),(0x1e))),\n($nine_65)) into @a;" command=eval line=358
Aborted by Jenkins Admin
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
tidb-server(PID: 2372) stopped
script returned exit code 143
tidb-server(PID: 2318) stopped
script returned exit code 143
kill finished with exit code 1
Killing processes
kill finished with exit code 1
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] // cache
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
Post stage
Post stage
[Pipeline] junit
Recording test results
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[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 ABORTED result.json
http://fileserver.pingcap.net
--2024-05-06 07:41:01--  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%  611M=0s

2024-05-06 07:41:01 (611 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
org.jenkinsci.plugins.workflow.actions.ErrorAction$ErrorId: be3c6fea-611b-49b9-b1de-f4f4edc4d898
Failed in branch Matrix - PART = '4'
Finished: ABORTED