Skipping 1,014 KB.. Full Log

time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:286 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:286 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:38+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ER_DUP_ENTRY != 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-18T07:10:38+08:00" level=warning msg="view:521 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_INVALID) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 values('a','aa');)"
time="2024-05-18T07:10:38+08:00" level=warning msg="view:602 query failed with non expected error(s)! (ErrBadTable != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: CREATE VIEW v02 AS SELECT * FROM DUAL;)"
time="2024-05-18T07:10:38+08:00" level=warning msg="view:618 query failed with non expected error(s)! (ErrUnknown != ER_WRONG_OBJECT) (err: Error 1105 (HY000): Unknown charset ) (query: create index i1 on v1 (col1);)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:327 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:327 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:368 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:368 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:385 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:38+08:00" level=warning msg="foreign_key_cascade_delete:385 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:432 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:432 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:449 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:449 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:495 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:495 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:535 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:535 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:575 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:575 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) REFERENCES `t1` (`a` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:615 Unknown named error `b`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2` in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:655 Unknown named error CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE) in --error ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)"
time="2024-05-18T07:10:39+08:00" level=warning msg="foreign_key_cascade_delete:655 query failed with non expected error(s)! (ErrNoReferencedRow2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`) REFERENCES `t1` (`id`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-18T07:10:39+08:00" level=error msg="run test [group_min_max_innodb] err: sql:EXPLAIN format='brief' SELECT DISTINCT a1\nFROM t1\nWHERE (pk_col = 2 OR pk_col = 22) AND a1 = 'a';: failed to run query \n\"EXPLAIN format='brief' SELECT DISTINCT a1\nFROM t1\nWHERE (pk_col = 2 OR pk_col = 22) AND a1 = 'a';\" \n around line 332, \nwe need(419):\nEXPLAIN format='brief' SELECT DISTINCT a1\nFROM t1\nWHERE (pk_col = 2 OR pk_col = 22) AND a1 = 'a';\nid\testRows\ttask\taccess object\toperator info\nHashAgg\t1.00\troot\t\tgroup by:group_min_max_innodb.t1.a1, funcs:firstrow(group_min_max_innodb.t1.a1)->group_min_max_innodb.t1.a1\n└─Selection\t1.00\troot\t\teq(group_min_max_innodb.t1.a1, \"a\")\n  └─Batch_Point_Get\t2.00\troot\ttable:t1\thandle:[2 22], keep order:false, desc:false\n\nbut got(419):\nEXPLAIN format='brief' SELECT DISTINCT a1\nFROM t1\nWHERE (pk_col = 2 OR pk_col = 22) AND a1 = 'a';\nid\testRows\ttask\taccess object\toperator info\nHashAgg\t1.00\troot\t\tgroup by:group_min_max_innodb.t1.a1, funcs:firstrow(group_min_max_innodb.t1.a1)->group_min_max_innodb.t1.a1\n└─Selection\t2.00\troot\t\teq(group_min_max_innodb.t1.a1, \"a\")\n  └─Batch_Point_Get\t2.00\troot\ttable:t1\thandle:[2 22], keep order:false, desc:false\n\n"
time="2024-05-18T07:10:39+08:00" level=warning msg="command not implemented" arguments=" include/have_ps_protocol.inc" command=source line=8
./t/multi_valued_index.test: ok! 659 test cases passed, take time 3.691550722 s
./t/group_min_max_ps_protocol.test: ok! 22 test cases passed, take time 0.206348375 s
time="2024-05-18T07:10:40+08:00" level=warning msg="groupby:32 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_BAD_FIELD_ERROR) (err: Error 1105 (HY000): Unknown column '3' in 'group statement') (query: select * from t group by 3 order by c1;)"
time="2024-05-18T07:10:40+08:00" level=warning msg="groupby:36 query failed with non expected error(s)! (ErrWrongGroupField != ER_INVALID_GROUP_FUNC_USE) (err: Error 1056 (42000): Can't group on 'count(c1)') (query: select count(c1) from t group by 1 order by c1;)"
time="2024-05-18T07:10:40+08:00" level=warning msg="groupby:54 query succeeded, but expected error(s)! (expected errors: ER_NON_UNIQ_ERROR) (query: select c1 as c2, c2 from t group by c2 + 1 order by c1;)"
./t/groupby.test: ok! 99 test cases passed, take time 0.239237405 s
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 0.535953897 s
time="2024-05-18T07:10:40+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.122528157 s
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.127493563 s
time="2024-05-18T07:10:40+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.173575935 s
time="2024-05-18T07:10:41+08:00" level=warning msg="having:258 query succeeded, but expected error(s)! (expected errors: 1064) (query: select sum(col1) as co2, count(col2) as cc from t1 group by col1 having col1 =10;)"
time="2024-05-18T07:10:41+08:00" level=warning msg="having:268 query succeeded, but expected error(s)! (expected errors: 1054) (query: select t1.col1 from t1\nwhere t1.col2 in\n(select t2.col2 from t2\ngroup by t2.col1, t2.col2 having t2.col1 <= 10);)"
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=313
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=320
time="2024-05-18T07:10:41+08:00" level=warning msg="having:359 query failed with non expected error(s)! (ErrBadField != 1052) (err: Error 1054 (42S22): Unknown column 'col1' in 'having clause') (query: select t1.col1*10+t2.col1 from t1,t2 where t1.col1=t2.col1\ngroup by t1.col1, t2.col1 having col1 = 2;)"
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=371
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=373
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=467
time="2024-05-18T07:10:41+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=469
time="2024-05-18T07:10:41+08:00" level=warning msg="having:473 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'f1'; this is incompatible with sql_mode=only_full_group_by) (query: select f1 from t1 having max(f1)=f1;)"
./t/null_key_all_innodb.test: ok! 71 test cases passed, take time 1.095103141 s
./t/odbc.test: ok! 32 test cases passed, take time 0.158526267 s
./t/operator.test: ok! 28 test cases passed, take time 0.006413562 s
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.581911686 s
time="2024-05-18T07:10:43+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.521976314 s
./t/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.28244392 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.130974463 s
time="2024-05-18T07:10:44+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-18T07:10:44+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-18T07:10:44+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/having.test: ok! 273 test cases passed, take time 3.454012288 s
time="2024-05-18T07:10:43+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-18T07:10:43+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/having_myisam.test: ok! 17 test cases passed, take time 0.332253515 s
./t/order_by_limit.test: ok! 45 test cases passed, take time 0.514606654 s
time="2024-05-18T07:10:44+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=53
time="2024-05-18T07:10:44+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=55
time="2024-05-18T07:10:44+08:00" level=warning msg="command not implemented" arguments=" 0 x 1 x 2 x 3 x 4 x 5 x 6 x 7 x 8 x 9 x 10 x 11 x 12 x 13 x 14 x" command=replace_result line=58
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 8.286639169 s
./t/heap_btree.test: ok! 147 test cases passed, take time 1.82184769 s
./t/heap_btree_myisam.test: ok! 12 test cases passed, take time 0.205407219 s
time="2024-05-18T07:10:46+08:00" level=error msg="run test [histogram_singleton] err: sql:EXPLAIN SELECT * FROM tbl_int WHERE col1 > 0;: failed to run query \n\"EXPLAIN SELECT * FROM tbl_int WHERE col1 > 0;\" \n around line 11, \nwe need(277):\nEXPLAIN SELECT * FROM tbl_int WHERE col1 > 0;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t8.00\troot\t\tdata:Selection_6\n└─Selection_6\t8.00\tcop[tikv]\t\tgt(histogram_singleton.tbl_int.col1, 0)\n  └─TableFullScan_5\t10.00\tcop[tikv]\ttable:tbl_int\tkeep order:false\n\nbut got(277):\nEXPLAIN SELECT * FROM tbl_int WHERE col1 > 0;\nid\testRows\ttask\taccess object\toperator info\nTableReader_7\t7.00\troot\t\tdata:Selection_6\n└─Selection_6\t7.00\tcop[tikv]\t\tgt(histogram_singleton.tbl_int.col1, 0)\n  └─TableFullScan_5\t10.00\tcop[tikv]\ttable:tbl_int\tkeep order:false\n\n"
time="2024-05-18T07:10:46+08:00" level=warning msg="ignore_strict:103 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 2.145884824 s
./t/orderby.test: ok! 53 test cases passed, take time 0.08974513 s
time="2024-05-18T07:10:46+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.005254793 s
./t/packet.test: ok! 50 test cases passed, take time 0.13352329 s
time="2024-05-18T07:10:47+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2024-05-18T07:10:47+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2024-05-18T07:10:47+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2024-05-18T07:10:47+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
time="2024-05-18T07:10:47+08:00" level=warning msg="ignore_strict:346 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_NO_DEFAULT_FOR_VIEW_FIELD) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: INSERT INTO v1 (vcol1) VALUES(12);)"
time="2024-05-18T07:10:47+08:00" level=warning msg="ignore_strict:391 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00') (query: INSERT INTO t1 VALUES(STR_TO_DATE('32.10.2004 15.30','%D.%D.%Y %H.%I'));)"
time="2024-05-18T07:10:47+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.400863792 s
time="2024-05-18T07:10:47+08:00" level=warning msg="ignore_strict:412 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-18T07:10:47+08:00" level=warning msg="ignore_strict:417 query failed with non expected error(s)! (ER_DATA_TOO_LONG != ER_TRUNCATED_WRONG_VALUE) (err: Error 1406 (22001): Data Too Long, field len 3, data len 4) (query: INSERT INTO t1 (col1) VALUES (CAST(1000 as CHAR(3)));)"
time="2024-05-18T07:10:47+08:00" level=warning msg="ignore_strict:439 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE_FOR_FIELD != 1265) (err: Error 1366 (HY000): Incorrect tinyint value: '1a' for column 'a' at row 1) (query: INSERT INTO t1 VALUES ('1a');)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:292 query succeeded, but expected error(s)! (expected errors: 1215) (query: alter table blobchild add constraint fkbad foreign key(a) references parent (a) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="ignore_strict:460 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_WARN_NULL_TO_NOTNULL) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/wl6030_2.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/wl6030_2.dat' INTO TABLE t1 FIELDS TERMINATED BY ',' ENCLOSED BY '\"';)"
time="2024-05-18T07:10:48+08:00" level=warning msg="ignore_strict:486 query succeeded, but expected error(s)! (expected errors: ER_BAD_NULL_ERROR) (query: INSERT INTO t1 VALUES (NULL);)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:317 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (a) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:345 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(a) references parent (b) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:373 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(b) references parent (b) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:404 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (a) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="foreign_key_cascade_mysql:432 query failed with non expected error(s)! (ErrFkDupName != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (b) on delete cascade on update restrict;)"
time="2024-05-18T07:10:48+08:00" level=warning msg="ignore_strict:624 query failed with non expected error(s)! (ErrLoadDataFromServerDisk != ER_DUP_ENTRY) (err: Error 8154 (HY000): Don't support load data from tidb-server's disk. Or if you want to load local data via client, the path of INFILE '../../std_data/rpl_loaddata.dat' needs to specify the clause of LOCAL first) (query: LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE t2 (a, @b) SET b= @b + 2;)"
./t/ignore_strict.test: ok! 157 test cases passed, take time 1.843885016 s
time="2024-05-18T07:10:48+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=25
time="2024-05-18T07:10:48+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=44
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 2.701767094 s
time="2024-05-18T07:10:48+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=61
time="2024-05-18T07:10:48+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=76
time="2024-05-18T07:10:48+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=91
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=106
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=121
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=136
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=151
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $default_engine <default_engine>" command=replace_result line=166
./t/implicit_char_to_num_conversion.test: ok! 110 test cases passed, take time 0.746298252 s
./t/in.test: ok! 13 test cases passed, take time 0.037242322 s
time="2024-05-18T07:10:49+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-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" ;" command=delimiter line=448
time="2024-05-18T07:10:49+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-18T07:10:49+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-18T07:10:49+08:00" level=warning msg="parser:562 query failed with non expected error(s)! (ErrSpDoesNotExist 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);)"
./t/index.test: ok! 33 test cases passed, take time 0.260270765 s
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 0.902925078 s

