Skipping 920 KB.. Full Log

[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
time="2024-05-07T07:34:02+08:00" level=warning msg="select_all:2954 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select * from t1 where f2 >= '0000-00-00' order by f2;)"
[Pipeline] }
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1486 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 0x616263FF);)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1488 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 X'616263FF');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1490 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 B'001111111111');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1492 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select (_utf8mb4 X'616263FF');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1497 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 0x616263FF);)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1499 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 X'616263FF');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1501 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select hex(_utf8mb4 B'001111111111');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1503 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: select (_utf8mb4 X'616263FF');)"
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=1512
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=1517
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=1524
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=1530
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=1788
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1792 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT CONCAT(utf8mb4, _utf8 '�') FROM t1;)"
time="2024-05-07T07:34:05+08:00" level=warning msg="ctype_utf8mb4:1794 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT CONCAT('a', _utf8 '�') FROM t1;)"
time="2024-05-07T07:34:05+08:00" level=warning msg="command not implemented" arguments=" utf8mb4" command=character_set line=1796
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1859
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1866
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments="  # See bug #27245598." command=disable_ps_protocol line=1877
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=1881
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_common.inc" command=source line=1931
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_filesort.inc" command=source line=1934
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_innodb_like.inc" command=source line=1935
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_like_escape.inc" command=source line=1936
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_ascii_order.inc" command=source line=1937
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/weight_string.inc" command=source line=1938
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/weight_string_euro.inc" command=source line=1939
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" include/ctype_unicode800.inc" command=source line=1940
./t/ctype_utf8mb4.test: ok! 776 test cases passed, take time 4.825168727 s
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query1;" command=eval line=316
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query2;" command=eval line=317
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" $query1;" command=eval line=318
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments=" $query2;" command=eval line=319
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=3737
time="2024-05-07T07:34:06+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=3741
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3776 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-10-09','%Y-%m-%d') <= '2007/10/2000:00:00 GMT-6';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3802 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-02-30 12:34','%Y-%m-%d %H:%i') = '2007-02-30 12:34:00';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3805 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3812 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3814 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-10-01 12:34','%Y-%m-%d %H:%i') = '2007-10-00 12:34';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3825 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('2007-10-00 12:34','%Y-%m-%d %H:%i') = '';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3828 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('1','%Y-%m-%d') = '1';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3830 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('1','%Y-%m-%d') = '1';)"
time="2024-05-07T07:34:06+08:00" level=warning msg="select_all:3832 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: select str_to_date('','%Y-%m-%d') = '';)"
./t/date_formats.test: ok! 105 test cases passed, take time 1.335018524 s
./t/date_time_ddl.test: ok! 76 test cases passed, take time 1.029741977 s
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:49 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:49 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 datetime default '12345678');)"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:71 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:71 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 datetime default -1);)"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:77 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:77 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 datetime default 99999999999999);)"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:91 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:08+08:00" level=warning msg="datetime_insert:91 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 datetime default 100000000000000);)"
time="2024-05-07T07:34:09+08:00" level=warning msg="datetime_insert:113 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:09+08:00" level=warning msg="datetime_insert:113 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 datetime not null default null);)"
time="2024-05-07T07:34:09+08:00" level=warning msg="datetime_insert:131 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:34:09+08:00" level=warning msg="datetime_insert:131 query failed with non expected error(s)! (ER_NO_DEFAULT_FOR_FIELD != ER_DEFAULT_VALUE) (err: Error 1364 (HY000): Field 'c1' doesn't have a default value) (query: insert t (id) values (1);)"
./t/datetime_insert.test: ok! 206 test cases passed, take time 0.862064968 s
./t/datetime_update.test: ok! 75 test cases passed, take time 0.28107457 s
time="2024-05-07T07:34:09+08:00" level=warning msg="daylight_saving_time:14 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_NON_UNIQ_ERROR) (err: Error 1292 (22007): Incorrect timestamp value: '2011-03-13 02:00:00' for column 'a' at row 1) (query: insert into t value('2011-03-13 02:00:00');)"
./t/daylight_saving_time.test: ok! 28 test cases passed, take time 0.11112335 s
time="2024-05-07T07:34:10+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=5
time="2024-05-07T07:34:09+08:00" level=warning msg="select_all:4212 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: SELECT date_nokey FROM C\nWHERE int_key IN (SELECT 1 FROM A)\nHAVING date_nokey = '10:41:7'\nORDER BY date_key;)"
time="2024-05-07T07:34:10+08:00" level=warning msg="command not implemented" arguments=" ;;" command=delimiter line=217
time="2024-05-07T07:34:10+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=223
time="2024-05-07T07:34:10+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=226
./t/ddl_i18n_utf8.test: ok! 56 test cases passed, take time 0.546781015 s
./t/decimal.test: ok! 14 test cases passed, take time 0.050703234 s
time="2024-05-07T07:34:10+08:00" level=warning msg="select_all:4561 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION select_all.st_geomfromtext does not exist) (query: SELECT coalesce((avg(distinct (ST_geomfromtext(\"point(25379 -22010)\")))))\nUNION ALL\nSELECT coalesce((avg(distinct (ST_geomfromtext(\"point(25379 -22010)\")))))\nAS foo\n;)"
./t/default.test: ok! 47 test cases passed, take time 0.249776629 s
time="2024-05-07T07:34:11+08:00" level=warning msg="delete:167 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: DELETE t2 FROM t1 JOIN t2 WHERE t1.a = 10;)"
./t/select_all.test: ok! 2430 test cases passed, take time 22.191548262 s
./t/select_qualified.test: ok! 19 test cases passed, take time 0.190091964 s
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=36
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=45
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=54
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=56
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=76
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=80
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=84
time="2024-05-07T07:34:11+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=86
time="2024-05-07T07:34:12+08:00" level=warning msg="delete:613 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v2 is not supported now) (query: DELETE FROM v2;)"
time="2024-05-07T07:34:12+08:00" level=warning msg="delete:617 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v2 is not supported now) (query: DELETE v2 FROM v2;)"
time="2024-05-07T07:34:12+08:00" level=warning msg="delete:662 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_NON_UPDATABLE_TABLE) (err: Error 1105 (HY000): delete view z is not supported now) (query: DELETE z FROM (SELECT 1) AS x, z;)"
./t/delete.test: ok! 205 test cases passed, take time 1.7227489839999999 s
time="2024-05-07T07:34:12+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-07T07:34:12+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/delete_myisam.test: ok! 15 test cases passed, take time 0.136275963 s
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" P2 p2" command=replace_result line=190
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=301
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=314
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=324
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=339
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=340
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=342
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=383
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=411
time="2024-05-07T07:34:13+08:00" level=warning msg="command not implemented" arguments=" include/no_running_event_scheduler.inc" command=source line=442
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" include/running_event_scheduler.inc" command=source line=514
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=558
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=574
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=583
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20609 # 20485 # 20481 #" command=replace_result line=588
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20609 # 20485 # 20481 #" command=replace_result line=605
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=627
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20485 # 20609 # 20481 #" command=replace_result line=668
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=732
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=817
time="2024-05-07T07:34:14+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1055
./t/index_merge_intersection_partition_tbl_simple.test: ok! 5865 test cases passed, take time 22.961748988 s
time="2024-05-07T07:34:16+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1110
time="2024-05-07T07:34:17+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1192
./t/show_check_cs.test: ok! 289 test cases passed, take time 6.569059038 s
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=15
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=17
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=24
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=27
time="2024-05-07T07:34:17+08:00" level=warning msg="derived:2818 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: UPDATE users\nSET position = (SELECT COUNT(t2.position) + 1\nFROM users AS t2\nWHERE t2.position < users.position)\nWHERE id = 3;)"
time="2024-05-07T07:34:17+08:00" level=warning msg="derived:2825 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: UPDATE users, (SELECT 1) AS dummy\nSET position = (SELECT COUNT(t2.position) + 1\nFROM users AS t2\nWHERE t2.position < users.position)\nWHERE id = 3;)"
./t/index_merge_intersection_single_tbl.test: ok! 3701 test cases passed, take time 5.406582493 s
./t/derived.test: ok! 688 test cases passed, take time 6.028991009 s
./t/derived_ci.test: ok! 11 test cases passed, take time 0.002220461 s
time="2024-05-07T07:34:19+08:00" level=warning msg="derived_cs:14 query succeeded, but expected error(s)! (expected errors: 1054) (query: select QN.a from (select 1 as a) as qn;)"
time="2024-05-07T07:34:19+08:00" level=warning msg="derived_cs:17 query succeeded, but expected error(s)! (expected errors: 1054) (query: select qn.a from (select 1 as a) as QN;)"
time="2024-05-07T07:34:19+08:00" level=warning msg="derived_cs:22 query succeeded, but expected error(s)! (expected errors: 1146) (query: with qn as (select 1) select * from QN;)"
time="2024-05-07T07:34:19+08:00" level=warning msg="derived_cs:25 query succeeded, but expected error(s)! (expected errors: 1146) (query: with QN as (select 1) select * from qn;)"
time="2024-05-07T07:34:19+08:00" level=warning msg="derived_cs:27 query succeeded, but expected error(s)! (expected errors: 1054) (query: with qn as (select 1 as a) select QN.a from qn;)"
./t/derived_cs.test: ok! 11 test cases passed, take time 0.002197043 s
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=160
time="2024-05-07T07:34:18+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=162
./t/show_check_cs_myisam.test: ok! 63 test cases passed, take time 0.803906931 s
./t/show_profile.test: ok! 7 test cases passed, take time 0.001921378 s
./t/show_variables.test: ok! 23 test cases passed, take time 0.057507894 s
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=87
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:105 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_IN_ORDER_NOT_SELECT) (query: select distinct min(b) from t1 group by a order by -min(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:164 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from t1 as S2 order by\nfloor(10*10) IN (select floor(10*S2.b) from t1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:167 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from t1 as S2 order by\nfloor(10*10) > ALL(select floor(10*S2.b) from t1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:174 query failed with non expected error(s)! (ErrFieldInOrderNotSelect != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(*);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:182 query failed with non expected error(s)! (ErrFieldInOrderNotSelect != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=216
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=248
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:266 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_IN_ORDER_NOT_SELECT) (query: select distinct min(b) from v1 group by a order by -min(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:327 query failed with non expected error(s)! (ErrBadField != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from v1 as S2 order by\nfloor(10*10) IN (select floor(10*S2.b) from v1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:330 query failed with non expected error(s)! (ErrBadField != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from v1 as S2 order by\nfloor(10*10) > ALL(select floor(10*S2.b) from v1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:337 query failed with non expected error(s)! (ErrFieldInOrderNotSelect != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(*);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:345 query failed with non expected error(s)! (ER_FIELD_IN_ORDER_NOT_SELECT != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=415
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:433 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_IN_ORDER_NOT_SELECT) (query: select distinct min(b) from v1 group by a order by -min(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:493 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from v1 as S2 order by\nfloor(10*10) IN (select floor(10*S2.b) from v1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:496 query failed with non expected error(s)! (ErrBadField != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from v1 as S2 order by\nfloor(10*10) > ALL(select floor(10*S2.b) from v1 as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:503 query failed with non expected error(s)! (ER_FIELD_IN_ORDER_NOT_SELECT != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(*);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:511 query failed with non expected error(s)! (ErrFieldInOrderNotSelect != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=547
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=578
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:595 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_IN_ORDER_NOT_SELECT) (query: select distinct min(b) from (SELECT t1.* FROM t1 left join t2 on 1) AS derived group by a order by -min(b);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:654 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from (SELECT t1.* FROM t1 left join t2 on 1) as S2 order by\nfloor(10*10) IN (select floor(10*S2.b) from (SELECT t1.* FROM t1 left join t2 on 1) as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:657 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_FIELD_IN_ORDER_NOT_SELECT) (err: Error 1054 (42S22): Unknown column 's2.b' in 'field list') (query: select distinct abs(b) from (SELECT t1.* FROM t1 left join t2 on 1) as S2 order by\nfloor(10*10) > ALL(select floor(10*S2.b) from (SELECT t1.* FROM t1 left join t2 on 1) as S3);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:664 query failed with non expected error(s)! (ErrFieldInOrderNotSelect != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(*);)"
time="2024-05-07T07:34:19+08:00" level=warning msg="distinct_innodb:672 query failed with non expected error(s)! (ER_FIELD_IN_ORDER_NOT_SELECT != ER_AGGREGATE_IN_ORDER_NOT_SELECT) (err: Error 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column '' which is not in SELECT list; this is incompatible with DISTINCT) (query: SELECT distinct 1 FROM t1 group by a order by count(*)-count(b);)"
./t/distinct_innodb.test: ok! 214 test cases passed, take time 0.509865949 s
./t/do.test: ok! 3 test cases passed, take time 0.000442719 s
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" drop table t1" command=send line=108
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" drop database mysqltest" command=send line=114
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments= command=reap line=119
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments= command=reap line=121
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=123
time="2024-05-07T07:34:19+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=126
time="2024-05-07T07:34:20+08:00" level=warning msg="command not implemented" arguments= command=disable_connect_log line=306
./t/drop.test: ok! 51 test cases passed, take time 0.321128299 s
./t/ds_mrr-big.test: ok! 19 test cases passed, take time 0.277540487 s
./t/echo.test: ok! 3 test cases passed, take time 0.000497436 s
./t/empty_table.test: ok! 7 test cases passed, take time 0.029126376 s
./t/endspace.test: ok! 64 test cases passed, take time 0.343410679 s
time="2024-05-07T07:34:20+08:00" level=warning msg="command not implemented" arguments=" include/have_debug.inc" command=source line=2
time="2024-05-07T07:34:21+08:00" level=warning msg="error_simulation:126 query succeeded, but expected error(s)! (expected errors: ER_LOCK_DEADLOCK) (query: select * from t1 order by a;)"
./t/error_simulation.test: ok! 19 test cases passed, take time 0.243175353 s
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:23 query failed with non expected error(s)! (ErrNoSuchTable not in 1044,1049) (err: Error 1146 (42S02): Table 'not_existing_database.t1' doesn't exist) (query: select count(not_existing_database.t1.a) from not_existing_database.t1;)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:27 query failed with non expected error(s)! (ErrUnknown != 1054) (err: Error 1105 (HY000): Unknown column '2' in 'group statement') (query: select 1 from t1 group by 2;)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:31 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != 1054) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'b'; this is incompatible with sql_mode=only_full_group_by) (query: select count(*),b from t1;)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:66 query failed with non expected error(s)! (ErrUnknown != ER_BAD_FIELD_ERROR) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t2 SELECT b FROM t1;)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:167 query failed with non expected error(s)! (ER_CANT_AGGREGATE_3COLLATIONS != ER_DATA_OUT_OF_RANGE) (err: Error 1270 (HY000): Illegal mix of collations (latin1_bin,IMPLICIT), (utf8_bin,COERCIBLE), (binary,COERCIBLE) for operation 'in') (query: SELECT (CONVERT('0' USING latin1) IN (CHAR(COT('v') USING utf8),''));)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:171 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION errors.updatexml does not exist) (query: SELECT UPDATEXML(-73 * -2465717823867977728,@@global.auto_increment_increment,null);)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:264 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION errors.point does not exist) (query: do count(rand(st_latfromgeohash(st_geohash(point(5920138304254667057,24370),41))));)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:268 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_GIS_INVALID_DATA) (err: Error 1305 (42000): FUNCTION errors.st_isvalid does not exist) (query: do ((st_isvalid(1))=(std(format(-29867 ,54,'es_DO')) over()));)"
time="2024-05-07T07:34:21+08:00" level=warning msg="errors:284 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE insert_select AS\nSELECT t2.c AS field3\nFROM t1, t2\nWHERE t1.b = t2.b AND t1.a <> t2.pk;)"
./t/errors.test: ok! 78 test cases passed, take time 0.351352015 s
./t/exec_selection.test: ok! 14 test cases passed, take time 0.041845231 s
time="2024-05-07T07:34:21+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=5
time="2024-05-07T07:34:21+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2024-05-07T07:34:21+08:00" level=warning msg="explain:27 query succeeded, but expected error(s)! (expected errors: 1176) (query: explain format=\"brief\" select * from t1 use key (str,str,foo) where str=\"foo\";)"
time="2024-05-07T07:34:21+08:00" level=warning msg="command not implemented" arguments=" (`select locate('semijoin', @@optimizer_switch) > 0`)\n{\nset optimizer_switch='semijoin=off';" command=if line=198
time="2024-05-07T07:34:22+08:00" level=warning msg="explain:426 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: PREPARE s FROM \"EXPLAIN format='brief' DELETE FROM t1 WHERE a || 'a' LIMIT 1\";)"
./t/explain.test: ok! 188 test cases passed, take time 0.912546435 s
./t/single_delete_update.test: ok! 131 test cases passed, take time 2.815127731 s
time="2024-05-07T07:34:22+08:00" level=warning msg="expression_index:78 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_WARN_DATA_TRUNCATED_FUNCTIONAL_INDEX) (err: Error 1406 (22001): Data Too Long, field len 1, data len 11) (query: INSERT INTO t1 (f2) VALUES (\"lorem ipsum\");)"
./t/index_merge_intersection_trs.test: ok! 4356 test cases passed, take time 4.200029367 s
./t/index_merge_mvindex_multiple_table.test: ok! 324 test cases passed, take time 0.371082969 s
time="2024-05-07T07:34:23+08:00" level=warning msg="expression_index:105 query failed with non expected error(s)! (ER_DUP_FIELDNAME != ER_INTERNAL_ERROR) (err: Error 1060 (42S21): Duplicate column name '_V$_idx1_1') (query: ALTER TABLE t1 ADD COLUMN `_V$_idx1_1` INT NOT NULL;)"
./t/sqllogic.test: ok! 40 test cases passed, take time 0.881008236 s
./t/str_quoted.test: ok! 9 test cases passed, take time 0.018702625 s
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:276 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col1) VALUES(CAST('2004-10-0' AS DATE));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:278 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col1) VALUES(CAST('2004-0-10' AS DATE));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:303 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col2) VALUES(CAST('2004-10-0 15:30' AS DATETIME));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:305 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col2) VALUES(CAST('2004-0-10 15:30' AS DATETIME));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:370 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col1) VALUES(CONVERT('2004-10-0' , DATE));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:372 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col1) VALUES(CONVERT('2004-0-10' , DATE));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:396 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col2) VALUES(CONVERT('2004-10-0 15:30',DATETIME));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:398 query succeeded, but expected error(s)! (expected errors: 1292) (query: INSERT INTO t1 (col2) VALUES(CONVERT('2004-0-10 15:30',DATETIME));)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:480 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1=col1 / 0 WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:562 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-8388609);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:564 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(8388608);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:566 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:568 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(16777216);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:570 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('-8388609');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:572 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('8388608');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:574 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('-1');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:576 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('16777216');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:578 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-8388609.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:580 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(8388608.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:582 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:584 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(16777216.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:587 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:589 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col2 = col2 + 50 WHERE col2 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:591 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:593 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:595 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:597 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:599 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:615 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-2147483649);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:617 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(2147643648);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:619 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:621 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(4294967296);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:623 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('-2147483649');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:625 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('2147643648');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:627 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('-1');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:629 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('4294967296');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:631 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-2147483649.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:633 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(2147643648.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:635 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:637 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(4294967296.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:640 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:642 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col2 =col2 + 50 WHERE col2 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:644 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:646 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:648 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:650 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:652 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:672 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-9223372036854775809);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:674 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(9223372036854775808);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:676 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:679 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(18446744073709551616);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:681 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('-9223372036854775809');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:683 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('9223372036854775808');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:685 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('-1');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:687 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('18446744073709551616');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:692 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-9223372036854785809.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:694 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(9223372036854785808.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:696 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:698 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(18446744073709551616.0);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:705 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:707 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:709 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:711 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:713 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:733 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (101.55);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:735 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (101);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:737 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (-101.55);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:739 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (1010.55);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:741 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (1010);)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:745 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('101.55');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:747 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('101');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:749 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-101.55');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="strict:751 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-1010.55');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:753 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-100E+1');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:755 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 VALUES ('-100E');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:757 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 =col1 * 50000 WHERE col1 =11;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:759 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:761 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:764 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:767 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:769 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:787 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES (+3.4E+39);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:789 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES (-1.1E-3);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:791 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES ('+3.4E+39');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:793 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES ('-1.1E-3');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:795 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 =col1 * 5000 WHERE col1 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:797 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2 =col2 / 0 WHERE col2 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:799 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:801 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:803 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:805 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:823 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES (-1.1E-3);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:825 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES ('+1.8E+309');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:827 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES ('-1.2E-3');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:833 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:835 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:837 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:839 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-07T07:34:23+08:00" level=warning msg="expression_index:259 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_SPATIAL_FUNCTIONAL_INDEX) (err: Error 3758 (HY000): Expression of expression index 'expression_index' contains a disallowed function) (query: CREATE TABLE t1(x VARCHAR(100), KEY ((ST_GeomFromText(x))));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="expression_index:307 query failed with non expected error(s)! (ER_BLOB_KEY_WITHOUT_LENGTH != ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED) (err: Error 1170 (42000): BLOB/TEXT column 'a1' used in key specification without a key length) (query: CREATE TABLE  table44 ( pk INTEGER AUTO_INCREMENT, a1 TEXT NOT NULL, b1\nDATETIME NOT NULL, c1 TIME NOT NULL, d1 BLOB NOT NULL, PRIMARY KEY (a1), KEY\n((VALUES(d1))));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="expression_index:337 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_FUNCTIONAL_INDEX_REF_AUTO_INCREMENT) (err: Error 3758 (HY000): Expression of expression index 'ind320' contains a disallowed function) (query: CREATE INDEX ind320 ON t1 ((pk >= col_time_nokey LIKE\nST_GeomFromGeoJSON(col_varchar_key) ));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="expression_index:377 query succeeded, but expected error(s)! (expected errors: ER_WRONG_NAME_FOR_INDEX) (query: CREATE TABLE t1 (\ncol1 FLOAT\n, col2 TIMESTAMP\n, col3 YEAR\n, INDEX ((ABS(col1)))\n, INDEX ((ADDDATE(col2, INTERVAL 2 DAY)))\n, INDEX ((ABS(col3)))\n);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="expression_index:389 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_FUNCTIONAL_INDEX_ON_LOB) (err: Error 3758 (HY000): Expression of expression index 'expression_index' contains a disallowed function) (query: CREATE TABLE t1 (\ncol4 TEXT NOT NULL\n, INDEX ((ST_AsBinary(col4)))\n);)"
./t/index_merge_mvindex_single_table.test: ok! 1005 test cases passed, take time 0.930298961 s
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:855 query succeeded, but expected error(s)! (expected errors: 1406) (query: INSERT INTO t1 (col1) VALUES ('hellobob');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:857 query succeeded, but expected error(s)! (expected errors: 1406) (query: INSERT INTO t1 (col2) VALUES ('hellobob');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:860 query succeeded, but expected error(s)! (expected errors: 1406) (query: UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he';)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:862 query succeeded, but expected error(s)! (expected errors: 1406) (query: UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he';)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:873 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('yellow');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:875 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('redd');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:877 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 VALUES ('');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:879 query succeeded, but expected error(s)! (expected errors: 1265) (query: UPDATE t1 SET col1 ='yellow' WHERE col1 ='green';)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:897 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col1=NULL WHERE col1 =100;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:899 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col2 =NULL WHERE col2 ='hello';)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:901 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col2 =NULL where col3 IS NOT NULL;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:915 query succeeded, but expected error(s)! (expected errors: 1364) (query: INSERT INTO t1 (col1) VALUES (2);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:917 query succeeded, but expected error(s)! (expected errors: 1364) (query: INSERT INTO t1 VALUES(default(col1),default(col2));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:921 query succeeded, but expected error(s)! (expected errors: 1048) (query: INSERT INTO t1 SELECT 1,NULL;)"
time="2024-05-07T07:34:24+08:00" level=warning msg="expression_index:437 query succeeded, but expected error(s)! (expected errors: ER_FUNCTIONAL_INDEX_ROW_VALUE_IS_NOT_ALLOWED) (query: CREATE TABLE t1 (\nj1 JSON,\nj3 JSON,\nKEY my_idx ((CAST(j1->'$[0]' as SIGNED))),\nKEY my_idx_char ((CAST(j3->'$[0]' as CHAR(10))))\n);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:991 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000 as char(3)));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:993 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000E+0 as char(3)));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:995 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000.0 as char(3)));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:997 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (cast('abc' as signed integer));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:999 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (10E+0 + 'a');)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:1001 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (cast('10a' as unsigned integer));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:1014 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 values (0,0,0);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:1016 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 values (0.0,0.0,0.0);)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:1018 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (convert('0000-00-00',date));)"
time="2024-05-07T07:34:24+08:00" level=warning msg="strict:1020 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast('0000-00-00' as date));)"
./t/index_merge_sqlgen_exprs.test: ok! 456 test cases passed, take time 0.776396592 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2362) stopped
[Pipeline] }
[Pipeline] // dir
./t/expression_index.test: ok! 166 test cases passed, take time 2.2624413580000002 s
./t/field_length.test: ok! 10 test cases passed, take time 0.041812682 s
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-8666/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-07T07:34:25+08:00" level=warning msg="strict:1424 query failed with non expected error(s)! (ErrUnknown != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t2(b DATE) SELECT a FROM t1;)"
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1563
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" SELECT $fields INTO OUTFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' FROM t1" command=eval line=1564
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1565
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" SELECT LOAD_FILE('$MYSQLTEST_VARDIR/tmp/wl6614.txt')" command=eval line=1566
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1567
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' INTO TABLE t2" command=eval line=1569
time="2024-05-07T07:34:25+08:00" level=warning msg="strict:1570 query succeeded, but expected error(s)! (expected errors: ER_WARN_TOO_FEW_RECORDS) (query: SELECT * FROM t2;)"
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1571
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' IGNORE INTO TABLE t2" command=eval line=1572
time="2024-05-07T07:34:25+08:00" level=warning msg="command not implemented" arguments=" SELECT $fields FROM t2" command=eval line=1573
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
./t/strict.test: ok! 483 test cases passed, take time 3.01444828 s
time="2024-05-07T07:34:26+08:00" level=warning msg="strict_autoinc_2innodb:33 query failed with non expected error(s)! (ErrDataOutOfRange != ER_WARN_DATA_OUT_OF_RANGE) (err: Error 1690 (22003): constant 700 overflows tinyint) (query: insert into t1 values(null);)"
./t/strict_autoinc_2innodb.test: ok! 14 test cases passed, take time 0.044511587 s
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/sub_query.test: ok! 74 test cases passed, take time 0.329433632 s
time="2024-05-07T07:34:26+08:00" level=warning msg="subquery_all:39 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: SELECT (SELECT 1 FROM (SELECT 1) as b HAVING a=1) as a;)"
time="2024-05-07T07:34:26+08:00" level=warning msg="subquery_all:41 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'b' in 'having clause') (query: SELECT (SELECT 1 FROM (SELECT 1) as b HAVING b=1) as a,(SELECT 1 FROM (SELECT 1) as c HAVING a=1) as b;)"
time="2024-05-07T07:34:26+08:00" level=warning msg="subquery_all:44 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'field list') (query: SELECT (SELECT a) as a;)"
time="2024-05-07T07:34:26+08:00" level=warning msg="subquery_all:93 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a1' in 'where clause') (query: select (select a from t1 where t1.a = a1) as a2, (select b from t2 where t2.b=a2) as a1;)"
time="2024-05-07T07:34:27+08:00" level=warning msg="subquery_all:310 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_SUBQUERY_NO_1_ROW) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: select numeropost as a FROM t1 ORDER BY (SELECT 1 FROM t1 HAVING a=1);)"
time="2024-05-07T07:34:28+08:00" level=warning msg="subquery_all:336 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: SELECT (SELECT numeropost FROM t1 HAVING numreponse=a),numreponse FROM (SELECT * FROM t1) as a;)"
time="2024-05-07T07:34:28+08:00" level=warning msg="subquery_all:449 query failed with non expected error(s)! (ErrBadTable != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: SELECT * FROM (SELECT 1) b WHERE 1 IN (SELECT *);)"
time="2024-05-07T07:34:35+08:00" level=warning msg="subquery_all:1644 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx ;)"
time="2024-05-07T07:34:35+08:00" level=warning msg="subquery_all:1646 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-07T07:34:35+08:00" level=warning msg="subquery_all:1649 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-07T07:34:35+08:00" level=warning msg="subquery_all:1651 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx from DUAL;)"
./t/filesort.test: ok! 54 test cases passed, take time 13.713536571 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.143303133 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.532716471 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.146561518 s
./t/foreign_key.test: ok! 158 test cases passed, take time 2.040431107 s
time="2024-05-07T07:34:42+08:00" level=warning msg="foreign_key1:161 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-07T07:34:42+08:00" level=warning msg="foreign_key1:164 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-07T07:34:42+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-07T07:34:42+08:00" level=warning msg="foreign_key1:176 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-07T07:34:43+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-07T07:34:43+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-07T07:34:44+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-07T07:34:44+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-07T07:34:44+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-07T07:34:44+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-07T07:34:44+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2024-05-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2024-05-07T07:34:46+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2024-05-07T07:34:46+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2024-05-07T07:34:46+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 4.470894895 s
time="2024-05-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="foreign_key_cascade_delete:63 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-07T07:34:46+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-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="foreign_key_cascade_delete:76 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-07T07:34:46+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-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="foreign_key_cascade_delete:94 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-07T07:34:46+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-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="foreign_key_cascade_delete:117 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+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-07T07:34:46+08:00" level=warning msg="foreign_key_cascade_delete:160 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t2 where id = 2;)"
time="2024-05-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+08:00" level=warning msg="foreign_key_cascade_delete:286 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+08:00" level=warning msg="foreign_key_cascade_delete:327 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+08:00" level=warning msg="foreign_key_cascade_delete:368 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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:47+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-07T07:34:50+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-07T07:34:51+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-07T07:34:52+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-07T07:34:52+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-07T07:34:52+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/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 7.236671276 s
time="2024-05-07T07:34:55+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-07T07:34:55+08:00" level=warning msg="foreign_key_cascade_mysql:317 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (a) on delete cascade on update restrict;)"
time="2024-05-07T07:34:55+08:00" level=warning msg="foreign_key_cascade_mysql:345 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(a) references parent (b) on delete cascade on update restrict;)"
time="2024-05-07T07:34:55+08:00" level=warning msg="foreign_key_cascade_mysql:373 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (b) on delete cascade on update restrict;)"
time="2024-05-07T07:34:55+08:00" level=warning msg="foreign_key_cascade_mysql:404 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (a) on delete cascade on update restrict;)"
time="2024-05-07T07:34:55+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;)"
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 2.448438845 s
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 1.096221342 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2309) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-8666/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2024-05-07T07:34:59+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6574
time="2024-05-07T07:34:59+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=6581
time="2024-05-07T07:34:59+08:00" level=warning msg="subquery_all:6766 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT 1 as col FROM t1 WHERE a IN (SELECT a FROM DUAL LIMIT 0);)"
./t/subquery_all.test: ok! 2358 test cases passed, take time 34.421930962 s
./t/subquery_antijoin.test: ok! 116 test cases passed, take time 1.577758684 s
time="2024-05-07T07:35:02+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-07T07:35:02+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-07T07:35:02+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-07T07:35:02+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-07T07:35:02+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-07T07:35:02+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=252
time="2024-05-07T07:35:04+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-07T07:35:06+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=brief $query;" command=eval line=946
./t/subquery_bugs.test: ok! 287 test cases passed, take time 6.369809478 s
time="2024-05-07T07:35:11+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-07T07:35:15+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=841
time="2024-05-07T07:35:15+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=848
time="2024-05-07T07:35:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1171
time="2024-05-07T07:35:16+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1308
time="2024-05-07T07:35:16+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-07T07:35:16+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-07T07:35:18+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=1680
time="2024-05-07T07:35:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1681
./t/subquery_mat.test: ok! 502 test cases passed, take time 9.323871398 s
./t/subquery_sj_innodb_all.test: ok! 68 test cases passed, take time 1.111790167 s
./t/subselect_innodb.test: ok! 175 test cases passed, take time 4.18744453 s
time="2024-05-07T07:35:24+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=6
time="2024-05-07T07:35:24+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=7
time="2024-05-07T07:35:24+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.453904377 s
Aborted by Jenkins Admin
Sending interrupt signal to process
Killing processes
./t/sum_distinct.test: ok! 32 test cases passed, take time 0.778460737 s
time="2024-05-07T07:35:25+08:00" level=warning msg="temp_table:82 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_DUP_ENTRY) (err: Error 8200 (HY000): TiDB doesn't support ALTER TABLE for local temporary table) (query: alter table t1 add primary key (a);)"
./t/temp_table.test: ok! 137 test cases passed, take time 1.347358106 s
./t/temptable_256_fields.test: ok! 5 test cases passed, take time 0.073185969 s
./t/temptable_disk.test: ok! 14 test cases passed, take time 0.266510731 s
time="2024-05-07T07:35:27+08:00" level=warning msg="time:61 Unknown named --error ER_BAD_FORMAT"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:61 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect date value: '-1' for column 'c1' at row 1) (query: INSERT INTO t (c1) values (-1);)"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:63 Unknown named --error ER_BAD_FORMAT"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:63 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect datetime value: '-1' for column 'c2' at row 1) (query: INSERT INTO t (c2) values (-1);)"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:65 Unknown named --error ER_BAD_FORMAT"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:65 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect timestamp value: '-1' for column 'c3' at row 1) (query: INSERT INTO t (c3) values (-1);)"
time="2024-05-07T07:35:27+08:00" level=warning msg="time:90 Unknown named --error "
time="2024-05-07T07:35:27+08:00" level=warning msg="time:90 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ) (err: Error 1292 (22007): Incorrect datetime value: '2004-04-31' for column 'col' at row 1) (query: insert into t values ('2004-04-31');)"
./t/time.test: ok! 71 test cases passed, take time 0.360026676 s
./t/time_zone_grant.test: ok! 58 test cases passed, take time 0.584773673 s
./t/time_zone_with_dst.test: ok! 28 test cases passed, take time 0.48986994 s
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:56 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:56 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default '12345678');)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:70 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:70 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011111);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:92 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:92 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:114 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:114 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:136 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:136 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010);)"
kill finished with exit code 0
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:150 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:150 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 20);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:156 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:156 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:170 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:170 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default -1);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:176 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:176 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 99999999999999);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:182 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:182 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 100000000000000);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:188 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:188 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 10000101000000);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:194 query succeeded, but expected error(s)! (expected errors: ER_DEFAULT_VALUE) (query: create table t (id int, c1 timestamp default null);)"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:200 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-07T07:35:29+08:00" level=warning msg="timestamp_insert:200 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp not null default null);)"
tidb-server(PID: 2242) stopped
script returned exit code 143
Killing processes
kill finished with exit code 1
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[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 ABORTED result.json
http://fileserver.pingcap.net
--2024-05-06 23:35:37--  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%  503M=0s

2024-05-06 23:35:37 (503 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

Click here to forcibly terminate running steps
No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
org.jenkinsci.plugins.workflow.actions.ErrorAction$ErrorId: 8ade5b63-af5d-47a5-a86c-bd6455e7c1a7
Finished: ABORTED