Skipping 883 KB.. Full Log

./t/groupby.test: ok! 99 test cases passed, take time 0.103171022 s
time="2024-05-06T10:30:29+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-06T10:30:29+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-06T10:30:29+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=313
time="2024-05-06T10:30: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=320
time="2024-05-06T10:30:29+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-06T10:30:29+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=371
time="2024-05-06T10:30:29+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=373
time="2024-05-06T10:30:29+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=467
time="2024-05-06T10:30: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=469
time="2024-05-06T10:30:29+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/join_outer.test: ok! 867 test cases passed, take time 5.350288739 s
./t/json.test: ok! 82 test cases passed, take time 0.379186932 s
time="2024-05-06T10:30:29+08:00" level=warning msg="json_agg:184 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION json_agg.st_pointfromtext does not exist) (query: SELECT JSON_ARRAYAGG(ST_PointFromText('POINT(10 10)')) FROM t2;)"
./t/json_agg.test: ok! 177 test cases passed, take time 0.543097512 s
time="2024-05-06T10:30:30+08:00" level=warning msg="json_ddl:70 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_TEXT) (query: ALTER TABLE t4 MODIFY COLUMN jj JSON;)"
./t/json_ddl.test: ok! 40 test cases passed, take time 0.53505157 s
time="2024-05-06T10:30:30+08:00" level=warning msg="json_functions:133 Unknown named --error Incorrect parameter count"
time="2024-05-06T10:30:30+08:00" level=warning msg="json_functions:133 query failed with non expected error(s)! (ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT != Incorrect parameter count) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'json_object') (query: SELECT JSON_OBJECT( 87, 'name', 'carrot');)"
time="2024-05-06T10:30:30+08:00" level=warning msg="json_functions:135 Unknown named --error JSON documents may not contain NULL"
time="2024-05-06T10:30:30+08:00" level=warning msg="json_functions:135 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != JSON documents may not contain NULL) (err: Error 1105 (HY000): JSON documents may not contain NULL member names) (query: SELECT JSON_OBJECT(NULL, 'carrot');)"
./t/having.test: ok! 273 test cases passed, take time 1.880772101 s
time="2024-05-06T10:30:30+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T10:30:30+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/having_myisam.test: ok! 17 test cases passed, take time 0.168713078 s
time="2024-05-06T10:30:30+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-06T10:30:30+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-06T10:30:30+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
./t/json_functions.test: ok! 784 test cases passed, take time 0.619418426 s
time="2024-05-06T10:30:31+08:00" level=warning msg="json_gcol:23 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{}');)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_gcol:25 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{\"a\": 1}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{\"a\":1}');)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_gcol:27 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '\"abc\"' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('\"abc\"');)"
./t/json_gcol.test: ok! 94 test cases passed, take time 0.249661659 s
./t/json_group_concat_innodb.test: ok! 40 test cases passed, take time 0.084412572 s
./t/heap_btree.test: ok! 147 test cases passed, take time 0.927152706 s
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:19 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:19 query failed with non expected error(s)! (ErrInvalidJSONText != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:26 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:26 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:43 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:43 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_CONSTRAINT_FAILED) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: create table t2 (t json) select t from t1;)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:51 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:51 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert into t1 values (\"xxx\");)"
time="2024-05-06T10:30:31+08:00" level=warning msg="json_type:59 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_PARSE_ERROR) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select cast('{a:1}' as json);)"
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=76
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=77
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=80
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=81
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=89
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=90
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=92
time="2024-05-06T10:30:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=93
./t/json_type.test: ok! 45 test cases passed, take time 0.216708328 s
./t/heap_btree_myisam.test: ok! 12 test cases passed, take time 0.093331054 s
./t/histogram_singleton.test: ok! 266 test cases passed, take time 0.538884628 s
time="2024-05-06T10:30:32+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-06T10:30:32+08:00" level=warning msg="key:313 query failed with non expected error(s)! (ErrMultiplePriKey != 1091) (err: Error 1068 (42000): Multiple primary key defined) (query: alter table t1 add primary key (c1, c2);)"
time="2024-05-06T10:30:32+08:00" level=warning msg="ignore_strict:346 query failed with non expected error(s)! (ErrUnknown != 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-06T10:30:32+08:00" level=warning msg="key:322 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1);)"
time="2024-05-06T10:30:32+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-06T10:30:32+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-06T10:30:32+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-06T10:30:33+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-06T10:30:33+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-06T10:30:33+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-06T10:30:33+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.848057522 s
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=25
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=44
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=61
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=76
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=91
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=106
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=121
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=136
time="2024-05-06T10:30:33+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=151
time="2024-05-06T10:30:33+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.339018688 s
./t/in.test: ok! 13 test cases passed, take time 0.01745521 s
./t/index.test: ok! 33 test cases passed, take time 0.176101023 s
./t/key.test: ok! 192 test cases passed, take time 2.123968782 s
./t/key_diff.test: ok! 10 test cases passed, take time 0.051976718 s
time="2024-05-06T10:30:34+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;)"
time="2024-05-06T10:30:35+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;)"
time="2024-05-06T10:30:35+08:00" level=warning msg="key_myisam:303 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: alter table t1 drop key k;)"
time="2024-05-06T10:30:35+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-06T10:30:35+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 );)"
time="2024-05-06T10:30:35+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/key_myisam.test: ok! 123 test cases passed, take time 1.29489519 s
./t/key_primary.test: ok! 12 test cases passed, take time 0.02808033 s
./t/keywords.test: ok! 51 test cases passed, take time 0.17572049 s
time="2024-05-06T10:30:35+08:00" level=warning msg="lead_lag:49 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_PARSE_ERROR) (err: Error 1210 (HY000): Incorrect arguments to lead) (query: SELECT id, sex, LEAD(id, 1.2) RESPECT NULLS OVER () FROM t1;)"
./t/filesort.test: ok! 54 test cases passed, take time 11.91742935 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.099283408 s
./t/lead_lag.test: ok! 214 test cases passed, take time 0.369053833 s
./t/lead_lag_explain.test: ok! 81 test cases passed, take time 0.194722568 s
./t/like.test: ok! 8 test cases passed, take time 0.010784502 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.472888786 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.126431956 s
time="2024-05-06T10:30:36+08:00" level=warning msg="limit:253 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-06T10:30:36+08:00" level=warning msg="limit:256 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-06T10:30:36+08:00" level=warning msg="limit:259 query failed with non expected error(s)! (ErrWrongArguments != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a, @a;)"
./t/limit.test: ok! 174 test cases passed, take time 0.515249818 s
./t/limit_myisam.test: ok! 5 test cases passed, take time 0.022276407 s
./t/long_tmpdir.test: ok! 3 test cases passed, take time 0.025234853 s
time="2024-05-06T10:30:36+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=7
time="2024-05-06T10:30:36+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=8
time="2024-05-06T10:30:36+08:00" level=warning msg="lowercase_fs_off:27 query failed with non expected error(s)! (ErrDBCreateExists != ER_DBACCESS_DENIED_ERROR) (err: Error 1007 (HY000): Can't create database 'D1'; database exists) (query: create database D1;)"
time="2024-05-06T10:30:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=29
time="2024-05-06T10:30:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=35
time="2024-05-06T10:30:36+08:00" level=warning msg="lowercase_fs_off:52 query succeeded, but expected error(s)! (expected errors: ER_TABLEACCESS_DENIED_ERROR) (query: select * from t1;)"
./t/lowercase_fs_off.test: ok! 22 test cases passed, take time 0.115226489 s
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=3
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase1.inc" command=source line=4
./t/lowercase_mixed_tmpdir.test: ok! 8 test cases passed, take time 0.030094729 s
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=98
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=108
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=115
time="2024-05-06T10:30:37+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=126
time="2024-05-06T10:30:37+08:00" level=warning msg="lowercase_table:144 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE mysql.general_log DISCARD TABLESPACE;)"
time="2024-05-06T10:30:37+08:00" level=warning msg="lowercase_table:146 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE MYSQL.general_log DISCARD TABLESPACE;)"
time="2024-05-06T10:30:37+08:00" level=warning msg="lowercase_table:148 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.GENERAL_LOG' doesn't exist) (query: ALTER TABLE mysql.GENERAL_LOG DISCARD TABLESPACE;)"
./t/lowercase_table.test: ok! 72 test cases passed, take time 0.42068208 s
./t/foreign_key.test: ok! 158 test cases passed, take time 1.579112382 s
./t/lowercase_table2.test: ok! 86 test cases passed, take time 0.660465975 s
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE `Table2`;" command=query_vertical line=81
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=82
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product_Order;" command=query_vertical line=109
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product;" command=query_vertical line=110
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Customer;" command=query_vertical line=111
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=112
./t/lowercase_table4.test: ok! 31 test cases passed, take time 0.206135598 s
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=15
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=16
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=28
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=35
./t/lowercase_table5.test: ok! 12 test cases passed, take time 0.069754459 s
time="2024-05-06T10:30:38+08:00" level=warning msg="foreign_key1:161 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="foreign_key1:164 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-06T10:30:38+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-06T10:30:38+08:00" level=warning msg="foreign_key1:176 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
./t/lowercase_table_grant.test: ok! 15 test cases passed, take time 0.052989331 s
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1 --character-set-server=utf8" command=exec line=27
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --character-set-server=utf8 --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=30
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=31
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=32
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=44
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=shutdown_server line=45
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=46
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" echo \"restart\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=50
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=51
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=52
./t/lowercase_utf8.test: ok! 6 test cases passed, take time 0.026122456 s
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1" command=exec line=22
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=25
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=26
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=27
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:56 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v1Aa);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:58 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2Aa set col1 = (select max(col1) from t1Aa);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:60 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v2Aa);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:62 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:64 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:66 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:68 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from v1aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:70 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v1Aa) where t1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:72 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1aA set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:74 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from t1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:76 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t1Aa,t2Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:78 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from t1Aa) where v1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:80 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from t1aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:82 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:84 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from t1Aa) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:86 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:88 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v2aA) where t1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:90 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v2Aa) where v1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:92 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2aA set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:94 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v2aA) where t1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:96 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from v2Aa) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:98 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v1aA);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:100 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from t1aA);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:102 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v2aA);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:104 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v3aA);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:106 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v1Aa);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:108 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete from v2aA where col1 = (select max(col1) from t1Aa);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:110 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v2aA);)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:112 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v1aA) > 0 and v2Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:114 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from v1Aa) > 0 and t1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:116 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from v1aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:118 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete v2aA from v2Aa,t2Aa where (select max(col1) from t1Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:120 query succeeded, but expected error(s)! (expected errors: 1093) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from t1aA) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:122 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from t1aA) > 0 and v1aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:124 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v2Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:126 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1Aa from t1aA,t2Aa where (select max(col1) from v2Aa) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:128 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v1Aa is not supported now) (query: delete v1Aa from v1aA,t2Aa where (select max(col1) from v2aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:130 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v1aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:132 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1aA values ((select max(col1) from v1Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:134 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v1aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:136 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from t1Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:138 query succeeded, but expected error(s)! (expected errors: 1093) (query: insert into t1aA values ((select max(col1) from t1Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:140 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from t1aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:142 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v2aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:144 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1Aa values ((select max(col1) from v2Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:146 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v2Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:148 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v1Aa));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:150 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3aA (col1) values ((select max(col1) from t1aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="lowercase_view:152 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v2aA));)"
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=176
time="2024-05-06T10:30:39+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=190
./t/lowercase_view.test: ok! 83 test cases passed, take time 0.365113081 s
./t/lpad.test: ok! 26 test cases passed, take time 0.004630284 s
time="2024-05-06T10:30:39+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-06T10:30:39+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);)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:389 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:389 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect * from t2,t where t2.c=t.f1;)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:397 Unknown named --error ER_DUP_QUERY_NAME"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:397 query failed with non expected error(s)! (ErrNonuniqTable != ER_DUP_QUERY_NAME) (err: Error 1066 (42000): Not unique table/alias: '%-.192s') (query: with t as (select * from t2 where c>3),\nt as (select a from t1 where a>2)\nselect * from t,t1 where t1.a=t.c;)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:408 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:408 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive t as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:414 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:414 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:421 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:421 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from t1\nwhere a in (select c from s where b<='ccc') and  b>'b'),\ns as (select * from t1,t2\nwhere t1.a=t2.c and t1.c in (select a from t where a<5))\nselect * from s where s.b>'aaa';)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:429 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:429 query failed with non expected error(s)! (ErrCTERecursiveRequiresUnion != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 3573 (HY000): Recursive Common Table Expression 's' should contain a UNION) (query: with recursive\nt as (select * from t1 where b>'aaa' and b <='d')\nselect t.b from t,t2\nwhere t.a=t2.c and\nt2.c in (with recursive\ns as (select t1.a from s,t1 where t1.a=s.a and t1.b<'c')\nselect * from s);)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:461 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:461 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2024-05-06T10:30:39+08:00" level=warning msg="mariadb_cte_nonrecursive:467 query succeeded, but expected error(s)! (expected errors: ER_DUP_FIELDNAME) (query: with t(f1,f1) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6574
time="2024-05-06T10:30:38+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=6581
time="2024-05-06T10:30:39+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);)"
time="2024-05-06T10:30:39+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-06T10:30:39+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-06T10:30:39+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-06T10:30:39+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-06T10:30:40+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2024-05-06T10:30:39+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=741
time="2024-05-06T10:30:39+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=742
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=769
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=770
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=800
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=817
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=834
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=852
./t/subquery_all.test: ok! 2358 test cases passed, take time 19.541068416 s
time="2024-05-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2024-05-06T10:30:40+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.155709877 s
time="2024-05-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="foreign_key_cascade_delete:63 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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="foreign_key_cascade_delete:76 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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="foreign_key_cascade_delete:160 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 t2 where id = 2;)"
./t/subquery_antijoin.test: ok! 116 test cases passed, take time 0.754047078 s
time="2024-05-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=252
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" |;" command=delimiter line=1297
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" ;|\ndrop table t1,t2;" command=delimiter line=1299
./t/mariadb_cte_nonrecursive.test: ok! 382 test cases passed, take time 1.605417311 s
time="2024-05-06T10:30:40+08:00" level=warning msg="command not implemented" arguments=" include/default_optimizer_switch.inc" command=source line=2
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:11 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:11 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.r' doesn't exist) (query: with recursive\nt as\n(\nselect * from t1 where t1.b >= 'c'\nunion\nselect * from r\n),\nr as\n(\nselect * from t\nunion\nselect t1.* from t1,r where r.a+1 = t1.a\n)\nselect * from r;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:28 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:28 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.b1' doesn't exist) (query: with recursive\na1(a,b) as\n(select * from t1 where t1.a>3\nunion\nselect * from b1 where b1.a >3\nunion\nselect * from c1 where c1.a>3),\nb1(a,b) as\n(select * from a1 where a1.b > 'ccc'\nunion\nselect * from c1 where c1.b > 'ddd'),\nc1(a,b) as\n(select * from a1 where a1.a<6 and a1.b< 'zz'\nunion\nselect * from b1 where b1.b > 'auu')\nselect * from c1;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:284 query succeeded, but expected error(s)! (expected errors: 1112) (query: with recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me' and dob = '2000-01-01'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect *\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id);)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:304 query succeeded, but expected error(s)! (expected errors: 1112) (query: with\nancestor_couples(husband, h_dob, wife, w_dob)\nas\n(\nwith recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect t1.name, t1.dob, t2.name, t2.dob\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id)\n)\nselect * from ancestor_couples;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:753 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:753 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me' and  father is not null\nunion all\nselect mother, 1 from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:772 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:772 query failed with non expected error(s)! (ErrViewWrongList != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father from folks where name = 'Me' and  father is not null\nunion all\nselect mother from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:810 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:810 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'coupled_ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\ncoupled_ancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me' and father is not null\nunion\nselect mother from folks where name = 'Me' and mother is not null\nunion\nselect n.father\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\nunion\nselect n.mother\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\n)\nselect p.* from coupled_ancestor_ids a, folks p\nwhere a.id = p.id;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:858 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:858 query failed with non expected error(s)! (ErrCTERecursiveForbiddenJoinOrder != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3576 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints) (query: with recursive\nancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me'\nunion\nselect mother from folks where name = 'Me'\nunion\nselect father from folks left join ancestor_ids a on folks.id = a.id\nunion\nselect mother from folks left join ancestor_ids a on folks.id = a.id\n),\nancestors\nas\n(\nselect p.* from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:923 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-06T10:30:40+08:00" level=warning msg="mariadb_cte_recursive:923 query failed with non expected error(s)! (ErrCTERecursiveForbidsAggregation != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3575 (HY000): Recursive Common Table Expression 'ancestor_ids' can contain neither aggregation nor window functions in recursive query block) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me'\nunion\nselect mother, 1 from folks where name = 'Me'\nunion\nselect max(father), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\nunion\nselect max(mother), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\n),\nancestors\nas\n(\nselect generation, name from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2024-05-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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');)"
time="2024-05-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+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-06T10:30:40+08:00" level=warning msg="foreign_key_cascade_delete:449 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+08:00" level=warning msg="foreign_key_cascade_delete:535 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+08:00" level=warning msg="foreign_key_cascade_delete:575 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:30:41+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-06T10:30:41+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-06T10:30:41+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-06T10:30:41+08:00" level=warning msg="mariadb_cte_recursive:1518 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 1064) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.applied_modules' doesn't exist) (query: with recursive\nreached_values as\n(\nselect v from value_nodes where v in ('v3','v7','v9')\nunion\nselect module_results.v from module_results, applied_modules\nwhere module_results.m = applied_modules.m\n),\napplied_modules as\n(\nselect module_nodes.m\nfrom\nmodule_nodes\nleft join\n(\nmodule_arguments\nleft join\nreached_values\non module_arguments.v = reached_values.v\n)\non reached_values.v is null and\nmodule_nodes.m = module_arguments.m\nwhere module_arguments.m is null\n)\nselect * from reached_values;)"
time="2024-05-06T10:30:41+08:00" level=warning msg="subquery_bugs:676 query failed with non expected error(s)! (ErrInvalidJSONText != 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-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q1;" command=eval line=1771
time="2024-05-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=1772
time="2024-05-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q2;" command=eval line=1774
time="2024-05-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=1775
time="2024-05-06T10:30:41+08:00" level=warning msg="mariadb_cte_recursive:1814 query failed with non expected error(s)! (ErrCTERecursiveForbidsAggregation != 3577) (err: Error 3575 (HY000): Recursive Common Table Expression 'cte' can contain neither aggregation nor window functions in recursive query block) (query: WITH RECURSIVE cte(f) AS (\nSELECT i FROM t\nUNION\nSELECT i FROM t\nWHERE i NOT IN ( SELECT * FROM t\nWHERE i IN ( SELECT * FROM cte ) GROUP BY i )\n) SELECT * FROM cte;)"
time="2024-05-06T10:30:41+08:00" level=warning msg="mariadb_cte_recursive:1887 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-06T10:30:41+08:00" level=warning msg="mariadb_cte_recursive:1887 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.cte_2' doesn't exist) (query: set @var=\n(\nwith recursive\ncte_1 as (\nselect 1\nunion\nselect * from cte_2),\ncte_2 as (\nselect * from cte_1\nunion\nselect a from t1, cte_2\nwhere t1.a=cte_2.a)\nselect * from cte_2\nlimit 1\n);)"
time="2024-05-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=1955
time="2024-05-06T10:30:41+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=1956
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2032
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $q;" command=eval line=2033
time="2024-05-06T10:30:42+08:00" level=warning msg="mariadb_cte_recursive:2118 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: WITH RECURSIVE qn AS\n(\nselect 1,0 as col from t1\nunion distinct\nselect 1,0 from t1\nunion all\nselect 3, 0*(@c:=@c+1) from qn where @c<1\nunion all\nselect 3, 0*(@d:=@d+1) from qn where @d<1\n)\nselect * from qn;)"
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2168
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2183
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=2195
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=2207
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=2219
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=brief $query;" command=eval line=946
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from cte as t;" command=eval line=2342
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from cte as t;" command=eval line=2347
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from t1 as t;" command=eval line=2351
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from t1 as t;" command=eval line=2356
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2410
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2435
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2436
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" explain $q1;" command=eval line=2448
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2449
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2464
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2475
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2476
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2535
time="2024-05-06T10:30:42+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2564
time="2024-05-06T10:30:42+08:00" level=warning msg="mariadb_cte_recursive:2566 query succeeded, but expected error(s)! (expected errors: 1146) (query: drop table folks;)"
time="2024-05-06T10:30:42+08:00" level=warning msg="mariadb_cte_recursive:2751 query failed with non expected error(s)! (ErrNotSupportedYet != 1064) (err: Error 1235 (42000): This version of TiDB doesn't yet support 'INTERSECT between recursive part's selects, hint: The operator between recursive part's selects must bu UNION[DISTINCT] or UNION ALL') (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a, distances d\nwhere a.departure = 'Seattle' and\na.departure = d.city1 and a.arrival = d.city2 and\nd.dist < 4000\nunion\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nintersect\nselect city2 from destinations s, distances d\nwhere s.city = d.city1 and d.dist < 4000\n)\nselect * from destinations;)"
time="2024-05-06T10:30:42+08:00" level=warning msg="mariadb_cte_recursive:2767 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != 1064) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'destinations', the recursive table must be referenced only once, and not in any subquery) (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a where a.departure = 'Seattle'\nunion\nselect * from\n(\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nexcept\nselect arrival from flights\nwhere arrival in\n('New York', 'London', 'Moscow', 'Dubai', 'Cairo', 'Tokyo')\n) t\n)\nselect * from destinations;)"
./t/mariadb_cte_recursive.test: ok! 313 test cases passed, take time 2.242707936 s
./t/math.test: ok! 6 test cases passed, take time 0.009896782 s
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=6
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=8
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=51
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments=" //\ncreate table t1 (i int)//\ninsert into t1 values (1),(2),(3)//\nselect * from t1 where i = 2//\ndrop table t1//\ndelimiter ;" command=delimiter line=57
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2024-05-06T10:30:43+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.553675302 s
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2024-05-06T10:30:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
time="2024-05-06T10:30:43+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.097958533 s
time="2024-05-06T10:30:43+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-06T10:30:43+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;)"
./t/subquery_bugs.test: ok! 287 test cases passed, take time 3.125676309 s
time="2024-05-06T10:30:44+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-06T10:30:44+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-06T10:30:45+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-06T10:30:45+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-06T10:30:45+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);)"
time="2024-05-06T10:30:46+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-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=561
time="2024-05-06T10:30:46+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-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=572
time="2024-05-06T10:30:44+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.33881771 s
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=576
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=579
time="2024-05-06T10:30:46+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-06T10:30:46+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-06T10:30:46+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-06T10:30:46+08:00" level=warning msg="multi_update:768 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 LIMIT 3;)"
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=835
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=839
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=840
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=843
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=848
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=849
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=850
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=859
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=860
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=866
time="2024-05-06T10:30:46+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.792538601 s
time="2024-05-06T10:30:46+08:00" level=warning msg="multi_update_innodb:24 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, t1 AS B SET A.pk = 1, B.a = 2;)"
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 6.230408027 s
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2024-05-06T10:30:46+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.340588714 s
./t/index_merge2.test: ok! 328 test cases passed, take time 1.729439929 s
time="2024-05-06T10:30:46+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=841
time="2024-05-06T10:30:46+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
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.118986166 s
time="2024-05-06T10:30:47+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-06T10:30:47+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.027958822 s
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.066130539 s
time="2024-05-06T10:30:47+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1171
time="2024-05-06T10:30:47+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1308
time="2024-05-06T10:30:47+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-06T10:30:47+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-06T10:30:47+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-06T10:30:48+08:00" level=warning msg="foreign_key_cascade_mysql:317 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (a) on delete cascade on update restrict;)"
time="2024-05-06T10:30:48+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-06T10:30:48+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-06T10:30:48+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-06T10:30:48+08:00" level=warning msg="foreign_key_cascade_mysql:432 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (b) on delete cascade on update restrict;)"
time="2024-05-06T10:30:48+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=1680
time="2024-05-06T10:30:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1681
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 2.170893685 s
./t/subquery_mat.test: ok! 502 test cases passed, take time 4.785475858 s
time="2024-05-06T10:30:49+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ER_DUP_ENTRY != 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/subquery_sj_innodb_all.test: ok! 68 test cases passed, take time 0.540382393 s
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 0.788664181 s

time="2024-05-06T10:30:49+08:00" level=error msg="1 tests failed\n"
time="2024-05-06T10:30:49+08:00" level=error msg="run test [alter_table1] err: sql:SELECT * FROM ti3;: failed to run query \n\"SELECT * FROM ti3;\" \n around line 784, \nwe need(43):\nSELECT * FROM ti3;\na\tb\n1\t1\n101\t7\n2\t2\n3\t5\nDR\nbut got(43):\nSELECT * FROM ti3;\na\tb\n1\t1\n101\t5\n2\t2\n201\t7\n\n"
tidb-server(PID: 2211) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-06T10:30:49+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-06T10:30:49+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-06T10:30:49+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
[Checks API] No suitable checks publisher found.
[Pipeline] archiveArtifacts
Archiving artifacts
./t/multi_valued_index.test: ok! 659 test cases passed, take time 3.5776652799999997 s
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 0.561971461 s
time="2024-05-06T10:30:51+08:00" level=warning msg="mysql_replace:20 query succeeded, but expected error(s)! (expected errors: ErrUnsupportedDDLOperation) (query: alter table t1 engine=heap;)"
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
./t/mysql_replace.test: ok! 19 test cases passed, take time 0.137051408 s
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.092263877 s
[Pipeline] // withEnv
[Pipeline] }
./t/subselect_innodb.test: ok! 175 test cases passed, take time 2.041654198 s
time="2024-05-06T10:30:51+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=6
time="2024-05-06T10:30:51+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=7
time="2024-05-06T10:30:51+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.243514435 s
[Pipeline] // stage
time="2024-05-06T10:30:51+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.095084919 s
[Pipeline] }
Failed in branch Matrix - PART = '1'
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
tidb-server(PID: 2333) stopped
script returned exit code 143
./t/sum_distinct.test: ok! 32 test cases passed, take time 0.524284581 s
time="2024-05-06T10:30:52+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);)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
[Pipeline] }
tidb-server(PID: 2284) stopped
script returned exit code 143
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] }
[Pipeline] // cache
[Pipeline] // dir
[Pipeline] }
[Pipeline] }
Cache not saved (inner-step execution failed)
tidb-server(PID: 2327) stopped
script returned exit code 143
[Pipeline] // dir
[Pipeline] // cache
Post stage
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
Post stage
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] junit
Recording test results
[Pipeline] // cache
[Pipeline] }
[Pipeline] junit
Recording test results
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // stage
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '3'
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh FAILURE result.json
http://fileserver.pingcap.net
--2024-05-06 02:30:57--  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%  636M=0s

2024-05-06 02:30:57 (636 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE