Skipping 1,082 KB.. Full Log

time="2024-05-12T06:45:57+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-12T06:45:57+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-12T06:45:57+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-12T06:45:57+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-12T06:45:57+08:00" level=warning msg="foreign_key_cascade_delete:615 query failed with non expected error(s)! (ER_NO_REFERENCED_ROW_2 not in ER_[planner:1452]Cannot add or update a child row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (err: Error 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`foreign_key_cascade_delete`.`t2`, CONSTRAINT `fk` FOREIGN KEY (`a`, `b`) REFERENCES `t1` (`a`, `b`) ON DELETE CASCADE)) (query: insert into t2 (id, a, b, name) values (1, 1, 1, 'a');)"
time="2024-05-12T06:45:57+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-12T06:45:57+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-12T06:45:57+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-12T06:45:58+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=146
time="2024-05-12T06:46:01+08:00" level=warning msg="type_float:251 query failed with non expected error(s)! (ErrTooBigDisplaywidth != 1427) (err: Error 1439 (42000): Display width out of range for column 's1' (max = 255)) (query: create table t1 (s1 float(0,2));)"
time="2024-05-12T06:46:02+08:00" level=warning msg="command not implemented" arguments=" select concat((truncate((-1.7976931348623157E+307),(0x1e))),\n($nine_65)) into @a;" command=eval line=358
./t/foreign_key_cascade_delete.test: ok! 527 test cases passed, take time 8.470827533 s
./t/partition_hash.test: ok! 306 test cases passed, take time 9.895159368 s
time="2024-05-12T06:46:03+08:00" level=warning msg="command not implemented" arguments=" include/not_embedded.inc" command=source line=2
time="2024-05-12T06:46:03+08:00" level=warning msg="command not implemented" arguments=" include/have_partition.inc" command=source line=3
time="2024-05-12T06:46:03+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=4
time="2024-05-12T06:46:03+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=73
time="2024-05-12T06:46:03+08:00" level=warning msg="command not implemented" arguments= command=reap line=79
time="2024-05-12T06:46:05+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 2.4330019849999998 s
time="2024-05-12T06:46:06+08:00" level=warning msg="partition_list:81 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 p3_a VALUES IN ((1 + 1 + 1), \"a0\"));)"
time="2024-05-12T06:46:06+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 3.926682959 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2545) stopped
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-qe-tidb-test-ghpr_integration_mysql_test-129/mysql-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
time="2024-05-12T06:46:10+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;)"
[Pipeline] }
time="2024-05-12T06:46:12+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-12T06:46:12+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-12T06:46:12+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-12T06:46:12+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-12T06:46:12+08:00" level=warning msg="foreign_key_cascade_mysql:432 query failed with non expected error(s)! (ER_FK_DUP_NAME != 1215) (err: Error 1826 (HY000): Duplicate foreign key constraint name 'fkbad') (query: alter table blobchild add constraint fkbad foreign key(c) references parent (b) on delete cascade on update restrict;)"
./t/type_float.test: ok! 269 test cases passed, take time 16.745088906 s
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=15
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=22
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=29
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=36
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=43
time="2024-05-12T06:46:13+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=50
time="2024-05-12T06:46:14+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=57
./t/type_nchar.test: ok! 23 test cases passed, take time 1.010664065 s
./t/foreign_key_cascade_mysql.test: ok! 301 test cases passed, take time 12.392887078 s
./t/foreign_key_cascade_type.test: ok! 143 test cases passed, take time 2.560238333 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2572) stopped
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-qe-tidb-test-ghpr_integration_mysql_test-129/mysql-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[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-12T06:46:26+08:00" level=warning msg="type_newdecimal:1836 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT a - b FROM t1;)"
time="2024-05-12T06:46:26+08:00" level=warning msg="type_newdecimal:1840 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT a - b FROM t3;)"
time="2024-05-12T06:46:27+08:00" level=warning msg="type_newdecimal:1861 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT * FROM t ORDER BY (a-b);)"
time="2024-05-12T06:46:27+08:00" level=warning msg="type_newdecimal:1880 query failed with non expected error(s)! (ER_INVALID_JSON_PATH != ER_INVALID_TYPE_FOR_JSON) (err: Error 3143 (42000): Invalid JSON path expression. The error is around character position 1.) (query: SELECT -1 DIV LEAST(1,JSON_INSERT(1, '$[1]','','',''));)"
./t/type_newdecimal.test: ok! 584 test cases passed, take time 13.652418751 s
time="2024-05-12T06:46:37+08:00" level=warning msg="type_ranges:151 query failed with non expected error(s)! (ER_WRONG_VALUE_COUNT_ON_ROW != 1060) (err: Error 1136 (21S01): Column count doesn't match value count at row 1) (query: insert into t3 select * from t1, t2;)"
./t/type_ranges.test: ok! 82 test cases passed, take time 10.694151446 s
time="2024-05-12T06:46:38+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=12
time="2024-05-12T06:46:39+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=22
time="2024-05-12T06:46:39+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=26
./t/type_set.test: ok! 33 test cases passed, take time 1.289537586 s
./t/type_time.test: ok! 144 test cases passed, take time 3.565597265 s
time="2024-05-12T06:46:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=104
time="2024-05-12T06:46:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=117
time="2024-05-12T06:46:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=132
time="2024-05-12T06:46:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=148
time="2024-05-12T06:46:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=164
time="2024-05-12T06:46:46+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=180
time="2024-05-12T06:46:46+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=199
time="2024-05-12T06:46:47+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=259
time="2024-05-12T06:46:47+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=271
time="2024-05-12T06:46:47+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=286
./t/type_timestamp.test: ok! 279 test cases passed, take time 5.866764337 s
time="2024-05-12T06:46:50+08:00" level=warning msg="command not implemented" arguments=" type_timestamp.test" command=source line=7
time="2024-05-12T06:46:50+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=23
time="2024-05-12T06:46:50+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=33
time="2024-05-12T06:46:50+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=51
./t/type_timestamp_explicit.test: ok! 48 test cases passed, take time 2.408119165 s
time="2024-05-12T06:46:52+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-12T06:46:52+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/type_timestamp_myisam.test: ok! 6 test cases passed, take time 0.181664544 s
./t/type_uint.test: ok! 9 test cases passed, take time 0.148410602 s
./t/type_unit.test: ok! 9 test cases passed, take time 0.15078331 s
./t/type_varchar.test: ok! 180 test cases passed, take time 12.432271651 s
./t/type_year.test: ok! 101 test cases passed, take time 2.266138972 s
time="2024-05-12T06:47:08+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=4
time="2024-05-12T06:47:14+08:00" level=warning msg="update:425 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: SET SESSION sql_safe_updates = DEFAULT;)"
time="2024-05-12T06:47:15+08:00" level=warning msg="update:448 query succeeded, but expected error(s)! (expected errors: ER_VIEW_INVALID) (query: SET sql_mode = default;)"
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=559
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=560
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=572
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=573
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=583
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=584
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=600
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=601
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=607
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=608
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=614
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=615
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=634
time="2024-05-12T06:47:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=635
time="2024-05-12T06:47:18+08:00" level=warning msg="update:648 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET b= NULL WHERE a < '00:38:47.008761';)"
time="2024-05-12T06:47:19+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=675
time="2024-05-12T06:47:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=676
time="2024-05-12T06:47:19+08:00" level=warning msg="update:694 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET a=1 ORDER BY CAST('invalid' AS DATETIME);)"
time="2024-05-12T06:47:20+08:00" level=warning msg="update:756 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: DROP TABLE t1, t2;)"
./t/update.test: ok! 246 test cases passed, take time 11.888535686 s
time="2024-05-12T06:47:20+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=4
time="2024-05-12T06:47:20+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=5
time="2024-05-12T06:47:20+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=6
./t/update_myisam.test: ok! 36 test cases passed, take time 1.582633213 s
./t/update_stmt.test: ok! 17 test cases passed, take time 0.143995912 s
./t/upgrade.test: ok! 34 test cases passed, take time 0.968054282 s
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=104
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=109
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=116
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $expect_file" command=exec line=146
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments= command=send_shutdown line=149
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=152
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" echo \"restart:--log-raw=ON \" > $expect_file" command=exec line=155
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=158
time="2024-05-12T06:47:24+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=161
./t/user_if_exists.test: ok! 79 test cases passed, take time 0.549418148 s
time="2024-05-12T06:47:25+08:00" level=warning msg="user_password_history:217 query succeeded, but expected error(s)! (expected errors: ER_NO_SUCH_TABLE) (query: CREATE USER no_pwd_history_err@localhost IDENTIFIED BY 'haha'\nPASSWORD HISTORY 0 PASSWORD REUSE INTERVAL 0 DAY;)"
time="2024-05-12T06:47:25+08:00" level=warning msg="user_password_history:230 query failed with non expected error(s)! (ER_CANNOT_USER != ER_NO_SUCH_TABLE) (err: Error 1396 (HY000): Operation DROP USER failed for no_pwd_history@localhost) (query: DROP USER no_pwd_history@localhost;)"
./t/user_password_history.test: ok! 141 test cases passed, take time 1.413119282 s
time="2024-05-12T06:47:26+08:00" level=warning msg="user_var:10 query succeeded, but expected error(s)! (expected errors: 1054) (query: set @a := foo;)"
time="2024-05-12T06:47:28+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=342
time="2024-05-12T06:47:28+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=348
time="2024-05-12T06:47:30+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=479
time="2024-05-12T06:47:30+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=483
time="2024-05-12T06:47:31+08:00" level=warning msg="user_var:533 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set    @X2345678901234567890123456789012345678901234567890123456789012345 = 12;)"
time="2024-05-12T06:47:31+08:00" level=warning msg="user_var:537 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @``= \"illegal\";)"
time="2024-05-12T06:47:31+08:00" level=warning msg="user_var:541 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @`endswithspace `= \"illegal\";)"
time="2024-05-12T06:47:31+08:00" level=warning msg="user_var:593 query succeeded, but expected error(s)! (expected errors: ER_TOO_MANY_ROWS) (query: SET @x= 2;)"
time="2024-05-12T06:47:31+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=602
time="2024-05-12T06:47:31+08:00" level=warning msg="user_var:609 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: SELECT * FROM t1 WHERE a = (SELECT (@x:=_utf8mb4 0x1023) FROM t1) OR b = @x;)"
time="2024-05-12T06:47:31+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=611
time="2024-05-12T06:47:32+08:00" level=warning msg="user_var:701 query failed with non expected error(s)! (ER_CANT_AGGREGATE_2COLLATIONS != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (latin1_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_latin1;)"
time="2024-05-12T06:47:32+08:00" level=warning msg="user_var:703 query failed with non expected error(s)! (ER_CANT_AGGREGATE_2COLLATIONS != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8mb4_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_utf8mb4;)"
./t/user_var.test: ok! 309 test cases passed, take time 6.512368722 s
time="2024-05-12T06:47:33+08:00" level=warning msg="validate_password:76 query failed with non expected error(s)! (ER_CANNOT_USER != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'aedSWEhjui';)"
time="2024-05-12T06:47:33+08:00" level=warning msg="validate_password:118 query failed with non expected error(s)! (ER_CANNOT_USER != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';)"
time="2024-05-12T06:47:33+08:00" level=warning msg="validate_password:129 query failed with non expected error(s)! (ErrWrongParamcountToNativeFct != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH('password', 0);)"
time="2024-05-12T06:47:33+08:00" level=warning msg="validate_password:131 query failed with non expected error(s)! (ErrWrongParamcountToNativeFct != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH();)"
./t/validate_password.test: ok! 155 test cases passed, take time 0.979820416 s
./t/validate_password_check_user.test: ok! 34 test cases passed, take time 0.216228902 s
time="2024-05-12T06:47:35+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=254
time="2024-05-12T06:47:35+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=255
time="2024-05-12T06:47:35+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=281
time="2024-05-12T06:47:35+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=282
./t/varbinary.test: ok! 149 test cases passed, take time 1.887935874 s
./t/variable.test: ok! 16 test cases passed, take time 0.014277583 s
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" include/have_log_bin.inc" command=source line=5
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" 1e-010 1e-10" command=replace_result line=59
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=121
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=124
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=172
time="2024-05-12T06:47:36+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=175
time="2024-05-12T06:47:36+08:00" level=warning msg="variables:304 query succeeded, but expected error(s)! (expected errors: ER_WRONG_TYPE_FOR_VAR) (query: set max_join_size=\"hello\";)"
time="2024-05-12T06:47:36+08:00" level=warning msg="variables:306 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine=UNKNOWN_TABLE_TYPE;)"
time="2024-05-12T06:47:36+08:00" level=warning msg="variables:311 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset UNKNOWN_CHARACTER_SET) (query: set character_set_client=UNKNOWN_CHARACTER_SET;)"
time="2024-05-12T06:47:36+08:00" level=warning msg="variables:317 query failed with non expected error(s)! (ErrUnknownCollation != ER_WRONG_VALUE_FOR_VAR) (err: Error 1273 (HY000): Unknown collation: '') (query: set collation_connection=NULL;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:458 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:465 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=472
time="2024-05-12T06:47:37+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=475
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:500 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set @@global.global.key_buffer_size= 1;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:502 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set GLOBAL global.key_buffer_size= 1;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:504 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: SELECT @@global.global.key_buffer_size;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:506 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session.key_buffer_size') (query: SELECT @@global.session.key_buffer_size;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:508 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local.key_buffer_size') (query: SELECT @@global.local.key_buffer_size;)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:646 query failed with non expected error(s)! (ErrUnknown != ER_WRONG_VALUE_FOR_VAR) (err: Error 1105 (HY000): ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA') (query: set global sql_mode=repeat('a',80);)"
time="2024-05-12T06:47:37+08:00" level=warning msg="variables:808 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable '') (query: select @@\"\";)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:906 query failed with non expected error(s)! (ErrIncorrectGlobalLocalVar != ER_WRONG_VALUE_FOR_VAR) (err: Error 1238 (HY000): Variable 'log_output' is a read only variable) (query: SET GLOBAL log_output = '';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:909 query failed with non expected error(s)! (ER_INCORRECT_GLOBAL_LOCAL_VAR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1238 (HY000): Variable 'log_output' is a read only variable) (query: SET GLOBAL log_output = 0;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:921 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_max_word_len;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:931 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_min_word_len;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:941 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_query_expansion_limit;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:951 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_stopword_file;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:963 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.back_log;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:974 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_files_support;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:986 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.character_sets_dir;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:998 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SELECT @@session.init_file;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1002 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@session.init_file= 'x';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1004 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@global.init_file= 'x';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1010 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lc_messages_dir;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1022 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_page_size;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1034 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_pages;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1046 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_bin;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1058 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_error;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1070 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_file_system;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1082 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_table_names;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1093 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.myisam_recover_options;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1104 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.open_files_limit;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1116 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.pid_file;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1141 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.port;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1152 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.protocol_version;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1162 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_external_locking;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1172 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_networking;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1182 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_show_database;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1193 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.thread_stack;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1223 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SELECT @@global.expire_logs_days;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1249
time="2024-05-12T06:47:38+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1251
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1324 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1331 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET SQL_MODE=DEFAULT;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1338 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1410 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET GLOBAL delay_key_write = OFF;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1454 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET @@foreign_key_checks = OFF;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1558 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_results = 2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1560 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_client=2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1562 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_connection=2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1564 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_server=2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1568 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_filesystem=2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1570 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_database=2048;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1596 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1105 (HY000): ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of '8589934592') (query: SET @@sql_mode= 8589934592;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1722
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1725 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SELECT @@session.relay_log_index;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1726
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1729 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@session.relay_log_index= 'x';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1731 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@global.relay_log_index= 'x';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1748 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_info_file;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1758 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_space_limit;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1769 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SELECT @@session.replica_load_tmpdir;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1773 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SET @@session.replica_load_tmpdir= 'x';)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1780 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SELECT @@session.replica_skip_errors;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1785 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SET @@global.replica_skip_errors= 7;)"
time="2024-05-12T06:47:38+08:00" level=warning msg="variables:1802 query failed with non expected error(s)! (ErrNoDB not in ER_NET_PACKET_TOO_LARGE,2013) (err: Error 1046 (3D000): No database selected) (query: INSERT INTO t1 VALUES ('123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');)"
./t/variables.test: ok! 559 test cases passed, take time 2.233091565 s
./t/variables_dynamic_privs.test: ok! 14 test cases passed, take time 0.144664609 s
time="2024-05-12T06:47:46+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-12T06:47:46+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-12T06:47:47+08:00" level=warning msg="view:618 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_OBJECT) (err: Error 1105 (HY000): Unknown charset ) (query: create index i1 on v1 (col1);)"
time="2024-05-12T06:48:49+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-12T06:48:49+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-12T06:48:54+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=4444
time="2024-05-12T06:49:04+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=5522
time="2024-05-12T06:49:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=5523
time="2024-05-12T06:49:07+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_count_sessions.inc" command=source line=6063
time="2024-05-12T06:49:16+08:00" level=warning msg="view:6298 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'x12345678901234567890123456789012345678901234567890123456789012322' is too long) (query: CREATE OR REPLACE VIEW v1\n(`x12345678901234567890123456789012345678901234567890123456789012322`) AS\nSELECT fld1 FROM t1;)"
./t/view.test: ok! 1458 test cases passed, take time 98.683767412 s
time="2024-05-12T06:49:18+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-12T06:49:20+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-12T06:49:20+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-12T06:49:20+08:00" level=warning msg="view_grant:369 query failed with non expected error(s)! (ErrTableaccessDenied != 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-12T06:49:23+08:00" level=warning msg="view_grant:607 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v3;)"
time="2024-05-12T06:49:23+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-12T06:49:23+08:00" level=warning msg="view_grant:611 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v5;)"
time="2024-05-12T06:49:25+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-12T06:49:25+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-12T06:49:28+08:00" level=warning msg="view_grant:966 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2024-05-12T06:49:28+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-12T06:49:30+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-12T06:49:31+08:00" level=warning msg="view_grant:1179 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v12 AS SELECT c1, c2 FROM mysqltest1.t1, mysqltest1.t2;)"
time="2024-05-12T06:49:31+08:00" level=warning msg="view_grant:1184 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 v21 AS SELECT c2, c1 FROM mysqltest1.t2, mysqltest1.t1;)"
time="2024-05-12T06:49:31+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-12T06:49:31+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-12T06:49:32+08:00" level=warning msg="view_grant:1192 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v32 AS SELECT c3, c2 FROM mysqltest1.t3, mysqltest1.t2;)"
time="2024-05-12T06:49:32+08:00" level=warning msg="view_grant:1197 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v42 AS SELECT c4, c2 FROM mysqltest1.t4, mysqltest1.t2;)"
time="2024-05-12T06:49:33+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-12T06:49:33+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-12T06:49:33+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-12T06:49:33+08:00" level=warning msg="view_grant:1575 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v1;)"
time="2024-05-12T06:49:38+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-12T06:49:39+08:00" level=warning msg="view_grant:1979 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser1'@'%' for table 't2') (query: SELECT * FROM v2_uses_t2;)"
time="2024-05-12T06:49:39+08:00" level=warning msg="view_grant:1986 query failed with non expected error(s)! (ErrTableaccessDenied != 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-12T06:49:42+08:00" level=warning msg="view_grant:2125 query failed with non expected error(s)! (ErrNonUpdatableTable != 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-12T06:49:42+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-12T06:49:42+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-12T06:49:42+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v4 of the UPDATE is not updatable) (query: update mysqltest1.t11 as t11, mysqltest2.v41 as v4 set v4.val= 'test20'\nwhere t11.id= v4.id;)"
time="2024-05-12T06:49:43+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2024-05-12T06:49:43+08:00" level=warning msg="view_grant:2955 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-12T06:49:43+08:00" level=warning msg="view_grant:2959 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-12T06:49:43+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';)"
./t/view_grant.test: ok! 719 test cases passed, take time 25.706303994 s
time="2024-05-12T06:49:44+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-12T06:49:44+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-12T06:49:44+08:00" level=warning msg="view_myisam:36 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 values (1,2);)"
time="2024-05-12T06:49:44+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-12T06:49:44+08:00" level=warning msg="view_myisam:41 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_MULTIUPDATE) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3(a,b) values (1,2);)"
time="2024-05-12T06:49:44+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-12T06:49:44+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-12T06:49:44+08:00" level=warning msg="view_myisam:58 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete v3,t1 from v3,t1;)"
time="2024-05-12T06:49:44+08:00" level=warning msg="view_myisam:60 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete t1,v3 from t1,v3;)"
time="2024-05-12T06:49:45+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-12T06:49:45+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 2.04596453 s
time="2024-05-12T06:49:46+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2024-05-12T06:49:46+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2024-05-12T06:49:46+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
time="2024-05-12T06:49:48+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2024-05-12T06:49:48+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2024-05-12T06:49:48+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2024-05-12T06:49:48+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=111
./t/warnings.test: ok! 74 test cases passed, take time 2.248775261 s
time="2024-05-12T06:49:49+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-12T06:49:49+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-12T06:49:49+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-12T06:49:49+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2024-05-12T06:49:49+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-12T06:49:50+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2024-05-12T06:49:50+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-12T06:49:50+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-12T06:49:50+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-12T06:49:50+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2024-05-12T06:49:51+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-12T06:49:51+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 2.4749440480000002 s
time="2024-05-12T06:49:52+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-12T06:49:52+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-12T06:49:53+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-12T06:49:54+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-12T06:49:54+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-12T06:50:00+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-12T06:50:01+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-12T06:50:01+08:00" level=warning msg="window_functions:1614 query failed with non expected error(s)! (ErrWindowInvalidWindowFuncUse != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (1+row_number() over ());)"
time="2024-05-12T06:50:01+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-12T06:50:05+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-12T06:50:05+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-12T06:50:05+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-12T06:50:05+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-12T06:50:07+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-12T06:50:07+08:00" level=warning msg="window_functions:2048 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(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-12T06:50:07+08:00" level=warning msg="window_functions:2050 query failed with non expected error(s)! (ErrBadField != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT 1+SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-12T06:50:07+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-12T06:50:07+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-12T06:50:07+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-12T06:50:14+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-12T06:50:17+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-12T06:50:17+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-12T06:50:17+08:00" level=warning msg="window_functions:2589 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL 1+(SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
time="2024-05-12T06:50:26+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-12T06:50:27+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-12T06:50:27+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-12T06:50:27+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-12T06:50:27+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 36.642227321 s
time="2024-05-12T06:50:28+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2024-05-12T06:50:28+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2024-05-12T06:50:28+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 1.934056658 s
time="2024-05-12T06:50:35+08:00" level=warning msg="window_functions_bugs:619 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(FIRST_VALUE(CAST('' AS JSON)) OVER (), '');)"
time="2024-05-12T06:50:35+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-12T06:50:35+08:00" level=warning msg="window_functions_bugs:623 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2024-05-12T06:50:35+08:00" level=warning msg="window_functions_bugs:625 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '');)"
./t/window_functions_bugs.test: ok! 157 test cases passed, take time 6.383222757 s
time="2024-05-12T06:50:37+08:00" level=warning msg="command not implemented" arguments=" include/have_hypergraph.inc  # Only supported by the hypergraph join optimizer." command=source line=8
./t/window_functions_interesting_orders.test: ok! 27 test cases passed, take time 5.167430686 s
./t/window_min_max.test: ok! 200 test cases passed, take time 3.758058843 s
time="2024-05-12T06:50:47+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2024-05-12T06:50:47+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-12T06:50:47+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2024-05-12T06:50:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2024-05-12T06:50:48+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2024-05-12T06:50:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2024-05-12T06:50:50+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
time="2024-05-12T06:50:51+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2024-05-12T06:50:53+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-12T06:50:53+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-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2024-05-12T06:50:53+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-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2024-05-12T06:50:53+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-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2024-05-12T06:50:53+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2024-05-12T06:50:53+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 6.907613108 s
time="2024-05-12T06:50:56+08:00" level=error msg="run test [with_non_recursive_bugs] err: sql:EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );: failed to run query \n\"EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\" \n around line 262, \nwe need(8172):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Apply\t5213.53\troot\t\tsemi join, equal:[eq(with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.dd.col_blob_key)]\n  ├─Projection(Build)\t5213.53\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.dd.col_blob\n  │ └─HashJoin\t5213.53\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, Column#122)]\n  │   ├─Selection(Build)\t3340.00\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │ └─IndexJoin\t4175.00\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n  │   │   ├─IndexMerge(Build)\t1115.56\troot\t\ttype: union\n  │   │   │ ├─IndexRangeScan(Build)\t10.00\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n  │   │   │ ├─IndexRangeScan(Build)\t3333.33\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n  │   │   │ └─Selection(Probe)\t1115.56\tcop[tikv]\t\tor(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │   │   └─TableRowIDScan\t3340.00\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n  │   │   └─IndexLookUp(Probe)\t1394.45\troot\t\t\n  │   │     ├─Selection(Build)\t1394.45\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n  │   │     │ └─IndexRangeScan\t1395.85\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n  │   │     └─TableRowIDScan(Probe)\t1394.45\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n  │   └─Projection(Probe)\t12475.01\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, cast(with_non_recursive_bugs.d.col_blob_key, datetime(6) BINARY)->Column#122\n  │     └─HashJoin\t12475.01\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_date)]\n  │       ├─TableReader(Build)\t9980.01\troot\t\tdata:Selection\n  │       │ └─Selection\t9980.01\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob)), not(isnull(with_non_recursive_bugs.d.col_date))\n  │       │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr1\tkeep order:false, stats:pseudo\n  │       └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n  │         └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_date))\n  │           └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr2\tkeep order:false, stats:pseudo\n  └─HashAgg(Probe)\t33333233.40\troot\t\tgroup by:with_non_recursive_bugs.dd.col_blob_key, funcs:firstrow(with_non_recursive_bugs.dd.col_blob_key)->with_non_recursive_bugs.dd.col_blob_key\n    └─HashJoin\t111332999556.00\troot\t\tCARTESIAN inner join, other cond:ge(cast(with_non_recursive_bugs.dd.pk, double BINARY), cast(with_non_recursive_bugs.d.col_date, double BINARY))\n      ├─Selection(Build)\t13930555.50\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n      │ └─IndexJoin\t17413194.38\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n      │   ├─IndexMerge(Build)\t4652805.54\troot\t\ttype: union\n      │   │ ├─IndexRangeScan(Build)\t52135.31\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n      │   │ ├─IndexRangeScan(Build)\t17378437.50\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n      │   │ └─Selection(Probe)\t4652805.54\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), or(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n      │   │   └─TableRowIDScan\t17413194.38\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n      │   └─IndexLookUp(Probe)\t5816006.92\troot\t\t\n      │     ├─Selection(Build)\t5816006.92\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n      │     │ └─IndexRangeScan\t7277285.94\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n      │     └─TableRowIDScan(Probe)\t5816006.92\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n      └─TableReader(Probe)\t41666541.75\troot\t\tdata:Selection\n        └─Selection\t41666541.75\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n          └─TableFullScan\t52135312.50\tcop[tikv]\ttable:innr1\tkeep order:false, stats:pseudo\nDROP TABLE d,dd;\nDROP VIEW view_d,view_dd;\n#\n# Syntax which wasn't accepted\n\nbut got(8172):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Apply\t5213.53\troot\t\tsemi join, equal:[eq(with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.dd.col_blob_key)]\n  ├─Projection(Build)\t5213.53\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.dd.col_blob\n  │ └─HashJoin\t5213.53\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, Column#122)]\n  │   ├─Selection(Build)\t3340.00\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │ └─IndexJoin\t4175.00\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n  │   │   ├─IndexMerge(Build)\t1115.56\troot\t\ttype: union\n  │   │   │ ├─IndexRangeScan(Build)\t10.00\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n  │   │   │ ├─IndexRangeScan(Build)\t3333.33\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n  │   │   │ └─Selection(Probe)\t1115.56\tcop[tikv]\t\tor(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │   │   └─TableRowIDScan\t3340.00\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n  │   │   └─IndexLookUp(Probe)\t1394.45\troot\t\t\n  │   │     ├─Selection(Build)\t1394.45\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n  │   │     │ └─IndexRangeScan\t1395.85\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n  │   │     └─TableRowIDScan(Probe)\t1394.45\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n  │   └─Projection(Probe)\t12475.01\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, cast(with_non_recursive_bugs.d.col_blob_key, datetime(6) BINARY)->Column#122\n  │     └─HashJoin\t12475.01\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_date)]\n  │       ├─TableReader(Build)\t9980.01\troot\t\tdata:Selection\n  │       │ └─Selection\t9980.01\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob)), not(isnull(with_non_recursive_bugs.d.col_date))\n  │       │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr1\tkeep order:false, stats:pseudo\n  │       └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n  │         └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_date))\n  │           └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr2\tkeep order:false, stats:pseudo\n  └─HashAgg(Probe)\t26693280.00\troot\t\tgroup by:with_non_recursive_bugs.dd.col_blob_key, funcs:firstrow(with_non_recursive_bugs.dd.col_blob_key)->with_non_recursive_bugs.dd.col_blob_key\n    └─Selection\t89155555200.00\troot\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n      └─HashJoin\t111444444000.00\troot\t\tCARTESIAN right outer join, other cond:ge(cast(with_non_recursive_bugs.dd.pk, double BINARY), cast(with_non_recursive_bugs.d.col_date, double BINARY))\n        ├─Selection(Build)\t13930555.50\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n        │ └─IndexJoin\t17413194.38\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n        │   ├─IndexMerge(Build)\t4652805.54\troot\t\ttype: union\n        │   │ ├─IndexRangeScan(Build)\t52135.31\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n        │   │ ├─IndexRangeScan(Build)\t17378437.50\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n        │   │ └─Selection(Probe)\t4652805.54\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), or(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n        │   │   └─TableRowIDScan\t17413194.38\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n        │   └─IndexLookUp(Probe)\t5816006.92\troot\t\t\n        │     ├─Selection(Build)\t5816006.92\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n        │     │ └─IndexRangeScan\t7277285.94\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n        │     └─TableRowIDScan(Probe)\t5816006.92\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n        └─TableReader(Probe)\t41708250.00\troot\t\tdata:Selection\n          └─Selection\t41708250.00\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6)\n            └─TableFullScan\t52135312.50\tcop[tikv]\ttable:innr1\tkeep order:false, stats:pseudo\n\n"
time="2024-05-12T06:50:56+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2024-05-12T06:50:56+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2024-05-12T06:50:57+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2024-05-12T06:50:58+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2024-05-12T06:50:58+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2024-05-12T06:50:58+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2024-05-12T06:50:58+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 2.4219210970000002 s
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 2.716494797 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.281851285 s
time="2024-05-12T06:51:03+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2024-05-12T06:51:03+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.45192007 s
./t/year_innodb.test: ok! 51 test cases passed, take time 1.486987079 s
time="2024-05-12T06:51:05+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
time="2024-05-12T06:51:34+08:00" level=warning msg="sub_query_more:969 query succeeded, but expected error(s)! (expected errors: ER_INVALID_GROUP_FUNC_USE) (query: SELECT SUM( (SELECT AVG( (SELECT t1.a FROM t2) ) FROM DUAL) ) FROM t1;)"
time="2024-05-12T06:51:34+08:00" level=warning msg="sub_query_more:972 query succeeded, but expected error(s)! (expected errors: ER_INVALID_GROUP_FUNC_USE) (query: SELECT\nSUM( (SELECT AVG( (SELECT COUNT(*) FROM t1 t HAVING t1.a < 12) ) FROM t2) )\nFROM t1;)"
./t/sub_query_more.test: ok! 332 test cases passed, take time 30.762103681 s
time="2024-05-12T06:51:36+08:00" level=warning msg="role:59 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation GRANT ROLE failed for peter@clickhost.net) (query: GRANT role1 TO peter@clickhost.net;)"
time="2024-05-12T06:51:37+08:00" level=warning msg="role:97 query failed with non expected error(s)! (ErrDynamicPrivilegeNotRegistered != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT SUPER, engineering ON *.* TO joan, sally;)"
time="2024-05-12T06:51:37+08:00" level=warning msg="role:99 query failed with non expected error(s)! (ER_WARN_DA_PRIVILEGE_NOT_REGISTERED != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT engineering,SELECT ON *.* TO joan;)"
time="2024-05-12T06:51:37+08:00" level=warning msg="role:153 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for `engineering_role`@`%`) (query: REVOKE engineering_role FROM foo@localhost;)"
time="2024-05-12T06:51:37+08:00" level=warning msg="role:156 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for managers@%) (query: REVOKE engineering FROM managers;)"
time="2024-05-12T06:51:37+08:00" level=warning msg="role:262 query failed with non expected error(s)! (ErrDBaccessDenied != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1044 (42000): Access denied for user 'joe'@'localhost' to database 'mysql') (query: SHOW GRANTS FOR `root`@`localhost` USING `replication`;)"
time="2024-05-12T06:51:39+08:00" level=warning msg="role:397 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=1;)"
time="2024-05-12T06:51:41+08:00" level=warning msg="role:619 query failed with non expected error(s)! (ErrCannotUser != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `rrrrr`@`%`) (query: SET DEFAULT ROLE `rrrrr` TO u1@localhost;)"
time="2024-05-12T06:51:41+08:00" level=warning msg="role:628 query failed with non expected error(s)! (ER_CANNOT_USER != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `asdasd`@`%`) (query: SET DEFAULT ROLE `asdasd` TO u1@localhost;)"
./t/role.test: ok! 340 test cases passed, take time 5.058827619 s
time="2024-05-12T06:51:42+08:00" level=warning msg="role2:23 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:42+08:00" level=warning msg="role2:51 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:42+08:00" level=warning msg="role2:87 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:42+08:00" level=warning msg="role2:116 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:42+08:00" level=warning msg="role2:120 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:177 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:179 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:181 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_ACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON *.* TO u1@localhost;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:183 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u1@localhost;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:185 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.t1 TO u1@localhost;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:218 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:220 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:253 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:284 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:43+08:00" level=warning msg="role2:288 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:347 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:349 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:378 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:380 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:413 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:444 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-12T06:51:44+08:00" level=warning msg="role2:448 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-12T06:51:46+08:00" level=warning msg="role2:534 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u2@localhost;)"
time="2024-05-12T06:51:46+08:00" level=warning msg="role2:547 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `%db1`.* TO u2@localhost;)"
time="2024-05-12T06:51:46+08:00" level=warning msg="role2:556 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb%`.* TO u2@localhost;)"
time="2024-05-12T06:51:46+08:00" level=warning msg="role2:558 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.* TO u2@localhost;)"
time="2024-05-12T06:51:46+08:00" level=warning msg="role2:560 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.`t1` TO u2@localhost;)"
./t/role2.test: ok! 259 test cases passed, take time 5.775503357 s

