Skipping 1,005 KB.. Full Log

time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:90 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update v1aA,t2Aa set v1Aa.col1 = (select max(col1) from v2Aa) where v1aA.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:92 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v2aA of the UPDATE is not updatable) (query: update t2Aa,v2aA set v2Aa.col1 = (select max(col1) from v2aA) where v2Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:94 query succeeded, but expected error(s)! (expected errors: 1443) (query: update t2Aa,t1Aa set t1aA.col1 = (select max(col1) from v2aA) where t1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:96 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v1Aa of the UPDATE is not updatable) (query: update t2Aa,v1Aa set v1aA.col1 = (select max(col1) from v2Aa) where v1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:98 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v1aA);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:100 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from t1aA);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:102 query failed with non expected error(s)! (ErrNonUpdatableTable != 1443) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v2aA);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:104 query failed with non expected error(s)! (ErrNonUpdatableTable != 1093) (err: Error 1288 (HY000): The target table v3Aa of the UPDATE is not updatable) (query: update v3aA set v3Aa.col1 = (select max(col1) from v3aA);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:106 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v1Aa);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:108 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete from v2aA where col1 = (select max(col1) from t1Aa);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:110 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete from v2Aa where col1 = (select max(col1) from v2aA);)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:112 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v1aA) > 0 and v2Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:114 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from v1Aa) > 0 and t1aA.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:116 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from v1aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:118 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v2aA is not supported now) (query: delete v2aA from v2Aa,t2Aa where (select max(col1) from t1Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:120 query succeeded, but expected error(s)! (expected errors: 1093) (query: delete t1aA from t1Aa,t2Aa where (select max(col1) from t1aA) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:122 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): delete view v1aA is not supported now) (query: delete v1aA from v1Aa,t2Aa where (select max(col1) from t1aA) > 0 and v1aA.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:124 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): delete view v2Aa is not supported now) (query: delete v2Aa from v2aA,t2Aa where (select max(col1) from v2Aa) > 0 and v2aA.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:126 query succeeded, but expected error(s)! (expected errors: 1443) (query: delete t1Aa from t1aA,t2Aa where (select max(col1) from v2Aa) > 0 and t1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:128 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): delete view v1Aa is not supported now) (query: delete v1Aa from v1aA,t2Aa where (select max(col1) from v2aA) > 0 and v1Aa.col1 = t2aA.col1;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:130 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v1aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:132 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1aA values ((select max(col1) from v1Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:134 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v1aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:136 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from t1Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:138 query succeeded, but expected error(s)! (expected errors: 1093) (query: insert into t1aA values ((select max(col1) from t1Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:140 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from t1aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:142 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2Aa values ((select max(col1) from v2aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:144 query succeeded, but expected error(s)! (expected errors: 1443) (query: insert into t1Aa values ((select max(col1) from v2Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:146 query failed with non expected error(s)! (ErrUnknown != 1093) (err: Error 1105 (HY000): insert into view v2aA is not supported now) (query: insert into v2aA values ((select max(col1) from v2Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:148 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v1Aa));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:150 query failed with non expected error(s)! (ErrUnknown != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3aA (col1) values ((select max(col1) from t1aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="lowercase_view:152 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != 1443) (err: Error 1105 (HY000): insert into view v3Aa is not supported now) (query: insert into v3Aa (col1) values ((select max(col1) from v2aA));)"
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=281
time="2025-06-27T17:29:47+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 0.42805185 s
./t/variable.test: ok! 16 test cases passed, take time 0.007843549 s
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" include/have_log_bin.inc" command=source line=5
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 1e-010 1e-10" command=replace_result line=59
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=121
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=124
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=176
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=190
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=172
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=175
time="2025-06-27T17:29:47+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="2025-06-27T17:29:47+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="2025-06-27T17:29:47+08:00" level=warning msg="variables:311 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset UNKNOWN_CHARACTER_SET) (query: set character_set_client=UNKNOWN_CHARACTER_SET;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="variables:317 query failed with non expected error(s)! (ER_UNKNOWN_COLLATION != ER_WRONG_VALUE_FOR_VAR) (err: Error 1273 (HY000): Unknown collation: '') (query: set collation_connection=NULL;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="variables:457 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="variables:464 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=471
time="2025-06-27T17:29:47+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=474
time="2025-06-27T17:29:47+08:00" level=warning msg="variables:499 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="2025-06-27T17:29:47+08:00" level=warning msg="variables:501 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="2025-06-27T17:29:47+08:00" level=warning msg="variables:503 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: SELECT @@global.global.key_buffer_size;)"
time="2025-06-27T17:29:47+08:00" level=warning msg="variables:505 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="2025-06-27T17:29:47+08:00" level=warning msg="variables:507 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;)"
./t/lowercase_view.test: ok! 83 test cases passed, take time 0.678486263 s
./t/lpad.test: ok! 26 test cases passed, take time 0.013584102 s
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:645 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 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA') (query: set global sql_mode=repeat('a',80);)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:807 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable '') (query: select @@\"\";)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:905 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 = '';)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:908 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:920 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_max_word_len;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:930 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_min_word_len;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:940 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_query_expansion_limit;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:950 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_stopword_file;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:962 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.back_log;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:973 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_files_support;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:985 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.character_sets_dir;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:997 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1001 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@session.init_file= 'x';)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1003 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1009 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lc_messages_dir;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1021 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_page_size;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1033 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_pages;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1045 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_error;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1057 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_file_system;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1069 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_table_names;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1080 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.myisam_recover_options;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1091 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.open_files_limit;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1103 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.pid_file;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1128 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.port;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1139 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.protocol_version;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1149 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_external_locking;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1159 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_networking;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1169 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_show_database;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1180 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.thread_stack;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1210 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SELECT @@global.expire_logs_days;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1236
time="2025-06-27T17:29:48+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1238
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1311 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1318 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET SQL_MODE=DEFAULT;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1325 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1397 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET GLOBAL delay_key_write = OFF;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1441 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET @@foreign_key_checks = OFF;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1545 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1547 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_client=2048;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1549 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_connection=2048;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1551 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_server=2048;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1555 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1557 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1583 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="2025-06-27T17:29:48+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1709
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1712 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="2025-06-27T17:29:48+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1713
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1716 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1718 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1735 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_info_file;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1745 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_space_limit;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1756 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1760 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="2025-06-27T17:29:48+08:00" level=warning msg="variables:1767 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SELECT @@session.replica_skip_errors;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1772 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SET @@global.replica_skip_errors= 7;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="variables:1789 query failed with non expected error(s)! (ER_NO_DB_ERROR 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! 554 test cases passed, take time 0.759820865 s
./t/variables_dynamic_privs.test: ok! 14 test cases passed, take time 0.087616647 s
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:389 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:389 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect * from t2,t where t2.c=t.f1;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:397 Unknown named --error ER_DUP_QUERY_NAME"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:397 query failed with non expected error(s)! (ErrNonuniqTable != ER_DUP_QUERY_NAME) (err: Error 1066 (42000): Not unique table/alias: '%-.192s') (query: with t as (select * from t2 where c>3),\nt as (select a from t1 where a>2)\nselect * from t,t1 where t1.a=t.c;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:408 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:408 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive t as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:414 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:414 query failed with non expected error(s)! (ErrNoSuchTable != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from s where a>2),\ns as (select a from t1,r where t1.a>r.c),\nr as (select c from t,t2 where t.a=t2.c)\nselect * from r where r.c<7;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:421 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:421 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 1146 (42S02): Table 'mariadb_cte_nonrecursive.s' doesn't exist) (query: with recursive\nt as (select * from t1\nwhere a in (select c from s where b<='ccc') and  b>'b'),\ns as (select * from t1,t2\nwhere t1.a=t2.c and t1.c in (select a from t where a<5))\nselect * from s where s.b>'aaa';)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:429 Unknown named --error ER_RECURSIVE_WITHOUT_ANCHORS"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:429 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_UNION != ER_RECURSIVE_WITHOUT_ANCHORS) (err: Error 3573 (HY000): Recursive Common Table Expression 's' should contain a UNION) (query: with recursive\nt as (select * from t1 where b>'aaa' and b <='d')\nselect t.b from t,t2\nwhere t.a=t2.c and\nt2.c in (with recursive\ns as (select t1.a from s,t1 where t1.a=s.a and t1.b<'c')\nselect * from s);)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:461 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:461 query failed with non expected error(s)! (ErrViewWrongList != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with t(f) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2025-06-27T17:29:48+08:00" level=warning msg="mariadb_cte_nonrecursive:467 query succeeded, but expected error(s)! (expected errors: ER_DUP_FIELDNAME) (query: with t(f1,f1) as (select * from t1 where b >= 'c')\nselect t1.b from t2,t1 where t1.a = t2.c;)"
time="2025-06-27T17:29:49+08:00" level=warning msg="view:521 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_INVALID) (err: Error 1105 (HY000): insert into view v1 is not supported now) (query: insert into v1 values('a','aa');)"
time="2025-06-27T17:29:49+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="2025-06-27T17:29:49+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="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=741
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=742
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=769
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=770
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=800
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=817
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=834
time="2025-06-27T17:29:49+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=852
time="2025-06-27T17:29:51+08:00" level=warning msg="command not implemented" arguments=" |;" command=delimiter line=1297
time="2025-06-27T17:29:51+08:00" level=warning msg="command not implemented" arguments=" ;|\ndrop table t1,t2;" command=delimiter line=1299
./t/mariadb_cte_nonrecursive.test: ok! 382 test cases passed, take time 3.07173589 s
time="2025-06-27T17:29:51+08:00" level=warning msg="command not implemented" arguments=" include/default_optimizer_switch.inc" command=source line=2
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:11 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:11 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.r' doesn't exist) (query: with recursive\nt as\n(\nselect * from t1 where t1.b >= 'c'\nunion\nselect * from r\n),\nr as\n(\nselect * from t\nunion\nselect t1.* from t1,r where r.a+1 = t1.a\n)\nselect * from r;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:28 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:28 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.b1' doesn't exist) (query: with recursive\na1(a,b) as\n(select * from t1 where t1.a>3\nunion\nselect * from b1 where b1.a >3\nunion\nselect * from c1 where c1.a>3),\nb1(a,b) as\n(select * from a1 where a1.b > 'ccc'\nunion\nselect * from c1 where c1.b > 'ddd'),\nc1(a,b) as\n(select * from a1 where a1.a<6 and a1.b< 'zz'\nunion\nselect * from b1 where b1.b > 'auu')\nselect * from c1;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:284 query succeeded, but expected error(s)! (expected errors: 1112) (query: with recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me' and dob = '2000-01-01'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect *\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id);)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:304 query succeeded, but expected error(s)! (expected errors: 1112) (query: with\nancestor_couples(husband, h_dob, wife, w_dob)\nas\n(\nwith recursive\nancestors\nas\n(\nselect *\nfrom folks\nwhere name = 'Me'\nunion\nselect p.*\nfrom folks as p, ancestors AS a\nwhere p.id = a.father OR p.id = a.mother\n)\nselect t1.name, t1.dob, t2.name, t2.dob\nfrom ancestors t1, ancestors t2\nwhere exists (select * from ancestors a\nwhere a.father=t1.id AND a.mother=t2.id)\n)\nselect * from ancestor_couples;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:753 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:753 query failed with non expected error(s)! (ErrInvalidRequiresSingleReference != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me' and  father is not null\nunion all\nselect mother, 1 from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:772 Unknown named --error ER_WITH_COL_WRONG_LIST"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:772 query failed with non expected error(s)! (ER_VIEW_WRONG_LIST != ER_WITH_COL_WRONG_LIST) (err: Error 1353 (HY000): In definition of view, derived table or common table expression, SELECT list and column names list have different column counts) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father from folks where name = 'Me' and  father is not null\nunion all\nselect mother from folks where name = 'Me' and  mother is not null\nunion all\nselect father, fa.generation+1 from folks, ancestor_ids fa\nwhere folks.id = fa.id and (father not in (select id from ancestor_ids))\nunion all\nselect mother, ma.generation+1 from folks, ancestor_ids ma\nwhere folks.id = ma.id and (mother not in (select id from ancestor_ids))\n)\nselect generation, name from ancestor_ids a, folks\nwhere a.id = folks.id;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:810 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:810 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_SINGLE_REFERENCE != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'coupled_ancestor_ids', the recursive table must be referenced only once, and not in any subquery) (query: with recursive\ncoupled_ancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me' and father is not null\nunion\nselect mother from folks where name = 'Me' and mother is not null\nunion\nselect n.father\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\nunion\nselect n.mother\nfrom folks, coupled_ancestor_ids fa, coupled_ancestor_ids ma, folks n\nwhere folks.father = fa.id and folks.mother = ma.id and\n(fa.id = n.id or ma.id = n.id) and\nn.father is not null and n.mother is not null\n)\nselect p.* from coupled_ancestor_ids a, folks p\nwhere a.id = p.id;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:858 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:858 query failed with non expected error(s)! (ErrCTERecursiveForbiddenJoinOrder != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3576 (HY000): In recursive query block of Recursive Common Table Expression 'ancestor_ids', the recursive table must neither be in the right argument of a LEFT JOIN, nor be forced to be non-first with join order hints) (query: with recursive\nancestor_ids (id)\nas\n(\nselect father from folks where name = 'Me'\nunion\nselect mother from folks where name = 'Me'\nunion\nselect father from folks left join ancestor_ids a on folks.id = a.id\nunion\nselect mother from folks left join ancestor_ids a on folks.id = a.id\n),\nancestors\nas\n(\nselect p.* from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:923 Unknown named --error ER_NOT_STANDARD_COMPLIANT_RECURSIVE"
time="2025-06-27T17:29:51+08:00" level=warning msg="mariadb_cte_recursive:923 query failed with non expected error(s)! (ER_CTE_RECURSIVE_FORBIDS_AGGREGATION != ER_NOT_STANDARD_COMPLIANT_RECURSIVE) (err: Error 3575 (HY000): Recursive Common Table Expression 'ancestor_ids' can contain neither aggregation nor window functions in recursive query block) (query: with recursive\nancestor_ids (id, generation)\nas\n(\nselect father, 1 from folks where name = 'Me'\nunion\nselect mother, 1 from folks where name = 'Me'\nunion\nselect max(father), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\nunion\nselect max(mother), max(a.generation)+1 from folks, ancestor_ids a\nwhere folks.id = a.id\ngroup by a.generation\n),\nancestors\nas\n(\nselect generation, name from folks as p, ancestor_ids as a\nwhere p.id = a.id\n)\nselect * from ancestors;)"
time="2025-06-27T17:29:52+08:00" level=warning msg="mariadb_cte_recursive:1518 query failed with non expected error(s)! (ErrNoSuchTable != 1064) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.applied_modules' doesn't exist) (query: with recursive\nreached_values as\n(\nselect v from value_nodes where v in ('v3','v7','v9')\nunion\nselect module_results.v from module_results, applied_modules\nwhere module_results.m = applied_modules.m\n),\napplied_modules as\n(\nselect module_nodes.m\nfrom\nmodule_nodes\nleft join\n(\nmodule_arguments\nleft join\nreached_values\non module_arguments.v = reached_values.v\n)\non reached_values.v is null and\nmodule_nodes.m = module_arguments.m\nwhere module_arguments.m is null\n)\nselect * from reached_values;)"
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q1;" command=eval line=1771
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=1772
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" ANALYZE $q2;" command=eval line=1774
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=1775
time="2025-06-27T17:29:53+08:00" level=warning msg="mariadb_cte_recursive:1814 query failed with non expected error(s)! (ErrCTERecursiveForbidsAggregation != 3577) (err: Error 3575 (HY000): Recursive Common Table Expression 'cte' can contain neither aggregation nor window functions in recursive query block) (query: WITH RECURSIVE cte(f) AS (\nSELECT i FROM t\nUNION\nSELECT i FROM t\nWHERE i NOT IN ( SELECT * FROM t\nWHERE i IN ( SELECT * FROM cte ) GROUP BY i )\n) SELECT * FROM cte;)"
time="2025-06-27T17:29:53+08:00" level=warning msg="mariadb_cte_recursive:1887 Unknown named --error ER_UNACCEPTABLE_MUTUAL_RECURSION"
time="2025-06-27T17:29:53+08:00" level=warning msg="mariadb_cte_recursive:1887 query failed with non expected error(s)! (ErrNoSuchTable != ER_UNACCEPTABLE_MUTUAL_RECURSION) (err: Error 1146 (42S02): Table 'mariadb_cte_recursive.cte_2' doesn't exist) (query: set @var=\n(\nwith recursive\ncte_1 as (\nselect 1\nunion\nselect * from cte_2),\ncte_2 as (\nselect * from cte_1\nunion\nselect a from t1, cte_2\nwhere t1.a=cte_2.a)\nselect * from cte_2\nlimit 1\n);)"
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=1955
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" explain extended $q;" command=eval line=1956
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2032
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $q;" command=eval line=2033
time="2025-06-27T17:29:53+08:00" level=warning msg="mariadb_cte_recursive:2118 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: WITH RECURSIVE qn AS\n(\nselect 1,0 as col from t1\nunion distinct\nselect 1,0 from t1\nunion all\nselect 3, 0*(@c:=@c+1) from qn where @c<1\nunion all\nselect 3, 0*(@d:=@d+1) from qn where @d<1\n)\nselect * from qn;)"
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2168
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2183
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q2;" command=eval line=2195
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q3;" command=eval line=2207
time="2025-06-27T17:29:53+08:00" level=warning msg="command not implemented" arguments=" $q4;" command=eval line=2219
time="2025-06-27T17:29:54+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from cte as t;" command=eval line=2342
time="2025-06-27T17:29:54+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from cte as t;" command=eval line=2347
time="2025-06-27T17:29:54+08:00" level=warning msg="command not implemented" arguments="\nexplain extended\n$rec_cte\nselect * from t1 as t;" command=eval line=2351
time="2025-06-27T17:29:54+08:00" level=warning msg="command not implemented" arguments="\n$rec_cte\nselect * from t1 as t;" command=eval line=2356
time="2025-06-27T17:29:54+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2410
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2435
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2436
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" explain $q1;" command=eval line=2448
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q1;" command=eval line=2449
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2464
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2475
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" explain $q;" command=eval line=2476
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2535
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=2564
time="2025-06-27T17:29:55+08:00" level=warning msg="mariadb_cte_recursive:2566 query succeeded, but expected error(s)! (expected errors: 1146) (query: drop table folks;)"
time="2025-06-27T17:29:55+08:00" level=warning msg="mariadb_cte_recursive:2751 query failed with non expected error(s)! (ErrNotSupportedYet != 1064) (err: Error 1235 (42000): This version of TiDB doesn't yet support 'INTERSECT between recursive part's selects, hint: The operator between recursive part's selects must bu UNION[DISTINCT] or UNION ALL') (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a, distances d\nwhere a.departure = 'Seattle' and\na.departure = d.city1 and a.arrival = d.city2 and\nd.dist < 4000\nunion\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nintersect\nselect city2 from destinations s, distances d\nwhere s.city = d.city1 and d.dist < 4000\n)\nselect * from destinations;)"
time="2025-06-27T17:29:55+08:00" level=warning msg="mariadb_cte_recursive:2767 query failed with non expected error(s)! (ER_CTE_RECURSIVE_REQUIRES_SINGLE_REFERENCE != 1064) (err: Error 3577 (HY000): In recursive query block of Recursive Common Table Expression 'destinations', the recursive table must be referenced only once, and not in any subquery) (query: with recursive destinations (city) as\n(\nselect a.arrival from flights a where a.departure = 'Seattle'\nunion\nselect * from\n(\nselect b.arrival from destinations r, flights b\nwhere r.city = b.departure\nexcept\nselect arrival from flights\nwhere arrival in\n('New York', 'London', 'Moscow', 'Dubai', 'Cairo', 'Tokyo')\n) t\n)\nselect * from destinations;)"
./t/mariadb_cte_recursive.test: ok! 313 test cases passed, take time 4.293650765 s
./t/math.test: ok! 6 test cases passed, take time 0.021943512 s
time="2025-06-27T17:29:55+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=4
time="2025-06-27T17:29:55+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user01@% has exceeded the 'max_user_connections' resource"
time="2025-06-27T17:29:56+08:00" level=error msg="open db failed Error 1203 (42000): User user01@% has exceeded the 'max_user_connections' resource, take time 501.403853ms"
time="2025-06-27T17:29:56+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource"
time="2025-06-27T17:29:56+08:00" level=error msg="open db failed Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource, take time 501.430274ms"
time="2025-06-27T17:29:56+08:00" level=warning msg="ping db failed, retry count 0 (remain 1) err Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource"
time="2025-06-27T17:29:57+08:00" level=error msg="open db failed Error 1203 (42000): User user02@% has exceeded the 'max_user_connections' resource, take time 501.519646ms"
./t/max_user_connections.test: ok! 20 test cases passed, take time 1.7166828870000002 s
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=6
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=8
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=51
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments=" //\ncreate table t1 (i int)//\ninsert into t1 values (1),(2),(3)//\nselect * from t1 where i = 2//\ndrop table t1//\ndelimiter ;" command=delimiter line=57
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=68
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=71
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=85
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=98
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=112
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=117
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=127
time="2025-06-27T17:29:57+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=129
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=184
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=186
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=210
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=212
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=225
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=236
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=248
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=269
./t/metadata.test: ok! 89 test cases passed, take time 0.950748577 s
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=14
time="2025-06-27T17:29:58+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=28
./t/metadata_myisam.test: ok! 14 test cases passed, take time 0.210057318 s
time="2025-06-27T17:29:58+08:00" level=warning msg="multi_update:23 query failed with non expected error(s)! (ErrUnknown not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.t1 from mysqltest_1@localhost;)"
time="2025-06-27T17:29:58+08:00" level=warning msg="multi_update:25 query failed with non expected error(s)! (ErrUnknown not in 0,ER_NONEXISTING_GRANT,ER_NONEXISTING_TABLE_GRANT) (err: Error 1105 (HY000): Unknown user: mysqltest_1@localhost) (query: revoke all privileges on mysqltest.* from mysqltest_1@localhost;)"
time="2025-06-27T17:29:59+08:00" level=warning msg="view:4024 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c1 = 'text1';)"
time="2025-06-27T17:29:59+08:00" level=warning msg="view:4045 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c2 = 'text2';)"
time="2025-06-27T17:29:59+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=4449
time="2025-06-27T17:30:00+08:00" level=warning msg="multi_update:245 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE t1,t2 SET t1.d=t2.d WHERE t1.n=t2.n;)"
time="2025-06-27T17:30:01+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=5527
time="2025-06-27T17:30:01+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=5528
time="2025-06-27T17:30:01+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_count_sessions.inc" command=source line=6068
time="2025-06-27T17:30:02+08:00" level=warning msg="multi_update:467 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: update t1,t2 set t1.col1 = (select max(col1) from t1) where t1.col1 = t2.col1;)"
time="2025-06-27T17:30:02+08:00" level=warning msg="multi_update:469 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete t1 from t1,t2 where t1.col1 < (select max(col1) from t1) and t1.col1 = t2.col1;)"
time="2025-06-27T17:30:02+08:00" level=warning msg="multi_update:494 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: delete from t1,t2 using t1,t2 where t1.a=(select a from t1);)"
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=" alter table t1 add column c int default 100 after a;" command=send line=555
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=563
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=" update t1, v1 set t1.b=t1.a+t1.b+v1.b where t1.a=v1.a;" command=send line=564
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=" include/wait_condition.inc" command=source line=574
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=578
time="2025-06-27T17:30:03+08:00" level=warning msg="command not implemented" arguments=";" command=reap line=581
time="2025-06-27T17:30:03+08:00" level=warning msg="view:6303 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! 1463 test cases passed, take time 14.813551628999999 s
time="2025-06-27T17:30:03+08:00" level=warning msg="multi_update:644 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: delete t3.* from t2,t3 where t2.a=t3.a;)"
time="2025-06-27T17:30:03+08:00" level=warning msg="multi_update:666 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: UPDATE IGNORE t1, t1 t1a SET t1.a = 1 WHERE t1a.a = 1;)"
time="2025-06-27T17:30:03+08:00" level=warning msg="multi_update:768 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 ORDER BY a;)"
time="2025-06-27T17:30:03+08:00" level=warning msg="multi_update:770 query failed with non expected error(s)! (ErrNonUpdatableTable not in ER_WRONG_USAGE, ER_VIEW_PREVENT_UPDATE) (err: Error 1288 (HY000): The target table v of the UPDATE is not updatable) (query: UPDATE v SET a=1 LIMIT 3;)"
time="2025-06-27T17:30:03+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="2025-06-27T17:30:03+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="2025-06-27T17:30:03+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="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=837
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=841
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=842
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=845
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=850
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=851
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $check_query;" command=eval line=852
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=861
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=862
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=868
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=869
./t/multi_update.test: ok! 358 test cases passed, take time 5.533407514 s
time="2025-06-27T17:30:04+08:00" level=warning msg="multi_update_innodb:24 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A, t1 AS B SET A.pk = 1, B.a = 2;)"
time="2025-06-27T17:30:04+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="2025-06-27T17:30:04+08:00" level=warning msg="view_grant:609 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v4;)"
time="2025-06-27T17:30:04+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="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=107
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=112
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=113
./t/multi_update_innodb.test: ok! 62 test cases passed, take time 0.624324349 s
time="2025-06-27T17:30:04+08:00" level=warning msg="view_grant:811 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'view_grant.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v;)"
time="2025-06-27T17:30:04+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK" command=replace_result line=825
./t/multi_update_tiny_hash.test: ok! 23 test cases passed, take time 0.23762166 s
time="2025-06-27T17:30:05+08:00" level=warning msg="view_grant:966 query failed with non expected error(s)! (ErrViewInvalid != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2025-06-27T17:30:05+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="2025-06-27T17:30:06+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="2025-06-27T17:30:06+08:00" level=warning msg="view_grant:1179 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v12 AS SELECT c1, c2 FROM mysqltest1.t1, mysqltest1.t2;)"
time="2025-06-27T17:30:06+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="2025-06-27T17:30:06+08:00" level=warning msg="view_grant:1186 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v23 AS SELECT c2, c3 FROM mysqltest1.t2, mysqltest1.t3;)"
time="2025-06-27T17:30:06+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="2025-06-27T17:30:06+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="2025-06-27T17:30:06+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="2025-06-27T17:30:07+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="2025-06-27T17:30:07+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="2025-06-27T17:30:07+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="2025-06-27T17:30:07+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="2025-06-27T17:30:08+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="2025-06-27T17:30:07+08:00" level=warning msg="multi_valued_index:582 query failed with non expected error(s)! (ErrDupEntry != 1176) (err: Error 1062 (23000): Duplicate entry '2-1850766141593485312-3' for key 't1.mv_idx_date') (query: INSERT INTO t1 SELECT * FROM t1 USE KEY FOR GROUP BY ( mv_idx_unsigned , mv_idx_signed ) GROUP BY j3 ORDER BY j1;)"
time="2025-06-27T17:30:08+08:00" level=warning msg="view_grant:1979 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser1'@'%' for table 't2') (query: SELECT * FROM v2_uses_t2;)"
time="2025-06-27T17:30:08+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="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2125 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v1 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v1_merge as v1 set v1.val= 'test5'\nwhere t2.id= v1.id;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2149 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v11 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v11_merge as v11 set v11.val= 'test11'\nwhere t2.id= v11.id;)"
time="2025-06-27T17:30:09+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="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v4 of the UPDATE is not updatable) (query: update mysqltest1.t11 as t11, mysqltest2.v41 as v4 set v4.val= 'test20'\nwhere t11.id= v4.id;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2955 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2959 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_grant:2962 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE IGNORE test1.v1_all SET cn='x';)"
./t/view_grant.test: ok! 719 test cases passed, take time 6.007756045 s
time="2025-06-27T17:30:09+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2025-06-27T17:30:09+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2025-06-27T17:30:09+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="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:38 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 select * from t2;)"
time="2025-06-27T17:30:09+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="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:43 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) select * from t2;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:56 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete from v3;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:58 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete v3,t1 from v3,t1;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:60 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete t1,v3 from t1,v3;)"
time="2025-06-27T17:30:09+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="2025-06-27T17:30:09+08:00" level=warning msg="view_myisam:126 query failed with non expected error(s)! (ErrUnknown != ER_TOO_MANY_FIELDS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE table_broken AS SELECT * FROM t1, t2, t3;)"
./t/view_myisam.test: ok! 31 test cases passed, take time 0.399025947 s
time="2025-06-27T17:30:09+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2025-06-27T17:30:09+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2025-06-27T17:30:09+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
time="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=111
./t/warnings.test: ok! 74 test cases passed, take time 0.399708196 s
./t/multi_valued_index.test: ok! 659 test cases passed, take time 5.061768481 s
time="2025-06-27T17:30:10+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="2025-06-27T17:30:10+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="2025-06-27T17:30:10+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="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2025-06-27T17:30:10+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="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2025-06-27T17:30:10+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="2025-06-27T17:30:10+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="2025-06-27T17:30:10+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="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2025-06-27T17:30:10+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="2025-06-27T17:30:10+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=462
./t/window_bitwise_ops.test: ok! 77 test cases passed, take time 0.417268147 s
time="2025-06-27T17:30:10+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="2025-06-27T17:30:10+08:00" level=warning msg="window_functions:120 query failed with non expected error(s)! (ErrIllegalReference != 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="2025-06-27T17:30:11+08:00" level=warning msg="window_functions:257 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: SELECT id, FIRST_VALUE(id) OVER w first, LAST_VALUE(id) OVER w last, sex FROM t1\nWINDOW w AS (PARTITION BY sex\nORDER BY id ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING);)"
./t/multi_valued_index_cost_based.test: ok! 312 test cases passed, take time 0.794891902 s
time="2025-06-27T17:30:11+08:00" level=warning msg="mysql_replace:20 query succeeded, but expected error(s)! (expected errors: ErrUnsupportedDDLOperation) (query: alter table t1 engine=heap;)"
./t/mysql_replace.test: ok! 19 test cases passed, take time 0.213996226 s
time="2025-06-27T17:30:11+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="2025-06-27T17:30:11+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;)"
./t/negation_elimination.test: ok! 66 test cases passed, take time 0.19135651 s
time="2025-06-27T17:30:11+08:00" level=warning msg="nth:39 query succeeded, but expected error(s)! (expected errors: ER_WRONG_ARGUMENTS) (query: SELECT id, sex, NTH_VALUE(id, NULL) OVER () FROM t1;)"
./t/nth.test: ok! 86 test cases passed, take time 0.214202293 s
time="2025-06-27T17:30:12+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="2025-06-27T17:30:12+08:00" level=warning msg="window_functions:1612 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (row_number() over ());)"
time="2025-06-27T17:30:12+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="2025-06-27T17:30:12+08:00" level=warning msg="window_functions:1630 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_ILLEGAL_ORDER_BY) (query: SELECT RANK() OVER (ORDER BY 1) FROM t;)"
./t/null_key_all_innodb.test: ok! 72 test cases passed, take time 1.11277294 s
time="2025-06-27T17:30:13+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="2025-06-27T17:30:13+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="2025-06-27T17:30:13+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="2025-06-27T17:30:13+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 );)"
./t/odbc.test: ok! 32 test cases passed, take time 0.21876016 s
./t/operator.test: ok! 28 test cases passed, take time 0.014420933 s
time="2025-06-27T17:30:13+08:00" level=warning msg="window_functions:2032 query failed with non expected error(s)! (ErrBadField != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(c))  FROM t;)"
time="2025-06-27T17:30:13+08:00" level=warning msg="window_functions:2048 query failed with non expected error(s)! (ErrBadField != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2025-06-27T17:30:13+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="2025-06-27T17:30:13+08:00" level=warning msg="window_functions:2056 query failed with non expected error(s)! (ErrBadField != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT 1 + (SELECT c FROM DUAL))  FROM t;)"
time="2025-06-27T17:30:13+08:00" level=warning msg="window_functions:2058 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 1 + (SELECT c FROM DUAL))  FROM t;)"
time="2025-06-27T17:30:13+08:00" level=warning msg="window_functions:2079 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(a), SUM(a) OVER () FROM t;)"
./t/opt_hint_timeout.test: ok! 29 test cases passed, take time 0.376876841 s
time="2025-06-27T17:30:13+08:00" level=warning msg="command not implemented" arguments=" include/not_hypergraph.inc  # Join order hints are not supported." command=source line=2
time="2025-06-27T17:30: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="2025-06-27T17:30:14+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="2025-06-27T17:30:14+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="2025-06-27T17:30:14+08:00" level=warning msg="window_functions:2589 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL 1+(SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
./t/opt_hints_join_order.test: ok! 83 test cases passed, take time 0.794784099 s
./t/opt_hints_subquery.test: ok! 187 test cases passed, take time 0.564753403 s
./t/optimizer_bug12837084.test: ok! 10 test cases passed, take time 0.231306764 s
time="2025-06-27T17:30:15+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=120
time="2025-06-27T17:30:16+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=169
time="2025-06-27T17:30:16+08:00" level=warning msg="command not implemented" arguments=" 9091 9090  # These two records can both be chosen from t2." command=replace_result line=183
time="2025-06-27T17:30:16+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;)"
./t/order_by_limit.test: ok! 45 test cases passed, take time 0.747136911 s
time="2025-06-27T17:30:16+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="2025-06-27T17:30:16+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="2025-06-27T17:30:16+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="2025-06-27T17:30:16+08:00" level=warning msg="window_functions:3706 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i), RANK() OVER w FROM t1 WINDOW w AS (ORDER BY i);)"
./t/window_functions.test: ok! 1303 test cases passed, take time 5.523135122 s
time="2025-06-27T17:30:16+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2025-06-27T17:30:16+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2025-06-27T17:30:16+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=4
./t/window_functions_big.test: ok! 33 test cases passed, take time 0.801179173 s
time="2025-06-27T17:30:17+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="2025-06-27T17:30:17+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="2025-06-27T17:30:17+08:00" level=warning msg="window_functions_bugs:623 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2025-06-27T17:30:17+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 1.009494653 s
time="2025-06-27T17:30:18+08:00" level=warning msg="command not implemented" arguments=" include/have_hypergraph.inc  # Only supported by the hypergraph join optimizer." command=source line=8
./t/window_functions_interesting_orders.test: ok! 27 test cases passed, take time 0.338011298 s
./t/order_by_sortkey.test: ok! 41 test cases passed, take time 1.959120563 s
./t/orderby.test: ok! 53 test cases passed, take time 0.137647317 s
time="2025-06-27T17:30:18+08:00" level=warning msg="overflow:9 query failed with non expected error(s)! (ER_DB_DROP_EXISTS not in ER_PARSE_ERROR,ER_TOO_LONG_IDENT,ER_WRONG_NAME_FOR_INDEX) (err: Error 1008 (HY000): Can't drop database 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'; database doesn't exist) (query: drop database AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA;)"
./t/overflow.test: ok! 2 test cases passed, take time 0.008376087 s
./t/packet.test: ok! 50 test cases passed, take time 0.186675346 s
time="2025-06-27T17:30:18+08:00" level=warning msg="command not implemented" arguments=" include/not_windows.inc" command=source line=4
time="2025-06-27T17:30:18+08:00" level=warning msg="command not implemented" arguments=" include/count_sessions.inc" command=source line=7
time="2025-06-27T17:30:18+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=9
time="2025-06-27T17:30:18+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=10
./t/window_min_max.test: ok! 200 test cases passed, take time 0.504966109 s
time="2025-06-27T17:30:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2025-06-27T17:30:19+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="2025-06-27T17:30:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2025-06-27T17:30:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2025-06-27T17:30:19+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2025-06-27T17:30:19+08:00" level=warning msg="packet_myisam:43 query failed with non expected error(s)! (ErrEntryTooLarge != ER_WARN_ALLOWED_PACKET_OVERFLOWED) (err: Error 8025 (HY000): entry too large, the max entry size is 6291456, the size of data is 67108897) (query: UPDATE t3\nSET c32= CONCAT(c32,\nREPEAT('a', @max_allowed_packet-1));)"
./t/packet_myisam.test: ok! 11 test cases passed, take time 0.425747112 s
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2025-06-27T17:30:20+08:00" level=warning msg="with_non_recursive:692 query failed with non expected error(s)! (ErrNoSuchTable != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ merge(qn,qn1) */ * from qn, qn qn1;)"
time="2025-06-27T17:30:20+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="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2025-06-27T17:30:20+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="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2025-06-27T17:30:20+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="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2025-06-27T17:30:20+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=796
./t/with_non_recursive.test: ok! 180 test cases passed, take time 1.6974414869999999 s
time="2025-06-27T17:30:21+08:00" level=warning msg="command not implemented" arguments=" $$\nselect \"non terminated\"$$\nselect \"terminated\";$$\nselect \"non terminated, space\"      $$\nselect \"terminated, space\";      $$\nselect \"non terminated, comment\" /* comment */$$\nselect \"terminated, comment\"; /* comment */$$\nselect \"stmt 1\";select \"stmt 2 non terminated\"$$\nselect \"stmt 1\";select \"stmt 2 terminated\";$$\nselect \"stmt 1\";select \"stmt 2 non terminated, space\"      $$\nselect \"stmt 1\";select \"stmt 2 terminated, space\";      $$\nselect \"stmt 1\";select \"stmt 2 non terminated, comment\" /* comment */$$\nselect \"stmt 1\";select \"stmt 2 terminated, comment\"; /* comment */$$\nselect \"stmt 1\";             select \"space, stmt 2\"$$\nselect \"stmt 1\";/* comment */select \"comment, stmt 2\"$$" command=delimiter line=423
time="2025-06-27T17:30:21+08:00" level=warning msg="command not implemented" arguments=" ;" command=delimiter line=448
time="2025-06-27T17:30:21+08:00" level=warning msg="parser:556 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait();)"
time="2025-06-27T17:30:21+08:00" level=warning msg="parser:558 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait(1);)"
time="2025-06-27T17:30:21+08:00" level=warning msg="parser:562 query failed with non expected error(s)! (ErrSpDoesNotExist not in 0,ER_WRONG_ARGUMENTS) (err: Error 1305 (42000): FUNCTION parser.source_pos_wait does not exist) (query: select source_pos_wait('binlog.999999', 4, -1);)"
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $q;" command=eval line=915
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:923 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:932 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:941 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 ORDER BY 1 LIMIT 1 UNION SELECT 1 FROM t1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:959 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:968 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:977 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT 1 FROM t1 LIMIT 1 UNION SELECT 1 FROM t1 ORDER BY 1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:986 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT 1 FROM t1 ORDER BY 1 UNION SELECT 1 FROM t1 LIMIT 1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1061 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine=a.myisam;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1065 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.b.myisam' in '') (query: SET default_storage_engine = a.b.MyISAM;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1067 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.MyISAM;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1069 query failed with non expected error(s)! (ErrBadField != ER_WRONG_TYPE_FOR_VAR) (err: Error 1054 (42S22): Unknown column 'a.myisam' in '') (query: SET default_storage_engine = `a`.`MyISAM`;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1071 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = \"a.MYISAM\";)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1073 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = 'a.MYISAM';)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1075 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine = `a.MYISAM`;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1220 query failed with non expected error(s)! (ErrNoSuchTable != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: REPLACE INTO `` SELECT * FROM ``;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1265 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=NONE;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1267 query succeeded, but expected error(s)! (expected errors: ER_ALTER_OPERATION_NOT_SUPPORTED) (query: ALTER TABLE t1 LOCK=SHARED;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1273 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITH VALIDATION;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1275 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 WITHOUT VALIDATION;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1277 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: ALTER TABLE t1 LOCK=SHARED, WITH VALIDATION, ALGORITHM=COPY,\nLOCK=EXCLUSIVE, WITHOUT VALIDATION, ALGORITHM=INPLACE;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1317 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and LIMIT) (query: SELECT a FROM t1 LIMIT 1 UNION ALL SELECT a FROM t1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1320 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: (SELECT a FROM t1 LIMIT 1) UNION ALL (SELECT a FROM t1 ORDER BY a) LIMIT 2;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1371 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1 ORDER BY a UNION SELECT a FROM t1;)"
time="2025-06-27T17:30:22+08:00" level=warning msg="parser:1377 query failed with non expected error(s)! (ErrWrongUsage != ER_PARSE_ERROR) (err: Error 1221 (HY000): Incorrect usage of UNION and ORDER BY) (query: SELECT a FROM t1\nUNION\nSELECT a FROM t1 ORDER BY a\nUNION\nSELECT a FROM t1;)"
./t/with_non_recursive_bugs.test: ok! 102 test cases passed, take time 1.9232873069999998 s
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2025-06-27T17:30:22+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2025-06-27T17:30:23+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2025-06-27T17:30:23+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=583
./t/with_recursive.test: ok! 86 test cases passed, take time 0.348854872 s
time="2025-06-27T17:30:23+08:00" level=warning msg="parser:1538 query failed with non expected error(s)! (ErrNonUniq != ER_NONUNIQ_TABLE) (err: Error 1052 (23000): Column 'a' in field list is ambiguous) (query: SELECT * FROM ( t1 JOIN t2 ON TRUE, t1 JOIN t3 ON TRUE );)"
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 0.3559259 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.033898357 s
time="2025-06-27T17:30:23+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2025-06-27T17:30:23+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.251822304 s
./t/year_innodb.test: ok! 51 test cases passed, take time 0.184337695 s
time="2025-06-27T17:30:24+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:1954 query failed with non expected error(s)! (ER_SYNTAX_ERROR != ER_PARSE_ERROR) (err: Error 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use) (query: CREATE TABLE t1 (a INT) PARTITION BY KEY ALGORITHM = 10 () PARTITIONS 3;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:1978 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_WRONG_TABLE_NAME) (err: Error 1146 (42S02): Table 'parser.' doesn't exist) (query: DROP INDEX idx1 ON ``;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2035 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET NAMES utf8 COLLATE DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2237 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE ROLE `RESOURCE`;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2245 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global') (query: SET GLOBAL = DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2247 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local') (query: SET LOCAL = DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2249 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist') (query: SET PERSIST = DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2251 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'persist_only') (query: SET PERSIST_ONLY = DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2253 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session') (query: SET SESSION = DEFAULT;)"
time="2025-06-27T17:30:25+08:00" level=warning msg="parser:2377 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: CREATE TABLE t4 (\nx VARCHAR(10)\nGENERATED ALWAYS AS(NULL)\nCOLLATE ascii_bin\nCOLLATE ascii_bin\n);)"
./t/parser.test: ok! 692 test cases passed, take time 6.216232773 s
./t/parser_precedence.test: ok! 138 test cases passed, take time 0.148217528 s
time="2025-06-27T17:30:26+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="2025-06-27T17:30:26+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 2.753026841 s
time="2025-06-27T17:30:27+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="2025-06-27T17:30:27+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="2025-06-27T17:30:27+08:00" level=warning msg="role:99 query failed with non expected error(s)! (ErrDynamicPrivilegeNotRegistered != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT engineering,SELECT ON *.* TO joan;)"
time="2025-06-27T17:30:27+08:00" level=warning msg="role:153 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for `engineering_role`@`%`) (query: REVOKE engineering_role FROM foo@localhost;)"
time="2025-06-27T17:30:27+08:00" level=warning msg="role:156 query failed with non expected error(s)! (ER_CANNOT_USER != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for managers@%) (query: REVOKE engineering FROM managers;)"
time="2025-06-27T17:30:27+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="2025-06-27T17:30:27+08:00" level=warning msg="partition:345 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: ALTER TABLE t1\nPARTITION BY HASH (a)\n(PARTITION p0 ENGINE=InnoDB,\nPARTITION p1 ENGINE=NonExistentEngine);)"
time="2025-06-27T17:30:27+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="2025-06-27T17:30:28+08:00" level=warning msg="role:619 query failed with non expected error(s)! (ER_CANNOT_USER != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `rrrrr`@`%`) (query: SET DEFAULT ROLE `rrrrr` TO u1@localhost;)"
time="2025-06-27T17:30:28+08:00" level=warning msg="role:628 query failed with non expected error(s)! (ER_CANNOT_USER != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `asdasd`@`%`) (query: SET DEFAULT ROLE `asdasd` TO u1@localhost;)"
./t/role.test: ok! 340 test cases passed, take time 1.866277974 s
time="2025-06-27T17:30:28+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="2025-06-27T17:30:28+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="2025-06-27T17:30:28+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="2025-06-27T17:30:28+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="2025-06-27T17:30:28+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+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="2025-06-27T17:30:29+08:00" level=warning msg="role2:560 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.`t1` TO u2@localhost;)"
./t/role2.test: ok! 259 test cases passed, take time 1.215700587 s

Great, All tests passed
mysqltest end
tidb-server(PID: 1687) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-33979/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2025-06-27T17:30:32+08:00" level=warning msg="partition:1357 query failed with non expected error(s)! (ER_PARTITION_WRONG_NO_SUBPART_ERROR != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0) (subpartition sp0),\npartition p1 values less than (1));)"
time="2025-06-27T17:30:32+08:00" level=warning msg="partition:1364 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by range (a)\nsubpartition by hash(a)\n(partition p0 values less than (0),\npartition p1 values less than (1) (subpartition sp0));)"
time="2025-06-27T17:30:32+08:00" level=warning msg="partition:1374 query failed with non expected error(s)! (ErrPartitionWrongNoSubpart != ER_PARSE_ERROR) (err: Error 1485 (HY000): Wrong number of subpartitions defined, mismatch with previous setting) (query: create table t1 (a int, b int)\npartition by list (a)\nsubpartition by hash(a)\n(partition p0 values in (0),\npartition p1 values in (1) (subpartition sp0));)"
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
time="2025-06-27T17:30:32+08:00" level=warning msg="partition:1463 Unknown named --error ErrGlobalIndexNotExplicitlySet"
time="2025-06-27T17:30:32+08:00" level=warning msg="partition:1463 query failed with non expected error(s)! (8264 != ErrGlobalIndexNotExplicitlySet) (err: Error 8264 (HY000): Global Index is needed for index 'PRIMARY', since the unique index is not including all partitioning columns, and GLOBAL is not given as IndexOption) (query: alter table t1 add primary key (b);)"
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
time="2025-06-27T17:30:33+08:00" level=warning msg="partition:1711 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != ER_NULL_IN_VALUES_LESS_THAN) (err: Error 1659 (HY000): Field 'NULL' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a int)\nPARTITION BY RANGE(a)\n(PARTITION p0 VALUES LESS THAN (NULL));)"
time="2025-06-27T17:30:34+08:00" level=warning msg="command not implemented" arguments=" ($cnt)\n{\nupdate t1 set s2 = 1;" command=while line=2063
time="2025-06-27T17:30:34+08:00" level=warning msg="command not implemented" arguments=" $cnt;" command=dec line=2067
time="2025-06-27T17:30:35+08:00" level=warning msg="command not implemented" arguments=" ($n)\n{\ninsert into t1 (user) values ('mysql');" command=while line=2192
time="2025-06-27T17:30:35+08:00" level=warning msg="command not implemented" arguments=" $n;" command=dec line=2195
time="2025-06-27T17:30:37+08:00" level=warning msg="partition:2435 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF) (err: Error 8200 (HY000): unsupported add column 's3' constraint UNIQUE KEY when altering 'partition.t1') (query: ALTER TABLE t1 ADD COLUMN (s3 VARCHAR(5) UNIQUE);)"
time="2025-06-27T17:30:37+08:00" level=warning msg="partition:2486 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table B of the UPDATE is not updatable) (query: UPDATE t1_part AS A NATURAL JOIN v1 as B SET A.nokey = 2 , B.partkey = 3;)"
time="2025-06-27T17:30:37+08:00" level=warning msg="partition:2488 query failed with non expected error(s)! (ErrNonUpdatableTable != ER_MULTI_UPDATE_KEY_CONFLICT) (err: Error 1288 (HY000): The target table A of the UPDATE is not updatable) (query: UPDATE v1 AS A NATURAL JOIN t1_part as B SET A.nokey = 2 , B.partkey = 3;)"
time="2025-06-27T17:30:37+08:00" level=warning msg="partition:2728 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DROP TABLE IF EXISTS `example`;)"
time="2025-06-27T17:30:38+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=2939
time="2025-06-27T17:30:38+08:00" level=warning msg="partition:2945 query failed with non expected error(s)! (ErrDupFieldName != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 CHANGE COLUMN i j INT, CHANGE COLUMN j i INT;)"
time="2025-06-27T17:30:38+08:00" level=warning msg="partition:2984 query failed with non expected error(s)! (ER_DUP_FIELDNAME != ER_DEPENDENT_BY_PARTITION_FUNC) (err: Error 1060 (42S21): Duplicate column name 'j') (query: ALTER TABLE t1 RENAME COLUMN i TO j, RENAME COLUMN j TO i;)"
./t/partition.test: ok! 725 test cases passed, take time 12.42708441 s
./t/partition_bug18198.test: ok! 45 test cases passed, take time 0.09055363 s
time="2025-06-27T17:30:38+08:00" level=warning msg="partition_column:49 query failed with non expected error(s)! (ER_FIELD_TYPE_NOT_ALLOWED_AS_PARTITION_FIELD != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a BLOB)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2025-06-27T17:30:38+08:00" level=warning msg="partition_column:54 query failed with non expected error(s)! (ErrFieldTypeNotAllowedAsPartitionField != ER_BLOB_FIELD_IN_PART_FUNC_ERROR) (err: Error 1659 (HY000): Field 'a' is of a not allowed type for this type of partitioning) (query: CREATE TABLE t1 (a TEXT)\nPARTITION BY RANGE COLUMNS (a)\n(PARTITION p0 VALUES LESS THAN (\"X\"));)"
time="2025-06-27T17:30:39+08:00" level=warning msg="partition_column:477 query failed with non expected error(s)! (ER_PARTITION_COLUMN_LIST_ERROR != 1566) (err: Error 1653 (HY000): Inconsistency in usage of column lists for partitioning) (query: create table t1 (a int, b int)\npartition by range columns(a,b)\n(partition p0 values less than (10));)"
time="2025-06-27T17:30:39+08:00" level=warning msg="partition_column:530 query failed with non expected error(s)! (ER_RANGE_NOT_INCREASING_ERROR != ER_REORG_OUTSIDE_RANGE) (err: Error 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition) (query: alter table t1 reorganize partition p0 into\n(partition p01 values less than (0,3),\npartition p02 values less than (1,1));)"
./t/partition_column.test: ok! 152 test cases passed, take time 1.71040519 s
./t/partition_column_prune.test: ok! 27 test cases passed, take time 0.579409501 s
./t/partition_func.test: ok! 1341 test cases passed, take time 14.780437147 s
./t/partition_grant.test: ok! 20 test cases passed, take time 0.26855863 s
time="2025-06-27T17:30:56+08:00" level=warning msg="command not implemented" arguments=" include/no_valgrind_without_big.inc" command=source line=9
./t/partition_hash.test: ok! 306 test cases passed, take time 4.955821151 s

Great, All tests passed
mysqltest end
tidb-server(PID: 1660) stopped
[Pipeline] }
[Pipeline] // dir
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-tidb-ghpr_mysql_test-33979/tidb-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] container
[Pipeline] {
[Pipeline] sh
+ bash scripts/plugins/report_job_result.sh SUCCESS result.json
http://fileserver.pingcap.net
--2025-06-27 09:31:04--  http://fileserver.pingcap.net/download/rd-atom-agent/agent_upload_verifyci_metadata.py
Resolving fileserver.pingcap.net (fileserver.pingcap.net)... 10.2.12.82
Connecting to fileserver.pingcap.net (fileserver.pingcap.net)|10.2.12.82|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4181 (4.1K) [application/octet-stream]
Saving to: ‘agent_upload_verifyci_metadata.py’

     0K ....                                                  100%  227M=0s

2025-06-27 09:31:04 (227 MB/s) - ‘agent_upload_verifyci_metadata.py’ saved [4181/4181]

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