Skipping 829 KB.. Full Log

time="2024-05-06T10:35:07+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=24
time="2024-05-06T10:35:07+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=27
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=160
time="2024-05-06T10:35:08+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.391324153 s
./t/show_profile.test: ok! 7 test cases passed, take time 0.000836213 s
./t/show_variables.test: ok! 23 test cases passed, take time 0.037665668 s
./t/index_merge_sqlgen_exprs_orandor_1_no_out_trans.test: ok! 8644 test cases passed, take time 16.638665288 s
time="2024-05-06T10:35:08+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-06T10:35:08+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/having.test: ok! 273 test cases passed, take time 1.696395509 s
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/having_myisam.test: ok! 17 test cases passed, take time 0.136647888 s
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=53
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=55
time="2024-05-06T10:35:08+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=58
./t/index_merge_update.test: ok! 103 test cases passed, take time 2.809865523 s
./t/derived.test: ok! 688 test cases passed, take time 5.259141176 s
./t/derived_ci.test: ok! 11 test cases passed, take time 0.001995198 s
time="2024-05-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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.001971759 s
time="2024-05-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+08:00" level=warning msg="distinct_innodb:174 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-06T10:35:09+08:00" level=warning msg="distinct_innodb:182 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-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=216
./t/heap_btree.test: ok! 147 test cases passed, take time 0.823026274 s
./t/heap_btree_myisam.test: ok! 12 test cases passed, take time 0.113712047 s
time="2024-05-06T10:35:09+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-06T10:35:09+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-06T10:35:09+08:00" level=warning msg="distinct_innodb:327 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-06T10:35:09+08:00" level=warning msg="distinct_innodb:330 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) > ALL(select floor(10*S2.b) from v1 as S3);)"
time="2024-05-06T10:35:09+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-06T10:35:09+08:00" level=warning msg="distinct_innodb:345 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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+08:00" level=warning msg="distinct_innodb:496 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) > ALL(select floor(10*S2.b) from v1 as S3);)"
time="2024-05-06T10:35:09+08:00" level=warning msg="distinct_innodb:503 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-06T10:35:09+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-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=547
time="2024-05-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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-06T10:35:09+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/inlj_inner_multi_pattern.test: ok! 229 test cases passed, take time 0.273685215 s
./t/innodb_log_file_size_functionality.test: ok! 11 test cases passed, take time 0.002230423 s
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=4
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=6
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/not_ubsan.inc" command=source line=8
./t/distinct_innodb.test: ok! 214 test cases passed, take time 0.451204064 s
./t/do.test: ok! 3 test cases passed, take time 0.000450246 s
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" drop table t1" command=send line=108
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" drop database mysqltest" command=send line=114
./t/histogram_singleton.test: ok! 266 test cases passed, take time 0.521483889 s
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments= command=reap line=119
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments= command=reap line=121
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=123
time="2024-05-06T10:35:09+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=126
time="2024-05-06T10:35:10+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.301233798 s
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:103 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
./t/ds_mrr-big.test: ok! 19 test cases passed, take time 0.240830144 s
./t/echo.test: ok! 3 test cases passed, take time 0.000512367 s
./t/empty_table.test: ok! 7 test cases passed, take time 0.027353252 s
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:346 query failed with non expected error(s)! (ErrUnknown != ER_NO_DEFAULT_FOR_VIEW_FIELD) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: INSERT INTO v1 (vcol1) VALUES(12);)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:391 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00') (query: INSERT INTO t1 VALUES(STR_TO_DATE('32.10.2004 15.30','%D.%D.%Y %H.%I'));)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:412 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:417 query failed with non expected error(s)! (ErrDataTooLong != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:439 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != 1265) (err: Error 1366 (HY000): Incorrect tinyint value: '1a' for column 'a' at row 1) (query: INSERT INTO t1 VALUES ('1a');)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:460 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_WARN_NULL_TO_NOTNULL) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/wl6030_2.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/wl6030_2.dat' INTO TABLE t1 FIELDS TERMINATED BY ',' ENCLOSED BY '\"';)"
time="2024-05-06T10:35:10+08:00" level=warning msg="ignore_strict:486 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
./t/single_delete_update.test: ok! 131 test cases passed, take time 2.019665696 s
./t/endspace.test: ok! 64 test cases passed, take time 0.290549805 s
time="2024-05-06T10:35:10+08:00" level=warning msg="command not implemented" arguments=" include/have_debug.inc" command=source line=2
time="2024-05-06T10:35:11+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;)"
time="2024-05-06T10:35:11+08:00" level=warning msg="ignore_strict:624 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_DUP_ENTRY) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/rpl_loaddata.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t2 (a, @b) SET b= @b + 2;)"
./t/ignore_strict.test: ok! 157 test cases passed, take time 0.926777106 s
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=25
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=44
./t/sqllogic.test: ok! 40 test cases passed, take time 0.576391697 s
./t/str_quoted.test: ok! 9 test cases passed, take time 0.012048322 s
./t/error_simulation.test: ok! 19 test cases passed, take time 0.238496045 s
time="2024-05-06T10:35:11+08:00" level=warning msg="errors:23 query failed with non expected error(s)! (ER_NO_SUCH_TABLE 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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+08:00" level=warning msg="errors:264 query failed with non expected error(s)! (ErrSpDoesNotExist != 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-06T10:35:11+08:00" level=warning msg="errors:268 query failed with non expected error(s)! (ErrSpDoesNotExist != 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-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=61
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=76
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=91
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=106
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=121
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=136
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=151
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=166
time="2024-05-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+08:00" level=warning msg="errors:284 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 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.299215337 s
./t/exec_selection.test: ok! 14 test cases passed, take time 0.03937852 s
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=5
time="2024-05-06T10:35:11+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2024-05-06T10:35:11+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\";)"
./t/implicit_char_to_num_conversion.test: ok! 110 test cases passed, take time 0.338177078 s
./t/in.test: ok! 13 test cases passed, take time 0.017297965 s
./t/index.test: ok! 33 test cases passed, take time 0.138069228 s
time="2024-05-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+08:00" level=warning msg="strict:877 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 VALUES ('');)"
time="2024-05-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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-06T10:35:11+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));)"
time="2024-05-06T10:35:12+08:00" level=warning msg="strict:1424 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 t2(b DATE) SELECT a FROM t1;)"
time="2024-05-06T10:35:12+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.878559212 s
./t/innodb_tmp_table_heap_to_disk.test: ok! 49 test cases passed, take time 2.385677392 s
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" include/no_valgrind_without_big.inc" command=source line=4
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=8
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" (`SELECT @@global.log_bin AND @@global.binlog_format = 'ROW'`)\n{" command=if line=12
time="2024-05-06T10:35:12+08:00" level=warning msg="insert:67 query succeeded, but expected error(s)! (expected errors: 1048) (query: insert into t1 values(NULL);)"
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1563
time="2024-05-06T10:35:12+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-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1565
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" SELECT LOAD_FILE('$MYSQLTEST_VARDIR/tmp/wl6614.txt')" command=eval line=1566
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1567
time="2024-05-06T10:35:12+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-06T10:35:12+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-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1571
time="2024-05-06T10:35:12+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-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" SELECT $fields FROM t2" command=eval line=1573
./t/strict.test: ok! 483 test cases passed, take time 1.5587032509999998 s
time="2024-05-06T10:35:12+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.029701999 s
time="2024-05-06T10:35:12+08:00" level=warning msg="expression_index:78 query failed with non expected error(s)! (ErrDataTooLong != 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/sub_query.test: ok! 74 test cases passed, take time 0.24698529 s
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=109
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=113
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=117
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=121
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=125
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=135
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=139
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=143
time="2024-05-06T10:35:12+08:00" level=warning msg="command not implemented" arguments=" select * from t1 where number =last_insert_id()" command=query_vertical line=147
time="2024-05-06T10:35:12+08:00" level=warning msg="insert:222 query succeeded, but expected error(s)! (expected errors: ER_FIELD_SPECIFIED_TWICE) (query: prepare stmt1 from ' replace into t1 (a,a) select 100, ''hundred'' ';)"
time="2024-05-06T10:35:12+08:00" level=warning msg="insert:228 query failed with non expected error(s)! (ER_WRONG_VALUE_COUNT_ON_ROW != ER_FIELD_SPECIFIED_TWICE) (err: Error 1136 (21S01): Column count doesn't match value count at row 1) (query: insert into t1 (a,a) values (1,1,1);)"
time="2024-05-06T10:35:12+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;)"
time="2024-05-06T10:35:12+08:00" level=warning msg="subquery_all:39 query failed with non expected error(s)! (ErrBadField != 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-06T10:35:12+08:00" level=warning msg="subquery_all:41 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != 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-06T10:35:12+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-06T10:35:13+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-06T10:35:12+08:00" level=warning msg="insert:273 query failed with non expected error(s)! (ErrUnknown != 1393) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 (f1) values (3) on duplicate key update f3= f3 + 10;)"
time="2024-05-06T10:35:12+08:00" level=warning msg="insert:275 query failed with non expected error(s)! (ErrUnknown != 1393) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 (f1) values (3) on duplicate key update f1= f3 + 10;)"
time="2024-05-06T10:35:12+08:00" level=warning msg="insert:278 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1393) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 (f1) values (3) on duplicate key update f1= f3 + 10;)"
time="2024-05-06T10:35:13+08:00" level=warning msg="insert:481 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: INSERT INTO default_date VALUES();)"
time="2024-05-06T10:35:13+08:00" level=warning msg="insert:892 query succeeded, but expected error(s)! (expected errors: ER_ROW_IS_REFERENCED_2) (query: CREATE TABLE t1(a INT, b INT);)"
./t/insert.test: ok! 248 test cases passed, take time 1.374245454 s
time="2024-05-06T10:35:13+08:00" level=warning msg="expression_index:259 query failed with non expected error(s)! (ErrFunctionalIndexFunctionIsNotAllowed != 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-06T10:35:13+08:00" level=warning msg="subquery_all:310 query failed with non expected error(s)! (ErrBadField != 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-06T10:35:13+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-06T10:35:13+08:00" level=warning msg="expression_index:307 query failed with non expected error(s)! (ErrBlobKeyWithoutLength != 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-06T10:35:13+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-06T10:35:13+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-06T10:35:13+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);)"
time="2024-05-06T10:35:13+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-06T10:35:14+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 *);)"
./t/insert_select.test: ok! 158 test cases passed, take time 0.914962333 s
./t/expression_index.test: ok! 166 test cases passed, take time 1.961197999 s
./t/field_length.test: ok! 10 test cases passed, take time 0.028238486 s
./t/insert_select_myisam.test: ok! 21 test cases passed, take time 0.117640999 s
time="2024-05-06T10:35:14+08:00" level=warning msg="insert_update:221 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 (id,c1) SELECT 1,NULL\nON DUPLICATE KEY UPDATE c1=NULL;)"
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=disable_abort_on_error line=367
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=enable_abort_on_error line=369
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=disable_abort_on_error line=371
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=enable_abort_on_error line=373
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=disable_abort_on_error line=381
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=enable_abort_on_error line=383
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=disable_abort_on_error line=385
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments= command=enable_abort_on_error line=387
time="2024-05-06T10:35:15+08:00" level=warning msg="insert_update:503 query succeeded, but expected error(s)! (expected errors: ER_BAD_FIELD_ERROR) (query: INSERT INTO t0\nSELECT a FROM t1 GROUP BY a\nON DUPLICATE KEY UPDATE k= a + 10;)"
time="2024-05-06T10:35:15+08:00" level=warning msg="insert_update:528 query succeeded, but expected error(s)! (expected errors: ER_BAD_FIELD_ERROR) (query: INSERT INTO t0\nSELECT a FROM t1 UNION SELECT a FROM t2\nON DUPLICATE KEY UPDATE k= a + 10;)"
./t/insert_update.test: ok! 249 test cases passed, take time 1.029289599 s
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/insert_update_myisam.test: ok! 38 test cases passed, take time 0.096290429 s
time="2024-05-06T10:35:15+08:00" level=warning msg="command not implemented" arguments=" include/invisible_indexes.inc" command=source line=2
./t/invisible_indexes.test: ok! 23 test cases passed, take time 0.923798544 s
./t/issue_11208.test: ok! 9 test cases passed, take time 0.018192861 s
./t/issue_165.test: ok! 3 test cases passed, take time 0.009579519 s
./t/issue_20571.test: ok! 42 test cases passed, take time 0.144749364 s
./t/issue_207.test: ok! 17 test cases passed, take time 0.081078515 s
./t/issue_227.test: ok! 8 test cases passed, take time 0.010584274 s
./t/issue_266.test: ok! 47 test cases passed, take time 0.087778576 s
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:15 Unknown named --error ER_TWICE_COLUMN"
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:15 query failed with non expected error(s)! (ER_FIELD_SPECIFIED_TWICE != ER_TWICE_COLUMN) (err: Error 1110 (42000): Column 'c1' specified twice) (query: insert into t set c1 = 1, c2 = 1, c1 = 2, c2 =2;)"
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:19 Unknown named --error ER_TWICE_COLUMN"
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:19 query failed with non expected error(s)! (ER_FIELD_SPECIFIED_TWICE != ER_TWICE_COLUMN) (err: Error 1110 (42000): Column 'c1' specified twice) (query: insert into t (c1,c2,c1,c2) values(1,1,2,2);)"
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:23 Unknown named --error ER_TWICE_COLUMN"
time="2024-05-06T10:35:17+08:00" level=warning msg="issue_294:23 query failed with non expected error(s)! (ER_WRONG_VALUE_COUNT_ON_ROW != ER_TWICE_COLUMN) (err: Error 1136 (21S01): Column count doesn't match value count at row 1) (query: insert into t values(1,1,2,2);)"
./t/issue_294.test: ok! 16 test cases passed, take time 0.033557785 s
time="2024-05-06T10:35:18+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-06T10:35:18+08:00" level=warning msg="subquery_all:1646 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-06T10:35:18+08:00" level=warning msg="subquery_all:1649 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T10:35:18+08:00" level=warning msg="subquery_all:1651 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx from DUAL;)"
time="2024-05-06T10:35:22+08:00" level=warning msg="command not implemented" arguments=" ($merge_table_support)\n{" command=if line=486
./t/index_merge1.test: ok! 160 test cases passed, take time 11.623191879 s
time="2024-05-06T10:35:24+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
./t/index_merge2.test: ok! 328 test cases passed, take time 1.6537373629999998 s
time="2024-05-06T10:35:25+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-06T10:35:25+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=10
./t/index_merge_bug29952775.test: ok! 7 test cases passed, take time 0.026580656 s
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.06926747 s
time="2024-05-06T10:35:25+08:00" level=warning msg="subquery_all:4221 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: EXPLAIN FORMAT= 'BRIEF'\nSELECT cc FROM\n( SELECT\n(SELECT COUNT(a) FROM\n(SELECT COUNT(b) FROM t1) AS x GROUP BY c\n) AS cc FROM t1 GROUP BY b\n) AS y;)"
time="2024-05-06T10:35:26+08:00" level=warning msg="subquery_all:4724 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_VIEW_CHECK_FAILED) (err: Error 1146 (42S02): Table 'subquery_all.v3' doesn't exist) (query: DELETE FROM v3;)"
time="2024-05-06T10:35:26+08:00" level=warning msg="subquery_all:4947 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( SELECT 1 UNION ( SELECT 1 UNION SELECT 1 ) );)"
time="2024-05-06T10:35:26+08:00" level=warning msg="subquery_all:4949 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( ( SELECT 1 UNION SELECT 1 ) UNION SELECT 1 );)"
time="2024-05-06T10:35:27+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);)"
time="2024-05-06T10:35:27+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=107
time="2024-05-06T10:35:27+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-06T10:35:27+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
./t/filesort.test: ok! 54 test cases passed, take time 13.690248717 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.10250577 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.657316678 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.126726064 s
./t/foreign_key.test: ok! 158 test cases passed, take time 1.555830924 s
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:161 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:164 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:173 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_TABLE_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES name5678901234567890123456789012345678901234567890123456789012345(a));)"
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:176 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'name5678901234567890123456789012345678901234567890123456789012345' is too long) (query: CREATE TABLE t1(a INT PRIMARY KEY, b INT,\nFOREIGN KEY(b) REFERENCES t2(name5678901234567890123456789012345678901234567890123456789012345));)"
time="2024-05-06T10:35:30+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6574
time="2024-05-06T10:35:30+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=6581
time="2024-05-06T10:35:31+08:00" level=warning msg="subquery_all:6766 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT 1 as col FROM t1 WHERE a IN (SELECT a FROM DUAL LIMIT 0);)"
time="2024-05-06T10:35:31+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=359
time="2024-05-06T10:35:31+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-06T10:35:31+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
./t/index_merge_delete.test: ok! 214 test cases passed, take time 6.33631576 s
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.16529733 s
./t/subquery_all.test: ok! 2358 test cases passed, take time 18.867778187 s
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:337 query failed with non expected error(s)! (ER_FK_DUP_NAME != ER_DUP_KEYNAME) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fk') (query: ALTER TABLE t2 ADD CONSTRAINT fk FOREIGN KEY(b) REFERENCES t1(a);)"
time="2024-05-06T10:35:31+08:00" level=warning msg="foreign_key1:343 query succeeded, but expected error(s)! (expected errors: ER_FK_DUP_NAME) (query: ALTER TABLE t2 ADD FOREIGN KEY(b) REFERENCES t1(a);)"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key1:437 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key1:439 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key1:446 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column a with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN a;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key1:448 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_FK_COLUMN_CANNOT_DROP) (err: Error 8200 (HY000): can't drop column b with composite index covered or Primary Key covered now) (query: ALTER TABLE t2 DROP COLUMN b;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments=" UPDATE parent SET pf2= 2, sleep_dummy= SLEEP(2)" command=send line=511
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key1:531 query succeeded, but expected error(s)! (expected errors: ER_LOCK_WAIT_TIMEOUT) (query: ALTER TABLE child ADD COLUMN (i INT);)"
./t/foreign_key1.test: ok! 207 test cases passed, take time 2.104251131 s
./t/subquery_antijoin.test: ok! 116 test cases passed, take time 0.793794355 s
time="2024-05-06T10:35:32+08:00" level=warning msg="subquery_bugs:157 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T10:35:32+08:00" level=warning msg="subquery_bugs:167 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="subquery_bugs:226 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX',\nSUM(k)\nFROM t1;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="subquery_bugs:236 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'k'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T10:35:32+08:00" level=warning msg="subquery_bugs:246 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=252
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:41 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:41 query failed with non expected error(s)! (ErrForeignKeyCascadeDepthExceeded != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t1 where id=0;)"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:63 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+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-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:76 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+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-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+08:00" level=warning msg="foreign_key_cascade_delete:94 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:32+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-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:117 Unknown named error CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))"
time="2024-05-06T10:35:33+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-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:136 Unknown named --error ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15."
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:136 query failed with non expected error(s)! (ErrForeignKeyCascadeDepthExceeded != ER_[executor:3008]Foreign key cascade delete/update exceeds max depth of 15.) (err: Error 3008 (HY000): Foreign key cascade delete/update exceeds max depth of 15.) (query: delete from t0 where id=0;)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:158 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:158 query failed with non expected error(s)! (ErrRowIsReferenced2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))) (query: delete from t1 where id = 2;)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4` in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:160 Unknown named error CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`)) in --error ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t4`, CONSTRAINT `fk_id3` FOREIGN KEY (`id3`) REFERENCES `t3` (`id2`))"
time="2024-05-06T10:35:33+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-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:286 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:327 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:368 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:385 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:432 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:449 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="subquery_bugs:676 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: SELECT DISTINCT * FROM t1\nORDER BY UUID_TO_BIN(\nST_ISEMPTY(\nST_POINTFROMTEXT(\nST_ASWKT(\nNOT EXISTS(\nSELECT 1 FROM t1\nWHERE IS_UUID(CAST(SHA(a>>0xA7FE1B22)AS JSON)) WINDOW w1 AS()\n),'AXIS-ORDER=SRID-DEFINED'\n),1,'AXIS-ORDER=LONG-LAT'\n)\n)\n);)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:495 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:535 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:575 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-06T10:35:33+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:34+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2024-05-06T10:35:34+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2024-05-06T10:35:34+08:00" level=warning msg="foreign_key_cascade_delete:655 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T10:35:34+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=brief $query;" command=eval line=946
./t/join-reorder.test: ok! 143 test cases passed, take time 15.607736965 s
time="2024-05-06T10:35:33+08:00" level=warning msg="command not implemented" arguments=" \"31 tables\" \"XX tables\" \"61 tables\" \"XX tables\"" command=replace_result line=122
time="2024-05-06T10:35:33+08:00" level=warning msg="command not implemented" arguments=" \"31 tables\" \"XX tables\" \"61 tables\" \"XX tables\"" command=replace_result line=126
./t/subquery_bugs.test: ok! 287 test cases passed, take time 3.138898467 s
time="2024-05-06T10:35:36+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);)"
./t/join.test: ok! 583 test cases passed, take time 4.37628863 s
./t/join_crash.test: ok! 36 test cases passed, take time 0.110724493 s
./t/join_nested_bka.test: ok! 28 test cases passed, take time 0.241134428 s
./t/join_nested_bka_nobnl.test: ok! 28 test cases passed, take time 0.227853394 s
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=123
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=126
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=400
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=409
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=841
time="2024-05-06T10:35:38+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=848
time="2024-05-06T10:35:39+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1171
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 6.163249625 s
time="2024-05-06T10:35:39+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1308
time="2024-05-06T10:35:39+08:00" level=warning msg="subquery_mat:1391 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief UPDATE t2,t3 SET t2.a=10 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T10:35:39+08:00" level=warning msg="subquery_mat:1393 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief DELETE t2.* FROM t2,t3 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T10:35:40+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=1680
time="2024-05-06T10:35:40+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 4.690031032 s
time="2024-05-06T10:35:40+08:00" level=warning msg="foreign_key_cascade_mysql:292 query succeeded, but expected error(s)! (expected errors: 1215) (query: alter table blobchild add constraint fkbad foreign key(a) references parent (a) on delete cascade on update restrict;)"
time="2024-05-06T10:35:40+08:00" level=warning msg="foreign_key_cascade_mysql:317 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (a) on delete cascade on update restrict;)"
time="2024-05-06T10:35:40+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-06T10:35:40+08:00" level=warning msg="foreign_key_cascade_mysql:373 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (b) on delete cascade on update restrict;)"
time="2024-05-06T10:35:40+08:00" level=warning msg="foreign_key_cascade_mysql:404 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (a) on delete cascade on update restrict;)"
time="2024-05-06T10:35:40+08:00" level=warning msg="foreign_key_cascade_mysql:432 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (b) on delete cascade on update restrict;)"
./t/subquery_sj_innodb_all.test: ok! 68 test cases passed, take time 0.537636157 s
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 2.201358203 s
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 0.825506563 s

time="2024-05-06T10:35:42+08:00" level=error msg="1 tests failed\n"
time="2024-05-06T10:35:42+08:00" level=error msg="run test [alter_table1] err: sql:SELECT * FROM ti3;: failed to run query \n\"SELECT * FROM ti3;\" \n around line 784, \nwe need(43):\nSELECT * FROM ti3;\na\tb\n1\t1\n101\t7\n2\t2\n3\t5\nDR\nbut got(43):\nSELECT * FROM ti3;\na\tb\n1\t1\n101\t5\n2\t2\n201\t7\n\n"
tidb-server(PID: 2280) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
./t/subselect_innodb.test: ok! 175 test cases passed, take time 2.088310405 s
time="2024-05-06T10:35:43+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=6
time="2024-05-06T10:35:43+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=7
time="2024-05-06T10:35:43+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.247150247 s
./t/join_outer.test: ok! 867 test cases passed, take time 5.610515901 s
./t/json.test: ok! 82 test cases passed, take time 0.436546668 s
./t/sum_distinct.test: ok! 32 test cases passed, take time 0.525929844 s
time="2024-05-06T10:35:44+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);)"
time="2024-05-06T10:35:44+08:00" level=warning msg="json_agg:184 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION json_agg.st_pointfromtext does not exist) (query: SELECT JSON_ARRAYAGG(ST_PointFromText('POINT(10 10)')) FROM t2;)"
[Checks API] No suitable checks publisher found.
[Pipeline] archiveArtifacts
Archiving artifacts
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
./t/json_agg.test: ok! 177 test cases passed, take time 0.520225581 s
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
./t/temp_table.test: ok! 137 test cases passed, take time 0.716764989 s
./t/temptable_256_fields.test: ok! 5 test cases passed, take time 0.032330469 s
./t/temptable_disk.test: ok! 14 test cases passed, take time 0.128516278 s
time="2024-05-06T10:35:45+08:00" level=warning msg="time:61 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T10:35:45+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-06T10:35:45+08:00" level=warning msg="time:63 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T10:35:45+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-06T10:35:45+08:00" level=warning msg="time:65 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T10:35:45+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);)"
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '1'
Sending interrupt signal to process
Killing processes
time="2024-05-06T10:35:45+08:00" level=warning msg="json_ddl:70 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_TEXT) (query: ALTER TABLE t4 MODIFY COLUMN jj JSON;)"
./t/json_ddl.test: ok! 40 test cases passed, take time 0.567178208 s
time="2024-05-06T10:35:45+08:00" level=warning msg="json_functions:133 Unknown named --error Incorrect parameter count"
time="2024-05-06T10:35:45+08:00" level=warning msg="json_functions:133 query failed with non expected error(s)! (ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT != Incorrect parameter count) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'json_object') (query: SELECT JSON_OBJECT( 87, 'name', 'carrot');)"
time="2024-05-06T10:35:45+08:00" level=warning msg="json_functions:135 Unknown named --error JSON documents may not contain NULL"
time="2024-05-06T10:35:45+08:00" level=warning msg="json_functions:135 query failed with non expected error(s)! (ErrUnknown != JSON documents may not contain NULL) (err: Error 1105 (HY000): JSON documents may not contain NULL member names) (query: SELECT JSON_OBJECT(NULL, 'carrot');)"
time="2024-05-06T10:35:45+08:00" level=warning msg="time:90 Unknown named --error "
time="2024-05-06T10:35:45+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.196535327 s
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
./t/time_zone_grant.test: ok! 58 test cases passed, take time 0.315102546 s
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
./t/time_zone_with_dst.test: ok! 28 test cases passed, take time 0.249261633 s
./t/json_functions.test: ok! 784 test cases passed, take time 0.638481322 s
tidb-server(PID: 2304) stopped
script returned exit code 143
kill finished with exit code 0
time="2024-05-06T10:35:46+08:00" level=warning msg="timestamp_insert:56 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T10:35:46+08:00" level=warning msg="timestamp_insert:56 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default '12345678');)"
time="2024-05-06T10:35:46+08:00" level=warning msg="timestamp_insert:70 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T10:35:46+08:00" level=warning msg="timestamp_insert:70 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 2010101011111);)"
tidb-server(PID: 2338) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] // cache
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
tidb-server(PID: 2269) stopped
script returned exit code 143
[Pipeline] // dir
Post stage
Post stage
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] junit
Recording test results
[Pipeline] junit
Recording test results
[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] }
[Checks API] No suitable checks publisher found.
[Pipeline] // withEnv
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] }
[Pipeline] // stage
[Pipeline] // timeout
[Pipeline] }
Failed in branch Matrix - PART = '3'
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh FAILURE result.json
http://fileserver.pingcap.net
--2024-05-06 02:35:51--  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%  114M=0s

2024-05-06 02:35:52 (114 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

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