time="2024-05-12T06:51:47+08:00" level=error msg="1 tests failed\n"
time="2024-05-12T06:51:47+08:00" level=error msg="run test [with_non_recursive_bugs] err: sql:EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );: failed to run query \n\"EXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\" \n around line 262, \nwe need(8172):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Apply\t5213.53\troot\t\tsemi join, equal:[eq(with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.dd.col_blob_key)]\n  ├─Projection(Build)\t5213.53\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.dd.col_blob\n  │ └─HashJoin\t5213.53\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, Column#122)]\n  │   ├─Selection(Build)\t3340.00\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │ └─IndexJoin\t4175.00\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n  │   │   ├─IndexMerge(Build)\t1115.56\troot\t\ttype: union\n  │   │   │ ├─IndexRangeScan(Build)\t10.00\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n  │   │   │ ├─IndexRangeScan(Build)\t3333.33\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n  │   │   │ └─Selection(Probe)\t1115.56\tcop[tikv]\t\tor(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │   │   └─TableRowIDScan\t3340.00\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n  │   │   └─IndexLookUp(Probe)\t1394.45\troot\t\t\n  │   │     ├─Selection(Build)\t1394.45\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n  │   │     │ └─IndexRangeScan\t1395.85\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n  │   │     └─TableRowIDScan(Probe)\t1394.45\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n  │   └─Projection(Probe)\t12475.01\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, cast(with_non_recursive_bugs.d.col_blob_key, datetime(6) BINARY)->Column#122\n  │     └─HashJoin\t12475.01\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_date)]\n  │       ├─TableReader(Build)\t9980.01\troot\t\tdata:Selection\n  │       │ └─Selection\t9980.01\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob)), not(isnull(with_non_recursive_bugs.d.col_date))\n  │       │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr1\tkeep order:false, stats:pseudo\n  │       └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n  │         └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_date))\n  │           └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr2\tkeep order:false, stats:pseudo\n  └─HashAgg(Probe)\t33333233.40\troot\t\tgroup by:with_non_recursive_bugs.dd.col_blob_key, funcs:firstrow(with_non_recursive_bugs.dd.col_blob_key)->with_non_recursive_bugs.dd.col_blob_key\n    └─HashJoin\t111332999556.00\troot\t\tCARTESIAN inner join, other cond:ge(cast(with_non_recursive_bugs.dd.pk, double BINARY), cast(with_non_recursive_bugs.d.col_date, double BINARY))\n      ├─Selection(Build)\t13930555.50\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n      │ └─IndexJoin\t17413194.38\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n      │   ├─IndexMerge(Build)\t4652805.54\troot\t\ttype: union\n      │   │ ├─IndexRangeScan(Build)\t52135.31\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n      │   │ ├─IndexRangeScan(Build)\t17378437.50\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n      │   │ └─Selection(Probe)\t4652805.54\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), or(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n      │   │   └─TableRowIDScan\t17413194.38\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n      │   └─IndexLookUp(Probe)\t5816006.92\troot\t\t\n      │     ├─Selection(Build)\t5816006.92\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n      │     │ └─IndexRangeScan\t7277285.94\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n      │     └─TableRowIDScan(Probe)\t5816006.92\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n      └─TableReader(Probe)\t41666541.75\troot\t\tdata:Selection\n        └─Selection\t41666541.75\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n          └─TableFullScan\t52135312.50\tcop[tikv]\ttable:innr1\tkeep order:false, stats:pseudo\nDROP TABLE d,dd;\nDROP VIEW view_d,view_dd;\n#\n# Syntax which wasn't accepted\n\nbut got(8172):\nEXPLAIN FORMAT='brief' WITH cte AS (\nSELECT\nalias1 . col_date AS field1 ,\nalias2 . col_blob AS field2\nFROM  view_d AS alias1  LEFT  JOIN view_dd AS alias2\nON  alias1 . col_blob_key =  alias2 . col_blob_key\nWHERE  alias1 . col_varchar_key IS  NULL\nAND  alias2 . col_int_key > 6\nAND alias2 . col_int_key <= ( 7 + 5 )\nOR alias1 . col_blob_key >= 'a' )\nDELETE /*+ MERGE(outrcte) */\nFROM outr1.*, outr2.*\nUSING d AS outr1 LEFT OUTER JOIN d AS outr2\nON ( outr1 . col_date = outr2 . col_date )\nJOIN cte AS outrcte\nON outr2 . col_blob_key = outrcte.field1\nWHERE outr1 . col_blob  IN\n( SELECT DISTINCT innr1 . col_blob_key AS y\nFROM dd AS innr1 RIGHT OUTER JOIN cte AS innrcte\nON innr1.pk >= innrcte.field1\nWHERE outr1 . col_int_key > 6  );\nid\testRows\ttask\taccess object\toperator info\nDelete\tN/A\troot\t\tN/A\n└─Apply\t5213.53\troot\t\tsemi join, equal:[eq(with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.dd.col_blob_key)]\n  ├─Projection(Build)\t5213.53\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.dd.col_blob\n  │ └─HashJoin\t5213.53\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, Column#122)]\n  │   ├─Selection(Build)\t3340.00\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │ └─IndexJoin\t4175.00\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n  │   │   ├─IndexMerge(Build)\t1115.56\troot\t\ttype: union\n  │   │   │ ├─IndexRangeScan(Build)\t10.00\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n  │   │   │ ├─IndexRangeScan(Build)\t3333.33\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n  │   │   │ └─Selection(Probe)\t1115.56\tcop[tikv]\t\tor(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n  │   │   │   └─TableRowIDScan\t3340.00\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n  │   │   └─IndexLookUp(Probe)\t1394.45\troot\t\t\n  │   │     ├─Selection(Build)\t1394.45\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n  │   │     │ └─IndexRangeScan\t1395.85\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n  │   │     └─TableRowIDScan(Probe)\t1394.45\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n  │   └─Projection(Probe)\t12475.01\troot\t\twith_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, with_non_recursive_bugs.d.col_int, with_non_recursive_bugs.d.col_time_key, with_non_recursive_bugs.d.pk, with_non_recursive_bugs.d.col_datetime_key, with_non_recursive_bugs.d.col_int_key, with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.d.col_varchar_key, with_non_recursive_bugs.d.col_varchar, with_non_recursive_bugs.d.col_time, with_non_recursive_bugs.d.col_blob, with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_datetime, with_non_recursive_bugs.d.col_date_key, cast(with_non_recursive_bugs.d.col_blob_key, datetime(6) BINARY)->Column#122\n  │     └─HashJoin\t12475.01\troot\t\tinner join, equal:[eq(with_non_recursive_bugs.d.col_date, with_non_recursive_bugs.d.col_date)]\n  │       ├─TableReader(Build)\t9980.01\troot\t\tdata:Selection\n  │       │ └─Selection\t9980.01\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_blob)), not(isnull(with_non_recursive_bugs.d.col_date))\n  │       │   └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr1\tkeep order:false, stats:pseudo\n  │       └─TableReader(Probe)\t9990.00\troot\t\tdata:Selection\n  │         └─Selection\t9990.00\tcop[tikv]\t\tnot(isnull(with_non_recursive_bugs.d.col_date))\n  │           └─TableFullScan\t10000.00\tcop[tikv]\ttable:outr2\tkeep order:false, stats:pseudo\n  └─HashAgg(Probe)\t26693280.00\troot\t\tgroup by:with_non_recursive_bugs.dd.col_blob_key, funcs:firstrow(with_non_recursive_bugs.dd.col_blob_key)->with_non_recursive_bugs.dd.col_blob_key\n    └─Selection\t89155555200.00\troot\t\tnot(isnull(with_non_recursive_bugs.dd.col_blob_key))\n      └─HashJoin\t111444444000.00\troot\t\tCARTESIAN right outer join, other cond:ge(cast(with_non_recursive_bugs.dd.pk, double BINARY), cast(with_non_recursive_bugs.d.col_date, double BINARY))\n        ├─Selection(Build)\t13930555.50\troot\t\tor(and(isnull(with_non_recursive_bugs.d.col_varchar_key), and(gt(with_non_recursive_bugs.dd.col_int_key, 6), le(with_non_recursive_bugs.dd.col_int_key, 12))), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n        │ └─IndexJoin\t17413194.38\troot\t\tleft outer join, inner:IndexLookUp, outer key:with_non_recursive_bugs.d.col_blob_key, inner key:with_non_recursive_bugs.dd.col_blob_key, equal cond:eq(with_non_recursive_bugs.d.col_blob_key, with_non_recursive_bugs.dd.col_blob_key)\n        │   ├─IndexMerge(Build)\t4652805.54\troot\t\ttype: union\n        │   │ ├─IndexRangeScan(Build)\t52135.31\tcop[tikv]\ttable:d, index:col_varchar_key(col_varchar_key)\trange:[NULL,NULL], keep order:false, stats:pseudo\n        │   │ ├─IndexRangeScan(Build)\t17378437.50\tcop[tikv]\ttable:d, index:col_blob_key(col_blob_key)\trange:[\"a\",+inf], keep order:false, stats:pseudo\n        │   │ └─Selection(Probe)\t4652805.54\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), or(isnull(with_non_recursive_bugs.d.col_varchar_key), ge(with_non_recursive_bugs.d.col_blob_key, \"a\"))\n        │   │   └─TableRowIDScan\t17413194.38\tcop[tikv]\ttable:d\tkeep order:false, stats:pseudo\n        │   └─IndexLookUp(Probe)\t5816006.92\troot\t\t\n        │     ├─Selection(Build)\t5816006.92\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6), not(isnull(with_non_recursive_bugs.dd.col_blob_key))\n        │     │ └─IndexRangeScan\t7277285.94\tcop[tikv]\ttable:dd, index:col_blob_key(col_blob_key)\trange: decided by [eq(with_non_recursive_bugs.dd.col_blob_key, with_non_recursive_bugs.d.col_blob_key)], keep order:false, stats:pseudo\n        │     └─TableRowIDScan(Probe)\t5816006.92\tcop[tikv]\ttable:dd\tkeep order:false, stats:pseudo\n        └─TableReader(Probe)\t41708250.00\troot\t\tdata:Selection\n          └─Selection\t41708250.00\tcop[tikv]\t\tgt(with_non_recursive_bugs.d.col_int_key, 6)\n            └─TableFullScan\t52135312.50\tcop[tikv]\ttable:innr1\tkeep order:false, stats:pseudo\n\n"
tidb-server(PID: 2596) stopped
[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] // 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'
[Pipeline] // parallel
[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