Skipping 1,001 KB.. Full Log

time="2024-05-06T15:17:38+08:00" level=warning msg="strict:595 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:597 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:599 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:615 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-2147483649);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:617 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(2147643648);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:619 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:621 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(4294967296);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:623 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('-2147483649');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:625 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('2147643648');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:627 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('-1');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:629 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('4294967296');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:631 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-2147483649.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:633 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(2147643648.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:635 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:637 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(4294967296.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:640 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 = col1 - 50 WHERE col1 < 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:642 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col2 =col2 + 50 WHERE col2 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:644 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:646 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:648 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:650 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:652 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:672 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-9223372036854775809);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:674 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(9223372036854775808);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:676 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:679 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(18446744073709551616);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:681 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('-9223372036854775809');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:683 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES('9223372036854775808');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:685 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('-1');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:687 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES('18446744073709551616');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:692 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(-9223372036854785809.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:694 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES(9223372036854785808.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:696 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(-1.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:698 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES(18446744073709551616.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:705 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:707 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:709 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:711 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:713 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:733 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (101.55);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:735 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (101);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:737 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (-101.55);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:739 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (1010.55);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:741 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES (1010);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:745 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('101.55');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:747 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('101');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:749 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-101.55');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:751 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-1010.55');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:753 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 VALUES ('-100E+1');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:755 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 VALUES ('-100E');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:757 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 =col1 * 50000 WHERE col1 =11;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:759 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1 =col1 / 0 WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:761 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col1= MOD(col1,0) WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:764 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:767 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:769 query succeeded, but expected error(s)! (expected errors: 1366) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:787 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES (+3.4E+39);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:789 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES (-1.1E-3);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:791 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES ('+3.4E+39');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:793 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES ('-1.1E-3');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:795 query succeeded, but expected error(s)! (expected errors: 1264) (query: UPDATE t1 SET col1 =col1 * 5000 WHERE col1 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:797 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2 =col2 / 0 WHERE col2 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:799 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:801 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:803 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:805 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:823 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES (-1.1E-3);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:825 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col1) VALUES ('+1.8E+309');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:827 query succeeded, but expected error(s)! (expected errors: 1264) (query: INSERT INTO t1 (col2) VALUES ('-1.2E-3');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:833 query succeeded, but expected error(s)! (expected errors: 1365) (query: UPDATE t1 SET col2= MOD(col2,0) WHERE col2 > 0;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:835 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:837 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('a59b');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:839 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('1a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:855 query succeeded, but expected error(s)! (expected errors: 1406) (query: INSERT INTO t1 (col1) VALUES ('hellobob');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:857 query succeeded, but expected error(s)! (expected errors: 1406) (query: INSERT INTO t1 (col2) VALUES ('hellobob');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:860 query succeeded, but expected error(s)! (expected errors: 1406) (query: UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he';)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:862 query succeeded, but expected error(s)! (expected errors: 1406) (query: UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he';)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:873 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('yellow');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:875 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 (col1) VALUES ('redd');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:877 query succeeded, but expected error(s)! (expected errors: 1265) (query: INSERT INTO t1 VALUES ('');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:879 query succeeded, but expected error(s)! (expected errors: 1265) (query: UPDATE t1 SET col1 ='yellow' WHERE col1 ='green';)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:897 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col1=NULL WHERE col1 =100;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:899 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col2 =NULL WHERE col2 ='hello';)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:901 query succeeded, but expected error(s)! (expected errors: 1048) (query: UPDATE t1 SET col2 =NULL where col3 IS NOT NULL;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:915 query succeeded, but expected error(s)! (expected errors: 1364) (query: INSERT INTO t1 (col1) VALUES (2);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:917 query succeeded, but expected error(s)! (expected errors: 1364) (query: INSERT INTO t1 VALUES(default(col1),default(col2));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:921 query succeeded, but expected error(s)! (expected errors: 1048) (query: INSERT INTO t1 SELECT 1,NULL;)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:991 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000 as char(3)));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:993 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000E+0 as char(3)));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:995 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast(1000.0 as char(3)));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:997 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (cast('abc' as signed integer));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:999 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (10E+0 + 'a');)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:1001 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col2) values (cast('10a' as unsigned integer));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:1014 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 values (0,0,0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:1016 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 values (0.0,0.0,0.0);)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:1018 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (convert('0000-00-00',date));)"
time="2024-05-06T15:17:38+08:00" level=warning msg="strict:1020 query succeeded, but expected error(s)! (expected errors: 1292) (query: insert into t1 (col1) values (cast('0000-00-00' as date));)"
time="2024-05-06T15:17:39+08:00" level=warning msg="strict:1424 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE t2(b DATE) SELECT a FROM t1;)"
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1563
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" SELECT $fields INTO OUTFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' FROM t1" command=eval line=1564
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1565
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" SELECT LOAD_FILE('$MYSQLTEST_VARDIR/tmp/wl6614.txt')" command=eval line=1566
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1567
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' INTO TABLE t2" command=eval line=1569
time="2024-05-06T15:17:39+08:00" level=warning msg="strict:1570 query succeeded, but expected error(s)! (expected errors: ER_WARN_TOO_FEW_RECORDS) (query: SELECT * FROM t2;)"
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR" command=replace_result line=1571
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" LOAD DATA INFILE '$MYSQLTEST_VARDIR/tmp/wl6614.txt' IGNORE INTO TABLE t2" command=eval line=1572
time="2024-05-06T15:17:39+08:00" level=warning msg="command not implemented" arguments=" SELECT $fields FROM t2" command=eval line=1573
./t/strict.test: ok! 483 test cases passed, take time 2.305655046 s
time="2024-05-06T15:17:40+08:00" level=warning msg="strict_autoinc_2innodb:33 query failed with non expected error(s)! (ErrDataOutOfRange != ER_WARN_DATA_OUT_OF_RANGE) (err: Error 1690 (22003): constant 700 overflows tinyint) (query: insert into t1 values(null);)"
./t/strict_autoinc_2innodb.test: ok! 14 test cases passed, take time 0.056021024 s
./t/sub_query.test: ok! 74 test cases passed, take time 0.291312385 s
time="2024-05-06T15:17:40+08:00" level=warning msg="subquery_all:39 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: SELECT (SELECT 1 FROM (SELECT 1) as b HAVING a=1) as a;)"
time="2024-05-06T15:17:40+08:00" level=warning msg="subquery_all:41 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'b' in 'having clause') (query: SELECT (SELECT 1 FROM (SELECT 1) as b HAVING b=1) as a,(SELECT 1 FROM (SELECT 1) as c HAVING a=1) as b;)"
time="2024-05-06T15:17:40+08:00" level=warning msg="subquery_all:44 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'field list') (query: SELECT (SELECT a) as a;)"
time="2024-05-06T15:17:40+08:00" level=warning msg="subquery_all:93 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a1' in 'where clause') (query: select (select a from t1 where t1.a = a1) as a2, (select b from t2 where t2.b=a2) as a1;)"
time="2024-05-06T15:17:41+08:00" level=warning msg="subquery_all:310 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_SUBQUERY_NO_1_ROW) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: select numeropost as a FROM t1 ORDER BY (SELECT 1 FROM t1 HAVING a=1);)"
time="2024-05-06T15:17:41+08:00" level=warning msg="subquery_all:336 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'a' in 'having clause') (query: SELECT (SELECT numeropost FROM t1 HAVING numreponse=a),numreponse FROM (SELECT * FROM t1) as a;)"
time="2024-05-06T15:17:41+08:00" level=warning msg="command not implemented" arguments=" \"i4,i1,i3\" \"i4,i1\" \"4,4,4\" \"4,4\" \"union(i4,intersect(i1,i3))\" \"union(i4,i1)\"" command=replace_result line=359
time="2024-05-06T15:17:41+08:00" level=warning msg="command not implemented" arguments=" \"i1,i2\" \"i2,i1\"" command=replace_result line=366
time="2024-05-06T15:17:41+08:00" level=warning msg="command not implemented" arguments=" \"i1,i3\" \"i3,i1\"" command=replace_result line=373
./t/index_merge_delete.test: ok! 214 test cases passed, take time 9.668214207 s
time="2024-05-06T15:17:42+08:00" level=warning msg="subquery_all:449 query failed with non expected error(s)! (ErrBadTable != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: SELECT * FROM (SELECT 1) b WHERE 1 IN (SELECT *);)"
./t/index_merge_innodb.test: ok! 12 test cases passed, take time 0.260457171 s
time="2024-05-06T15:17:47+08:00" level=warning msg="subquery_all:1644 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx ;)"
time="2024-05-06T15:17:47+08:00" level=warning msg="subquery_all:1646 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T15:17:47+08:00" level=warning msg="subquery_all:1649 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx;)"
time="2024-05-06T15:17:47+08:00" level=warning msg="subquery_all:1651 query failed with non expected error(s)! (ErrBadField != ER_ILLEGAL_REFERENCE) (err: Error 1054 (42S22): Unknown column 'xx' in 'where clause') (query: select 1 = ALL (select 1 from t1 where 1 = xx ), 1 as xx from DUAL;)"
time="2024-05-06T15:18:00+08:00" level=warning msg="subquery_all:4221 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: EXPLAIN FORMAT= 'BRIEF'\nSELECT cc FROM\n( SELECT\n(SELECT COUNT(a) FROM\n(SELECT COUNT(b) FROM t1) AS x GROUP BY c\n) AS cc FROM t1 GROUP BY b\n) AS y;)"
time="2024-05-06T15:18:01+08:00" level=warning msg="subquery_all:4724 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_VIEW_CHECK_FAILED) (err: Error 1146 (42S02): Table 'subquery_all.v3' doesn't exist) (query: DELETE FROM v3;)"
time="2024-05-06T15:18:01+08:00" level=warning msg="subquery_all:4947 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( SELECT 1 UNION ( SELECT 1 UNION SELECT 1 ) );)"
time="2024-05-06T15:18:01+08:00" level=warning msg="subquery_all:4949 query succeeded, but expected error(s)! (expected errors: ER_DERIVED_MUST_HAVE_ALIAS) (query: SELECT * FROM ( ( SELECT 1 UNION SELECT 1 ) UNION SELECT 1 );)"
time="2024-05-06T15:18:01+08:00" level=warning msg="subquery_all:4995 query succeeded, but expected error(s)! (expected errors: ER_AGGREGATE_ORDER_NON_AGG_QUERY) (query: SELECT 1 FROM t1 GROUP BY\n(SELECT LAST_INSERT_ID() FROM t1 ORDER BY MIN(a) ASC LIMIT 1);)"
time="2024-05-06T15:18:05+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=6574
time="2024-05-06T15:18:05+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=6581
time="2024-05-06T15:18:06+08:00" level=warning msg="subquery_all:6766 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT 1 as col FROM t1 WHERE a IN (SELECT a FROM DUAL LIMIT 0);)"
./t/subquery_all.test: ok! 2358 test cases passed, take time 26.436212692 s
./t/subquery_antijoin.test: ok! 116 test cases passed, take time 0.993975972 s
time="2024-05-06T15:18:08+08:00" level=warning msg="subquery_bugs:157 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T15:18:08+08:00" level=warning msg="subquery_bugs:167 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T15:18:08+08:00" level=warning msg="subquery_bugs:226 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX',\nSUM(k)\nFROM t1;)"
time="2024-05-06T15:18:08+08:00" level=warning msg="subquery_bugs:236 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 'k'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT SUM(k), k\nFROM t1\nHAVING (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')) = 'XXX';)"
time="2024-05-06T15:18:08+08:00" level=warning msg="subquery_bugs:246 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT (SELECT 'X' FROM t2\nWHERE t2.k = CONCAT(t1.k, 'X')\nAND SUM(t1.k)) = 'XXX'\nFROM t1;)"
time="2024-05-06T15:18:08+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=252
time="2024-05-06T15:18:09+08:00" level=warning msg="subquery_bugs:676 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 root must not be followed by other values.) (query: SELECT DISTINCT * FROM t1\nORDER BY UUID_TO_BIN(\nST_ISEMPTY(\nST_POINTFROMTEXT(\nST_ASWKT(\nNOT EXISTS(\nSELECT 1 FROM t1\nWHERE IS_UUID(CAST(SHA(a>>0xA7FE1B22)AS JSON)) WINDOW w1 AS()\n),'AXIS-ORDER=SRID-DEFINED'\n),1,'AXIS-ORDER=LONG-LAT'\n)\n)\n);)"
time="2024-05-06T15:18:10+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=brief $query;" command=eval line=946
./t/subquery_bugs.test: ok! 287 test cases passed, take time 4.041727391 s
time="2024-05-06T15:18:13+08:00" level=warning msg="subquery_mat:135 query succeeded, but expected error(s)! (expected errors: 1235) (query: select * from t1 where (a1, a2) in (select b1, min(b2) from t2i limit 1,1);)"
time="2024-05-06T15:18:16+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=841
time="2024-05-06T15:18:16+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=848
time="2024-05-06T15:18:16+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1171
time="2024-05-06T15:18:17+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1308
time="2024-05-06T15:18:17+08:00" level=warning msg="subquery_mat:1391 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief UPDATE t2,t3 SET t2.a=10 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T15:18:17+08:00" level=warning msg="subquery_mat:1393 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_TABLE_USED) (query: EXPLAIN format =brief DELETE t2.* FROM t2,t3 WHERE t2.a IN (SELECT * FROM t2 WHERE a <> 2);)"
time="2024-05-06T15:18:18+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=1680
time="2024-05-06T15:18:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=1681
./t/subquery_mat.test: ok! 502 test cases passed, take time 6.21377215 s
./t/subquery_sj_innodb_all.test: ok! 68 test cases passed, take time 0.734971386 s
./t/subselect_innodb.test: ok! 175 test cases passed, take time 2.751235564 s
time="2024-05-06T15:18:22+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=6
time="2024-05-06T15:18:22+08:00" level=warning msg="command not implemented" arguments=" include/big_test.inc" command=source line=7
time="2024-05-06T15:18:22+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=8
./t/sum_distinct-big.test: ok! 24 test cases passed, take time 0.241988495 s
./t/sum_distinct.test: ok! 32 test cases passed, take time 0.630812472 s
time="2024-05-06T15:18:23+08:00" level=warning msg="temp_table:82 query failed with non expected error(s)! (ErrUnsupportedDDLOperation != ER_DUP_ENTRY) (err: Error 8200 (HY000): TiDB doesn't support ALTER TABLE for local temporary table) (query: alter table t1 add primary key (a);)"
./t/temp_table.test: ok! 137 test cases passed, take time 0.899630112 s
./t/temptable_256_fields.test: ok! 5 test cases passed, take time 0.046317128 s
./t/temptable_disk.test: ok! 14 test cases passed, take time 0.155127749 s
time="2024-05-06T15:18:24+08:00" level=warning msg="time:61 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:61 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect date value: '-1' for column 'c1' at row 1) (query: INSERT INTO t (c1) values (-1);)"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:63 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:63 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect datetime value: '-1' for column 'c2' at row 1) (query: INSERT INTO t (c2) values (-1);)"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:65 Unknown named --error ER_BAD_FORMAT"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:65 query failed with non expected error(s)! (ER_TRUNCATED_WRONG_VALUE != ER_BAD_FORMAT) (err: Error 1292 (22007): Incorrect timestamp value: '-1' for column 'c3' at row 1) (query: INSERT INTO t (c3) values (-1);)"
time="2024-05-06T15:18:24+08:00" level=warning msg="time:90 Unknown named --error "
time="2024-05-06T15:18:24+08:00" level=warning msg="time:90 query failed with non expected error(s)! (ErrTruncatedWrongValue != ) (err: Error 1292 (22007): Incorrect datetime value: '2004-04-31' for column 'col' at row 1) (query: insert into t values ('2004-04-31');)"
./t/time.test: ok! 71 test cases passed, take time 0.328695842 s
./t/time_zone_grant.test: ok! 58 test cases passed, take time 0.454453904 s
./t/time_zone_with_dst.test: ok! 28 test cases passed, take time 0.430806461 s
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:56 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:56 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default '12345678');)"
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:70 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:70 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011111);)"
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:92 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:25+08:00" level=warning msg="timestamp_insert:92 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101011);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:114 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:114 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010101);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:136 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:136 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2010);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:150 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:150 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 20);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:156 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:156 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 2);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:170 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:170 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default -1);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:176 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:176 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 99999999999999);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:182 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:182 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 100000000000000);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:188 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:188 query failed with non expected error(s)! (ER_INVALID_DEFAULT != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp default 10000101000000);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:194 query succeeded, but expected error(s)! (expected errors: ER_DEFAULT_VALUE) (query: create table t (id int, c1 timestamp default null);)"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:200 Unknown named --error ER_DEFAULT_VALUE"
time="2024-05-06T15:18:26+08:00" level=warning msg="timestamp_insert:200 query failed with non expected error(s)! (ErrInvalidDefault != ER_DEFAULT_VALUE) (err: Error 1067 (42000): Invalid default value for 'c1') (query: create table t (id int, c1 timestamp not null default null);)"
./t/timestamp_insert.test: ok! 199 test cases passed, take time 0.946447068 s
./t/timestamp_update.test: ok! 75 test cases passed, take time 0.306545435 s
./t/tpcc.test: ok! 35 test cases passed, take time 0.569304859 s
time="2024-05-06T15:18:27+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=8
time="2024-05-06T15:18:31+08:00" level=warning msg="command not implemented" arguments= command=disable_connect_log line=162
./t/transaction_isolation_func.test: ok! 62 test cases passed, take time 4.088169648 s
./t/truth_value_transform.test: ok! 19 test cases passed, take time 0.064228307 s
./t/type.test: ok! 16 test cases passed, take time 0.091273541 s
time="2024-05-06T15:18:32+08:00" level=warning msg="type_binary:122 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_TRUNCATED_WRONG_VALUE) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: create table t1\nselect convert(0x9999999999999999999999999999999999999999999,unsigned);)"
./t/type_binary.test: ok! 93 test cases passed, take time 0.642003601 s
time="2024-05-06T15:18:33+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=153
time="2024-05-06T15:18:33+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=155
./t/type_bit_innodb.test: ok! 89 test cases passed, take time 0.995904152 s
time="2024-05-06T15:18:34+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=255
time="2024-05-06T15:18:34+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=257
./t/type_bit_myisam.test: ok! 168 test cases passed, take time 1.625760377 s
time="2024-05-06T15:18:35+08:00" level=warning msg="type_blob:38 query failed with non expected error(s)! (ErrBlobCantHaveDefault != 1074) (err: Error 1101 (42000): BLOB/TEXT/JSON column 'a' can't have a default value) (query: CREATE TABLE t1 (a varchar(70000) default \"hello\");)"
time="2024-05-06T15:18:36+08:00" level=warning msg="type_blob:345 query succeeded, but expected error(s)! (expected errors: ER_DUP_ENTRY) (query: insert into t1 (txt) values ('Chevy'), ('CHEVY');)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:521 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: CREATE TABLE b15776 (a int(256));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:578 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: explain select cast(1 as char(4294967295));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:584 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select cast(1 as char(4294967296));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:588 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select cast(1 as binary(4294967296));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:606 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: explain select convert(1, char(4294967295));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:608 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select convert(1, char(4294967296));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:619 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: explain select convert(1, binary(4294967296));)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:636 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: UPDATE t2 SET c = REPEAT('1', 70000);)"
time="2024-05-06T15:18:37+08:00" level=warning msg="type_blob:640 query succeeded, but expected error(s)! (expected errors: ER_TOO_BIG_DISPLAYWIDTH) (query: UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1;)"
./t/type_blob.test: ok! 296 test cases passed, take time 2.710145541 s
time="2024-05-06T15:18:38+08:00" level=warning msg="type_datetime:151 query failed with non expected error(s)! (ErrTruncatedWrongValue != ER_INVALID_DEFAULT) (err: Error 1292 (22007): Truncated incorrect time value: '916:00:00 a') (query: create table t1 (t time default '916:00:00 a');)"
time="2024-05-06T15:18:39+08:00" level=warning msg="command not implemented" arguments=" (`select locate('semijoin', @@optimizer_switch) > 0`)\n{\nset optimizer_switch='semijoin=off';" command=if line=395
time="2024-05-06T15:18:39+08:00" level=warning msg="type_datetime:466 query failed with non expected error(s)! (ErrTruncatedWrongValue != 1067) (err: Error 1292 (22007): Truncated incorrect time value: '916:00:00 a') (query: create table t1 (t time default '916:00:00 a');)"
time="2024-05-06T15:18:39+08:00" level=warning msg="type_datetime:494 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE) (query: DELETE IGNORE  FROM t1 WHERE dt1 = '0000-00-01 00:00:01';)"
time="2024-05-06T15:18:40+08:00" level=warning msg="type_datetime:679 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: DELETE FROM type_datetime.t WHERE `col_int_nokey` > `col_int_nokey`\nAND TIMESTAMP( '18:16:35.025453' ) IS  NULL;)"
time="2024-05-06T15:18:40+08:00" level=warning msg="type_datetime:682 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE type_datetime.t SET `col_varchar_nokey` = TIMESTAMP(`col_time_nokey`,'00:00:00')\nWHERE `col_int_nokey` > `col_int_nokey`\nAND TIMESTAMP('18:16:35.025453') IS  NULL;)"
time="2024-05-06T15:18:40+08:00" level=warning msg="type_datetime:706 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_WRONG_VALUE_FOR_TYPE) (err: Error 1305 (42000): FUNCTION type_datetime.st_longfromgeohash does not exist) (query: do ucase(insert(maketime(9.565398e+307 ,'',\nst_longfromgeohash(('4358-04-12 03:45:08.727399'))),\n0xdc0823,6756,release_all_locks()));)"
time="2024-05-06T15:18:40+08:00" level=warning msg="type_datetime:711 query failed with non expected error(s)! (ErrSpDoesNotExist != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION type_datetime.soundex does not exist) (query: do soundex(maketime(cast((2530967061762658367) as decimal),\nexp(repeat('1',32)),((period_add(579349005,27636))xor (sha(current_user)))));)"
time="2024-05-06T15:18:40+08:00" level=warning msg="type_datetime:715 query failed with non expected error(s)! (ER_SP_DOES_NOT_EXIST != ER_DATA_OUT_OF_RANGE) (err: Error 1305 (42000): FUNCTION type_datetime.st_mlinefromtext does not exist) (query: do st_mlinefromtext(\nmaketime(\nnow(),\ninstr(1,pow(15270551309908264860,100)),\n31\n)\n);)"
./t/type_datetime.test: ok! 334 test cases passed, take time 2.677134131 s
time="2024-05-06T15:18:40+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=25
time="2024-05-06T15:18:41+08:00" level=warning msg="command not implemented" arguments=" utf8mb4" command=character_set line=171
time="2024-05-06T15:18:41+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=344
time="2024-05-06T15:18:41+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=350
time="2024-05-06T15:18:42+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=529
./t/type_decimal.test: ok! 361 test cases passed, take time 1.991198352 s
time="2024-05-06T15:18:43+08:00" level=warning msg="command not implemented" arguments=" utf8mb4" command=character_set line=107
time="2024-05-06T15:18:43+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=114
time="2024-05-06T15:18:43+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=129
time="2024-05-06T15:18:43+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=131
time="2024-05-06T15:18:44+08:00" level=warning msg="command not implemented" arguments=" 5 4 3 4" command=replace_result line=263
time="2024-05-06T15:18:44+08:00" level=warning msg="type_enum:288 query succeeded, but expected error(s)! (expected errors: ER_TOO_LONG_SET_ENUM_VALUE) (query: CREATE TABLE t1(exhausting_charset enum(\n'zz\nzz'))\nCHARSET=utf8mb4;)"
./t/type_enum.test: ok! 122 test cases passed, take time 1.52504314 s
time="2024-05-06T15:18:45+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=146
time="2024-05-06T15:18:45+08:00" level=warning msg="type_float:251 query failed with non expected error(s)! (ErrTooBigDisplaywidth != 1427) (err: Error 1439 (42000): Display width out of range for column 's1' (max = 255)) (query: create table t1 (s1 float(0,2));)"
time="2024-05-06T15:18:46+08:00" level=warning msg="command not implemented" arguments=" select concat((truncate((-1.7976931348623157E+307),(0x1e))),\n($nine_65)) into @a;" command=eval line=358
./t/type_float.test: ok! 269 test cases passed, take time 4.380085051 s
time="2024-05-06T15:18:48+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=15
time="2024-05-06T15:18:48+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=22
time="2024-05-06T15:18:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=29
time="2024-05-06T15:18:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=36
time="2024-05-06T15:18:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=43
time="2024-05-06T15:18:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=50
time="2024-05-06T15:18:49+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=57
./t/type_nchar.test: ok! 23 test cases passed, take time 0.311019236 s
./t/index_merge_intersection_partition_tbl_simple.test: ok! 5865 test cases passed, take time 64.013427691 s
time="2024-05-06T15:18:52+08:00" level=warning msg="type_newdecimal:1836 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT a - b FROM t1;)"
time="2024-05-06T15:18:52+08:00" level=warning msg="type_newdecimal:1840 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT a - b FROM t3;)"
time="2024-05-06T15:18:52+08:00" level=warning msg="type_newdecimal:1861 query succeeded, but expected error(s)! (expected errors: ER_DATA_OUT_OF_RANGE) (query: SELECT * FROM t ORDER BY (a-b);)"
time="2024-05-06T15:18:52+08:00" level=warning msg="type_newdecimal:1880 query failed with non expected error(s)! (ER_INVALID_JSON_PATH != ER_INVALID_TYPE_FOR_JSON) (err: Error 3143 (42000): Invalid JSON path expression. The error is around character position 1.) (query: SELECT -1 DIV LEAST(1,JSON_INSERT(1, '$[1]','','',''));)"
./t/type_newdecimal.test: ok! 584 test cases passed, take time 3.50988195 s
time="2024-05-06T15:18:54+08:00" level=warning msg="type_ranges:151 query failed with non expected error(s)! (ER_WRONG_VALUE_COUNT_ON_ROW != 1060) (err: Error 1136 (21S01): Column count doesn't match value count at row 1) (query: insert into t3 select * from t1, t2;)"
./t/type_ranges.test: ok! 82 test cases passed, take time 1.80138255 s
time="2024-05-06T15:18:54+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=12
time="2024-05-06T15:18:54+08:00" level=warning msg="command not implemented" arguments=" latin1" command=character_set line=22
time="2024-05-06T15:18:54+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=26
./t/type_set.test: ok! 33 test cases passed, take time 0.416169634 s
./t/type_time.test: ok! 144 test cases passed, take time 1.180233861 s
time="2024-05-06T15:18:56+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=104
time="2024-05-06T15:18:56+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=117
time="2024-05-06T15:18:56+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=132
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=148
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=164
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=180
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=199
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=259
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=271
time="2024-05-06T15:18:57+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=286
./t/type_timestamp.test: ok! 279 test cases passed, take time 1.954583392 s
time="2024-05-06T15:18:58+08:00" level=warning msg="command not implemented" arguments=" type_timestamp.test" command=source line=7
time="2024-05-06T15:18:58+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=23
time="2024-05-06T15:18:58+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=33
time="2024-05-06T15:18:58+08:00" level=warning msg="command not implemented" arguments=" $DEFAULT_ENGINE ENGINE" command=replace_result line=51
./t/type_timestamp_explicit.test: ok! 48 test cases passed, take time 0.698888473 s
time="2024-05-06T15:18:59+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T15:18:59+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
./t/type_timestamp_myisam.test: ok! 6 test cases passed, take time 0.052948091 s
./t/index_merge_intersection_single_tbl.test: ok! 3701 test cases passed, take time 11.673856912 s
./t/type_uint.test: ok! 9 test cases passed, take time 0.043882574 s
./t/type_unit.test: ok! 9 test cases passed, take time 0.06765307 s
./t/type_varchar.test: ok! 180 test cases passed, take time 2.535866365 s
./t/type_year.test: ok! 101 test cases passed, take time 0.713666632 s
time="2024-05-06T15:19:02+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=4
time="2024-05-06T15:19:04+08:00" level=warning msg="update:425 query succeeded, but expected error(s)! (expected errors: ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) (query: SET SESSION sql_safe_updates = DEFAULT;)"
time="2024-05-06T15:19:04+08:00" level=warning msg="update:448 query succeeded, but expected error(s)! (expected errors: ER_VIEW_INVALID) (query: SET sql_mode = default;)"
time="2024-05-06T15:19:04+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=559
time="2024-05-06T15:19:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=560
time="2024-05-06T15:19:04+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=572
time="2024-05-06T15:19:04+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=573
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=583
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=584
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=600
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=601
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=607
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=608
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=614
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=615
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=634
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=635
time="2024-05-06T15:19:05+08:00" level=warning msg="update:648 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET b= NULL WHERE a < '00:38:47.008761';)"
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN $query;" command=eval line=675
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=676
time="2024-05-06T15:19:05+08:00" level=warning msg="update:694 query succeeded, but expected error(s)! (expected errors: ER_TRUNCATED_WRONG_VALUE) (query: UPDATE t1 SET a=1 ORDER BY CAST('invalid' AS DATETIME);)"
time="2024-05-06T15:19:05+08:00" level=warning msg="update:756 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: DROP TABLE t1, t2;)"
./t/update.test: ok! 246 test cases passed, take time 2.765028184 s
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=4
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=5
time="2024-05-06T15:19:05+08:00" level=warning msg="command not implemented" arguments=" include/not_binlog_format_statement.inc" command=source line=6
./t/update_myisam.test: ok! 36 test cases passed, take time 0.459937067 s
./t/update_stmt.test: ok! 17 test cases passed, take time 0.046719409 s
./t/upgrade.test: ok! 34 test cases passed, take time 0.323364227 s
time="2024-05-06T15:19:06+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=104
time="2024-05-06T15:19:06+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=109
time="2024-05-06T15:19:06+08:00" level=warning msg="command not implemented" arguments=" SELECT User,plugin,authentication_string,ssl_type,\npassword_expired,password_lifetime FROM mysql.user WHERE USER='user2';" command=query_vertical line=116
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments=" echo \"wait\" > $expect_file" command=exec line=146
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments= command=send_shutdown line=149
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_disconnected.inc" command=source line=152
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments=" echo \"restart:--log-raw=ON \" > $expect_file" command=exec line=155
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments= command=enable_reconnect line=158
time="2024-05-06T15:19:07+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_connected_again.inc" command=source line=161
./t/user_if_exists.test: ok! 79 test cases passed, take time 0.38714337 s
time="2024-05-06T15:19:07+08:00" level=warning msg="user_password_history:217 query succeeded, but expected error(s)! (expected errors: ER_NO_SUCH_TABLE) (query: CREATE USER no_pwd_history_err@localhost IDENTIFIED BY 'haha'\nPASSWORD HISTORY 0 PASSWORD REUSE INTERVAL 0 DAY;)"
./t/index_merge_intersection_trs.test: ok! 4356 test cases passed, take time 8.879531234 s
time="2024-05-06T15:19:07+08:00" level=warning msg="user_password_history:230 query failed with non expected error(s)! (ErrCannotUser != ER_NO_SUCH_TABLE) (err: Error 1396 (HY000): Operation DROP USER failed for no_pwd_history@localhost) (query: DROP USER no_pwd_history@localhost;)"
./t/index_merge_mvindex_multiple_table.test: ok! 324 test cases passed, take time 0.785085001 s
./t/user_password_history.test: ok! 141 test cases passed, take time 1.03592012 s
time="2024-05-06T15:19:08+08:00" level=warning msg="user_var:10 query succeeded, but expected error(s)! (expected errors: 1054) (query: set @a := foo;)"
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=342
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=348
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments=" include/turn_off_only_full_group_by.inc" command=source line=479
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments=" include/restore_sql_mode_after_turn_off_only_full_group_by.inc" command=source line=483
time="2024-05-06T15:19:09+08:00" level=warning msg="user_var:533 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set    @X2345678901234567890123456789012345678901234567890123456789012345 = 12;)"
time="2024-05-06T15:19:09+08:00" level=warning msg="user_var:537 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @``= \"illegal\";)"
time="2024-05-06T15:19:09+08:00" level=warning msg="user_var:541 query succeeded, but expected error(s)! (expected errors: ER_ILLEGAL_USER_VAR) (query: set @`endswithspace `= \"illegal\";)"
time="2024-05-06T15:19:09+08:00" level=warning msg="user_var:593 query succeeded, but expected error(s)! (expected errors: ER_TOO_MANY_ROWS) (query: SET @x= 2;)"
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=602
time="2024-05-06T15:19:09+08:00" level=warning msg="user_var:609 query succeeded, but expected error(s)! (expected errors: ER_INVALID_CHARACTER_STRING) (query: SELECT * FROM t1 WHERE a = (SELECT (@x:=_utf8mb4 0x1023) FROM t1) OR b = @x;)"
time="2024-05-06T15:19:09+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=611
time="2024-05-06T15:19:10+08:00" level=warning msg="user_var:701 query failed with non expected error(s)! (ErrCantAggregate2collations != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (latin1_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_latin1;)"
time="2024-05-06T15:19:10+08:00" level=warning msg="user_var:703 query failed with non expected error(s)! (ER_CANT_AGGREGATE_2COLLATIONS != ER_IMPOSSIBLE_STRING_CONVERSION) (err: Error 1267 (HY000): Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8mb4_bin,COERCIBLE) for operation '=') (query: EXECUTE s1 USING @str_utf8mb4;)"
./t/user_var.test: ok! 309 test cases passed, take time 2.052004441 s
./t/index_merge_mvindex_single_table.test: ok! 1005 test cases passed, take time 2.046962317 s
time="2024-05-06T15:19:10+08:00" level=warning msg="validate_password:76 query failed with non expected error(s)! (ErrCannotUser != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'aedSWEhjui';)"
time="2024-05-06T15:19:10+08:00" level=warning msg="validate_password:118 query failed with non expected error(s)! (ErrCannotUser != ErrNotValidPassword) (err: Error 1396 (HY000): Operation CREATE USER failed for 'user'@'localhost') (query: CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';)"
time="2024-05-06T15:19:10+08:00" level=warning msg="validate_password:129 query failed with non expected error(s)! (ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH('password', 0);)"
time="2024-05-06T15:19:10+08:00" level=warning msg="validate_password:131 query failed with non expected error(s)! (ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT != 1) (err: Error 1582 (42000): Incorrect parameter count in the call to native function 'validate_password_strength') (query: SELECT VALIDATE_PASSWORD_STRENGTH();)"
./t/validate_password.test: ok! 155 test cases passed, take time 0.712382829 s
./t/validate_password_check_user.test: ok! 34 test cases passed, take time 0.142986215 s
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=254
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=255
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=281
time="2024-05-06T15:19:11+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.517015897 s
./t/variable.test: ok! 16 test cases passed, take time 0.006810112 s
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" include/have_log_bin.inc" command=source line=5
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=6
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" 1e-010 1e-10" command=replace_result line=59
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=121
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" 18446744073709551615 HA_POS_ERROR 4294967295 HA_POS_ERROR" command=replace_result line=124
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=172
time="2024-05-06T15:19:11+08:00" level=warning msg="command not implemented" arguments=" 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE" command=replace_result line=175
time="2024-05-06T15:19:11+08:00" level=warning msg="variables:304 query succeeded, but expected error(s)! (expected errors: ER_WRONG_TYPE_FOR_VAR) (query: set max_join_size=\"hello\";)"
time="2024-05-06T15:19:11+08:00" level=warning msg="variables:306 query succeeded, but expected error(s)! (expected errors: ER_UNKNOWN_STORAGE_ENGINE) (query: set default_storage_engine=UNKNOWN_TABLE_TYPE;)"
time="2024-05-06T15:19:11+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="2024-05-06T15:19:11+08:00" level=warning msg="variables:317 query failed with non expected error(s)! (ErrUnknownCollation != ER_WRONG_VALUE_FOR_VAR) (err: Error 1273 (HY000): Unknown collation: '') (query: set collation_connection=NULL;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:458 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:465 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: set global ft_boolean_syntax = @@init_connect;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=472
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments=" 4294967296 MAX_FILE_SIZE 2146435072 MAX_FILE_SIZE" command=replace_result line=475
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:500 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set @@global.global.key_buffer_size= 1;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:502 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'global.key_buffer_size') (query: set GLOBAL global.key_buffer_size= 1;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:504 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="2024-05-06T15:19:12+08:00" level=warning msg="variables:506 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'session.key_buffer_size') (query: SELECT @@global.session.key_buffer_size;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:508 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable 'local.key_buffer_size') (query: SELECT @@global.local.key_buffer_size;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:646 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="2024-05-06T15:19:12+08:00" level=warning msg="variables:808 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_PARSE_ERROR) (err: Error 1193 (HY000): Unknown system variable '') (query: select @@\"\";)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:906 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="2024-05-06T15:19:12+08:00" level=warning msg="variables:909 query failed with non expected error(s)! (ER_INCORRECT_GLOBAL_LOCAL_VAR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1238 (HY000): Variable 'log_output' is a read only variable) (query: SET GLOBAL log_output = 0;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:921 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_max_word_len;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:931 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_min_word_len;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:941 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_query_expansion_limit;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:951 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.ft_stopword_file;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:963 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.back_log;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:974 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_files_support;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:986 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.character_sets_dir;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:998 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SELECT @@session.init_file;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1002 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="2024-05-06T15:19:12+08:00" level=warning msg="variables:1004 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'init_file') (query: SET @@global.init_file= 'x';)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1010 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lc_messages_dir;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1022 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_page_size;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1034 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.large_pages;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1046 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_bin;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1058 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.log_error;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1070 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_file_system;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1082 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.lower_case_table_names;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1093 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.myisam_recover_options;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1104 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.open_files_limit;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1116 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.pid_file;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1141 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.port;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1152 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.protocol_version;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1162 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_external_locking;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1172 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_networking;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1182 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.skip_show_database;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1193 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.thread_stack;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1223 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SELECT @@global.expire_logs_days;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments= command=enable_metadata line=1249
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments= command=disable_metadata line=1251
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1324 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1331 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET SQL_MODE=DEFAULT;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1338 query succeeded, but expected error(s)! (expected errors: ER_WARN_CANT_DROP_DEFAULT_KEYCACHE) (query: SET @@global.key_buffer_size=0;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1410 query succeeded, but expected error(s)! (expected errors: ER_WRONG_VALUE_FOR_VAR) (query: SET GLOBAL delay_key_write = OFF;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1454 query succeeded, but expected error(s)! (expected errors: ER_PARSE_ERROR) (query: SET @@foreign_key_checks = OFF;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1558 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_results = 2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1560 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_client=2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1562 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_connection=2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1564 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_server=2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1568 query failed with non expected error(s)! (ErrUnknown != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_filesystem=2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1570 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_UNKNOWN_CHARACTER_SET) (err: Error 1105 (HY000): Unknown charset 2048) (query: set session character_set_database=2048;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1596 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_WRONG_VALUE_FOR_VAR) (err: Error 1105 (HY000): ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of '8589934592') (query: SET @@sql_mode= 8589934592;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1722
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1725 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SELECT @@session.relay_log_index;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="command not implemented" arguments=" $MYSQLTEST_VARDIR MYSQLTEST_VARDIR $HOST_NAME hostname" command=replace_result line=1726
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1729 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@session.relay_log_index= 'x';)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1731 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'relay_log_index') (query: SET @@global.relay_log_index= 'x';)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1748 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_info_file;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1758 query succeeded, but expected error(s)! (expected errors: ER_INCORRECT_GLOBAL_LOCAL_VAR) (query: SELECT @@session.relay_log_space_limit;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1769 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SELECT @@session.replica_load_tmpdir;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1773 query failed with non expected error(s)! (ErrUnknownSystemVariable != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_load_tmpdir') (query: SET @@session.replica_load_tmpdir= 'x';)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1780 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SELECT @@session.replica_skip_errors;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1785 query failed with non expected error(s)! (ER_UNKNOWN_SYSTEM_VARIABLE != ER_INCORRECT_GLOBAL_LOCAL_VAR) (err: Error 1193 (HY000): Unknown system variable 'replica_skip_errors') (query: SET @@global.replica_skip_errors= 7;)"
time="2024-05-06T15:19:12+08:00" level=warning msg="variables:1802 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! 559 test cases passed, take time 0.791162226 s
./t/index_merge_sqlgen_exprs.test: ok! 456 test cases passed, take time 2.477468421 s

Great, All tests passed
mysqltest end
tidb-server(PID: 2375) stopped
[Pipeline] }
Cache not saved (ws/jenkins-pingcap-qe-tidb-test-ghpr_mysql_test-112/mysql-test already exists)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
./t/variables_dynamic_privs.test: ok! 14 test cases passed, take time 3.1367520190000002 s
time="2024-05-06T15:19:18+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="2024-05-06T15:19:18+08:00" level=warning msg="view:602 query failed with non expected error(s)! (ER_BAD_TABLE_ERROR != ER_NO_TABLES_USED) (err: Error 1051 (42S02): Unknown table '') (query: CREATE VIEW v02 AS SELECT * FROM DUAL;)"
time="2024-05-06T15:19:18+08:00" level=warning msg="view:618 query failed with non expected error(s)! (ErrUnknown != ER_WRONG_OBJECT) (err: Error 1105 (HY000): Unknown charset ) (query: create index i1 on v1 (col1);)"
time="2024-05-06T15:19:33+08:00" level=warning msg="view:4019 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c1 = 'text1';)"
time="2024-05-06T15:19:33+08:00" level=warning msg="view:4040 query succeeded, but expected error(s)! (expected errors: ER_CANT_AGGREGATE_2COLLATIONS) (query: SELECT * FROM v1 WHERE c2 = 'text2';)"
time="2024-05-06T15:19:34+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=4444
time="2024-05-06T15:19:36+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=5522
time="2024-05-06T15:19:36+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=5523
time="2024-05-06T15:19:37+08:00" level=warning msg="command not implemented" arguments=" include/wait_until_count_sessions.inc" command=source line=6063
time="2024-05-06T15:19:41+08:00" level=warning msg="view:6298 query failed with non expected error(s)! (ErrTooLongIdent != ER_WRONG_COLUMN_NAME) (err: Error 1059 (42000): Identifier name 'x12345678901234567890123456789012345678901234567890123456789012322' is too long) (query: CREATE OR REPLACE VIEW v1\n(`x12345678901234567890123456789012345678901234567890123456789012322`) AS\nSELECT fld1 FROM t1;)"
./t/view.test: ok! 1458 test cases passed, take time 26.338276197 s
time="2024-05-06T15:19:47+08:00" level=warning msg="view_grant:48 query succeeded, but expected error(s)! (expected errors: ER_TABLEACCESS_DENIED_ERROR) (query: create or replace view v1 as select * from mysqltest.t1;)"
time="2024-05-06T15:19:48+08:00" level=warning msg="view_grant:219 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select c from mysqltest.v3;)"
time="2024-05-06T15:19:48+08:00" level=warning msg="view_grant:223 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select c from mysqltest.v4;)"
time="2024-05-06T15:19:48+08:00" level=warning msg="view_grant:369 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't2') (query: create view v3 as select a from mysqltest.t2;)"
time="2024-05-06T15:19:49+08:00" level=warning msg="view_grant:607 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v3;)"
time="2024-05-06T15:19:49+08:00" level=warning msg="view_grant:609 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v4;)"
time="2024-05-06T15:19:49+08:00" level=warning msg="view_grant:611 query failed with non expected error(s)! (ErrTableaccessDenied != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_1'@'localhost' for table 't1') (query: select * from v5;)"
time="2024-05-06T15:19:52+08:00" level=warning msg="view_grant:811 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'view_grant.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v;)"
time="2024-05-06T15:19:52+08:00" level=warning msg="command not implemented" arguments=" $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK" command=replace_result line=825
time="2024-05-06T15:19:53+08:00" level=warning msg="view_grant:966 query failed with non expected error(s)! (ErrViewInvalid != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2024-05-06T15:19:53+08:00" level=warning msg="view_grant:971 query failed with non expected error(s)! (ER_VIEW_INVALID != ER_NO_SUCH_USER) (err: Error 1356 (HY000): View 'db17254.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them) (query: SELECT * FROM v1;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1103 query succeeded, but expected error(s)! (expected errors: ER_SPECIFIC_ACCESS_DENIED_ERROR) (query: SHOW CREATE VIEW v2;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1179 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v12 AS SELECT c1, c2 FROM mysqltest1.t1, mysqltest1.t2;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1184 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v21 AS SELECT c2, c1 FROM mysqltest1.t2, mysqltest1.t1;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1186 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v23 AS SELECT c2, c3 FROM mysqltest1.t2, mysqltest1.t3;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1188 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v24 AS SELECT c2, c4 FROM mysqltest1.t2, mysqltest1.t4;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1192 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v32 AS SELECT c3, c2 FROM mysqltest1.t3, mysqltest1.t2;)"
time="2024-05-06T15:19:54+08:00" level=warning msg="view_grant:1197 query failed with non expected error(s)! (ErrTableaccessDenied != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1142 (42000): SELECT command denied to user 'mysqltest_u1'@'localhost' for table 't2') (query: CREATE VIEW v42 AS SELECT c4, c2 FROM mysqltest1.t4, mysqltest1.t2;)"
time="2024-05-06T15:19:56+08:00" level=warning msg="view_grant:1483 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-06T15:19:56+08:00" level=warning msg="view_grant:1541 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-06T15:19:56+08:00" level=warning msg="view_grant:1552 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v2;)"
time="2024-05-06T15:19:56+08:00" level=warning msg="view_grant:1575 query succeeded, but expected error(s)! (expected errors: ER_VIEW_NO_EXPLAIN) (query: explain format='brief' select * from v1;)"
time="2024-05-06T15:19:57+08:00" level=warning msg="view_grant:1910 query failed with non expected error(s)! (ErrUnsupportedOp != ER_NO_SUCH_USER) (err: Error 8040 (HY000): operation not supported) (query: LOCK TABLES v1 READ;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:1979 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser1'@'%' for table 't2') (query: SELECT * FROM v2_uses_t2;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:1986 query failed with non expected error(s)! (ER_TABLEACCESS_DENIED_ERROR != ER_VIEW_INVALID) (err: Error 1142 (42000): SELECT command denied to user 'mysqluser2'@'%' for table 't1') (query: SELECT * FROM v2_uses_t1;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:2125 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v1 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v1_merge as v1 set v1.val= 'test5'\nwhere t2.id= v1.id;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:2149 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 1288 (HY000): The target table v11 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest1.v11_merge as v11 set v11.val= 'test11'\nwhere t2.id= v11.id;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:2177 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v3 of the UPDATE is not updatable) (query: update mysqltest2.t2 as t2, mysqltest2.v3_merge as v3 set v3.val= 'test17'\nwhere t2.id= v3.id;)"
time="2024-05-06T15:19:58+08:00" level=warning msg="view_grant:2195 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v4 of the UPDATE is not updatable) (query: update mysqltest1.t11 as t11, mysqltest2.v41 as v4 set v4.val= 'test20'\nwhere t11.id= v4.id;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="command not implemented" arguments= command=enable_connect_log line=2951
time="2024-05-06T15:19:59+08:00" level=warning msg="view_grant:2955 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_grant:2959 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE test1.v1_all SET cn='x';)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_grant:2962 query failed with non expected error(s)! (ER_NON_UPDATABLE_TABLE != ER_VIEW_INVALID) (err: Error 1288 (HY000): The target table v1_all of the UPDATE is not updatable) (query: UPDATE IGNORE test1.v1_all SET cn='x';)"
./t/view_grant.test: ok! 719 test cases passed, take time 16.91556584 s
time="2024-05-06T15:19:59+08:00" level=warning msg="command not implemented" arguments=" include/force_myisam_default.inc" command=source line=2
time="2024-05-06T15:19:59+08:00" level=warning msg="command not implemented" arguments=" include/have_myisam.inc" command=source line=3
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:36 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 values (1,2);)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:38 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_NO_INSERT_FIELD_LIST) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3 select * from t2;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:41 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_MULTIUPDATE) (err: Error 1105 (HY000): insert into view v3 is not supported now) (query: insert into v3(a,b) values (1,2);)"
time="2024-05-06T15:19:59+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="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:56 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete from v3;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:58 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete v3,t1 from v3,t1;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:60 query failed with non expected error(s)! (ErrUnknown != ER_VIEW_DELETE_MERGE_VIEW) (err: Error 1105 (HY000): delete view v3 is not supported now) (query: delete t1,v3 from t1,v3;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:122 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_TOO_MANY_FIELDS) (err: Error 1146 (42S02): Table 'view_myisam.t1' doesn't exist) (query: CREATE VIEW view_broken AS SELECT * FROM t1, t2, t3;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="view_myisam:126 query failed with non expected error(s)! (ER_UNKNOWN_ERROR != ER_TOO_MANY_FIELDS) (err: Error 1105 (HY000): 'CREATE TABLE ... SELECT' is not implemented yet) (query: CREATE TABLE table_broken AS SELECT * FROM t1, t2, t3;)"
./t/view_myisam.test: ok! 31 test cases passed, take time 0.413328652 s
time="2024-05-06T15:19:59+08:00" level=warning msg="warnings:27 query succeeded, but expected error(s)! (expected errors: 1064) (query: show errors;)"
time="2024-05-06T15:19:59+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=48
time="2024-05-06T15:19:59+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=50
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=101
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=enable_ps_protocol line=103
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=disable_ps_protocol line=109
time="2024-05-06T15:20:00+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.574676068 s
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:122 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:133 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:143 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=191
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:209 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE) (query: SELECT '---',\nHEX(BIT_OR(b) OVER w) AS `OR`,\nHEX(BIT_AND(b) OVER w) AS `AND`,\nHEX(BIT_XOR(b) OVER w) AS `XOR`,\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS BETWEEN 1 PRECEDING AND CURRENT ROW);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=horizontal_results line=219
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:365 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:376 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:386 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_OPERANDS_SIZE) (query: SELECT HEX(BIT_AND(b) OVER w),\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS 2 PRECEDING);)"
time="2024-05-06T15:20:00+08:00" level=warning msg="command not implemented" arguments= command=vertical_results line=434
time="2024-05-06T15:20:00+08:00" level=warning msg="window_bitwise_ops:452 query succeeded, but expected error(s)! (expected errors: ER_INVALID_BITWISE_AGGREGATE_OPERANDS_SIZE) (query: SELECT '---',\nHEX(BIT_OR(b) OVER w) AS `OR`,\nHEX(BIT_AND(b) OVER w) AS `AND`,\nHEX(BIT_XOR(b) OVER w) AS `XOR`,\nSUM(d) OVER w AS dsum\nFROM t\nWINDOW w AS (ORDER BY i ROWS BETWEEN 1 PRECEDING AND CURRENT ROW);)"
time="2024-05-06T15:20:00+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.630326291 s
time="2024-05-06T15:20:01+08:00" level=warning msg="window_functions:102 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT a, SUM(b) OVER () FROM tb GROUP BY a; # illegal b reference\nDROP TABLE tb;)"
time="2024-05-06T15:20:01+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="2024-05-06T15:20:01+08:00" level=warning msg="window_functions:257 query succeeded, but expected error(s)! (expected errors: ER_WRONG_USAGE) (query: SELECT id, FIRST_VALUE(id) OVER w first, LAST_VALUE(id) OVER w last, sex FROM t1\nWINDOW w AS (PARTITION BY sex\nORDER BY id ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING);)"
time="2024-05-06T15:20:01+08:00" level=warning msg="window_functions:585 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT id, SUM(SUM(id)) OVER (ORDER BY sex ROWS UNBOUNDED PRECEDING) FROM t1,t2 WHERE t1.id=t2.user_id GROUP BY sex;)"
time="2024-05-06T15:20:01+08:00" level=warning msg="window_functions:587 query succeeded, but expected error(s)! (expected errors: ER_WRONG_FIELD_WITH_GROUP) (query: SELECT SUM(id) OVER (ORDER BY sex ROWS UNBOUNDED PRECEDING) FROM t1,t2 WHERE t1.id=t2.user_id GROUP BY sex;)"
time="2024-05-06T15:20:03+08:00" level=warning msg="window_functions:1552 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(s1), RANK() OVER (ORDER BY s1) FROM t1;)"
time="2024-05-06T15:20:03+08:00" level=warning msg="window_functions:1612 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (row_number() over ());)"
time="2024-05-06T15:20:03+08:00" level=warning msg="window_functions:1614 query failed with non expected error(s)! (ER_WINDOW_INVALID_WINDOW_FUNC_USE != ER_AGGREGATE_ORDER_FOR_UNION) (err: Error 3593 (HY000): You cannot use the window function 'row_number' in this context.') (query: (select a from t) union (select a from t) order by (1+row_number() over ());)"
time="2024-05-06T15:20:03+08:00" level=warning msg="window_functions:1630 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_ILLEGAL_ORDER_BY) (query: SELECT RANK() OVER (ORDER BY 1) FROM t;)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:1937 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a IN (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:1944 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a > ANY (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:1948 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: SELECT * FROM t upper\nWHERE upper.a > ALL (SELECT ROW_NUMBER() OVER () FROM t\nWHERE t.a > upper.a);)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:1962 query succeeded, but expected error(s)! (expected errors: ER_NOT_SUPPORTED_YET) (query: select * from t1 AS upper where i+1\nIN (select row_number() over () + upper.i from t1 );)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:2032 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(c))  FROM t;)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:2048 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:2050 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT 1+SUM(a) OVER () AS c, (SELECT SUM(1 + (SELECT c FROM DUAL)))  FROM t;)"
time="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:2056 query failed with non expected error(s)! (ER_BAD_FIELD_ERROR != ER_WINDOW_INVALID_WINDOW_FUNC_ALIAS_USE) (err: Error 1054 (42S22): Unknown column 'c' in 'field list') (query: SELECT SUM(a) OVER () AS c, (SELECT 1 + (SELECT c FROM DUAL))  FROM t;)"
time="2024-05-06T15:20:04+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="2024-05-06T15:20:04+08:00" level=warning msg="window_functions:2079 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(a), SUM(a) OVER () FROM t;)"
time="2024-05-06T15:20:05+08:00" level=warning msg="window_functions:2398 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT COUNT(*) AS count,\nROW_NUMBER() OVER (ORDER BY b) AS rn\nFROM t ORDER BY b;)"
time="2024-05-06T15:20:06+08:00" level=warning msg="window_functions:2585 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL (SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
time="2024-05-06T15:20:06+08:00" level=warning msg="window_functions:2587 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE BETWEEN INTERVAL 1 MINUTE PRECEDING AND INTERVAL (SELECT a FROM t2) MINUTE FOLLOWING) FROM t1;)"
time="2024-05-06T15:20:06+08:00" level=warning msg="window_functions:2589 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_RANGE_BOUND_NOT_CONSTANT) (query: SELECT RANK() OVER (ORDER BY a RANGE INTERVAL 1+(SELECT a FROM t2) MINUTE PRECEDING) FROM t1;)"
time="2024-05-06T15:20:08+08:00" level=warning msg="window_functions:3523 query succeeded, but expected error(s)! (expected errors: ER_WINDOW_FRAME_ILLEGAL) (query: EXECUTE stmt USING @p1;)"
time="2024-05-06T15:20:08+08:00" level=warning msg="window_functions:3700 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i) FROM t1 WINDOW w AS (ORDER BY i);)"
time="2024-05-06T15:20:08+08:00" level=warning msg="window_functions:3702 query failed with non expected error(s)! (ErrMixOfGroupFuncAndFieldsIncompatible != ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (err: Error 8123 (HY000): In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'i'; this is incompatible with sql_mode=only_full_group_by) (query: SELECT AVG(i), RANK() OVER (ORDER BY i) FROM t1;)"
time="2024-05-06T15:20:08+08:00" level=warning msg="window_functions:3704 query succeeded, but expected error(s)! (expected errors: ER_MIX_OF_GROUP_FUNC_AND_FIELDS) (query: SELECT AVG(i) FROM t1 ORDER BY RANK() OVER (PARTITION BY AVG(i) ORDER BY i);)"
time="2024-05-06T15:20:08+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 7.749020384 s
time="2024-05-06T15:20:08+08:00" level=warning msg="command not implemented" arguments=" include/not_valgrind.inc" command=source line=2
time="2024-05-06T15:20:08+08:00" level=warning msg="command not implemented" arguments=" include/not_sparc_debug.inc" command=source line=3
time="2024-05-06T15:20:08+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.987896326 s
time="2024-05-06T15:20:11+08:00" level=warning msg="window_functions_bugs:619 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(FIRST_VALUE(CAST('' AS JSON)) OVER (), '');)"
time="2024-05-06T15:20:11+08:00" level=warning msg="window_functions_bugs:621 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(NTH_VALUE(CAST('' AS JSON), 1) OVER (), '');)"
time="2024-05-06T15:20:11+08:00" level=warning msg="window_functions_bugs:623 query failed with non expected error(s)! (ER_INVALID_JSON_TEXT != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(LEAD(CAST('true' AS JSON), 2, CAST('' AS JSON)) OVER (), '');)"
time="2024-05-06T15:20:11+08:00" level=warning msg="window_functions_bugs:625 query failed with non expected error(s)! (ErrInvalidJSONText != ER_INVALID_JSON_TEXT_IN_PARAM) (err: Error 3140 (22032): Invalid JSON text: The document is empty) (query: SELECT JSON_ARRAY(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '');)"
./t/window_functions_bugs.test: ok! 157 test cases passed, take time 2.815443068 s
time="2024-05-06T15:20:12+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.579071518 s
./t/window_min_max.test: ok! 200 test cases passed, take time 0.773122371 s
time="2024-05-06T15:20:14+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=49
time="2024-05-06T15:20:14+08:00" level=warning msg="command not implemented" arguments=" (0)\n{\nSELECT (WITH qn AS (SELECT t2.a*a as a FROM t1),\nqn2 AS (SELECT 3*a AS b FROM qn)\nSELECT * from qn2 LIMIT 1)\nFROM t2 as t1;" command=if line=107
time="2024-05-06T15:20:14+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=134
time="2024-05-06T15:20:14+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=256
time="2024-05-06T15:20:14+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=261
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=383
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=393
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=622
time="2024-05-06T15:20:15+08:00" level=warning msg="with_non_recursive:692 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-06T15:20:15+08:00" level=warning msg="with_non_recursive:694 query failed with non expected error(s)! (ER_NO_SUCH_TABLE != ER_CANT_REOPEN_TABLE) (err: Error 1146 (42S02): Table 'with_non_recursive.tmp' doesn't exist) (query: with qn as (select * from tmp) select /*+ no_merge(qn,qn1) */ * from qn, qn qn1;)"
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=710
time="2024-05-06T15:20:15+08:00" level=warning msg="with_non_recursive:711 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: select * from t1;)"
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=715
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=720
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=725
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=734
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=743
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=749
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=760
time="2024-05-06T15:20:15+08:00" level=warning msg="with_non_recursive:761 query succeeded, but expected error(s)! (expected errors: ER_NON_UPDATABLE_TABLE) (query: select * from t1;)"
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=765
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=770
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=775
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=781
time="2024-05-06T15:20:15+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=790
time="2024-05-06T15:20:15+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.601259539 s
./t/with_non_recursive_bugs.test: ok! 102 test cases passed, take time 2.817861446 s
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" EXPLAIN FORMAT=tree $query;" command=eval line=46
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=47
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=254
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=255
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=261
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=262
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=275
time="2024-05-06T15:20:18+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=276
time="2024-05-06T15:20:21+08:00" level=warning msg="command not implemented" arguments=" $query order by path;" command=eval line=539
time="2024-05-06T15:20:21+08:00" level=warning msg="command not implemented" arguments=" $query;" command=eval line=559
time="2024-05-06T15:20:21+08:00" level=warning msg="command not implemented" arguments=" explain $query;" command=eval line=582
time="2024-05-06T15:20:21+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 3.26969101 s
./t/with_recursive_bugs.test: ok! 30 test cases passed, take time 1.337546439 s
./t/with_recursive_innodb_tmp_table.test: ok! 14 test cases passed, take time 0.0636651 s
time="2024-05-06T15:20:23+08:00" level=warning msg="command not implemented" arguments= command=single_query line=47
time="2024-05-06T15:20: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.209557793 s
./t/year_innodb.test: ok! 51 test cases passed, take time 0.358091974 s
time="2024-05-06T15:20:24+08:00" level=warning msg="command not implemented" arguments=" include/have_innodb.inc" command=source line=2
time="2024-05-06T15:20:29+08:00" level=warning msg="sub_query_more:969 query succeeded, but expected error(s)! (expected errors: ER_INVALID_GROUP_FUNC_USE) (query: SELECT SUM( (SELECT AVG( (SELECT t1.a FROM t2) ) FROM DUAL) ) FROM t1;)"
time="2024-05-06T15:20:29+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 5.24655709 s
time="2024-05-06T15:20:29+08:00" level=warning msg="role:59 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation GRANT ROLE failed for peter@clickhost.net) (query: GRANT role1 TO peter@clickhost.net;)"
time="2024-05-06T15:20:29+08:00" level=warning msg="role:97 query failed with non expected error(s)! (ErrDynamicPrivilegeNotRegistered != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT SUPER, engineering ON *.* TO joan, sally;)"
time="2024-05-06T15:20:29+08:00" level=warning msg="role:99 query failed with non expected error(s)! (ER_WARN_DA_PRIVILEGE_NOT_REGISTERED != ER_PARSE_ERROR) (err: Error 3929 (HY000): Dynamic privilege 'ENGINEERING' is not registered with the server.) (query: GRANT engineering,SELECT ON *.* TO joan;)"
time="2024-05-06T15:20:30+08:00" level=warning msg="role:153 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for `engineering_role`@`%`) (query: REVOKE engineering_role FROM foo@localhost;)"
time="2024-05-06T15:20:30+08:00" level=warning msg="role:156 query failed with non expected error(s)! (ErrCannotUser != ER_UNKNOWN_AUTHID) (err: Error 1396 (HY000): Operation REVOKE ROLE failed for managers@%) (query: REVOKE engineering FROM managers;)"
time="2024-05-06T15:20:30+08:00" level=warning msg="role:262 query failed with non expected error(s)! (ER_DBACCESS_DENIED_ERROR != ER_TABLEACCESS_DENIED_ERROR) (err: Error 1044 (42000): Access denied for user 'joe'@'localhost' to database 'mysql') (query: SHOW GRANTS FOR `root`@`localhost` USING `replication`;)"
time="2024-05-06T15:20:31+08:00" level=warning msg="role:397 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_COLUMNACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=1;)"
time="2024-05-06T15:20:35+08:00" level=warning msg="role:619 query failed with non expected error(s)! (ErrCannotUser != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `rrrrr`@`%`) (query: SET DEFAULT ROLE `rrrrr` TO u1@localhost;)"
time="2024-05-06T15:20:35+08:00" level=warning msg="role:628 query failed with non expected error(s)! (ErrCannotUser != ER_ROLE_NOT_GRANTED) (err: Error 1396 (HY000): Operation SET DEFAULT ROLE failed for `asdasd`@`%`) (query: SET DEFAULT ROLE `asdasd` TO u1@localhost;)"
./t/role.test: ok! 340 test cases passed, take time 6.22966156 s
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:23 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:51 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:87 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:116 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:120 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:177 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:179 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:181 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_ACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON *.* TO u1@localhost;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:183 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u1@localhost;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:185 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.t1 TO u1@localhost;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:218 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:220 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:253 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:284 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:288 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:347 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:349 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:378 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:380 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t2 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:413 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:444 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_TABLEACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Update' fail) (query: UPDATE db1.t1 SET c1=2;)"
time="2024-05-06T15:20:36+08:00" level=warning msg="role2:448 query succeeded, but expected error(s)! (expected errors: ER_COLUMNACCESS_DENIED_ERROR) (query: SELECT c2 FROM db1.t1;)"
time="2024-05-06T15:20:37+08:00" level=warning msg="role2:534 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Grant Option' fail) (query: GRANT SELECT ON db1.* TO u2@localhost;)"
time="2024-05-06T15:20:37+08:00" level=warning msg="role2:547 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `%db1`.* TO u2@localhost;)"
time="2024-05-06T15:20:37+08:00" level=warning msg="role2:556 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb%`.* TO u2@localhost;)"
time="2024-05-06T15:20:37+08:00" level=warning msg="role2:558 query failed with non expected error(s)! (ErrPrivilegeCheckFail != ER_DBACCESS_DENIED_ERROR) (err: Error 8121 (HY000): privilege check for 'Select' fail) (query: GRANT SELECT ON `secdb_`.* TO u2@localhost;)"
time="2024-05-06T15:20:37+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.647466986 s

