Skipping 779 KB.. Full Log

./t/select_all.test: ok! 2430 test cases passed, take time 13.089039611 s
./t/select_qualified.test: ok! 19 test cases passed, take time 0.079679403 s
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=36
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=45
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=54
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=56
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=76
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=80
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=84
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=86
./t/func_gconcat.test: ok! 422 test cases passed, take time 1.889365568 s
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=25
time="2024-05-06T18:06:35+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=31
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=70
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=74
time="2024-05-06T18:06:35+08:00" level=warning msg="expression_index:259 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_SPATIAL_FUNCTIONAL_INDEX) (err: Error 3758 (HY000): Expression of expression index 'expression_index' contains a disallowed function) (query: CREATE TABLE t1(x VARCHAR(100), KEY ((ST_GeomFromText(x))));)"
time="2024-05-06T18:06:36+08:00" level=warning msg="expression_index:307 query failed with non expected error(s)! (ER_BLOB_KEY_WITHOUT_LENGTH != ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED) (err: Error 1170 (42000): BLOB/TEXT column 'a1' used in key specification without a key length) (query: CREATE TABLE  table44 ( pk INTEGER AUTO_INCREMENT, a1 TEXT NOT NULL, b1\nDATETIME NOT NULL, c1 TIME NOT NULL, d1 BLOB NOT NULL, PRIMARY KEY (a1), KEY\n((VALUES(d1))));)"
time="2024-05-06T18:06:36+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-06T18:06:36+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-06T18:06:36+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-06T18:06:36+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);)"
./t/expression_index.test: ok! 166 test cases passed, take time 1.987972362 s
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=301
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=314
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=324
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=339
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=340
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=342
./t/field_length.test: ok! 10 test cases passed, take time 0.031117851 s
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=383
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=411
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/no_running_event_scheduler.inc" command=source line=442
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" include/running_event_scheduler.inc" command=source line=514
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=558
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=574
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=583
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20609 # 20485 # 20481 #" command=replace_result line=588
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20609 # 20485 # 20481 #" command=replace_result line=605
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 4225 # 4097 #" command=replace_result line=627
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments=" 20613 # 20485 # 20609 # 20481 #" command=replace_result line=668
time="2024-05-06T18:06:36+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=732
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=817
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1055
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1110
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=1192
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=753
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=762
./t/show_check_cs.test: ok! 289 test cases passed, take time 1.82936056 s
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=15
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=17
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=24
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=27
time="2024-05-06T18:06:37+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=160
time="2024-05-06T18:06:37+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.360392016 s
./t/show_profile.test: ok! 7 test cases passed, take time 0.000751178 s
./t/show_variables.test: ok! 23 test cases passed, take time 0.035437128 s
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:983 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'a'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT a FROM t1 HAVING COUNT(*)>2;)"
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:985 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 'a'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT COUNT(*), a FROM t1;)"
time="2024-05-06T18:06:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=987
time="2024-05-06T18:06: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=993
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:1052 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT\n(SELECT COUNT( int_nokey )\nFROM derived1 AS X\nWHERE\nX.int_nokey < 61\nGROUP BY pk\nLIMIT 1)\nFROM D AS X\nWHERE X.int_key < 13\nGROUP BY int_nokey LIMIT 1;)"
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:1080 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 'a'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT COUNT(*),a FROM t1;)"
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:1085 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT COUNT(*), (SELECT count(*) FROM t1 inr WHERE inr.a = outr.a)\nFROM t1 outr;)"
time="2024-05-06T18:06:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=1118
time="2024-05-06T18:06: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=1145
time="2024-05-06T18:06:38+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=1191
time="2024-05-06T18:06: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=1197
time="2024-05-06T18:06:38+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1239
time="2024-05-06T18:06:38+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1241
time="2024-05-06T18:06:38+08:00" level=warning msg="func_group:1257 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_ORDER_NON_AGG_QUERY) (query: SELECT 1 FROM t1 ORDER BY AVG(DISTINCT a);)"
./t/func_group.test: ok! 643 test cases passed, take time 3.231430191 s
./t/func_group_innodb.test: ok! 71 test cases passed, take time 0.238767374 s
./t/func_group_innodb_16k.test: ok! 7 test cases passed, take time 0.045323054 s
time="2024-05-06T18:06:39+08:00" level=warning msg="command not implemented" arguments=" 40.00 40.0" command=replace_result line=108
time="2024-05-06T18:06:39+08:00" level=warning msg="command not implemented" arguments=" select\nsum(distinct(if('a',\n(select adddate(elt(convert($nines,decimal(64,0)),count(*)),\ninterval 1 day))\n, .1))) as foo;" command=eval line=211
./t/func_if.test: ok! 83 test cases passed, take time 0.353839409 s
time="2024-05-06T18:06:40+08:00" level=warning msg="func_in_all:71 query succeeded, but expected error(s)! (expected errors: 1267) (query: select * from t1 where a in (b);)"
time="2024-05-06T18:06:40+08:00" level=warning msg="func_in_all:73 query succeeded, but expected error(s)! (expected errors: 1270) (query: select * from t1 where a in (b,c);)"
time="2024-05-06T18:06:40+08:00" level=warning msg="func_in_all:75 query succeeded, but expected error(s)! (expected errors: 1271) (query: select * from t1 where 'a' in (a,b,c);)"
./t/single_delete_update.test: ok! 131 test cases passed, take time 1.9380881840000002 s
./t/sqllogic.test: ok! 40 test cases passed, take time 0.506030327 s
./t/str_quoted.test: ok! 9 test cases passed, take time 0.011661273 s
time="2024-05-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:40+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=644
time="2024-05-06T18:06:41+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=646
./t/func_in_all.test: ok! 280 test cases passed, take time 1.233094946 s
time="2024-05-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+08:00" level=warning msg="strict:877 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 VALUES ('');)"
time="2024-05-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+08:00" level=warning msg="func_in_none:91 query succeeded, but expected error(s)! (expected errors: 1267) (query: select * from t1 where a in (b);)"
time="2024-05-06T18:06:41+08:00" level=warning msg="func_in_none:93 query succeeded, but expected error(s)! (expected errors: 1270) (query: select * from t1 where a in (b,c);)"
time="2024-05-06T18:06:41+08:00" level=warning msg="func_in_none:95 query succeeded, but expected error(s)! (expected errors: 1271) (query: select * from t1 where 'a' in (a,b,c);)"
time="2024-05-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+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-06T18:06:41+08:00" level=warning msg="strict:1424 query failed with non expected error(s)! (ErrUnknown != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t2(b DATE) SELECT a FROM t1;)"
time="2024-05-06T18:06:42+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1563
time="2024-05-06T18:06:42+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-06T18:06:42+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1565
time="2024-05-06T18:06:42+08:00" level=warning msg="command not implemented" arguments=" SELECT LOAD_FILE('$MYSQLTEST_VARDIR/tmp/wl6614.txt')" command=eval line=1566
time="2024-05-06T18:06:42+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1567
time="2024-05-06T18:06:42+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-06T18:06:42+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-06T18:06:42+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1571
time="2024-05-06T18:06:42+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-06T18:06:42+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.612660449 s
time="2024-05-06T18:06:42+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.028955689 s
./t/sub_query.test: ok! 74 test cases passed, take time 0.189741804 s
time="2024-05-06T18:06:42+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=660
time="2024-05-06T18:06:42+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=662
./t/func_in_none.test: ok! 275 test cases passed, take time 1.191957645 s
./t/func_isnull.test: ok! 39 test cases passed, take time 0.169923749 s
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:7 query succeeded, but expected error(s)! (expected errors: ER_JSON_DOCUMENT_TOO_DEEP) (query: select json_valid(repeat('[', 1000));)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:9 query succeeded, but expected error(s)! (expected errors: ER_JSON_DOCUMENT_TOO_DEEP) (query: select json_valid(repeat('{\"a\":', 1000));)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:25 query failed with non expected error(s)! (ErrInvalidJSONPathArrayCell != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3165 (42000): A path expression is not a path to a cell in an array.) (query: select json_array_insert('true', '$', 1);)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:34 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: select json_contains('', '', '$');)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:113 query failed with non expected error(s)! (ER_INVALID_TYPE_FOR_JSON != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3146 (HY000): Invalid data type for JSON data in argument 1 to function json_merge; a JSON string or JSON type is required.) (query: select json_merge('string', 123);)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:121 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select json_merge('a','b');)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:135 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select json_keys('foo');)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:177 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: select json_length('');)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:183 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select json_length('{}{');)"
time="2024-05-06T18:06:42+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-06T18:06:42+08:00" level=warning msg="subquery_all:41 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'b' in 'having clause') (query: SELECT (SELECT 1 FROM (SELECT 1) as b HAVING b=1) as a,(SELECT 1 FROM (SELECT 1) as c HAVING a=1) as b;)"
time="2024-05-06T18:06:42+08:00" level=warning msg="subquery_all:44 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'field list') (query: SELECT (SELECT a) as a;)"
time="2024-05-06T18:06:42+08:00" level=warning msg="subquery_all:93 query failed with non expected error(s)! (ErrBadField != 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-06T18:06:42+08:00" level=warning msg="func_json:293 Unknown named --error Invalid data type for JSON data"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:293 query failed with non expected error(s)! (ErrInvalidTypeForJSON != Invalid data type for JSON data) (err: Error 3146 (HY000): Invalid data type for JSON data in argument 0 to function json_keys; a JSON string or JSON type is required.) (query: SELECT JSON_KEYS(f) FROM t1 ORDER BY 1;)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:316 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select JSON_EXTRACT('{\"foo\": \"bar\" foobar foo invalid ', '$.foo');)"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:370 Unknown named --error Invalid data type for JSON data"
time="2024-05-06T18:06:42+08:00" level=warning msg="func_json:370 query failed with non expected error(s)! (ErrInvalidTypeForJSON != Invalid data type for JSON data) (err: Error 3146 (HY000): Invalid data type for JSON data in argument 0 to function json_extract; a JSON string or JSON type is required.) (query: select 1 from t1 where json_extract(a,'$','$[81]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:493 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 JSON_MERGE_PATCH(NULL, 'a');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:501 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 JSON_MERGE_PATCH('{', '[1,2,3]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:503 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 JSON_MERGE_PATCH('{\"a\":\"b\"}', '[1,');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=525
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=526
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=537
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=538
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=581
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=586
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:717 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: select json_arrayagg(a) over () from (select 1 a) t;)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:720 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: select json_objectagg(a, b) over () from (select 1 a, 2 b) t;)"
time="2024-05-06T18:06:43+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-06T18:06:43+08:00" level=warning msg="subquery_all:336 query failed with non expected error(s)! (ErrBadField != 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-06T18:06:43+08:00" level=warning msg="func_json:855 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_ARRAY_APPEND(@json, '$.A[last-1][last]', 5);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:874 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH # support in the future) (query: SELECT JSON_ARRAY_INSERT(@json, '$.A[last-1][last-1]', 5);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:893 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_CONTAINS(@json, '15', '$.A[last-1][last]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:912 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_CONTAINS_PATH(@json, 'one', '$.A[last-1]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:931 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_EXTRACT(@json, '$.A[last-7][1]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:937 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_KEYS(@json, '$[last].C');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:956 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_LENGTH(@json, '$.A[last-1][last-2]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:975 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_REMOVE(@json, '$.A[last-9]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:994 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_REPLACE(@json, '$.A[last]', 4);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1000 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_SEARCH(@json, 'all', 'abc', NULL, '$[last-1]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1019 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_SET(@json, '$.A[last-3]', 100);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1030 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_SEARCH(@json, 'one', '12', NULL, '$[3][0 to 3]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1041 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_EXTRACT(@json, '$[0 to 3][2]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1043 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_EXTRACT(@json, '$[3][3][last-1 to last]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1058 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_CONTAINS_PATH(@json,'one', '$[3][0 to 3]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1069 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: SELECT JSON_CONTAINS(@json, '$[3][0 to 3]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1113 query failed with non expected error(s)! (ErrUnknown != ER_INVALID_JSON_PATH_WILDCARD) (err: Error 1105 (HY000): Invalid path expression) (query: SELECT JSON_SET(@json, '$[0][1 to 2].key1', 1);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1124 query failed with non expected error(s)! (ErrUnknown != ER_INVALID_JSON_PATH_WILDCARD) (err: Error 1105 (HY000): Invalid path expression) (query: SELECT JSON_REPLACE(@json, '$[1][last-2 to last]', 4);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1135 query failed with non expected error(s)! (ErrInvalidJSONPath != ER_INVALID_JSON_PATH_WILDCARD) (err: Error 3143 (42000): Invalid JSON path expression. The error is around character position 5.) (query: SELECT JSON_REMOVE(@json, '$[1][-6 to last-2]');)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_json:1161 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_PATH) (query: SELECT JSON_EXTRACT(@json, '$[0 to 0]');)"
./t/func_json.test: ok! 472 test cases passed, take time 0.982749912 s
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments=" 15" command=replace_numeric_round line=21
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:362 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_ARGUMENTS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t1 SELECT CEIL(ST_LINESTRINGFROMWKB(1) DIV NULL);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:364 query failed with non expected error(s)! (ErrUnknown != ER_WRONG_ARGUMENTS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t1 SELECT FLOOR(ST_LINESTRINGFROMWKB(1) DIV NULL);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments="  # See bug #27245598." command=disable_ps_protocol line=537
time="2024-05-06T18:06:43+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=539
time="2024-05-06T18:06:43+08:00" level=warning msg="subquery_all:449 query failed with non expected error(s)! (ErrBadTable != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: SELECT * FROM (SELECT 1) b WHERE 1 IN (SELECT *);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:604 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (ln(0));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:606 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (ln(-1));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:608 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (log(0));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:610 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (log(1,0));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:612 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (log2(0));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:614 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: INSERT INTO t1 VALUES (log10(0));)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:618 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: UPDATE t1 SET a = ln(0);)"
time="2024-05-06T18:06:43+08:00" level=warning msg="func_math:627 query succeeded, but expected error(s)! (expected errors: ER_INVALID_ARGUMENT_FOR_LOGARITHM) (query: DELETE FROM t1 WHERE a <=> ln(0);)"
time="2024-05-06T18:06:44+08:00" level=warning msg="func_math:963 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: select cast(pow(2,63)-1024 as signed) as pp;)"
time="2024-05-06T18:06:44+08:00" level=warning msg="func_math:1286 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT a, 0-a FROM t1;)"
./t/func_math.test: ok! 383 test cases passed, take time 0.817224078 s
time="2024-05-06T18:06:44+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=81
time="2024-05-06T18:06:44+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=231
./t/func_misc.test: ok! 234 test cases passed, take time 0.376650808 s
./t/join-reorder.test: ok! 143 test cases passed, take time 17.530728267 s
time="2024-05-06T18:06:44+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-06T18:06:44+08:00" level=warning msg="command not implemented" arguments=" \"31 tables\" \"XX tables\" \"61 tables\" \"XX tables\"" command=replace_result line=126
./t/func_op.test: ok! 19 test cases passed, take time 0.050457864 s
time="2024-05-06T18:06:45+08:00" level=warning msg="command not implemented" arguments=" include/func_prefix_key.inc" command=source line=36
./t/func_prefix_key.test: ok! 32 test cases passed, take time 0.914081678 s
time="2024-05-06T18:06:45+08:00" level=warning msg="command not implemented" arguments=" 0.00..0.00 0.00" command=replace_result line=7
./t/func_rand.test: ok! 2 test cases passed, take time 0.000381151 s
time="2024-05-06T18:06:46+08:00" level=warning msg="func_regexp:81 query succeeded, but expected error(s)! (expected errors: ER_CHARACTER_SET_MISMATCH) (query: SELECT NULL REGEXP BINARY NULL;)"
./t/func_regexp.test: ok! 38 test cases passed, take time 0.111316004 s
./t/func_sapdb.test: ok! 87 test cases passed, take time 0.069683375 s
./t/func_set.test: ok! 69 test cases passed, take time 0.209411452 s
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:46 query succeeded, but expected error(s)! (expected errors: ER_CANNOT_CONVERT_STRING) (query: SELECT LOCATE(x'ff', _utf8mb4'abcdef');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:49 query succeeded, but expected error(s)! (expected errors: ER_CANNOT_CONVERT_STRING) (query: SELECT POSITION(x'ff' IN _utf8mb4'abcdef');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:52 query succeeded, but expected error(s)! (expected errors: ER_CANNOT_CONVERT_STRING) (query: SELECT INSTR(_utf8mb4'abcdef', x'ff');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:244 query failed with non expected error(s)! (ER_UNKNOWN_CHARACTER_SET != 1267) (err: Error 1115 (42000): Unsupported character introducer: 'latin2') (query: select _latin1'1'=_latin2'1';)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:250 query failed with non expected error(s)! (ER_UNKNOWN_COLLATION != 1267) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select row('A' COLLATE latin1_general_ci,'b','c') = row('a' COLLATE latin1_bin,'b','c');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:273 query succeeded, but expected error(s)! (expected errors: ER_CANNOT_CONVERT_STRING) (query: SELECT FIELD(_utf8mb4'abc', x'ff');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:290 query failed with non expected error(s)! (ErrUnknownCollation != 1267) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select FIND_IN_SET(_latin1'B' COLLATE latin1_general_ci,_latin1'a,b,c,d' COLLATE latin1_bin);)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:314 query failed with non expected error(s)! (ER_UNKNOWN_CHARACTER_SET != 1270) (err: Error 1115 (42000): Unsupported character introducer: 'latin2') (query: select _latin1'B' between _latin1'a' and _latin2'b';)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:316 query failed with non expected error(s)! (ErrUnknownCollation != 1270) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select _latin1'B' collate latin1_general_ci between _latin1'a' collate latin1_bin and _latin1'b';)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:329 query failed with non expected error(s)! (ErrUnknownCollation != 1270) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select _latin1'B' COLLATE latin1_general_ci in (_latin1'a' COLLATE latin1_bin,_latin1'b');)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:331 query failed with non expected error(s)! (ER_UNKNOWN_COLLATION != 1270) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select _latin1'B' COLLATE latin1_general_ci in (_latin1'a',_latin1'b' COLLATE latin1_bin);)"
time="2024-05-06T18:06:46+08:00" level=warning msg="func_str:440 query failed with non expected error(s)! (ErrUnknownCollation != 1267) (err: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'latin1_general_ci') (query: select * from t7\nwhere concat(s1 collate latin1_general_ci,s1 collate latin1_swedish_ci) = 'AA';)"
time="2024-05-06T18:06:47+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=678
time="2024-05-06T18:06:47+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=681
time="2024-05-06T18:06:47+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1205
time="2024-05-06T18:06:47+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1207
time="2024-05-06T18:06:47+08:00" level=warning msg="func_str:1417 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION func_str.st_linefromwkb does not exist) (query: DO\nround(\nconcat( (\ncoalesce( (\nST_linefromwkb('2147483648',\n-b'1111111111111111111111111111111111111111111')),\n( convert('[.DC2.]',decimal(30,30)) ),\nbit_count('')\n) ),\n( lpad( ( elt('01','}:K5')),\nsha1('P'),\n( ( select '-9223372036854775808.1' > all (select '')))\n)\n)\n)\n);)"
time="2024-05-06T18:06:48+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-06T18:06:48+08:00" level=warning msg="subquery_all:1646 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T18:06:48+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-06T18:06:48+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-06T18:06:48+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=1667
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments= command=disable_connect_log line=1680
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=2236
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=2238
time="2024-05-06T18:06:48+08:00" level=warning msg="func_str:2276 query failed with non expected error(s)! (ErrUnknownCharacterSet != ER_CANNOT_CONVERT_STRING) (err: Error 1115 (42000): Unknown character set: 'gb18030') (query: SELECT (SELECT 1\nFROM t\nWHERE CONVERT(1 USING gb18030) <> GROUP_CONCAT(x'a3')\n);)"
time="2024-05-06T18:06:48+08:00" level=warning msg="func_str:2297 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_CANNOT_CONVERT_STRING) (err: Error 1305 (42000): FUNCTION func_str.st_isvalid does not exist) (query: DO ST_ISVALID(INSTR(9223372036854775806 ,0x46bc299f));)"
time="2024-05-06T18:06:48+08:00" level=warning msg="func_str:2300 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_CANNOT_CONVERT_STRING) (err: Error 1305 (42000): FUNCTION func_str.st_srid does not exist) (query: DO ST_SRID(LOCATE(0x58ed0b8e,8,135));)"
time="2024-05-06T18:06:48+08:00" level=warning msg="func_str:2310 query failed with non expected error(s)! (ER_UNKNOWN_CHARACTER_SET != ER_DATA_OUT_OF_RANGE) (err: Error 1115 (42000): Unknown character set: 'ujis') (query: DO NOT CAST(UTC_TIME AS CHAR(2877246026) CHARACTER SET ujis);)"
./t/join.test: ok! 583 test cases passed, take time 4.58437417 s
./t/func_str.test: ok! 1046 test cases passed, take time 2.5244989650000003 s
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments=" include/no_ps_protocol.inc" command=source line=2
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=3
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=4
time="2024-05-06T18:06:48+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=5
./t/func_str_myisam.test: ok! 42 test cases passed, take time 0.188957462 s
./t/join_crash.test: ok! 36 test cases passed, take time 0.117628835 s
time="2024-05-06T18:06:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=34
./t/func_system.test: ok! 35 test cases passed, take time 0.076959715 s
./t/join_nested_bka.test: ok! 28 test cases passed, take time 0.233663359 s
./t/func_test.test: ok! 112 test cases passed, take time 0.192746672 s
./t/join_nested_bka_nobnl.test: ok! 28 test cases passed, take time 0.234548945 s
time="2024-05-06T18:06:49+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=123
time="2024-05-06T18:06:49+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-06T18:06:50+08:00" level=warning msg="command not implemented" arguments=" SELECT\nDATE('20091000'),\nSTR_TO_DATE('200910','%Y%m'),\nLAST_DAY('2009-10-00'),\nLAST_DAY(DATE('2009-10-00')),\nLAST_DAY(DATE'2009-10-00'),\nLAST_DAY(STR_TO_DATE('200910','%Y%m')),\nWEEK('2009-10-00'),\nWEEK(DATE('2009-10-00')),\nWEEK(DATE'2009-10-00'),\nWEEK(STR_TO_DATE('200910','%Y%m')),\nWEEKOFYEAR('2009-10-00'),\nWEEKOFYEAR(DATE('2009-10-00')),\nWEEKOFYEAR(DATE'2009-10-00'),\nWEEKOFYEAR(STR_TO_DATE('200910','%Y%m')),\nDAYOFYEAR('2009-10-00'),\nDAYOFYEAR(DATE('2009-10-00')),\nDAYOFYEAR(DATE'2009-10-00'),\nDAYOFYEAR(STR_TO_DATE('200910','%Y%m')),\nWEEKDAY('2009-10-00'),\nWEEKDAY(DATE('2009-10-00')),\nWEEKDAY(DATE'2009-10-00'),\nWEEKDAY(STR_TO_DATE('200910','%Y%m')),\nTO_DAYs('2009-10-00'),\nTO_DAYs(DATE('2009-10-00')),\nTO_DAYs(DATE'2009-10-00'),\nTO_DAYs(STR_TO_DATE('200910','%Y%m'));" command=query_vertical line=950
time="2024-05-06T18:06:50+08:00" level=warning msg="command not implemented" arguments=" SELECT\nDATE('00000100'),\nSTR_TO_DATE('000001','%Y%m'),\nLAST_DAY('0000-01-00'),\nLAST_DAY(DATE('0000-01-00')),\nLAST_DAY(DATE'0000-01-00'),\nLAST_DAY(STR_TO_DATE('000001','%Y%m')),\nWEEK('0000-01-00'),\nWEEK(DATE('0000-01-00')),\nWEEK(DATE'0000-01-00'),\nWEEK(STR_TO_DATE('000001','%Y%m')),\nWEEKOFYEAR('0000-01-00'),\nWEEKOFYEAR(DATE('0000-01-00')),\nWEEKOFYEAR(DATE'0000-01-00'),\nWEEKOFYEAR(STR_TO_DATE('000001','%Y%m')),\nDAYOFYEAR('0000-01-00'),\nDAYOFYEAR(DATE('0000-01-00')),\nDAYOFYEAR(DATE'0000-01-00'),\nDAYOFYEAR(STR_TO_DATE('000001','%Y%m')),\nWEEKDAY('0000-01-00'),\nWEEKDAY(DATE('0000-01-00')),\nWEEKDAY(DATE'0000-01-00'),\nWEEKDAY(STR_TO_DATE('000001','%Y%m')),\nTO_DAYs('0000-01-00'),\nTO_DAYs(DATE('0000-01-00')),\nTO_DAYs(DATE'0000-01-00'),\nTO_DAYs(STR_TO_DATE('000001','%Y%m'));" command=query_vertical line=978
time="2024-05-06T18:06:50+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=400
time="2024-05-06T18:06:50+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-06T18:06:50+08:00" level=warning msg="func_time:1050 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET default_storage_engine=NULL;)"
time="2024-05-06T18:06:50+08:00" level=warning msg="command not implemented" arguments="  # See bug #27245598." command=disable_ps_protocol line=1119
time="2024-05-06T18:06:50+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=1122
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1204 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: DO DAYOFYEAR(SEC_TO_TIME((~(((RELEASE_ALL_LOCKS())-((1)))))));)"
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1206 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_GIS_INVALID_DATA) (err: Error 1305 (42000): FUNCTION func_time.mbrdisjoint does not exist) (query: DO DAYOFYEAR(((MBRDISJOINT(0xbc,1))OR(WEEK(SEC_TO_TIME(419824656)))));)"
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1208 query failed with non expected error(s)! (ER_INVALID_JSON_PATH != ER_INVALID_TYPE_FOR_JSON) (err: Error 3143 (42000): Invalid JSON path expression. The error is around character position 1.) (query: DO DAYOFYEAR(SEC_TO_TIME(OCT(BIT_AND(JSON_REPLACE((23533),'key3',NULL)))));)"
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1214 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_NONPOSITIVE_RADIUS) (err: Error 1305 (42000): FUNCTION func_time.point does not exist) (query: DO DAYOFYEAR(MAKETIME('1981-06-27 11:16:09.211343',\n(((NOT(ST_DISTANCE_SPHERE(POINT(4472,28027),\nPOINT(28061,-9007199254740996),-644021130))))<=>(@c)),(1)));)"
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1218 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_GIS_INVALID_DATA) (err: Error 1305 (42000): FUNCTION func_time.st_aswkt does not exist) (query: DO DAYOFYEAR(MAKETIME(ROUND(-23797,'6588-01-08'),\nCOERCIBILITY(BIT_COUNT(RTRIM((~(\nINET6_NTOA(0xa04810f0839d318fa075bd)))))),\n((ST_ASWKT(1))OR(1))));)"
time="2024-05-06T18:06:50+08:00" level=warning msg="func_time:1330 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: WITH cte1 AS\n(SELECT(replace(md5(0x9025c5c7),\nconvert((1) using utf8),\n(!(cast((connection_id()) AS char(20)))))) AS a1 FROM t0022)\nSELECT cte1.a1\nFROM cte1 WHERE cte1.a1 = from_unixtime(1537000917);)"
./t/func_time.test: ok! 563 test cases passed, take time 1.039110995 s
./t/func_timestamp.test: ok! 8 test cases passed, take time 0.025252175 s
./t/func_uuid.test: ok! 64 test cases passed, take time 0.110226458 s
./t/filesort.test: ok! 54 test cases passed, take time 13.837220039 s
./t/filesort_json.test: ok! 16 test cases passed, take time 0.142309412 s
./t/filesort_merge.test: ok! 34 test cases passed, take time 0.431968709 s
./t/filter_single_col_idx_big.test: ok! 26 test cases passed, take time 0.122470113 s
./t/foreign_key.test: ok! 158 test cases passed, take time 1.5498040309999999 s
./t/function_defaults.test: ok! 319 test cases passed, take time 1.975503697 s
time="2024-05-06T18:06:53+08:00" level=warning msg="functional_index:77 query failed with non expected error(s)! (ErrDataOutOfRange != ER_WARN_DATA_OUT_OF_RANGE_FUNCTIONAL_INDEX) (err: Error 1690 (22003): DECIMAL value is out of range in '(2, 1)') (query: INSERT INTO t1 (f1) VALUES (CAST(1000 AS JSON));)"
time="2024-05-06T18:06:53+08:00" level=warning msg="functional_index:79 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\");)"
time="2024-05-06T18:06:53+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-06T18:06:53+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-06T18:06:53+08:00" level=warning msg="foreign_key1:173 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-06T18:06:53+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-06T18:06:53+08:00" level=warning msg="functional_index:110 query succeeded, but expected error(s)! (expected errors: ER_INTERNAL_ERROR) (query: ALTER TABLE t1 ADD COLUMN `!hidden!idx1!1!0` INT NOT NULL;)"
time="2024-05-06T18:06:53+08:00" level=warning msg="functional_index:120 query succeeded, but expected error(s)! (expected errors: ER_INTERNAL_ERROR) (query: ALTER TABLE t1 ADD COLUMN `!hidden!idx3!0!1` INT NOT NULL;)"
time="2024-05-06T18:06:54+08:00" level=warning msg="foreign_key1:337 query failed with non expected error(s)! (ErrFkDupName != 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-06T18:06:54+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-06T18:06:54+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-06T18:06:54+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-06T18:06:54+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-06T18:06:54+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-06T18:06:54+08:00" level=warning msg="functional_index:274 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-06T18:06:54+08:00" level=warning msg="functional_index:290 query failed with non expected error(s)! (ER_TABLE_MUST_HAVE_COLUMNS != ER_TABLE_MUST_HAVE_A_VISIBLE_COLUMN) (err: Error 1113 (42000): A table must have at least 1 column) (query: ALTER TABLE t DROP COLUMN x;)"
time="2024-05-06T18:06:54+08:00" level=warning msg="functional_index:324 query failed with non expected error(s)! (ER_BLOB_KEY_WITHOUT_LENGTH != ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED) (err: Error 1170 (42000): BLOB/TEXT column 'a1' used in key specification without a key length) (query: CREATE TABLE  table44 ( pk INTEGER AUTO_INCREMENT, a1 TEXT NOT NULL, b1\nDATETIME NOT NULL, c1 TIME NOT NULL, d1 BLOB NOT NULL, PRIMARY KEY (a1), KEY\n((VALUES(d1))));)"
time="2024-05-06T18:06:54+08:00" level=warning msg="functional_index:356 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_WRONG_ARGUMENTS) (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-06T18:06:54+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=489
time="2024-05-06T18:06:54+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-06T18:06:54+08:00" level=warning msg="command not implemented" arguments=" $conA <conA>" command=replace_result line=514
time="2024-05-06T18:06:54+08:00" level=warning msg="command not implemented" arguments=" set @conA_id = $conA" command=eval line=515
time="2024-05-06T18:06:54+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=521
time="2024-05-06T18:06:55+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);)"
Aborted by Jenkins Admin
Sending interrupt signal to process
Killing processes
time="2024-05-06T18:06:54+08:00" level=warning msg="functional_index:410 query failed with non expected error(s)! (ER_FUNCTIONAL_INDEX_FUNCTION_IS_NOT_ALLOWED != ER_FUNCTIONAL_INDEX_ON_LOB) (err: Error 3758 (HY000): Expression of expression index 'expression_index' contains a disallowed function) (query: CREATE TABLE t1 (\ncol4 TEXT NOT NULL\n, INDEX ((ST_AsBinary(col4)))\n);)"
./t/foreign_key1.test: ok! 207 test cases passed, take time 2.045030247 s
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:63 query failed with non expected error(s)! (ER_ROW_IS_REFERENCED_2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:94 query failed with non expected error(s)! (ER_ROW_IS_REFERENCED_2 not in ER_[planner:1451]Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (err: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t3`, CONSTRAINT `fk_5` FOREIGN KEY (`id`) REFERENCES `t2` (`id`))) (query: delete from t1 where id = 1;)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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;)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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;)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
./t/join_outer.test: ok! 867 test cases passed, take time 5.552754107 s
tidb-server(PID: 2383) stopped
script returned exit code 143
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:286 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:327 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:368 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:385 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+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-06T18:06:55+08:00" level=warning msg="foreign_key_cascade_delete:449 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+08:00" level=warning msg="foreign_key_cascade_delete:495 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
./t/functional_index.test: ok! 181 test cases passed, take time 3.072978975 s
time="2024-05-06T18:06:55+08:00" level=warning msg="gcol_alter_table:20 Unknown named --error "
time="2024-05-06T18:06:55+08:00" level=warning msg="gcol_alter_table:20 query failed with non expected error(s)! (ER_DEPENDENT_BY_GENERATED_COLUMN != ) (err: Error 3108 (HY000): Column 'c2' has a generated column dependency.) (query: alter table t drop c2;)"
time="2024-05-06T18:06:55+08:00" level=warning msg="gcol_alter_table:22 Unknown named --error "
time="2024-05-06T18:06:55+08:00" level=warning msg="gcol_alter_table:22 query failed with non expected error(s)! (ER_DEPENDENT_BY_GENERATED_COLUMN != ) (err: Error 3108 (HY000): Column 'c2' has a generated column dependency.) (query: alter table t change c2 c6 int generated always as (c1 + 1) stored;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:36 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:36 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t modify column b int generated always as (a + 1) virtual;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:38 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:38 query failed with non expected error(s)! (ErrUnsupportedOnGeneratedColumn != ) (err: Error 3106 (HY000): 'modifying a stored column' is not supported for generated columns.) (query: alter table t modify column b int generated always as (a + 1) stored;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:40 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:40 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t change column b b1 int generated always as (a + 1) virtual;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:42 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:42 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'modifying a stored column' is not supported for generated columns.) (query: alter table t change column b b1 int generated always as (a + 1) stored;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:44 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:44 query failed with non expected error(s)! (ErrUnsupportedOnGeneratedColumn != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t modify column c int generated always as (a + 1) virtual;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:46 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:46 query failed with non expected error(s)! (ErrUnsupportedOnGeneratedColumn != ) (err: Error 3106 (HY000): 'modifying a stored column' is not supported for generated columns.) (query: alter table t modify column c int generated always as (a + 1) stored;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:48 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:48 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t change column c c1 int generated always as (a + 1) virtual;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:50 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:50 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'modifying a stored column' is not supported for generated columns.) (query: alter table t change column c c1 int generated always as (a + 1) stored;)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
time="2024-05-06T18:06:55+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;)"
tidb-server(PID: 2269) stopped
script returned exit code 143
time="2024-05-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+08:00" level=warning msg="foreign_key_cascade_delete:535 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-06T18:06:56+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-06T18:06:56+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-06T18:06:56+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-06T18:06:56+08:00" level=warning msg="gcol_alter_table:63 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:63 query failed with non expected error(s)! (ErrUnsupportedOnGeneratedColumn != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t modify column b int;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:65 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:65 query failed with non expected error(s)! (ErrUnsupportedOnGeneratedColumn != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t modify column c int;)"
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:67 Unknown named --error "
time="2024-05-06T18:06:56+08:00" level=warning msg="gcol_alter_table:67 query failed with non expected error(s)! (ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN != ) (err: Error 3106 (HY000): 'Changing the STORED status' is not supported for generated columns.) (query: alter table t change column b b1 int;)"
tidb-server(PID: 2308) stopped
script returned exit code 143
kill finished with exit code 0
tidb-server(PID: 2328) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] }
[Pipeline] }
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] // cache
[Pipeline] // cache
[Pipeline] }
[Pipeline] }
[Pipeline] }
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
[Pipeline] // dir
[Pipeline] // dir
Post stage
Post stage
Post stage
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Pipeline] junit
Recording test results
[Pipeline] junit
Recording test results
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Checks API] No suitable checks publisher found.
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] }
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] // timeout
[Pipeline] }
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // stage
[Pipeline] // stage
[Pipeline] }
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] // container
[Pipeline] }
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // node
[Pipeline] // node
[Pipeline] }
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // withEnv
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // stage
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '1'
[Pipeline] }
Failed in branch Matrix - PART = '3'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh ABORTED result.json
http://fileserver.pingcap.net
--2024-05-06 10:07:03--  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%  570M=0s

2024-05-06 10:07:03 (570 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

No junit report file
parse result file result.json success
upload data succesfully.
[Pipeline] }
[Pipeline] // container
[Pipeline] archiveArtifacts
Archiving artifacts
Recording fingerprints
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
org.jenkinsci.plugins.workflow.actions.ErrorAction$ErrorId: 2d7bae36-3860-4a5a-a19d-a8b41fdb7509
Failed in branch Matrix - PART = '4'
Finished: ABORTED