Skipping 1,048 KB.. Full Log

time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
./t/index_merge1.test: ok! 160 test cases passed, take time 7.506195923 s
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_count_sessions.inc" command=source line=6063
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=269
./t/metadata.test: ok! 89 test cases passed, take time 0.513776178 s
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2024-05-18T08:27:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
time="2024-05-18T08:27:35+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.100893807 s
time="2024-05-18T08:27:35+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-18T08:27:35+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-18T08:27:36+08:00" level=warning msg="view:6298 query failed with non expected error(s)! (ER_TOO_LONG_IDENT != 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 15.210093302 s
time="2024-05-18T08:27:36+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-18T08:27:36+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-18T08:27:36+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
./t/index_merge2.test: ok! 328 test cases passed, take time 1.7941161509999999 s
time="2024-05-18T08:27:37+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-18T08:27:37+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.039684159 s
time="2024-05-18T08:27:37+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-18T08:27:37+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-18T08:27:37+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;)"
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.074465401 s
time="2024-05-18T08:27:37+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-18T08:27:37+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-18T08:27:37+08:00" level=warning msg="view_grant:607 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 v3;)"
time="2024-05-18T08:27:37+08:00" level=warning msg="view_grant:609 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 v4;)"
time="2024-05-18T08:27:37+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-18T08:27:37+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-18T08:27:38+08:00" level=warning msg="view_grant:811 query failed with non expected error(s)! (ErrViewInvalid != 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-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK" command=replace_result line=825
time="2024-05-18T08:27:38+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-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=561
time="2024-05-18T08:27:38+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-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=572
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=576
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=579
time="2024-05-18T08:27:38+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-18T08:27:38+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-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
time="2024-05-18T08:27:38+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-18T08:27:38+08:00" level=warning msg="multi_update:766 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 ORDER BY a;)"
time="2024-05-18T08:27:38+08:00" level=warning msg="multi_update:768 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 LIMIT 3;)"
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=835
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=839
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=840
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=843
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=848
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=849
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=850
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=859
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=860
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=866
time="2024-05-18T08:27:38+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=867
time="2024-05-18T08:27:38+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-18T08:27:38+08:00" level=warning msg="view_grant:971 query failed with non expected error(s)! (ER_VIEW_INVALID != 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/multi_update.test: ok! 356 test cases passed, take time 3.183648267 s
time="2024-05-18T08:27:38+08:00" level=warning msg="multi_update_innodb:24 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A, t1 AS B SET A.pk = 1, B.a = 2;)"
time="2024-05-18T08:27:39+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2024-05-18T08:27:39+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2024-05-18T08:27:39+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=113
time="2024-05-18T08:27:39+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/multi_update_innodb.test: ok! 62 test cases passed, take time 0.28090608 s
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.111458895 s
time="2024-05-18T08:27:39+08:00" level=warning msg="view_grant:1179 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 v12 AS SELECT c1, c2 FROM mysqltest1.t1, mysqltest1.t2;)"
time="2024-05-18T08:27:39+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-18T08:27:39+08:00" level=warning msg="view_grant:1186 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 v23 AS SELECT c2, c3 FROM mysqltest1.t2, mysqltest1.t3;)"
time="2024-05-18T08:27:39+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-18T08:27:39+08:00" level=warning msg="view_grant:1192 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 v32 AS SELECT c3, c2 FROM mysqltest1.t3, mysqltest1.t2;)"
time="2024-05-18T08:27:39+08:00" level=warning msg="view_grant:1197 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 v42 AS SELECT c4, c2 FROM mysqltest1.t4, mysqltest1.t2;)"
time="2024-05-18T08:27:39+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-18T08:27:39+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-18T08:27:39+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-18T08:27:39+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-18T08:27:40+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-18T08:27:41+08:00" level=warning msg="view_grant:1979 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != 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-18T08:27:41+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-18T08:27:40+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-18T08:27:40+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-18T08:27:40+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
./t/index_merge_delete.test: ok! 214 test cases passed, take time 4.093049417 s
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.187387105 s
time="2024-05-18T08:27:41+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-18T08:27:41+08:00" level=warning msg="view_grant:2149 query failed with non expected error(s)! (ErrNonUpdatableTable != 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-18T08:27:41+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-18T08:27:41+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ErrNonUpdatableTable != 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-18T08:27:41+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2024-05-18T08:27:41+08:00" level=warning msg="view_grant:2955 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 test1.v1_all SET cn='x';)"
time="2024-05-18T08:27:41+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-18T08:27:41+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 4.906254513 s
time="2024-05-18T08:27:41+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;)"
time="2024-05-18T08:27:41+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-18T08:27:41+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-18T08:27:41+08:00" level=warning msg="view_myisam:36 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 values (1,2);)"
time="2024-05-18T08:27:41+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-18T08:27:41+08:00" level=warning msg="view_myisam:41 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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-18T08:27:41+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-18T08:27:41+08:00" level=warning msg="view_myisam:56 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 from v3;)"
time="2024-05-18T08:27:41+08:00" level=warning msg="view_myisam:58 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 v3,t1 from v3,t1;)"
time="2024-05-18T08:27:41+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-18T08:27:41+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-18T08:27:41+08:00" level=warning msg="view_myisam:126 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 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.257477971 s
time="2024-05-18T08:27:42+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2024-05-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2024-05-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
time="2024-05-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2024-05-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2024-05-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2024-05-18T08:27:42+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.368553497 s
time="2024-05-18T08:27:42+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-18T08:27:42+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-18T08:27:42+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-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2024-05-18T08:27:42+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-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2024-05-18T08:27:42+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-18T08:27:42+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-18T08:27:42+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-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2024-05-18T08:27:42+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-18T08:27:42+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=462
./t/window_bitwise_ops.test: ok! 77 test cases passed, take time 0.398055265 s
./t/multi_valued_index.test: ok! 659 test cases passed, take time 3.56801618 s
time="2024-05-18T08:27:43+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-18T08:27:43+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-18T08:27:43+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);)"
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 0.515239907 s
time="2024-05-18T08:27:43+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-18T08:27:43+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-18T08:27:43+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.16057085 s
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.095216365 s
time="2024-05-18T08:27:43+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.096337159 s
time="2024-05-18T08:27:44+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-18T08:27:44+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-18T08:27:44+08:00" level=warning msg="window_functions:1614 query failed with non expected error(s)! (ErrWindowInvalidWindowFuncUse != 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-18T08:27:44+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/null_key_all_innodb.test: ok! 71 test cases passed, take time 0.85886878 s
time="2024-05-18T08:27:45+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);)"
time="2024-05-18T08:27:45+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);)"
./t/odbc.test: ok! 32 test cases passed, take time 0.127072514 s
./t/operator.test: ok! 28 test cases passed, take time 0.006068004 s
time="2024-05-18T08:27:45+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-18T08:27:45+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-18T08:27:45+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-18T08:27:45+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-18T08:27:45+08:00" level=warning msg="window_functions:2050 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 1+SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-18T08:27:45+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-18T08:27:45+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-18T08:27:45+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;)"
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.480127156 s
time="2024-05-18T08:27:45+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.423450854 s
time="2024-05-18T08:27:45+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/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.244914312 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.119511223 s
time="2024-05-18T08:27:46+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-18T08:27:46+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-18T08:27:46+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-18T08:27:46+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-18T08:27:46+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-18T08:27:46+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.496634426 s
time="2024-05-18T08:27:47+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-18T08:27:47+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-18T08:27:47+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-18T08:27:47+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-18T08:27:47+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 4.9310539559999995 s
time="2024-05-18T08:27:47+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2024-05-18T08:27:47+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2024-05-18T08:27:47+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=4
./t/window_functions_big.test: ok! 33 test cases passed, take time 0.682124129 s
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 1.956073967 s
./t/orderby.test: ok! 53 test cases passed, take time 0.062942574 s
time="2024-05-18T08:27:49+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.004398585 s
./t/packet.test: ok! 50 test cases passed, take time 0.088478215 s
time="2024-05-18T08:27:49+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2024-05-18T08:27:49+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2024-05-18T08:27:49+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2024-05-18T08:27:49+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
time="2024-05-18T08:27:49+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-18T08:27:49+08:00" level=warning msg="window_functions_bugs:621 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(NTH_VALUE(CAST('' AS JSON), 1) OVER (), '');)"
time="2024-05-18T08:27:49+08:00" level=warning msg="window_functions_bugs:623 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(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2024-05-18T08:27:49+08:00" level=warning msg="window_functions_bugs:625 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(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '');)"
./t/window_functions_bugs.test: ok! 157 test cases passed, take time 0.835681178 s
time="2024-05-18T08:27:49+08:00" level=warning msg="command not implemented" arguments=" include/have_hypergraph.inc  # Only supported by the hypergraph join optimizer." command=source line=8
time="2024-05-18T08:27:49+08:00" level=error msg="run test [window_functions_interesting_orders] err: sql:EXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;: failed to run query \n\"EXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\" \n around line 70, \nwe need(665):\nEXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\nid\testRows\ttask\taccess object\toperator info\nProjection_8\t0.00\troot\tNULL\tColumn#6->Column#7\n└─Window_9\t0.00\troot\tNULL\tsum(cast(window_functions_interesting_orders.t1.a, decimal(10,0) BINARY))->Column#6 over(order by window_functions_interesting_orders.t1.b range between unbounded preceding and current row)\n  └─Sort_13\t0.00\troot\tNULL\twindow_functions_interesting_orders.t1.b\n    └─TableReader_12\t0.00\troot\tNULL\tdata:Selection_11\n      └─Selection_11\t0.00\tcop[tikv]\tNULL\teq(window_functions_interesting_orders.t1.b, 3)\n        └─TableFullScan_10\t8.00\tcop[tikv]\ttable:t1\tkeep order:false\n\nbut got(665):\nEXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\nid\testRows\ttask\taccess object\toperator info\nProjection_8\t8.00\troot\tNULL\tColumn#6->Column#7\n└─Window_9\t8.00\troot\tNULL\tsum(cast(window_functions_interesting_orders.t1.a, decimal(10,0) BINARY))->Column#6 over(order by window_functions_interesting_orders.t1.b range between unbounded preceding and current row)\n  └─Sort_13\t8.00\troot\tNULL\twindow_functions_interesting_orders.t1.b\n    └─TableReader_12\t8.00\troot\tNULL\tdata:Selection_11\n      └─Selection_11\t8.00\tcop[tikv]\tNULL\teq(window_functions_interesting_orders.t1.b, 3)\n        └─TableFullScan_10\t8.00\tcop[tikv]\ttable:t1\tkeep order:false\n\n"
time="2024-05-18T08:27:49+08:00" level=warning msg="packet_myisam:43 query failed with non expected error(s)! (ErrEntryTooLarge != ER_WARN_ALLOWED_PACKET_OVERFLOWED) (err: Error 8025 (HY000): entry too large, the max entry size is 6291456, the size of data is 67108897) (query: UPDATE t3\nSET c32= CONCAT(c32,\nREPEAT('a', @max_allowed_packet-1));)"
./t/packet_myisam.test: ok! 11 test cases passed, take time 0.362305205 s
./t/window_min_max.test: ok! 200 test cases passed, take time 0.503907681 s
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2024-05-18T08:27:50+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-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
time="2024-05-18T08:27:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $$\nselect \"non terminated\"$$\nselect \"terminated\";$$\nselect \"non terminated, space\"      $$\nselect \"terminated, space\";      $$\nselect \"non terminated, comment\" /* comment */$$\nselect \"terminated, comment\"; /* comment */$$\nselect \"stmt 1\";select \"stmt 2 non terminated\"$$\nselect \"stmt 1\";select \"stmt 2 terminated\";$$\nselect \"stmt 1\";select \"stmt 2 non terminated, space\"      $$\nselect \"stmt 1\";select \"stmt 2 terminated, space\";      $$\nselect \"stmt 1\";select \"stmt 2 non terminated, comment\" /* comment */$$\nselect \"stmt 1\";select \"stmt 2 terminated, comment\"; /* comment */$$\nselect \"stmt 1\";             select \"space, stmt 2\"$$\nselect \"stmt 1\";/* comment */select \"comment, stmt 2\"$$" command=delimiter line=423
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" ;" command=delimiter line=448
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:556 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait();)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:558 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait(1);)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:562 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST not in 0,ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait('binlog.999999', 4, -1);)"
time="2024-05-18T08:27:51+08:00" level=warning msg="with_non_recursive:692 query failed with non expected error(s)! (ErrNoSuchTable != 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-18T08:27:51+08:00" level=warning msg="with_non_recursive:694 query failed with non expected error(s)! (ErrNoSuchTable != 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-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2024-05-18T08:27:51+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-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2024-05-18T08:27:51+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-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2024-05-18T08:27:51+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.955802735 s
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=915
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:923 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:932 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:941 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 ORDER BY 1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:959 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:968 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:977 query failed with non expected error(s)! (ER_WRONG_USAGE != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:986 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1061 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine=a.myisam;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1065 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.b.myisam' in '') (query: SET default_storage_engine = a.b.MyISAM;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1067 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.MyISAM;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1069 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.`MyISAM`;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1071 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = \"a.MYISAM\";)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1073 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = 'a.MYISAM';)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1075 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = `a.MYISAM`;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1220 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: REPLACE INTO `` SELECT * FROM ``;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1265 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=NONE;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1267 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=SHARED;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1273 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITH VALIDATION;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1275 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITHOUT VALIDATION;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1277 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 LOCK=SHARED, WITH VALIDATION, ALGORITHM=COPY,\nLOCK=EXCLUSIVE, WITHOUT VALIDATION, ALGORITHM=INPLACE;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1317 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT a FROM t1 LIMIT 1 UNION ALL SELECT a FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1320 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: (SELECT a FROM t1 LIMIT 1) UNION ALL (SELECT a FROM t1 ORDER BY a) LIMIT 2;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1371 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1 ORDER BY a UNION SELECT a FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1377 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1\nUNION\nSELECT a FROM t1 ORDER BY a\nUNION\nSELECT a FROM t1;)"
time="2024-05-18T08:27:51+08:00" level=warning msg="parser:1538 query failed with non expected error(s)! (ER_NON_UNIQ_ERROR != ER_NONUNIQ_TABLE) (err: Error 1052 (23000): Column 'a' in field list is ambiguous) (query: SELECT * FROM ( t1 JOIN t2 ON TRUE, t1 JOIN t3 ON TRUE );)"
time="2024-05-18T08:27:51+08:00" level=error msg="run test [with_non_recursive_bugs] err: sql:EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);: failed to run query \n\"EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\" \n around line 466, \nwe need(7312):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Projection\t16.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.cc.col_datetime_key, with_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key\n  └─HashJoin\t16.00\troot\t\tCARTESIAN inner join\n    ├─HashAgg(Build)\t1.00\troot\t\tgroup by:with_non_recursive_bugs.cc.col_int, with_non_recursive_bugs.cc.col_int_key, funcs:firstrow(1)->Column#175\n    │ └─HashJoin\t0.00\troot\t\tinner join, equal:[eq(Column#167, Column#168)]\n    │   ├─Projection(Build)\t0.00\troot\t\twith_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_int, cast(with_non_recursive_bugs.cc.pk, double BINARY)->Column#167\n    │   │ └─IndexLookUp\t0.00\troot\t\t\n    │   │   ├─IndexRangeScan(Build)\t0.00\tcop[tikv]\ttable:innr1, index:col_int_key(col_int_key)\trange:[4 -inf,4 7], keep order:false\n    │   │   └─Selection(Probe)\t0.00\tcop[tikv]\t\teq(7, with_non_recursive_bugs.cc.col_int)\n    │   │     └─TableRowIDScan\t0.00\tcop[tikv]\ttable:innr1\tkeep order:false\n    │   └─Projection(Probe)\t8.89\troot\t\tcast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#168\n    │     └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n    │       ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n    │       │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n    │       │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n    │       │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n    │       │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │       │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n    │       │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n    │       └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │         └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n    │           └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n    └─HashJoin(Probe)\t16.00\troot\t\tinner join, equal:[eq(Column#163, Column#164)]\n      ├─Projection(Build)\t8.89\troot\t\twith_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_datetime_key, cast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#164\n      │ └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n      │   ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n      │   │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n      │   │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n      │   │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n      │   │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │   │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n      │   │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n      │   └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │     └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n      │       └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n      └─Projection(Probe)\t18.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, cast(with_non_recursive_bugs.d.pk, double BINARY)->Column#163\n        └─HashJoin\t18.00\troot\t\tleft outer join, equal:[eq(with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_int)]\n          ├─TableReader(Build)\t9.00\troot\t\tdata:Selection\n          │ └─Selection\t9.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_int))\n          │   └─TableFullScan\t10.00\tcop[tikv]\ttable:outr2\tkeep order:false\n          └─TableReader(Probe)\t10.00\troot\t\tdata:TableFullScan\n            └─TableFullScan\t10.00\tcop[tikv]\ttable:outr1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t8061\tOptimizer hint NO_MERGE is not supported by TiDB and is ignored\n\nbut got(7312):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Projection\t16.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.cc.col_datetime_key, with_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key\n  └─HashJoin\t16.00\troot\t\tCARTESIAN inner join\n    ├─HashAgg(Build)\t1.00\troot\t\tgroup by:with_non_recursive_bugs.cc.col_int, with_non_recursive_bugs.cc.col_int_key, funcs:firstrow(1)->Column#175\n    │ └─HashJoin\t0.10\troot\t\tinner join, equal:[eq(Column#167, Column#168)]\n    │   ├─Projection(Build)\t0.10\troot\t\twith_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_int, cast(with_non_recursive_bugs.cc.pk, double BINARY)->Column#167\n    │   │ └─IndexLookUp\t0.10\troot\t\t\n    │   │   ├─IndexRangeScan(Build)\t1.00\tcop[tikv]\ttable:innr1, index:col_int_key(col_int_key)\trange:[4 -inf,4 7], keep order:false\n    │   │   └─Selection(Probe)\t0.10\tcop[tikv]\t\teq(7, with_non_recursive_bugs.cc.col_int)\n    │   │     └─TableRowIDScan\t1.00\tcop[tikv]\ttable:innr1\tkeep order:false\n    │   └─Projection(Probe)\t8.89\troot\t\tcast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#168\n    │     └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n    │       ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n    │       │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n    │       │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n    │       │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n    │       │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │       │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n    │       │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n    │       └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │         └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n    │           └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n    └─HashJoin(Probe)\t16.00\troot\t\tinner join, equal:[eq(Column#163, Column#164)]\n      ├─Projection(Build)\t8.89\troot\t\twith_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_datetime_key, cast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#164\n      │ └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n      │   ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n      │   │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n      │   │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n      │   │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n      │   │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │   │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n      │   │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n      │   └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │     └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n      │       └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n      └─Projection(Probe)\t18.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, cast(with_non_recursive_bugs.d.pk, double BINARY)->Column#163\n        └─HashJoin\t18.00\troot\t\tleft outer join, equal:[eq(with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_int)]\n          ├─TableReader(Build)\t9.00\troot\t\tdata:Selection\n          │ └─Selection\t9.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_int))\n          │   └─TableFullScan\t10.00\tcop[tikv]\ttable:outr2\tkeep order:false\n          └─TableReader(Probe)\t10.00\troot\t\tdata:TableFullScan\n            └─TableFullScan\t10.00\tcop[tikv]\ttable:outr1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t8061\tOptimizer hint NO_MERGE is not supported by TiDB and is ignored\n\n"
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2024-05-18T08:27:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2024-05-18T08:27:52+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.351718701 s
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 0.323838159 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.033636762 s
time="2024-05-18T08:27:52+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2024-05-18T08:27:52+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.170506809 s
./t/year_innodb.test: ok! 51 test cases passed, take time 0.220689328 s
time="2024-05-18T08:27:53+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:1954 query failed with non expected error(s)! (ErrSyntax != ER_PARSE_ERROR) (err: Error 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use) (query: CREATE TABLE t1 (a INT) PARTITION BY KEY ALGORITHM = 10 () PARTITIONS 3;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:1978 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: DROP INDEX idx1 ON ``;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2035 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET NAMES utf8 COLLATE DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2237 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE ROLE `RESOURCE`;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2245 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global') (query: SET GLOBAL = DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2247 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local') (query: SET LOCAL = DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2249 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist') (query: SET PERSIST = DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2251 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist_only') (query: SET PERSIST_ONLY = DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2253 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session') (query: SET SESSION = DEFAULT;)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2339 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t1 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2348 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t2 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2357 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t3 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nNOT NULL\nCOLLATE ascii_bin\n);)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2368 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t3 (\nx VARCHAR(10)\nCOLLATE ascii_bin\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\n);)"
time="2024-05-18T08:27:54+08:00" level=warning msg="parser:2378 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t4 (\nx VARCHAR(10)\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
./t/parser.test: ok! 693 test cases passed, take time 4.939295473 s
./t/parser_precedence.test: ok! 138 test cases passed, take time 0.07897325 s
time="2024-05-18T08:27:56+08:00" level=warning msg="partition:345 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: ALTER TABLE t1\nPARTITION BY HASH (a)\n(PARTITION p0 ENGINE=InnoDB,\nPARTITION p1 ENGINE=NonExistentEngine);)"
time="2024-05-18T08:27:56+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-18T08:27:56+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.139291178 s
time="2024-05-18T08:27:56+08:00" level=warning msg="role:59 query failed with non expected error(s)! (ErrCannotUser != 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-18T08:27:56+08:00" level=warning msg="role:97 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 SUPER, engineering ON *.* TO joan, sally;)"
time="2024-05-18T08:27:56+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-18T08:27:56+08:00" level=warning msg="role:153 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for `engineering_role`@`%`) (query: REVOKE engineering_role FROM foo@localhost;)"
time="2024-05-18T08:27:56+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-18T08:27:56+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-18T08:27:57+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-18T08:27:57+08:00" level=warning msg="role:619 query failed with non expected error(s)! (ErrCannotUser != 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-18T08:27:57+08:00" level=warning msg="role:628 query failed with non expected error(s)! (ErrCannotUser != 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.731569376 s
time="2024-05-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+08:00" level=warning msg="partition:1357 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0) (subpartition sp0),\npartition p1 values less than (1));)"
time="2024-05-18T08:27:58+08:00" level=warning msg="partition:1364 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0),\npartition p1 values less than (1) (subpartition sp0));)"
time="2024-05-18T08:27:58+08:00" level=warning msg="partition:1374 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by list (a)\nsubpartition by hash(a)\n(partition p0 values in (0),\npartition p1 values in (1) (subpartition sp0));)"
time="2024-05-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:58+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-18T08:27:59+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-18T08:27:59+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-18T08:27:59+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-18T08:27:59+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-18T08:27:59+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.098027629 s

time="2024-05-18T08:27:59+08:00" level=error msg="9 tests failed\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [range_all] err: sql:EXPLAIN FORMAT= 'BRIEF' select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;: failed to run query \n\"EXPLAIN FORMAT= 'BRIEF' select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\" \n around line 224, \nwe need(554):\nEXPLAIN FORMAT= 'BRIEF' select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\nid\testRows\ttask\taccess object\toperator info\nProjection\t0.00\troot\t\trange_all.t1.key1, range_all.t2.keya\n└─HashJoin\t0.00\troot\t\tCARTESIAN inner join\n  ├─IndexReader(Build)\t0.00\troot\t\tindex:IndexRangeScan\n  │ └─IndexRangeScan\t0.00\tcop[tikv]\ttable:t2, index:j1(keya)\trange:[3,3], keep order:false\n  └─IndexReader(Probe)\t7.00\troot\t\tindex:IndexRangeScan\n    └─IndexRangeScan\t7.00\tcop[tikv]\ttable:t1, index:i1(key1)\trange:[-inf,4), keep order:false\nEX\nbut got(554):\nEXPLAIN FORMAT= 'BRIEF' select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\nid\testRows\ttask\taccess object\toperator info\nProjection\t14.00\troot\t\trange_all.t1.key1, range_all.t2.keya\n└─HashJoin\t14.00\troot\t\tCARTESIAN inner join\n  ├─IndexReader(Build)\t2.00\troot\t\tindex:IndexRangeScan\n  │ └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t2, index:j1(keya)\trange:[3,3], keep order:false\n  └─IndexReader(Probe)\t7.00\troot\t\tindex:IndexRangeScan\n    └─IndexRangeScan\t7.00\tcop[tikv]\ttable:t1, index:i1(key1)\trange:[-inf,4), keep order:false\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [range_mrr_cost] err: sql:explain FORMAT=\"brief\" select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;: failed to run query \n\"explain FORMAT=\"brief\" select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\" \n around line 241, \nwe need(563):\nexplain FORMAT=\"brief\" select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\nid\testRows\ttask\taccess object\toperator info\nProjection\t0.00\troot\t\trange_mrr_cost.t1.key1, range_mrr_cost.t2.keya\n└─HashJoin\t0.00\troot\t\tCARTESIAN inner join\n  ├─IndexReader(Build)\t0.00\troot\t\tindex:IndexRangeScan\n  │ └─IndexRangeScan\t0.00\tcop[tikv]\ttable:t2, index:j1(keya)\trange:[3,3], keep order:false\n  └─IndexReader(Probe)\t7.00\troot\t\tindex:IndexRangeScan\n    └─IndexRangeScan\t7.00\tcop[tikv]\ttable:t1, index:i1(key1)\trange:[-inf,4), keep order:false\nex\nbut got(563):\nexplain FORMAT=\"brief\" select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3;\nid\testRows\ttask\taccess object\toperator info\nProjection\t14.00\troot\t\trange_mrr_cost.t1.key1, range_mrr_cost.t2.keya\n└─HashJoin\t14.00\troot\t\tCARTESIAN inner join\n  ├─IndexReader(Build)\t2.00\troot\t\tindex:IndexRangeScan\n  │ └─IndexRangeScan\t2.00\tcop[tikv]\ttable:t2, index:j1(keya)\trange:[3,3], keep order:false\n  └─IndexReader(Probe)\t7.00\troot\t\tindex:IndexRangeScan\n    └─IndexRangeScan\t7.00\tcop[tikv]\ttable:t1, index:i1(key1)\trange:[-inf,4), keep order:false\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [row] err: sql:EXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2;: failed to run query \n\"EXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2;\" \n around line 211, \nwe need(241):\nEXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2;\nid\testRows\ttask\taccess object\toperator info\nIndexReader_6\t1.11\troot\t\tindex:IndexRangeScan_5\n└─IndexRangeScan_5\t1.11\tcop[tikv]\ttable:t2, index:PRIMARY(a, b, c)\trange:[3 2,3 2], keep order:false\n\nbut got(241):\nEXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2;\nid\testRows\ttask\taccess object\toperator info\nIndexReader_6\t1.00\troot\t\tindex:IndexRangeScan_5\n└─IndexRangeScan_5\t1.00\tcop[tikv]\ttable:t2, index:PRIMARY(a, b, c)\trange:[3 2,3 2], keep order:false\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [select_all] err: sql:explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;: failed to run query \n\"explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;\" \n around line 1325, \nwe need(307):\nexplain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;\nid\testRows\ttask\taccess object\toperator info\nIndexReader_12\t1.00\troot\t\tindex:IndexRangeScan_11\n└─IndexRangeScan_11\t1.00\tcop[tikv]\ttable:t2, index:fld3(fld3)\trange:[\"honeysuckle\",\"honoring\"], keep order:true\n\nbut got(307):\nexplain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;\nid\testRows\ttask\taccess object\toperator info\nIndexReader_12\t0.03\troot\t\tindex:IndexRangeScan_11\n└─IndexRangeScan_11\t0.03\tcop[tikv]\ttable:t2, index:fld3(fld3)\trange:[\"honeysuckle\",\"honoring\"], keep order:true\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [subquery_all] err: sql:EXPLAIN FORMAT= 'BRIEF' select a in (select max(ie) from t1 where oref=4 group by grp) from t3;: failed to run query \n\"EXPLAIN FORMAT= 'BRIEF' select a in (select max(ie) from t1 where oref=4 group by grp) from t3;\" \n around line 3497, \nwe need(766):\nEXPLAIN FORMAT= 'BRIEF' select a in (select max(ie) from t1 where oref=4 group by grp) from t3;\nid\testRows\ttask\taccess object\toperator info\n  └─TableFullScan\t10000.00\tcop[tikv]\ttable:t3\tkeep order:false, stats:pseudo\nHashJoin\t10000.00\troot\t\tCARTESIAN left outer semi join, other cond:eq(subquery_all.t3.a, Column#11)\n│     └─TableFullScan\t6.00\tcop[tikv]\ttable:t1\tkeep order:false\n│   └─Selection\t0.00\tcop[tikv]\t\teq(subquery_all.t1.oref, 4)\n│ └─TableReader\t0.00\troot\t\tdata:Selection\n└─TableReader(Probe)\t10000.00\troot\t\tdata:TableFullScan\n├─HashAgg(Build)\t1.00\troot\t\tgroup by:subquery_all.t1.grp, funcs:max(subquery_all.t1.ie)->Column#11\ndrop table t1, t2, t3;\ncreate table t1 (a int, oref int, key(a));\ninsert into t1 values\n(1, 1),\n(1, \nbut got(766):\nEXPLAIN FORMAT= 'BRIEF' select a in (select max(ie) from t1 where oref=4 group by grp) from t3;\nid\testRows\ttask\taccess object\toperator info\n  └─TableFullScan\t10000.00\tcop[tikv]\ttable:t3\tkeep order:false, stats:pseudo\nHashJoin\t10000.00\troot\t\tCARTESIAN left outer semi join, other cond:eq(subquery_all.t3.a, Column#11)\n│       └─TableFullScan\t6.00\tcop[tikv]\ttable:t1\tkeep order:false\n│     └─Selection\t1.50\tcop[tikv]\t\teq(subquery_all.t1.oref, 4)\n│   └─HashAgg\t1.00\tcop[tikv]\t\tgroup by:subquery_all.t1.grp, funcs:max(subquery_all.t1.ie)->Column#13\n│ └─TableReader\t1.00\troot\t\tdata:HashAgg\n└─TableReader(Probe)\t10000.00\troot\t\tdata:TableFullScan\n├─HashAgg(Build)\t1.00\troot\t\tgroup by:subquery_all.t1.grp, funcs:max(Column#13)->Column#11\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [subquery_mat] err: sql:explain format=brief\nselect/*+ HASH_JOIN(t1,T2), HASH_AGG() */ *  from t1 where a1 in (select b1 from t2 where b1 > '0');: failed to run query \n\"explain format=brief\nselect/*+ HASH_JOIN(t1,T2), HASH_AGG() */ *  from t1 where a1 in (select b1 from t2 where b1 > '0');\" \n around line 82, \nwe need(1015):\nexplain format=brief\nselect/*+ HASH_JOIN(t1,T2), HASH_AGG() */ *  from t1 where a1 in (select b1 from t2 where b1 > '0');\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t3.00\troot\t\tinner join, equal:[eq(subquery_mat.t1.a1, subquery_mat.t2.b1)]\n├─HashAgg(Build)\t3.00\troot\t\tgroup by:subquery_mat.t2.b1, funcs:firstrow(subquery_mat.t2.b1)->subquery_mat.t2.b1\n│ └─TableReader\t3.00\troot\t\tdata:HashAgg\n│   └─HashAgg\t3.00\tcop[tikv]\t\tgroup by:subquery_mat.t2.b1, \n│     └─Selection\t5.00\tcop[tikv]\t\tgt(subquery_mat.t2.b1, \"0\"), not(isnull(subquery_mat.t2.b1))\n│       └─TableFullScan\t5.00\tcop[tikv]\ttable:t2\tkeep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:Selection\n  └─Selection\t3.00\tcop[tikv]\t\tnot(isnull(subquery_mat.t1.a1))\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t1815\tThere are no matching table names for (T2) in optimizer hint /*+ HASH_JOIN(t1, t2) */ or /*+ TIDB_HJ(t1, t2) */. Maybe you can use the table alias name\n\nbut got(1015):\nexplain format=brief\nselect/*+ HASH_JOIN(t1,T2), HASH_AGG() */ *  from t1 where a1 in (select b1 from t2 where b1 > '0');\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t2.00\troot\t\tinner join, equal:[eq(subquery_mat.t1.a1, subquery_mat.t2.b1)]\n├─HashAgg(Build)\t2.00\troot\t\tgroup by:subquery_mat.t2.b1, funcs:firstrow(subquery_mat.t2.b1)->subquery_mat.t2.b1\n│ └─TableReader\t2.00\troot\t\tdata:HashAgg\n│   └─HashAgg\t2.00\tcop[tikv]\t\tgroup by:subquery_mat.t2.b1, \n│     └─Selection\t3.33\tcop[tikv]\t\tgt(subquery_mat.t2.b1, \"0\"), not(isnull(subquery_mat.t2.b1))\n│       └─TableFullScan\t5.00\tcop[tikv]\ttable:t2\tkeep order:false\n└─TableReader(Probe)\t3.00\troot\t\tdata:Selection\n  └─Selection\t3.00\tcop[tikv]\t\tnot(isnull(subquery_mat.t1.a1))\n    └─TableFullScan\t3.00\tcop[tikv]\ttable:t1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t1815\tThere are no matching table names for (T2) in optimizer hint /*+ HASH_JOIN(t1, t2) */ or /*+ TIDB_HJ(t1, t2) */. Maybe you can use the table alias name\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [type_bit_innodb] err: sql:explain format='brief' select a+0 from t1;: failed to run query \n\"explain format='brief' select a+0 from t1;\" \n around line 55, \nwe need(286):\nexplain format='brief' select a+0 from t1;\nid\testRows\ttask\taccess object\toperator info\nProjection\t4.00\troot\t\tplus(type_bit_innodb.t1.a, 0)->Column#3\n└─TableReader\t4.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t4.00\tcop[tikv]\ttable:t1\tkeep order:false\nselect a+0 from t1;\na+0\n0\n\nbut got(286):\nexplain format='brief' select a+0 from t1;\nid\testRows\ttask\taccess object\toperator info\nProjection\t10000.00\troot\t\tplus(type_bit_innodb.t1.a, 0)->Column#3\n└─TableReader\t10000.00\troot\t\tdata:TableFullScan\n  └─TableFullScan\t10000.00\tcop[tikv]\ttable:t1\tkeep order:false, stats:pseudo\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [window_functions_interesting_orders] err: sql:EXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;: failed to run query \n\"EXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\" \n around line 70, \nwe need(665):\nEXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\nid\testRows\ttask\taccess object\toperator info\nProjection_8\t0.00\troot\tNULL\tColumn#6->Column#7\n└─Window_9\t0.00\troot\tNULL\tsum(cast(window_functions_interesting_orders.t1.a, decimal(10,0) BINARY))->Column#6 over(order by window_functions_interesting_orders.t1.b range between unbounded preceding and current row)\n  └─Sort_13\t0.00\troot\tNULL\twindow_functions_interesting_orders.t1.b\n    └─TableReader_12\t0.00\troot\tNULL\tdata:Selection_11\n      └─Selection_11\t0.00\tcop[tikv]\tNULL\teq(window_functions_interesting_orders.t1.b, 3)\n        └─TableFullScan_10\t8.00\tcop[tikv]\ttable:t1\tkeep order:false\n\nbut got(665):\nEXPLAIN SELECT SUM(a) OVER (ORDER BY b) FROM t1 WHERE b=3;\nid\testRows\ttask\taccess object\toperator info\nProjection_8\t8.00\troot\tNULL\tColumn#6->Column#7\n└─Window_9\t8.00\troot\tNULL\tsum(cast(window_functions_interesting_orders.t1.a, decimal(10,0) BINARY))->Column#6 over(order by window_functions_interesting_orders.t1.b range between unbounded preceding and current row)\n  └─Sort_13\t8.00\troot\tNULL\twindow_functions_interesting_orders.t1.b\n    └─TableReader_12\t8.00\troot\tNULL\tdata:Selection_11\n      └─Selection_11\t8.00\tcop[tikv]\tNULL\teq(window_functions_interesting_orders.t1.b, 3)\n        └─TableFullScan_10\t8.00\tcop[tikv]\ttable:t1\tkeep order:false\n\n"
time="2024-05-18T08:27:59+08:00" level=error msg="run test [with_non_recursive_bugs] err: sql:EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);: failed to run query \n\"EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\" \n around line 466, \nwe need(7312):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Projection\t16.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.cc.col_datetime_key, with_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key\n  └─HashJoin\t16.00\troot\t\tCARTESIAN inner join\n    ├─HashAgg(Build)\t1.00\troot\t\tgroup by:with_non_recursive_bugs.cc.col_int, with_non_recursive_bugs.cc.col_int_key, funcs:firstrow(1)->Column#175\n    │ └─HashJoin\t0.00\troot\t\tinner join, equal:[eq(Column#167, Column#168)]\n    │   ├─Projection(Build)\t0.00\troot\t\twith_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_int, cast(with_non_recursive_bugs.cc.pk, double BINARY)->Column#167\n    │   │ └─IndexLookUp\t0.00\troot\t\t\n    │   │   ├─IndexRangeScan(Build)\t0.00\tcop[tikv]\ttable:innr1, index:col_int_key(col_int_key)\trange:[4 -inf,4 7], keep order:false\n    │   │   └─Selection(Probe)\t0.00\tcop[tikv]\t\teq(7, with_non_recursive_bugs.cc.col_int)\n    │   │     └─TableRowIDScan\t0.00\tcop[tikv]\ttable:innr1\tkeep order:false\n    │   └─Projection(Probe)\t8.89\troot\t\tcast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#168\n    │     └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n    │       ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n    │       │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n    │       │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n    │       │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n    │       │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │       │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n    │       │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n    │       └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │         └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n    │           └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n    └─HashJoin(Probe)\t16.00\troot\t\tinner join, equal:[eq(Column#163, Column#164)]\n      ├─Projection(Build)\t8.89\troot\t\twith_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_datetime_key, cast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#164\n      │ └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n      │   ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n      │   │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n      │   │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n      │   │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n      │   │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │   │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n      │   │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n      │   └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │     └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n      │       └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n      └─Projection(Probe)\t18.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, cast(with_non_recursive_bugs.d.pk, double BINARY)->Column#163\n        └─HashJoin\t18.00\troot\t\tleft outer join, equal:[eq(with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_int)]\n          ├─TableReader(Build)\t9.00\troot\t\tdata:Selection\n          │ └─Selection\t9.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_int))\n          │   └─TableFullScan\t10.00\tcop[tikv]\ttable:outr2\tkeep order:false\n          └─TableReader(Probe)\t10.00\troot\t\tdata:TableFullScan\n            └─TableFullScan\t10.00\tcop[tikv]\ttable:outr1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t8061\tOptimizer hint NO_MERGE is not supported by TiDB and is ignored\n\nbut got(7312):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias2 . col_datetime_key AS field1 ,\nalias1 . col_varchar_key AS field2 ,\nalias2 . col_int_key AS field3\nFROM  view_b AS alias1  LEFT  JOIN  cc AS alias2  LEFT  JOIN view_d AS alias3\nON  alias2 . col_varchar_key =  alias3 . col_blob_key\nON  alias1 . col_blob =  alias3 . col_blob_key\nWHERE  alias3 . col_varchar_key  LIKE ( 'w' )\nOR  alias2 . pk <> 4  )\nDELETE /*+ NO_MERGE(outrcte) */  QUICK\noutr1.*, outr2.* FROM d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_int = outr2 . col_int )\nINNER JOIN cte AS outrcte\nON outr1 . pk = outrcte.field1\nWHERE (4, 7 )  IN (\nSELECT DISTINCT innr1 . col_int_key AS x , innr1 . col_int AS y\nFROM cc AS innr1 JOIN cte AS innrcte\nON innr1.pk = innrcte.field1\nWHERE innr1 . col_int >= innr1 . pk\n);\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Projection\t16.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.cc.col_datetime_key, with_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key\n  └─HashJoin\t16.00\troot\t\tCARTESIAN inner join\n    ├─HashAgg(Build)\t1.00\troot\t\tgroup by:with_non_recursive_bugs.cc.col_int, with_non_recursive_bugs.cc.col_int_key, funcs:firstrow(1)->Column#175\n    │ └─HashJoin\t0.10\troot\t\tinner join, equal:[eq(Column#167, Column#168)]\n    │   ├─Projection(Build)\t0.10\troot\t\twith_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_int, cast(with_non_recursive_bugs.cc.pk, double BINARY)->Column#167\n    │   │ └─IndexLookUp\t0.10\troot\t\t\n    │   │   ├─IndexRangeScan(Build)\t1.00\tcop[tikv]\ttable:innr1, index:col_int_key(col_int_key)\trange:[4 -inf,4 7], keep order:false\n    │   │   └─Selection(Probe)\t0.10\tcop[tikv]\t\teq(7, with_non_recursive_bugs.cc.col_int)\n    │   │     └─TableRowIDScan\t1.00\tcop[tikv]\ttable:innr1\tkeep order:false\n    │   └─Projection(Probe)\t8.89\troot\t\tcast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#168\n    │     └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n    │       ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n    │       │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n    │       │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n    │       │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n    │       │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │       │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n    │       │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n    │       └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n    │         └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n    │           └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n    └─HashJoin(Probe)\t16.00\troot\t\tinner join, equal:[eq(Column#163, Column#164)]\n      ├─Projection(Build)\t8.89\troot\t\twith_non_recursive_bugs.b.col_varchar_key, with_non_recursive_bugs.cc.col_int_key, with_non_recursive_bugs.cc.col_datetime_key, cast(with_non_recursive_bugs.cc.col_datetime_key, double BINARY)->Column#164\n      │ └─HashJoin\t8.89\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.cc.col_varchar_key)], other cond:or(like(with_non_recursive_bugs.d.col_varchar_key, \"w\", 92), ne(with_non_recursive_bugs.cc.pk, 4))\n      │   ├─HashJoin(Build)\t8.00\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.b.col_blob)]\n      │   │ ├─TableReader(Build)\t8.00\troot\t\tdata:Selection\n      │   │ │ └─Selection\t8.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob_key))\n      │   │ │   └─TableFullScan\t10.00\tcop[tikv]\ttable:d\tkeep order:false\n      │   │ └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │   │   └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.b.col_blob))\n      │   │     └─TableFullScan\t10.00\tcop[tikv]\ttable:b\tkeep order:false\n      │   └─TableReader(Probe)\t10.00\troot\t\tdata:Selection\n      │     └─Selection\t10.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.cc.col_varchar_key))\n      │       └─TableFullScan\t10.00\tcop[tikv]\ttable:alias2\tkeep order:false\n      └─Projection(Probe)\t18.00\troot\t\twith_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_time_key, cast(with_non_recursive_bugs.d.pk, double BINARY)->Column#163\n        └─HashJoin\t18.00\troot\t\tleft outer join, equal:[eq(with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_int)]\n          ├─TableReader(Build)\t9.00\troot\t\tdata:Selection\n          │ └─Selection\t9.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_int))\n          │   └─TableFullScan\t10.00\tcop[tikv]\ttable:outr2\tkeep order:false\n          └─TableReader(Probe)\t10.00\troot\t\tdata:TableFullScan\n            └─TableFullScan\t10.00\tcop[tikv]\ttable:outr1\tkeep order:false\nLevel\tCode\tMessage\nWarning\t8061\tOptimizer hint NO_MERGE is not supported by TiDB and is ignored\n\n"
tidb-server(PID: 2342) stopped
time="2024-05-18T08:27:59+08:00" level=warning msg="partition:1711 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_NULL_IN_VALUES_LESS_THAN) (err: Error 1659 (HY000): Field 'NULL' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a int)\nPARTITION BY RANGE(a)\n(PARTITION p0 VALUES LESS THAN (NULL));)"
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-18T08:27:59+08:00" level=warning msg="command not implemented" arguments=" ($cnt)\n{\nupdate t1 set s2 = 1;" command=while line=2063
time="2024-05-18T08:27:59+08:00" level=warning msg="command not implemented" arguments=" $cnt;" command=dec line=2067
time="2024-05-18T08:28:00+08:00" level=warning msg="command not implemented" arguments=" ($n)\n{\ninsert into t1 (user) values ('mysql');" command=while line=2192
time="2024-05-18T08:28:00+08:00" level=warning msg="command not implemented" arguments=" $n;" command=dec line=2195
[Checks API] No suitable checks publisher found.
[Pipeline] archiveArtifacts
Archiving artifacts
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
Sending interrupt signal to process
Killing processes
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2435 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) (err: Error 8200 (HY000): unsupported add column 's3' constraint UNIQUE KEY when altering 'partition.t1') (query: ALTER TABLE t1 ADD COLUMN (s3 VARCHAR(5) UNIQUE);)"
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2486 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table B of the UPDATE is not updatable) (query: UPDATE t1_part AS A NATURAL JOIN v1 as B SET A.nokey = 2 , B.partkey = 3;)"
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2488 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 NATURAL JOIN t1_part as B SET A.nokey = 2 , B.partkey = 3;)"
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2728 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DROP TABLE IF EXISTS `example`;)"
time="2024-05-18T08:28:02+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=2939
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2945 query failed with non expected error(s)! (ER_DUP_FIELDNAME != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 CHANGE COLUMN i j INT, CHANGE COLUMN j i INT;)"
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
time="2024-05-18T08:28:02+08:00" level=warning msg="partition:2984 query failed with non expected error(s)! (ErrDupFieldName != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 RENAME COLUMN i TO j, RENAME COLUMN j TO i;)"
./t/partition.test: ok! 725 test cases passed, take time 8.290228767 s
./t/partition_bug18198.test: ok! 45 test cases passed, take time 0.041202969 s
time="2024-05-18T08:28:03+08:00" level=warning msg="partition_column:49 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a BLOB)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2024-05-18T08:28:03+08:00" level=warning msg="partition_column:54 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a TEXT)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
kill finished with exit code 0
tidb-server(PID: 2227) 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
tidb-server(PID: 2280) 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] }
[Checks API] No suitable checks publisher found.
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '3'
[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 FAILURE result.json
http://fileserver.pingcap.net
--2024-05-18 00:28:07--  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%  531M=0s

2024-05-18 00:28:07 (531 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

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