time="2024-05-06T15:20:37+08:00" level=error msg="3 tests failed\n"
time="2024-05-06T15:20:37+08:00" level=error msg="run test [range_all] err: sql:EXPLAIN FORMAT= 'BRIEF' SELECT * FROM t1 WHERE status <> 'A' AND status <> 'B';: failed to run query \n\"EXPLAIN FORMAT= 'BRIEF' SELECT * FROM t1 WHERE status <> 'A' AND status <> 'B';\" \n around line 802, \nwe need(293):\nEXPLAIN FORMAT= 'BRIEF' SELECT * FROM t1 WHERE status <> 'A' AND status <> 'B';\nid\testRows\ttask\taccess object\toperator info\nIndexReader\t8.00\troot\t\tindex:IndexRangeScan\n└─IndexRangeScan\t8.00\tcop[tikv]\ttable:t1, index:status(status)\trange:[-inf,\"A\"), (\"A\",\"B\"), (\"B\",+inf], keep order:false,\nbut got(293):\nEXPLAIN FORMAT= 'BRIEF' SELECT * FROM t1 WHERE status <> 'A' AND status <> 'B';\nid\testRows\ttask\taccess object\toperator info\nIndexReader\t8.00\troot\t\tindex:IndexRangeScan\n└─IndexRangeScan\t8.00\tcop[tikv]\ttable:t1, index:status(status)\trange:[-inf,\"A\"), (\"A\",\"B\"), (\"B\",+inf], keep order:false\n\n"
time="2024-05-06T15:20:37+08:00" level=error msg="run test [range_mrr_cost] err: sql:explain FORMAT=\"brief\" select * from t1, t2  where t1.uid=t2.uid AND t1.uid > 0;: failed to run query \n\"explain FORMAT=\"brief\" select * from t1, t2  where t1.uid=t2.uid AND t1.uid > 0;\" \n around line 428, \nwe need(619):\nexplain FORMAT=\"brief\" select * from t1, t2  where t1.uid=t2.uid AND t1.uid > 0;\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t676.00\t#\t\tinner join, equal:[eq(range_mrr_cost.t1.uid, range_mrr_cost.t2.uid)]\n├─IndexLookUp(Build)\t26.00\t#\t\t\n│ ├─IndexRangeScan(Build)\t26.00\t#\ttable:t2, index:uid_index(uid)\trange:(0,+inf], keep order:false, stats:partial[id:allEvicted]\n│ └─TableRowIDScan(Probe)\t26.00\t#\ttable:t2\tkeep order:false, stats:partial[id:allEvicted]\n└─IndexLookUp(Probe)\t26.00\t#\t\t\n  ├─IndexRangeScan(Build)\t26.00\t#\ttable:t1, index:uid_index(uid)\trange:(0,+inf], keep order:false, sta\nbut got(619):\nexplain FORMAT=\"brief\" select * from t1, t2  where t1.uid=t2.uid AND t1.uid > 0;\nid\testRows\ttask\taccess object\toperator info\nHashJoin\t676.00\t#\t\tinner join, equal:[eq(range_mrr_cost.t1.uid, range_mrr_cost.t2.uid)]\n├─IndexLookUp(Build)\t26.00\t#\t\t\n│ ├─IndexRangeScan(Build)\t26.00\t#\ttable:t2, index:uid_index(uid)\trange:(0,+inf], keep order:false\n│ └─TableRowIDScan(Probe)\t26.00\t#\ttable:t2\tkeep order:false\n└─IndexLookUp(Probe)\t26.00\t#\t\t\n  ├─IndexRangeScan(Build)\t26.00\t#\ttable:t1, index:uid_index(uid)\trange:(0,+inf], keep order:false\n  └─TableRowIDScan(Probe)\t26.00\t#\ttable:t1\tkeep order:false\n\n"
time="2024-05-06T15:20:37+08:00" level=error msg="run test [select_all] err: sql:EXPLAIN SELECT STRAIGHT_JOIN COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;: failed to run query \n\"EXPLAIN SELECT STRAIGHT_JOIN COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;\" \n around line 2458, \nwe need(569):\nEXPLAIN SELECT STRAIGHT_JOIN COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;\nid\testRows\ttask\taccess object\toperator info\nStreamAgg_9\t1.00\troot\t\tfuncs:count(1)->Column#6\n└─HashJoin_19\t6.00\troot\t\tCARTESIAN inner join, other cond:or(eq(select_all.t1.b, select_all.t2.b), isnull(select_all.t2.b))\n  ├─IndexReader_15(Build)\t2.00\troot\t\tindex:IndexFullScan_14\n  │ └─IndexFullScan_14\t2.00\tcop[tikv]\ttable:t2, index:b(b)\tkeep order:false\n  └─TableReader_17(Probe)\t3.00\troot\t\tdata:TableFullScan_16\n    └─TableFullScan_16\t3.00\tcop[tikv]\ttable:t1\tkeep\nbut got(569):\nEXPLAIN SELECT STRAIGHT_JOIN COUNT(*) FROM t2, t1 WHERE t1.b = t2.b OR t2.b IS NULL;\nid\testRows\ttask\taccess object\toperator info\nStreamAgg_9\t1.00\troot\t\tfuncs:count(1)->Column#6\n└─HashJoin_19\t6.00\troot\t\tCARTESIAN inner join, other cond:or(eq(select_all.t1.b, select_all.t2.b), isnull(select_all.t2.b))\n  ├─TableReader_13(Build)\t2.00\troot\t\tdata:TableFullScan_12\n  │ └─TableFullScan_12\t2.00\tcop[tikv]\ttable:t2\tkeep order:false\n  └─TableReader_17(Probe)\t3.00\troot\t\tdata:TableFullScan_16\n    └─TableFullScan_16\t3.00\tcop[tikv]\ttable:t1\tkeep order:false\n\n"
tidb-server(PID: 2400) stopped
[Pipeline] }
Cache not saved (inner-step execution failed)
[Pipeline] // cache
[Pipeline] }
[Pipeline] // dir
Post stage
[Pipeline] junit
Recording test results
[Checks API] No suitable checks publisher found.
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
Failed in branch Matrix - PART = '4'
[Pipeline] // parallel
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // container
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] }
[Pipeline] // podTemplate
[Pipeline] End of Pipeline
ERROR: script returned exit code 1
Finished: FAILURE