Great, All tests passed
time="2024-05-18T07:10:49+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=915
time="2024-05-18T07:10:49+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-18T07:10:49+08:00" level=warning msg="parser:932 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;)"
time="2024-05-18T07:10:49+08:00" level=warning msg="parser:941 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 ORDER BY 1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2024-05-18T07:10:49+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-18T07:10:49+08:00" level=warning msg="parser:968 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 LIMIT 1;)"
time="2024-05-18T07:10:49+08:00" level=warning msg="parser:977 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 ORDER BY 1;)"
time="2024-05-18T07:10:49+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;)"
mysqltest end
tidb-server(PID: 2290) stopped
time="2024-05-18T07:10:49+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-18T07:10:49+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-18T07:10:49+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-18T07:10:49+08:00" level=warning msg="parser:1069 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.`MyISAM`;)"
time="2024-05-18T07:10:49+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-18T07:10:49+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-18T07:10:49+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-18T07:10:50+08:00" level=warning msg="parser:1220 query failed with non expected error(s)! (ErrNoSuchTable != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: REPLACE INTO `` SELECT * FROM ``;)"
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-9429/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
time="2024-05-18T07:10:50+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-18T07:10:50+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-18T07:10:50+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-18T07:10:50+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-18T07:10:50+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-18T07:10:50+08:00" level=warning msg="parser:1317 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 a FROM t1 LIMIT 1 UNION ALL SELECT a FROM t1;)"
time="2024-05-18T07:10:50+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-18T07:10:50+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-18T07:10:50+08:00" level=warning msg="parser:1377 query failed with non expected error(s)! (ER_WRONG_USAGE != 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;)"
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
time="2024-05-18T07:10:50+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 );)"
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2024-05-18T07:10:53+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-18T07:10:53+08:00" level=warning msg="parser:1978 query failed with non expected error(s)! (ErrNoSuchTable != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: DROP INDEX idx1 ON ``;)"
time="2024-05-18T07:10:53+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-18T07:10:53+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-18T07:10:53+08:00" level=warning msg="parser:2245 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global') (query: SET GLOBAL = DEFAULT;)"
time="2024-05-18T07:10:53+08:00" level=warning msg="parser:2247 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local') (query: SET LOCAL = DEFAULT;)"
time="2024-05-18T07:10:53+08:00" level=warning msg="parser:2249 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist') (query: SET PERSIST = DEFAULT;)"
time="2024-05-18T07:10:53+08:00" level=warning msg="parser:2251 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist_only') (query: SET PERSIST_ONLY = DEFAULT;)"
time="2024-05-18T07:10:53+08:00" level=warning msg="parser:2253 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session') (query: SET SESSION = DEFAULT;)"
time="2024-05-18T07:10:53+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-18T07:10:53+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-18T07:10:53+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-18T07:10:53+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-18T07:10:53+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 5.919847366 s
./t/parser_precedence.test: ok! 138 test cases passed, take time 0.087391724 s
time="2024-05-18T07:10:51+08:00" level=warning msg="view:4019 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c1 = 'text1';)"
time="2024-05-18T07:10:51+08:00" level=warning msg="view:4040 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c2 = 'text2';)"
time="2024-05-18T07:10:52+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=4444
time="2024-05-18T07:10:55+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-18T07:10:55+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=5522
time="2024-05-18T07:10:55+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=5523
time="2024-05-18T07:10:55+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_count_sessions.inc" command=source line=6063
time="2024-05-18T07:10:57+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 21.460277561 s
time="2024-05-18T07:10:58+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-18T07:10:58+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-18T07:10:58+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-18T07:10:58+08:00" level=warning msg="view_grant:369 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't2') (query: create view v3 as select a from mysqltest.t2;)"
time="2024-05-18T07:10: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-18T07:10:58+08:00" level=warning msg="partition:1364 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != 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-18T07:10:58+08:00" level=warning msg="partition:1374 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != 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-18T07:10: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));)"
time="2024-05-18T07:10:59+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-18T07:10:59+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-18T07:10:59+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-18T07:10:59+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-18T07:11:00+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-18T07:11:00+08:00" level=warning msg="command not implemented" arguments=" ($cnt)\n{\nupdate t1 set s2 = 1;" command=while line=2063
time="2024-05-18T07:11:00+08:00" level=warning msg="command not implemented" arguments=" $cnt;" command=dec line=2067
time="2024-05-18T07:11: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-18T07:11:00+08:00" level=warning msg="command not implemented" arguments=" $n;" command=dec line=2195
time="2024-05-18T07:11:00+08:00" level=warning msg="view_grant:966 query failed with non expected error(s)! (ErrViewInvalid != 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-18T07:11:00+08:00" level=warning msg="view_grant:971 query failed with non expected error(s)! (ErrViewInvalid != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2024-05-18T07:11:01+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;)"
time="2024-05-18T07:11:01+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-18T07:11:01+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-18T07:11:01+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-18T07:11:01+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-18T07:11:01+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-18T07:11:01+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-18T07:11:00+08:00" level=warning msg="command not implemented" arguments=" ($merge_table_support)\n{" command=if line=486
time="2024-05-18T07:11:02+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-18T07:11:02+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-18T07:11:02+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-18T07:11:02+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;)"
./t/index_merge1.test: ok! 160 test cases passed, take time 12.661488486 s
time="2024-05-18T07:11: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-18T07:11:02+08:00" level=warning msg="partition:2486 query failed with non expected error(s)! (ErrNonUpdatableTable != 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-18T07:11: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-18T07:11:03+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-18T07:11:03+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=2939
time="2024-05-18T07:11:03+08:00" level=warning msg="partition:2945 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 CHANGE COLUMN i j INT, CHANGE COLUMN j i INT;)"
time="2024-05-18T07:11:03+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 9.779295532 s
./t/partition_bug18198.test: ok! 45 test cases passed, take time 0.056900396 s
time="2024-05-18T07:11: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-18T07:11:03+08:00" level=warning msg="partition_column:54 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != 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\"));)"
time="2024-05-18T07:11:03+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-18T07:11:04+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-18T07:11:04+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-18T07:11:04+08:00" level=warning msg="partition_column:477 query failed with non expected error(s)! (ErrPartitionColumnList != 1566) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: create table t1 (a int, b int)\npartition by range columns(a,b)\n(partition p0 values less than (10));)"
time="2024-05-18T07:11:04+08:00" level=warning msg="partition_column:530 query failed with non expected error(s)! (ErrRangeNotIncreasing != ER_REORG_OUTSIDE_RANGE) (err: Error 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition) (query: alter table t1 reorganize partition p0 into\n(partition p01 values less than (0,3),\npartition p02 values less than (1,1));)"
time="2024-05-18T07:11:04+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-18T07:11:04+08:00" level=warning msg="view_grant:2149 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v11 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v11_merge as v11 set v11.val= 'test11'\nwhere t2.id= v11.id;)"
time="2024-05-18T07:11:04+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-18T07:11:04+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v4 of the UPDATE is not updatable) (query: update mysqltest1.t11 as t11, mysqltest2.v41 as v4 set v4.val= 'test20'\nwhere t11.id= v4.id;)"
./t/partition_column.test: ok! 152 test cases passed, take time 1.347600579 s
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2024-05-18T07:11:05+08:00" level=warning msg="view_grant:2955 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-18T07:11:05+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-18T07:11:05+08:00" level=warning msg="view_grant:2962 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 IGNORE test1.v1_all SET cn='x';)"
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments=" ($index_merge_random_rows_in_EXPLAIN)\n{" command=if line=588
./t/view_grant.test: ok! 719 test cases passed, take time 7.214704659 s
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:36 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 values (1,2);)"
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:38 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 select * from t2;)"
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:41 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_MULTIUPDATE) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3(a,b) values (1,2);)"
time="2024-05-18T07:11:05+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-18T07:11:05+08:00" level=warning msg="view_myisam:56 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete from v3;)"
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:58 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete v3,t1 from v3,t1;)"
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:60 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete t1,v3 from t1,v3;)"
time="2024-05-18T07:11:05+08:00" level=warning msg="view_myisam:122 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != 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-18T07:11:05+08:00" level=warning msg="view_myisam:126 query failed with non expected error(s)! (ErrUnknown != ER_TOO_MANY_FIELDS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE table_broken AS SELECT * FROM t1, t2, t3;)"
./t/view_myisam.test: ok! 31 test cases passed, take time 0.400431687 s
./t/partition_column_prune.test: ok! 27 test cases passed, take time 0.475951935 s
time="2024-05-18T07:11:05+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
./t/index_merge2.test: ok! 328 test cases passed, take time 3.166858306 s
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments=" include/have_64bit.inc" command=source line=9
time="2024-05-18T07:11:05+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.063853653 s
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2024-05-18T07:11:05+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=111
./t/index_merge_bugs.test: ok! 11 test cases passed, take time 0.191405548 s
./t/warnings.test: ok! 74 test cases passed, take time 0.493326535 s
time="2024-05-18T07:11:06+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-18T07:11:06+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-18T07:11:06+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-18T07:11:06+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2024-05-18T07:11:06+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-18T07:11:06+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2024-05-18T07:11:06+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-18T07:11:06+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-18T07:11:06+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-18T07:11:06+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2024-05-18T07:11:06+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-18T07:11:06+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.529349665 s
time="2024-05-18T07:11:07+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-18T07:11:07+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-18T07:11:07+08:00" level=warning msg="window_functions:257 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: SELECT id, FIRST_VALUE(id) OVER w first, LAST_VALUE(id) OVER w last, sex FROM t1\nWINDOW w AS (PARTITION BY sex\nORDER BY id ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING);)"
time="2024-05-18T07:11:07+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-18T07:11:07+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-18T07:11:08+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-18T07:11:08+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=114
time="2024-05-18T07:11:08+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=121
time="2024-05-18T07:11:08+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-18T07:11:09+08:00" level=warning msg="window_functions:1612 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 (row_number() over ());)"
time="2024-05-18T07:11:09+08:00" level=warning msg="window_functions:1614 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (1+row_number() over ());)"
time="2024-05-18T07:11:09+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;)"
time="2024-05-18T07:11:09+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-18T07:11:09+08:00" level=warning msg="window_functions:1944 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a > ANY (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-18T07:11:09+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-18T07:11:10+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-18T07:11:10+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-18T07:11:10+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-18T07:11:10+08:00" level=warning msg="window_functions:2050 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT 1+SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-18T07:11:10+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-18T07:11:10+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-18T07:11:10+08:00" level=warning msg="window_functions:2079 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(a), SUM(a) OVER () FROM t;)"
time="2024-05-18T07:11:11+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;)"
time="2024-05-18T07:11:11+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-18T07:11:11+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-18T07:11:11+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
time="2024-05-18T07:11:11+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-18T07:11:11+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-18T07:11:11+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;)"
./t/index_merge_delete.test: ok! 214 test cases passed, take time 6.308076159 s
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.283862166 s
time="2024-05-18T07:11:13+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-18T07:11:13+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-18T07:11:13+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-18T07:11:13+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-18T07:11:13+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 6.954287388 s
time="2024-05-18T07:11:13+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2024-05-18T07:11:13+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2024-05-18T07:11:13+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.894738282 s
time="2024-05-18T07:11:15+08:00" level=warning msg="window_functions_bugs:619 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(FIRST_VALUE(CAST('' AS JSON)) OVER (), '');)"
time="2024-05-18T07:11:15+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-18T07:11:15+08:00" level=warning msg="window_functions_bugs:623 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2024-05-18T07:11:15+08:00" level=warning msg="window_functions_bugs:625 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '');)"
./t/window_functions_bugs.test: ok! 157 test cases passed, take time 1.151542334 s
time="2024-05-18T07:11:15+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-18T07:11:16+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"
./t/window_min_max.test: ok! 200 test cases passed, take time 0.604565451 s
time="2024-05-18T07:11:16+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2024-05-18T07:11:16+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-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
./t/partition_func.test: ok! 1341 test cases passed, take time 11.543829239 s
./t/partition_grant.test: ok! 21 test cases passed, take time 0.170960448 s
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" include/no_valgrind_without_big.inc" command=source line=9
time="2024-05-18T07:11:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2024-05-18T07:11:18+08:00" level=warning msg="with_non_recursive:692 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-18T07:11:18+08:00" level=warning msg="with_non_recursive:694 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ no_merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2024-05-18T07:11:18+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-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2024-05-18T07:11:18+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-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2024-05-18T07:11:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2024-05-18T07:11:18+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 1.175880006 s
time="2024-05-18T07:11:19+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-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2024-05-18T07:11:19+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2024-05-18T07:11:19+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.568186799 s
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 0.559661113 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.071868913 s
time="2024-05-18T07:11:20+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2024-05-18T07:11:20+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.241413365 s
./t/year_innodb.test: ok! 51 test cases passed, take time 0.364762011 s
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
./t/partition_hash.test: ok! 306 test cases passed, take time 3.95727825 s
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments=" include/not_embedded.inc" command=source line=2
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments=" include/have_partition.inc" command=source line=3
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=4
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=73
time="2024-05-18T07:11:21+08:00" level=warning msg="command not implemented" arguments= command=reap line=79
time="2024-05-18T07:11:22+08:00" level=warning msg="command not implemented" arguments= command=enable_parsing line=444
./t/partition_innodb.test: ok! 114 test cases passed, take time 1.01958843 s
time="2024-05-18T07:11:22+08:00" level=warning msg="partition_list:81 query failed with non expected error(s)! (ER_PARTITION_COLUMN_LIST_ERROR != ER_PARSE_ERROR) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: ALTER TABLE t1 ADD PARTITION\n(PARTITION p3_a VALUES IN ((1 + 1 + 1), \"a0\"));)"
time="2024-05-18T07:11:22+08:00" level=warning msg="partition_list:96 query failed with non expected error(s)! (ErrPartitionColumnList != ER_PARSE_ERROR) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: ALTER TABLE t1 ADD PARTITION\n(PARTITION part_2 VALUES IN ((21 ,22, 23, 24, 25, 26, 27, 28, 29, 30,\n31 ,32, 33, 34, 35, 36, 37, 38, 39, 40),\n(41 ,42, 43, 44, 45, 46, 47, 48, 49, 50,\n51 ,52, 53, 54, 55, 56, 57, 58, 59, 60)));)"
./t/partition_list.test: ok! 107 test cases passed, take time 0.673027996 s

