Skipping 991 KB.. Full Log

[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
time="2024-05-07T07:45:10+08:00" level=error msg="open db failed Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked., take time 502.695326ms"
time="2024-05-07T07:45:10+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT" command=replace_result line=71
time="2024-05-07T07:45:10+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked."
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2024-05-07T07:45:10+08:00" level=error msg="open db failed Error 3118 (HY000): Access denied for user 'unlocked_user'@'::1'. Account is locked., take time 501.404279ms"
./t/grant_user_lock.test: ok! 27 test cases passed, take time 1.74987414 s
time="2024-05-07T07:45:11+08:00" level=warning msg="view:6298 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'x12345678901234567890123456789012345678901234567890123456789012322' is too long) (query: CREATE OR REPLACE VIEW v1\n(`x12345678901234567890123456789012345678901234567890123456789012322`) AS\nSELECT fld1 FROM t1;)"
./t/view.test: ok! 1458 test cases passed, take time 16.600029619 s
time="2024-05-07T07:45:11+08:00" level=warning msg="view_grant:48 query succeeded, but expected error(s)! (expected errors: ER_TABLEACCESS_DENIED_ERROR) (query: create or replace view v1 as select * from mysqltest.t1;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:219 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select c from mysqltest.v3;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:223 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select c from mysqltest.v4;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:369 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't2') (query: create view v3 as select a from mysqltest.t2;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:607 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v3;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:609 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v4;)"
time="2024-05-07T07:45:12+08:00" level=warning msg="view_grant:611 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v5;)"
time="2024-05-07T07:45:13+08:00" level=warning msg="view_grant:811 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'view_grant.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v;)"
time="2024-05-07T07:45:13+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK" command=replace_result line=825
./t/join.test: ok! 583 test cases passed, take time 10.116963325 s
./t/join_crash.test: ok! 36 test cases passed, take time 0.289110347 s
time="2024-05-07T07:45:13+08:00" level=warning msg="view_grant:966 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2024-05-07T07:45:13+08:00" level=warning msg="view_grant:971 query failed with non expected error(s)! (ErrViewInvalid != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
./t/group_min_max_innodb.test: ok! 132 test cases passed, take time 2.5830909159999997 s
time="2024-05-07T07:45:13+08:00" level=warning msg="command not implemented" arguments=" include/have_ps_protocol.inc" command=source line=8
./t/group_min_max_ps_protocol.test: ok! 22 test cases passed, take time 0.214023025 s
time="2024-05-07T07:45:13+08:00" level=warning msg="groupby:32 query failed with non expected error(s)! (ErrUnknown != ER_BAD_FIELD_ERROR) (err: Error 1105 (HY000): Unknown column '3' in 'group statement') (query: select * from t group by 3 order by c1;)"
time="2024-05-07T07:45:13+08:00" level=warning msg="groupby:36 query failed with non expected error(s)! (ErrWrongGroupField != ER_INVALID_GROUP_FUNC_USE) (err: Error 1056 (42000): Can't group on 'count(c1)') (query: select count(c1) from t group by 1 order by c1;)"
time="2024-05-07T07:45:13+08:00" level=warning msg="groupby:54 query succeeded, but expected error(s)! (expected errors: ER_NON_UNIQ_ERROR) (query: select c1 as c2, c2 from t group by c2 + 1 order by c1;)"
./t/groupby.test: ok! 99 test cases passed, take time 0.251743494 s
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1103 query succeeded, but expected error(s)! (expected errors: ER_SPECIFIC_ACCESS_DENIED_ERROR) (query: SHOW CREATE VIEW v2;)"
./t/join_nested_bka.test: ok! 28 test cases passed, take time 0.49864284 s
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1179 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v12 AS SELECT c1, c2 FROM mysqltest1.t1, mysqltest1.t2;)"
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1184 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v21 AS SELECT c2, c1 FROM mysqltest1.t2, mysqltest1.t1;)"
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1186 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v23 AS SELECT c2, c3 FROM mysqltest1.t2, mysqltest1.t3;)"
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1188 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v24 AS SELECT c2, c4 FROM mysqltest1.t2, mysqltest1.t4;)"
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1192 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v32 AS SELECT c3, c2 FROM mysqltest1.t3, mysqltest1.t2;)"
time="2024-05-07T07:45:14+08:00" level=warning msg="view_grant:1197 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v42 AS SELECT c4, c2 FROM mysqltest1.t4, mysqltest1.t2;)"
./t/join_nested_bka_nobnl.test: ok! 28 test cases passed, take time 0.499013694 s
time="2024-05-07T07:45:15+08:00" level=warning msg="view_grant:1483 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="view_grant:1541 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="view_grant:1552 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="view_grant:1575 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v1;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=123
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=126
time="2024-05-07T07:45:15+08:00" level=warning msg="having:258 query succeeded, but expected error(s)! (expected errors: 1064) (query: select sum(col1) as co2, count(col2) as cc from t1 group by col1 having col1 =10;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="having:268 query succeeded, but expected error(s)! (expected errors: 1054) (query: select t1.col1 from t1\nwhere t1.col2 in\n(select t2.col2 from t2\ngroup by t2.col1, t2.col2 having t2.col1 <= 10);)"
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=313
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=320
time="2024-05-07T07:45:15+08:00" level=warning msg="having:359 query failed with non expected error(s)! (ErrBadField != 1052) (err: Error 1054 (42S22): Unknown column 'col1' in 'having clause') (query: select t1.col1*10+t2.col1 from t1,t2 where t1.col1=t2.col1\ngroup by t1.col1, t2.col1 having col1 = 2;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=371
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=373
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=467
time="2024-05-07T07:45:15+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=469
time="2024-05-07T07:45:15+08:00" level=warning msg="having:473 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'f1'; this is incompatible with sql_mode=only_full_group_by) (query: select f1 from t1 having max(f1)=f1;)"
time="2024-05-07T07:45:15+08:00" level=warning msg="view_grant:1910 query failed with non expected error(s)! (ErrUnsupportedOp != ER_NO_SUCH_USER) (err: Error 8040 (HY000): operation not supported) (query: LOCK TABLES v1 READ;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:1979 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser1'@'%' for table 't2') (query: SELECT * FROM v2_uses_t2;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:1986 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser2'@'%' for table 't1') (query: SELECT * FROM v2_uses_t1;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=400
time="2024-05-07T07:45:16+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-07T07:45:16+08:00" level=warning msg="view_grant:2125 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v1 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v1_merge as v1 set v1.val= 'test5'\nwhere t2.id= v1.id;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2149 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v11 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v11_merge as v11 set v11.val= 'test11'\nwhere t2.id= v11.id;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2177 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v3 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest2.v3_merge as v3 set v3.val= 'test17'\nwhere t2.id= v3.id;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v4 of the UPDATE is not updatable) (query: update mysqltest1.t11 as t11, mysqltest2.v41 as v4 set v4.val= 'test20'\nwhere t11.id= v4.id;)"
time="2024-05-07T07:45:16+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2955 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2959 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-07T07:45:16+08:00" level=warning msg="view_grant:2962 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE IGNORE test1.v1_all SET cn='x';)"
./t/view_grant.test: ok! 719 test cases passed, take time 5.221612347 s
time="2024-05-07T07:45:16+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-07T07:45:16+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:36 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 values (1,2);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:38 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 select * from t2;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:41 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_MULTIUPDATE) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3(a,b) values (1,2);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:43 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_MULTIUPDATE) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3(a,b) select * from t2;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:56 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete from v3;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:58 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete v3,t1 from v3,t1;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:60 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete t1,v3 from t1,v3;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:122 query failed with non expected error(s)! (ErrNoSuchTable != ER_TOO_MANY_FIELDS) (err: Error 1146 (42S02): Table 'view_myisam.t1' doesn't exist) (query: CREATE VIEW view_broken AS SELECT * FROM t1, t2, t3;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="view_myisam:126 query failed with non expected error(s)! (ErrUnknown != ER_TOO_MANY_FIELDS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE table_broken AS SELECT * FROM t1, t2, t3;)"
./t/view_myisam.test: ok! 31 test cases passed, take time 0.251721802 s
time="2024-05-07T07:45:17+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=111
./t/warnings.test: ok! 74 test cases passed, take time 0.349054954 s
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:122 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:133 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:143 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:209 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE) (query: SELECT '---',\nHEX(BIT_OR(b) OVER w) AS `OR`,\nHEX(BIT_AND(b) OVER w) AS `AND`,\nHEX(BIT_XOR(b) OVER w) AS `XOR`,\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS BETWEEN 1 PRECEDING AND CURRENT ROW);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:365 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:376 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:17+08:00" level=warning msg="window_bitwise_ops:386 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-07T07:45:18+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2024-05-07T07:45:18+08:00" level=warning msg="window_bitwise_ops:452 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE) (query: SELECT '---',\nHEX(BIT_OR(b) OVER w) AS `OR`,\nHEX(BIT_AND(b) OVER w) AS `AND`,\nHEX(BIT_XOR(b) OVER w) AS `XOR`,\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS BETWEEN 1 PRECEDING AND CURRENT ROW);)"
time="2024-05-07T07:45:18+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=462
./t/having.test: ok! 273 test cases passed, take time 3.599005182 s
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-07T07:45:17+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/having_myisam.test: ok! 17 test cases passed, take time 0.338022541 s
./t/window_bitwise_ops.test: ok! 77 test cases passed, take time 0.460926987 s
time="2024-05-07T07:45:18+08:00" level=warning msg="window_functions:102 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT a, SUM(b) OVER () FROM tb GROUP BY a; # illegal b reference\nDROP TABLE tb;)"
time="2024-05-07T07:45:18+08:00" level=warning msg="window_functions:120 query failed with non expected error(s)! (ER_ILLEGAL_REFERENCE != ER_WRONG_GROUP_FIELD) (err: Error 1247 (42S22): Reference 'x' not supported (reference to window function)) (query: SELECT i/SUM(j) OVER (PARTITION BY k) AS x FROM t GROUP BY x;)"
time="2024-05-07T07:45:18+08:00" level=warning msg="window_functions:257 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: SELECT id, FIRST_VALUE(id) OVER w first, LAST_VALUE(id) OVER w last, sex FROM t1\nWINDOW w AS (PARTITION BY sex\nORDER BY id ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING);)"
time="2024-05-07T07:45:18+08:00" level=warning msg="window_functions:585 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT id, SUM(SUM(id)) OVER (ORDER BY sex ROWS UNBOUNDED PRECEDING) FROM t1,t2 WHERE t1.id=t2.user_id GROUP BY sex;)"
time="2024-05-07T07:45:18+08:00" level=warning msg="window_functions:587 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT SUM(id) OVER (ORDER BY sex ROWS UNBOUNDED PRECEDING) FROM t1,t2 WHERE t1.id=t2.user_id GROUP BY sex;)"
time="2024-05-07T07:45:18+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=53
time="2024-05-07T07:45:18+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=55
time="2024-05-07T07:45:18+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=58
time="2024-05-07T07:45:19+08:00" level=warning msg="window_functions:1552 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(s1), RANK() OVER (ORDER BY s1) FROM t1;)"
time="2024-05-07T07:45:19+08:00" level=warning msg="window_functions:1612 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (row_number() over ());)"
time="2024-05-07T07:45:19+08:00" level=warning msg="window_functions:1614 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (1+row_number() over ());)"
time="2024-05-07T07:45:19+08:00" level=warning msg="window_functions:1630 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_ILLEGAL_ORDER_BY) (query: SELECT RANK() OVER (ORDER BY 1) FROM t;)"
./t/heap_btree.test: ok! 147 test cases passed, take time 2.005050203 s
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:1937 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a IN (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
./t/heap_btree_myisam.test: ok! 12 test cases passed, take time 0.201641698 s
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:1944 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a > ANY (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:1948 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a > ALL (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:1962 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: select * from t1 AS upper where i+1\nIN (select row_number() over () + upper.i from t1 );)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2032 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(c))  FROM t;)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2048 query failed with non expected error(s)! (ErrBadField != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2050 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT 1+SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2056 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT 1 + (SELECT c FROM DUAL))  FROM t;)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2058 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT 1+SUM(a) OVER () AS c, (SELECT 1 + (SELECT c FROM DUAL))  FROM t;)"
time="2024-05-07T07:45:20+08:00" level=warning msg="window_functions:2079 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(a), SUM(a) OVER () FROM t;)"
time="2024-05-07T07:45:21+08:00" level=warning msg="window_functions:2398 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT COUNT(*) AS count,\nROW_NUMBER() OVER (ORDER BY b) AS rn\nFROM t ORDER BY b;)"
./t/histogram_singleton.test: ok! 266 test cases passed, take time 1.269218776 s
time="2024-05-07T07:45:21+08:00" level=warning msg="window_functions:2585 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL (SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
time="2024-05-07T07:45:21+08:00" level=warning msg="window_functions:2587 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE BETWEEN INTERVAL 1 MINUTE PRECEDING AND INTERVAL (SELECT a FROM t2) MINUTE FOLLOWING) FROM t1;)"
time="2024-05-07T07:45:21+08:00" level=warning msg="window_functions:2589 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL 1+(SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
time="2024-05-07T07:45:21+08:00" level=warning msg="ignore_strict:103 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
time="2024-05-07T07:45:22+08:00" level=warning msg="ignore_strict:346 query failed with non expected error(s)! (ErrUnknown != ER_NO_DEFAULT_FOR_VIEW_FIELD) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: INSERT INTO v1 (vcol1) VALUES(12);)"
time="2024-05-07T07:45:22+08:00" level=warning msg="ignore_strict:391 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00') (query: INSERT INTO t1 VALUES(STR_TO_DATE('32.10.2004 15.30','%D.%D.%Y %H.%I'));)"
time="2024-05-07T07:45:22+08:00" level=warning msg="ignore_strict:412 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-07T07:45:22+08:00" level=warning msg="ignore_strict:417 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-07T07:45:23+08:00" level=warning msg="ignore_strict:439 query failed with non expected error(s)! (ErrTruncatedWrongValueForField != 1265) (err: Error 1366 (HY000): Incorrect tinyint value: '1a' for column 'a' at row 1) (query: INSERT INTO t1 VALUES ('1a');)"
time="2024-05-07T07:45:23+08:00" level=warning msg="ignore_strict:460 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_WARN_NULL_TO_NOTNULL) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/wl6030_2.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/wl6030_2.dat' INTO TABLE t1 FIELDS TERMINATED BY ',' ENCLOSED BY '\"';)"
time="2024-05-07T07:45:23+08:00" level=warning msg="window_functions:3523 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_FRAME_ILLEGAL) (query: EXECUTE stmt USING @p1;)"
time="2024-05-07T07:45:23+08:00" level=warning msg="window_functions:3700 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i) FROM t1 WINDOW w AS (ORDER BY i);)"
time="2024-05-07T07:45:23+08:00" level=warning msg="window_functions:3702 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 'i'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT AVG(i), RANK() OVER (ORDER BY i) FROM t1;)"
time="2024-05-07T07:45:23+08:00" level=warning msg="window_functions:3704 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i) FROM t1 ORDER BY RANK() OVER (PARTITION BY AVG(i) ORDER BY i);)"
time="2024-05-07T07:45:23+08:00" level=warning msg="window_functions:3706 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i), RANK() OVER w FROM t1 WINDOW w AS (ORDER BY i);)"
./t/window_functions.test: ok! 1303 test cases passed, take time 5.096614386 s
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=4
time="2024-05-07T07:45:23+08:00" level=warning msg="ignore_strict:486 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
time="2024-05-07T07:45:23+08:00" level=warning msg="ignore_strict:624 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_DUP_ENTRY) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/rpl_loaddata.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t2 (a, @b) SET b= @b + 2;)"
./t/ignore_strict.test: ok! 157 test cases passed, take time 1.6485861769999999 s
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=25
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=44
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=61
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=76
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=91
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=106
time="2024-05-07T07:45:23+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=121
time="2024-05-07T07:45:24+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=136
time="2024-05-07T07:45:24+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=151
time="2024-05-07T07:45:24+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=166
./t/window_functions_big.test: ok! 33 test cases passed, take time 0.6664937 s
./t/implicit_char_to_num_conversion.test: ok! 110 test cases passed, take time 0.685094749 s
./t/in.test: ok! 13 test cases passed, take time 0.030293427 s
./t/index.test: ok! 33 test cases passed, take time 0.256550363 s
time="2024-05-07T07:45:24+08:00" level=warning msg="window_functions_bugs:619 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_ARRAY(FIRST_VALUE(CAST('' AS JSON)) OVER (), '');)"
time="2024-05-07T07:45:24+08:00" level=warning msg="window_functions_bugs:621 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_ARRAY(NTH_VALUE(CAST('' AS JSON), 1) OVER (), '');)"
time="2024-05-07T07:45:24+08:00" level=warning msg="window_functions_bugs:623 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_ARRAY(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2024-05-07T07:45:24+08:00" level=warning msg="window_functions_bugs:625 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_ARRAY(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '');)"
./t/window_functions_bugs.test: ok! 157 test cases passed, take time 0.816033416 s
time="2024-05-07T07:45:24+08:00" level=warning msg="command not implemented" arguments=" include/have_hypergraph.inc  # Only supported by the hypergraph join optimizer." command=source line=8
./t/window_functions_interesting_orders.test: ok! 27 test cases passed, take time 0.466329185 s
./t/window_min_max.test: ok! 200 test cases passed, take time 0.499571652 s
time="2024-05-07T07:45:25+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2024-05-07T07:45:25+08:00" level=warning msg="command not implemented" arguments=" (0)\n{\nSELECT (WITH qn AS (SELECT t2.a*a as a FROM t1),\nqn2 AS (SELECT 3*a AS b FROM qn)\nSELECT * from qn2 LIMIT 1)\nFROM t2 as t1;" command=if line=107
time="2024-05-07T07:45:25+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2024-05-07T07:45:26+08:00" level=warning msg="with_non_recursive:692 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-07T07:45:26+08:00" level=warning msg="with_non_recursive:694 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ no_merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2024-05-07T07:45:26+08:00" level=warning msg="with_non_recursive:711 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: select * from t1;)"
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2024-05-07T07:45:26+08:00" level=warning msg="with_non_recursive:761 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: select * from t1;)"
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2024-05-07T07:45:26+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=796
./t/with_non_recursive.test: ok! 180 test cases passed, take time 0.97455595 s
./t/join_outer.test: ok! 867 test cases passed, take time 12.497734145999999 s
./t/json.test: ok! 82 test cases passed, take time 0.877436304 s
time="2024-05-07T07:45:28+08:00" level=warning msg="json_agg:184 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION json_agg.st_pointfromtext does not exist) (query: SELECT JSON_ARRAYAGG(ST_PointFromText('POINT(10 10)')) FROM t2;)"
./t/with_non_recursive_bugs.test: ok! 102 test cases passed, take time 1.975788876 s
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2024-05-07T07:45:28+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=583
./t/with_recursive.test: ok! 86 test cases passed, take time 0.352370948 s
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 0.380511154 s
./t/json_agg.test: ok! 177 test cases passed, take time 1.125048771 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.035418664 s
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2024-05-07T07:45:29+08:00" level=warning msg="command not implemented" arguments= command=single_query line=49
./t/xd.test: ok! 7 test cases passed, take time 0.172254022 s
./t/year_innodb.test: ok! 51 test cases passed, take time 0.19541067 s
time="2024-05-07T07:45:30+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
time="2024-05-07T07:45:30+08:00" level=warning msg="json_ddl:70 query succeeded, but expected error(s)! (expected errors: ER_INVALID_JSON_TEXT) (query: ALTER TABLE t4 MODIFY COLUMN jj JSON;)"
./t/json_ddl.test: ok! 40 test cases passed, take time 1.117527242 s
time="2024-05-07T07:45:30+08:00" level=warning msg="json_functions:133 Unknown named --error Incorrect parameter count"
time="2024-05-07T07:45:30+08:00" level=warning msg="json_functions:133 query failed with non expected error(s)! (ErrWrongParamcountToNativeFct != Incorrect parameter count) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'json_object') (query: SELECT JSON_OBJECT( 87, 'name', 'carrot');)"
time="2024-05-07T07:45:30+08:00" level=warning msg="json_functions:135 Unknown named --error JSON documents may not contain NULL"
time="2024-05-07T07:45:30+08:00" level=warning msg="json_functions:135 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != JSON documents may not contain NULL) (err: Error 1105 (HY000): JSON documents may not contain NULL member names) (query: SELECT JSON_OBJECT(NULL, 'carrot');)"
./t/json_functions.test: ok! 784 test cases passed, take time 1.316745522 s
time="2024-05-07T07:45:32+08:00" level=warning msg="json_gcol:23 query failed with non expected error(s)! (ErrTruncatedWrongValueForField != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{}');)"
time="2024-05-07T07:45:32+08:00" level=warning msg="json_gcol:25 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '{\"a\": 1}' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('{\"a\":1}');)"
time="2024-05-07T07:45:32+08:00" level=warning msg="json_gcol:27 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != ER_INVALID_JSON_VALUE_FOR_CAST) (err: Error 1366 (HY000): Incorrect int value: '\"abc\"' for column 'gc' at row 1) (query: INSERT INTO t(j) VALUES ('\"abc\"');)"
./t/json_gcol.test: ok! 94 test cases passed, take time 0.560526206 s
./t/json_group_concat_innodb.test: ok! 40 test cases passed, take time 0.190814945 s
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:19 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:19 query failed with non expected error(s)! (ErrInvalidJSONText != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:26 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:26 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert t1 values ('a');)"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:43 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:43 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_CONSTRAINT_FAILED) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: create table t2 (t json) select t from t1;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:51 Unknown named --error ER_CONSTRAINT_FAILED"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:51 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_CONSTRAINT_FAILED) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: insert into t1 values (\"xxx\");)"
time="2024-05-07T07:45:33+08:00" level=warning msg="json_type:59 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_PARSE_ERROR) (err: Error 3140 (22032): Invalid JSON text: The document root must not be followed by other values.) (query: select cast('{a:1}' as json);)"
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=76
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=77
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=80
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=81
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=89
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=90
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=92
time="2024-05-07T07:45:33+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=93
./t/json_type.test: ok! 45 test cases passed, take time 0.493314047 s
time="2024-05-07T07:45:33+08:00" level=warning msg="sub_query_more:969 query succeeded, but expected error(s)! (expected errors: ER_INVALID_GROUP_FUNC_USE) (query: SELECT SUM( (SELECT AVG( (SELECT t1.a FROM t2) ) FROM DUAL) ) FROM t1;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="sub_query_more:972 query succeeded, but expected error(s)! (expected errors: ER_INVALID_GROUP_FUNC_USE) (query: SELECT\nSUM( (SELECT AVG( (SELECT COUNT(*) FROM t1 t HAVING t1.a < 12) ) FROM t2) )\nFROM t1;)"
./t/sub_query_more.test: ok! 332 test cases passed, take time 3.211497553 s
time="2024-05-07T07:45:33+08:00" level=warning msg="role:59 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation GRANT ROLE failed for peter@clickhost.net) (query: GRANT role1 TO peter@clickhost.net;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="role:97 query failed with non expected error(s)! (ER_WARN_DA_PRIVILEGE_NOT_REGISTERED != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT SUPER, engineering ON *.* TO joan, sally;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="role:99 query failed with non expected error(s)! (ErrDynamicPrivilegeNotRegistered != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT engineering,SELECT ON *.* TO joan;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="role:153 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for `engineering_role`@`%`) (query: REVOKE engineering_role FROM foo@localhost;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="role:156 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for managers@%) (query: REVOKE engineering FROM managers;)"
time="2024-05-07T07:45:33+08:00" level=warning msg="role:262 query failed with non expected error(s)! (ER_DBACCESS_DENIED_ERROR != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1044 (42000): Access denied for user 'joe'@'localhost' to database 'mysql') (query: SHOW GRANTS FOR `root`@`localhost` USING `replication`;)"
time="2024-05-07T07:45:34+08:00" level=warning msg="role:397 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=1;)"
time="2024-05-07T07:45:34+08:00" level=warning msg="role:619 query failed with non expected error(s)! (ER_CANNOT_USER != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `rrrrr`@`%`) (query: SET DEFAULT ROLE `rrrrr` TO u1@localhost;)"
time="2024-05-07T07:45:34+08:00" level=warning msg="role:628 query failed with non expected error(s)! (ER_CANNOT_USER != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `asdasd`@`%`) (query: SET DEFAULT ROLE `asdasd` TO u1@localhost;)"
./t/role.test: ok! 340 test cases passed, take time 1.634335348 s
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:23 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:51 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:87 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:116 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:120 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="key:313 query failed with non expected error(s)! (ER_MULTIPLE_PRI_KEY != 1091) (err: Error 1068 (42000): Multiple primary key defined) (query: alter table t1 add primary key (c1, c2);)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:177 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:179 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:181 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_ACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON *.* TO u1@localhost;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:183 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u1@localhost;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:185 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.t1 TO u1@localhost;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:218 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:220 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:253 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:284 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:288 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:347 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:349 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:378 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:380 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:413 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:444 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:448 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="key:322 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: alter table t1 add index i3 (c3), add index i2 (c2), add unique index i1 (c1);)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:534 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u2@localhost;)"
time="2024-05-07T07:45:35+08:00" level=warning msg="role2:547 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `%db1`.* TO u2@localhost;)"
time="2024-05-07T07:45:36+08:00" level=warning msg="role2:556 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb%`.* TO u2@localhost;)"
time="2024-05-07T07:45:36+08:00" level=warning msg="role2:558 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.* TO u2@localhost;)"
time="2024-05-07T07:45:36+08:00" level=warning msg="role2:560 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.`t1` TO u2@localhost;)"
./t/role2.test: ok! 259 test cases passed, take time 1.049599328 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2347) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-8667/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/key.test: ok! 192 test cases passed, take time 4.436991149 s
./t/key_diff.test: ok! 10 test cases passed, take time 0.12441486 s
time="2024-05-07T07:45:40+08:00" level=warning msg="key_myisam:303 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: alter table t1 drop key k;)"
./t/key_myisam.test: ok! 123 test cases passed, take time 2.361952967 s
./t/key_primary.test: ok! 12 test cases passed, take time 0.05422627 s
./t/keywords.test: ok! 51 test cases passed, take time 0.428295443 s
time="2024-05-07T07:45:41+08:00" level=warning msg="lead_lag:49 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_PARSE_ERROR) (err: Error 1210 (HY000): Incorrect arguments to lead) (query: SELECT id, sex, LEAD(id, 1.2) RESPECT NULLS OVER () FROM t1;)"
./t/lead_lag.test: ok! 214 test cases passed, take time 0.845857813 s
./t/lead_lag_explain.test: ok! 81 test cases passed, take time 0.440023455 s
time="2024-05-07T07:45:40+08:00" level=warning msg="command not implemented" arguments=" ($merge_table_support)\n{" command=if line=486
./t/index_merge1.test: ok! 160 test cases passed, take time 17.818483674 s
./t/like.test: ok! 8 test cases passed, take time 0.01791391 s
time="2024-05-07T07:45:43+08:00" level=warning msg="limit:253 query failed with non expected error(s)! (ErrWrongArguments != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-07T07:45:43+08:00" level=warning msg="limit:256 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a;)"
time="2024-05-07T07:45:43+08:00" level=warning msg="limit:259 query failed with non expected error(s)! (ER_WRONG_ARGUMENTS != ER_DATA_OUT_OF_RANGE) (err: Error 1210 (HY000): Incorrect arguments to LIMIT) (query: execute s using @a, @a;)"
./t/limit.test: ok! 174 test cases passed, take time 1.142595277 s
./t/limit_myisam.test: ok! 5 test cases passed, take time 0.04249394 s
./t/long_tmpdir.test: ok! 3 test cases passed, take time 0.096397125 s
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=7
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=8
time="2024-05-07T07:45:44+08:00" level=warning msg="lowercase_fs_off:27 query failed with non expected error(s)! (ErrDBCreateExists != ER_DBACCESS_DENIED_ERROR) (err: Error 1007 (HY000): Can't create database 'D1'; database exists) (query: create database D1;)"
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=29
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=35
time="2024-05-07T07:45:44+08:00" level=warning msg="lowercase_fs_off:52 query succeeded, but expected error(s)! (expected errors: ER_TABLEACCESS_DENIED_ERROR) (query: select * from t1;)"
./t/lowercase_fs_off.test: ok! 22 test cases passed, take time 0.241137843 s
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=3
time="2024-05-07T07:45:44+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase1.inc" command=source line=4
./t/lowercase_mixed_tmpdir.test: ok! 8 test cases passed, take time 0.063009583 s
time="2024-05-07T07:45:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=98
time="2024-05-07T07:45:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=108
time="2024-05-07T07:45:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=115
time="2024-05-07T07:45:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=126
time="2024-05-07T07:45:45+08:00" level=warning msg="lowercase_table:144 query failed with non expected error(s)! (ErrNoSuchTable != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE mysql.general_log DISCARD TABLESPACE;)"
time="2024-05-07T07:45:45+08:00" level=warning msg="lowercase_table:146 query failed with non expected error(s)! (ErrNoSuchTable != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.general_log' doesn't exist) (query: ALTER TABLE MYSQL.general_log DISCARD TABLESPACE;)"
time="2024-05-07T07:45:45+08:00" level=warning msg="lowercase_table:148 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_BAD_LOG_STATEMENT) (err: Error 1146 (42S02): Table 'mysql.GENERAL_LOG' doesn't exist) (query: ALTER TABLE mysql.GENERAL_LOG DISCARD TABLESPACE;)"
./t/lowercase_table.test: ok! 72 test cases passed, take time 0.975819835 s
time="2024-05-07T07:45:45+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
./t/index_merge2.test: ok! 328 test cases passed, take time 3.507154143 s
time="2024-05-07T07:45:46+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-07T07:45:46+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=10
./t/index_merge_bug29952775.test: ok! 7 test cases passed, take time 0.056883469 s
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.143678228 s
./t/lowercase_table2.test: ok! 86 test cases passed, take time 1.565206731 s
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE `Table2`;" command=query_vertical line=81
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=82
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product_Order;" command=query_vertical line=109
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Product;" command=query_vertical line=110
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SHOW CREATE TABLE Customer;" command=query_vertical line=111
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS\nWHERE CONSTRAINT_SCHEMA != 'PERFORMANCE_SCHEMA';" command=query_vertical line=112
./t/lowercase_table4.test: ok! 31 test cases passed, take time 0.531252774 s
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" include/have_lowercase0.inc" command=source line=15
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" include/have_case_sensitive_file_system.inc" command=source line=16
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=28
time="2024-05-07T07:45:47+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=35
./t/lowercase_table5.test: ok! 12 test cases passed, take time 0.189977813 s
./t/lowercase_table_grant.test: ok! 15 test cases passed, take time 0.142544713 s
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1 --character-set-server=utf8" command=exec line=27
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --character-set-server=utf8 --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=30
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=31
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=32
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=44
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments= command=shutdown_server line=45
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=46
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" echo \"restart\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=50
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=51
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=52
./t/lowercase_utf8.test: ok! 6 test cases passed, take time 0.070776072 s
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" $MYSQLD $extra_args --initialize-insecure --datadir=$DDIR --init-file=$BOOTSTRAP_SQL --lower-case-table-names=1" command=exec line=22
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" echo \"restart: --datadir=$DDIR --no-console --log-error=$MYSQLD_LOG\" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect" command=exec line=25
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=26
time="2024-05-07T07:45:48+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=27
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:56 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v1Aa);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:58 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2Aa set col1 = (select max(col1) from t1Aa);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:60 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA set col1 = (select max(col1) from v2Aa);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:62 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:64 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:66 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:68 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from v1aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:70 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v1Aa) where t1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:72 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1aA set v1Aa.col1 = (select max(col1) from v1aA) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:74 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from t1aA) where v2aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:76 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t1Aa,t2Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:78 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from t1Aa) where v1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:80 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2Aa set v2aA.col1 = (select max(col1) from t1aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:82 query succeeded, but expected error(s)! (expected errors: 1093) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from t1Aa) where t1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:84 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from t1Aa) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:86 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1093) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update v2aA,t2Aa set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:88 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t1aA,t2Aa set t1Aa.col1 = (select max(col1) from v2aA) where t1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:90 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v2Aa) where v1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:92 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2aA set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:94 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v2aA) where t1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:96 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from v2Aa) where v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:98 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v1aA);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:100 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from t1aA);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:102 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v2aA);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:104 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v3aA);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:106 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v1Aa);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:108 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete from v2aA where col1 = (select max(col1) from t1Aa);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:110 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v2aA);)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:112 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v1aA) > 0 and v2Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:114 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from v1Aa) > 0 and t1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:116 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from v1aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:118 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete v2aA from v2Aa,t2Aa where (select max(col1) from t1Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:120 query succeeded, but expected error(s)! (expected errors: 1093) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from t1aA) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:122 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from t1aA) > 0 and v1aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:124 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v2Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:126 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1Aa from t1aA,t2Aa where (select max(col1) from v2Aa) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:128 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v1Aa is not supported now) (query: delete v1Aa from v1aA,t2Aa where (select max(col1) from v2aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:130 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v1aA));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:132 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1aA values ((select max(col1) from v1Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:134 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v1aA));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:136 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from t1Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:138 query succeeded, but expected error(s)! (expected errors: 1093) (query: insert into t1aA values ((select max(col1) from t1Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:140 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from t1aA));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:142 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v2aA));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:144 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1Aa values ((select max(col1) from v2Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:146 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v2Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:148 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v1Aa));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:150 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3aA (col1) values ((select max(col1) from t1aA));)"
time="2024-05-07T07:45:48+08:00" level=warning msg="lowercase_view:152 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v2aA));)"
time="2024-05-07T07:45:49+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=176
time="2024-05-07T07:45: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=190
./t/lowercase_view.test: ok! 83 test cases passed, take time 0.76576747 s
./t/lpad.test: ok! 26 test cases passed, take time 0.008405064 s
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:389 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:389 query failed with non expected error(s)! (ErrViewWrongList != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect * from t2,t where t2.c=t.f1;)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:397 Unknown named --error ER_DUP_QUERY_NAME"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:397 query failed with non expected error(s)! (ErrNonuniqTable != ER_DUP_QUERY_NAME) (err: Error 1066 (42000): Not unique table/alias: '%-.192s') (query: with t as (select * from t2 where c>3),\nt as (select a from t1 where a>2)\nselect * from t,t1 where t1.a=t.c;)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:408 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:408 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive t as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:414 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:414 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:421 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:421 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from t1\nwhere a in (select c from s where b<='ccc') and  b>'b'),\ns as (select * from t1,t2\nwhere t1.a=t2.c and t1.c in (select a from t where a<5))\nselect * from s where s.b>'aaa';)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:429 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:429 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_UNION != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 3573 (HY000): Recursive Common Table Expression 's' should contain a UNION) (query: with recursive\nt as (select * from t1 where b>'aaa' and b <='d')\nselect t.b from t,t2\nwhere t.a=t2.c and\nt2.c in (with recursive\ns as (select t1.a from s,t1 where t1.a=s.a and t1.b<'c')\nselect * from s);)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:461 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:461 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2024-05-07T07:45:49+08:00" level=warning msg="mariadb_cte_nonrecursive:467 query succeeded, but expected error(s)! (expected errors: ER_DUP_FIELDNAME) (query: with t(f1,f1) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2024-05-07T07:45:50+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=107
time="2024-05-07T07:45:50+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-07T07:45:50+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=741
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=742
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=769
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=770
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=800
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=817
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=834
time="2024-05-07T07:45:51+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=852
time="2024-05-07T07:45:52+08:00" level=warning msg="command not implemented" arguments=" |;" command=delimiter line=1297
time="2024-05-07T07:45:52+08:00" level=warning msg="command not implemented" arguments=" ;|\ndrop table t1,t2;" command=delimiter line=1299
./t/mariadb_cte_nonrecursive.test: ok! 382 test cases passed, take time 3.269679413 s
time="2024-05-07T07:45:52+08:00" level=warning msg="command not implemented" arguments=" include/default_optimizer_switch.inc" command=source line=2
time="2024-05-07T07:45:52+08:00" level=warning msg="mariadb_cte_recursive:11 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T07:45:52+08:00" level=warning msg="mariadb_cte_recursive:11 query failed with non expected error(s)! (ErrNoSuchTable != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.r' doesn't exist) (query: with recursive\nt as\n(\nselect * from t1 where t1.b >= 'c'\nunion\nselect * from r\n),\nr as\n(\nselect * from t\nunion\nselect t1.* from t1,r where r.a+1 = t1.a\n)\nselect * from r;)"
time="2024-05-07T07:45:52+08:00" level=warning msg="mariadb_cte_recursive:28 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T07:45:52+08:00" level=warning msg="mariadb_cte_recursive:28 query failed with non expected error(s)! (ErrNoSuchTable != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.b1' doesn't exist) (query: with recursive\na1(a,b) as\n(select * from t1 where t1.a>3\nunion\nselect * from b1 where b1.a >3\nunion\nselect * from c1 where c1.a>3),\nb1(a,b) as\n(select * from a1 where a1.b > 'ccc'\nunion\nselect * from c1 where c1.b > 'ddd'),\nc1(a,b) as\n(select * from a1 where a1.a<6 and a1.b< 'zz'\nunion\nselect * from b1 where b1.b > 'auu')\nselect * from c1;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:284 query succeeded, but expected error(s)! (expected errors: 1112) (query: with recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me' and dob = '2000-01-01'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect *\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id);)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:304 query succeeded, but expected error(s)! (expected errors: 1112) (query: with\nancestor_couples(husband, h_dob, wife, w_dob)\nas\n(\nwith recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect t1.name, t1.dob, t2.name, t2.dob\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id)\n)\nselect * from ancestor_couples;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:753 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:753 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me' and  father is not null\nunion all\nselect mother, 1 from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:772 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:772 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father from folks where name = 'Me' and  father is not null\nunion all\nselect mother from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:810 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:810 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_SINGLE_REFERENCE != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'coupled_ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\ncoupled_ancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me' and father is not null\nunion\nselect mother from folks where name = 'Me' and mother is not null\nunion\nselect n.father\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\nunion\nselect n.mother\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\n)\nselect p.* from coupled_ancestor_ids a, folks p\nwhere a.id = p.id;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:858 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:858 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDDEN_JOIN_ORDER != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3576 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints) (query: with recursive\nancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me'\nunion\nselect mother from folks where name = 'Me'\nunion\nselect father from folks left join ancestor_ids a on folks.id = a.id\nunion\nselect mother from folks left join ancestor_ids a on folks.id = a.id\n),\nancestors\nas\n(\nselect p.* from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:923 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2024-05-07T07:45:53+08:00" level=warning msg="mariadb_cte_recursive:923 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDS_AGGREGATION != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3575 (HY000): Recursive Common Table Expression 'ancestor_ids' can contain neither aggregation nor window functions in recursive query block) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me'\nunion\nselect mother, 1 from folks where name = 'Me'\nunion\nselect max(father), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\nunion\nselect max(mother), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\n),\nancestors\nas\n(\nselect generation, name from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2024-05-07T07:45:54+08:00" level=warning msg="mariadb_cte_recursive:1518 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 1064) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.applied_modules' doesn't exist) (query: with recursive\nreached_values as\n(\nselect v from value_nodes where v in ('v3','v7','v9')\nunion\nselect module_results.v from module_results, applied_modules\nwhere module_results.m = applied_modules.m\n),\napplied_modules as\n(\nselect module_nodes.m\nfrom\nmodule_nodes\nleft join\n(\nmodule_arguments\nleft join\nreached_values\non module_arguments.v = reached_values.v\n)\non reached_values.v is null and\nmodule_nodes.m = module_arguments.m\nwhere module_arguments.m is null\n)\nselect * from reached_values;)"
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q1;" command=eval line=1771
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=1772
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q2;" command=eval line=1774
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=1775
time="2024-05-07T07:45:55+08:00" level=warning msg="mariadb_cte_recursive:1814 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDS_AGGREGATION != 3577) (err: Error 3575 (HY000): Recursive Common Table Expression 'cte' can contain neither aggregation nor window functions in recursive query block) (query: WITH RECURSIVE cte(f) AS (\nSELECT i FROM t\nUNION\nSELECT i FROM t\nWHERE i NOT IN ( SELECT * FROM t\nWHERE i IN ( SELECT * FROM cte ) GROUP BY i )\n) SELECT * FROM cte;)"
time="2024-05-07T07:45:55+08:00" level=warning msg="mariadb_cte_recursive:1887 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2024-05-07T07:45:55+08:00" level=warning msg="mariadb_cte_recursive:1887 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.cte_2' doesn't exist) (query: set @var=\n(\nwith recursive\ncte_1 as (\nselect 1\nunion\nselect * from cte_2),\ncte_2 as (\nselect * from cte_1\nunion\nselect a from t1, cte_2\nwhere t1.a=cte_2.a)\nselect * from cte_2\nlimit 1\n);)"
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=1955
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=1956
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2032
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $q;" command=eval line=2033
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=359
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-07T07:45:55+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
time="2024-05-07T07:45:55+08:00" level=warning msg="mariadb_cte_recursive:2118 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: WITH RECURSIVE qn AS\n(\nselect 1,0 as col from t1\nunion distinct\nselect 1,0 from t1\nunion all\nselect 3, 0*(@c:=@c+1) from qn where @c<1\nunion all\nselect 3, 0*(@d:=@d+1) from qn where @d<1\n)\nselect * from qn;)"
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2168
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2183
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=2195
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=2207
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=2219
./t/index_merge_delete.test: ok! 214 test cases passed, take time 9.797193863 s
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from cte as t;" command=eval line=2342
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from cte as t;" command=eval line=2347
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from t1 as t;" command=eval line=2351
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from t1 as t;" command=eval line=2356
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.228815763 s
time="2024-05-07T07:45:56+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2410
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2435
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2436
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" explain $q1;" command=eval line=2448
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2449
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2464
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2475
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2476
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2535
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2564
time="2024-05-07T07:45:57+08:00" level=warning msg="mariadb_cte_recursive:2566 query succeeded, but expected error(s)! (expected errors: 1146) (query: drop table folks;)"
time="2024-05-07T07:45:57+08:00" level=warning msg="mariadb_cte_recursive:2751 query failed with non expected error(s)! (ErrNotSupportedYet != 1064) (err: Error 1235 (42000): This version of TiDB doesn't yet support 'INTERSECT between recursive part's selects, hint: The operator between recursive part's selects must bu UNION[DISTINCT] or UNION ALL') (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a, distances d\nwhere a.departure = 'Seattle' and\na.departure = d.city1 and a.arrival = d.city2 and\nd.dist < 4000\nunion\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nintersect\nselect city2 from destinations s, distances d\nwhere s.city = d.city1 and d.dist < 4000\n)\nselect * from destinations;)"
time="2024-05-07T07:45:57+08:00" level=warning msg="mariadb_cte_recursive:2767 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != 1064) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'destinations', the recursive table must be referenced only once, and not in any subquery) (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a where a.departure = 'Seattle'\nunion\nselect * from\n(\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nexcept\nselect arrival from flights\nwhere arrival in\n('New York', 'London', 'Moscow', 'Dubai', 'Cairo', 'Tokyo')\n) t\n)\nselect * from destinations;)"
./t/mariadb_cte_recursive.test: ok! 313 test cases passed, take time 4.862253124 s
./t/math.test: ok! 6 test cases passed, take time 0.025981273 s
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=6
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=8
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=51
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments=" //\ncreate table t1 (i int)//\ninsert into t1 values (1),(2),(3)//\nselect * from t1 where i = 2//\ndrop table t1//\ndelimiter ;" command=delimiter line=57
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2024-05-07T07:45:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=269
./t/metadata.test: ok! 89 test cases passed, take time 1.1928761940000001 s
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2024-05-07T07:45:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
time="2024-05-07T07:45:59+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=28
./t/metadata_myisam.test: ok! 14 test cases passed, take time 0.237962532 s
time="2024-05-07T07:45:59+08:00" level=warning msg="multi_update:23 query failed with non expected error(s)! (ER_UNKNOWN_ERROR not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.t1 from mysqltest_1@localhost;)"
time="2024-05-07T07:45:59+08:00" level=warning msg="multi_update:25 query failed with non expected error(s)! (ER_UNKNOWN_ERROR not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.* from mysqltest_1@localhost;)"
time="2024-05-07T07:46:00+08:00" level=warning msg="multi_update:243 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE t1,t2 SET t1.d=t2.d WHERE t1.n=t2.n;)"
time="2024-05-07T07:46:02+08:00" level=warning msg="multi_update:465 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: update t1,t2 set t1.col1 = (select max(col1) from t1) where t1.col1 = t2.col1;)"
time="2024-05-07T07:46:02+08:00" level=warning msg="multi_update:467 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2.col1;)"
time="2024-05-07T07:46:03+08:00" level=warning msg="multi_update:492 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete from t1,t2 using t1,t2 where t1.a=(select a from t1);)"
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=" alter table t1 add column c int default 100 after a;" command=send line=553
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=561
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=" update t1, v1 set t1.b=t1.a+t1.b+v1.b where t1.a=v1.a;" command=send line=562
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=572
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=576
time="2024-05-07T07:46:04+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=579
time="2024-05-07T07:46:04+08:00" level=warning msg="multi_update:642 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: delete t3.* from t2,t3 where t2.a=t3.a;)"
time="2024-05-07T07:46:04+08:00" level=warning msg="multi_update:664 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1;)"
time="2024-05-07T07:46:04+08:00" level=warning msg="multi_update:766 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 ORDER BY a;)"
time="2024-05-07T07:46:04+08:00" level=warning msg="multi_update:768 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 LIMIT 3;)"
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=835
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=839
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=840
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=843
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=848
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=849
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=850
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=859
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=860
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=866
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=867
./t/multi_update.test: ok! 356 test cases passed, take time 6.034212544 s
time="2024-05-07T07:46:05+08:00" level=warning msg="multi_update_innodb:24 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A, t1 AS B SET A.pk = 1, B.a = 2;)"
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2024-05-07T07:46:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=113
./t/multi_update_innodb.test: ok! 62 test cases passed, take time 0.72764672 s
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.279422204 s
time="2024-05-07T07:46:10+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ErrDupEntry != 1176) (err: Error 1062 (23000): Duplicate entry '2-1850766141593485312-3' for key 't1.mv_idx_date') (query: INSERT INTO t1 SELECT * FROM t1 USE KEY FOR GROUP BY ( mv_idx_unsigned , mv_idx_signed ) GROUP BY j3 ORDER BY j1;)"
./t/multi_valued_index.test: ok! 659 test cases passed, take time 7.672318746 s
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 1.003371653 s
time="2024-05-07T07:46:15+08:00" level=warning msg="mysql_replace:20 query succeeded, but expected error(s)! (expected errors: ErrUnsupportedDDLOperation) (query: alter table t1 engine=heap;)"
./t/mysql_replace.test: ok! 19 test cases passed, take time 0.192038367 s
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.234853921 s
time="2024-05-07T07:46:15+08:00" level=warning msg="nth:39 query succeeded, but expected error(s)! (expected errors: ER_WRONG_ARGUMENTS) (query: SELECT id, sex, NTH_VALUE(id, NULL) OVER () FROM t1;)"
./t/nth.test: ok! 86 test cases passed, take time 0.218792081 s
./t/null_key_all_innodb.test: ok! 71 test cases passed, take time 1.585949434 s
./t/odbc.test: ok! 32 test cases passed, take time 0.297643447 s
./t/operator.test: ok! 28 test cases passed, take time 0.011877128 s
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.716193802 s
time="2024-05-07T07:46:19+08:00" level=warning msg="command not implemented" arguments=" include/not_hypergraph.inc  # Join order hints are not supported." command=source line=2
./t/opt_hints_join_order.test: ok! 83 test cases passed, take time 0.949346173 s
./t/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.519370896 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.255741542 s
time="2024-05-07T07:46:21+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=120
time="2024-05-07T07:46:21+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=169
time="2024-05-07T07:46:21+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=183
./t/order_by_limit.test: ok! 45 test cases passed, take time 0.939351615 s
Aborted by Jenkins Admin
Sending interrupt signal to process
Killing processes
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 2.562935001 s
./t/orderby.test: ok! 53 test cases passed, take time 0.155143579 s
time="2024-05-07T07:46:24+08:00" level=warning msg="overflow:9 query failed with non expected error(s)! (ErrDBDropExists not in ER_PARSE_ERROR,ER_TOO_LONG_IDENT,ER_WRONG_NAME_FOR_INDEX) (err: Error 1008 (HY000): Can't drop database 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'; database doesn't exist) (query: drop database AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA;)"
./t/overflow.test: ok! 2 test cases passed, take time 0.008713707 s
./t/packet.test: ok! 50 test cases passed, take time 0.221121715 s
time="2024-05-07T07:46:25+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2024-05-07T07:46:25+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2024-05-07T07:46:25+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2024-05-07T07:46:25+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
tidb-server(PID: 2241) stopped
script returned exit code 143
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
kill finished with exit code 1
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '3'
Sending interrupt signal to process
Killing processes
kill finished with exit code 1
tidb-server(PID: 2295) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh ABORTED result.json
http://fileserver.pingcap.net
--2024-05-06 23:46:31--  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%  639M=0s

2024-05-06 23:46:31 (639 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: e1f67b52-0793-44a5-9d12-696ccc8e5d49
Failed in branch Matrix - PART = '3'
org.jenkinsci.plugins.workflow.actions.ErrorAction$ErrorId: e7cd2258-596b-4ccf-8755-3830e9c21566
Finished: ABORTED