time="2024-05-18T07:11:23+08:00" level=error msg="1 tests failed\n"
time="2024-05-18T07:11:23+08:00" level=error msg="run test [limit] err: sql:explain select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;: failed to run query \n\"explain select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;\" \n around line 236, \nwe need(466):\nexplain select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;\nid\testRows\ttask\taccess object\toperator info\nTopN_11\t1.00\troot\t\tColumn#3, offset:0, count:3\n└─StreamAgg_30\t1.00\troot\t\tfuncs:count(Column#5)->Column#3\n  └─TableReader_31\t1.00\troot\t\tdata:StreamAgg_19\n    └─StreamAgg_19\t1.00\tcop[tikv]\t\tfuncs:count(1)->Column#5\n      └─Selection_29\t7.00\tcop[tikv]\t\tgt(limit.t1.a, 0)\n        └─TableFullScan_28\t7.00\tcop[tikv]\ttable:t1\tkeep order:false\n\nbut got(466):\nexplain select count(*) c FROM t1 WHERE a > 0 ORDER BY c LIMIT 3;\nid\testRows\ttask\taccess object\toperator info\nTopN_11\t1.00\troot\t\tColumn#3, offset:0, count:3\n└─StreamAgg_30\t1.00\troot\t\tfuncs:count(Column#5)->Column#3\n  └─TableReader_31\t1.00\troot\t\tdata:StreamAgg_19\n    └─StreamAgg_19\t1.00\tcop[tikv]\t\tfuncs:count(1)->Column#5\n      └─Selection_29\t6.00\tcop[tikv]\t\tgt(limit.t1.a, 0)\n        └─TableFullScan_28\t7.00\tcop[tikv]\ttable:t1\tkeep order:false\n\n"
tidb-server(PID: 2348) stopped
[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] 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 = '3'
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
Sending interrupt signal to process
Killing processes
kill finished with exit code 0
tidb-server(PID: 2305) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
tidb-server(PID: 2271) stopped
script returned exit code 143
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '2'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh FAILURE result.json
http://fileserver.pingcap.net
--2024-05-17 23:11:30--  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%  252M=0s

2024-05-17 23:11:30 (252 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