miniob-test about miniob HOT 2499 CLOSED

update: result file difference(`-` is yours and `+` is base)
 1. UPDATE A ROW
 UPDATE UPDATE_TABLE_1 SET T_NAME='N01' WHERE ID=1;
-FAILURE
+SUCCESS
 SELECT * FROM UPDATE_TABLE_1;
-1 | N1 | 1 | 1
+1 | N01 | 1 | 1
 2 | N2 | 1 | 1
 3 | N3 | 2 | 1
 ID | T_NAME | COL1 | COL2

null: result file difference(`-` is yours and `+` is base)
 2. SELECT
 SELECT * FROM NULL_TABLE;
-1 | 18 | 0 | NULL
-2 | NULL | 0 | NULL
-3 | 12 | 0 | NULL
-4 | 15 | 0 | NULL
+1 | 18 | 10 | 2020-01-01
+2 | NULL | 20 | 2010-01-11
+3 | 12 | 30 | NULL
+4 | 15 | 30 | 2021-01-31
 ID | NUM | PRICE | BIRTHDAY

select-tables: result file difference(`-` is yours and `+` is base)
 4. JOIN EMPTY TABLE
 CREATE TABLE SELECT_TABLES_6(ID INT, RES INT);
 SUCCESS
 SELECT SELECT_TABLES_1.ID,SELECT_TABLES_6.ID FROM SELECT_TABLES_1, SELECT_TABLES_6 WHERE SELECT_TABLES_1.ID=SELECT_TABLES_6.ID;
+SELECT_TABLES_1.ID | SELECT_TABLES_6.ID

date: result file difference(`-` is yours and `+` is base)
 2. COMPARE DATE DATA
 SELECT * FROM DATE_TABLE WHERE U_DATE>'2020-1-20';
 1 | 2020-01-21
 2 | 2020-10-21
 9 | 2038-01-19
 ID | U_DATE
 SELECT * FROM DATE_TABLE WHERE U_DATE<'2019-12-31';
+5 | 2019-12-21
+6 | 2016-02-29
+7 | 1970-01-01
+8 | 2000-01-01
 ID | U_DATE
 SELECT * FROM DATE_TABLE WHERE U_DATE='2020-1-1';
+3 | 2020-01-01
+4 | 2020-01-01
 ID | U_DATE

expression: result file difference(`-` is yours and `+` is base)
 1. SELECT
 SELECT * FROM EXP_TABLE WHERE 1 = 5/4;
-FAILURE
+ID | COL1 | COL2 | COL3 | COL4
 SELECT * FROM EXP_TABLE WHERE COL1-2 > 0;
-FAILURE
+3 | 3 | 4 | 5 | 4
+ID | COL1 | COL2 | COL3 | COL4
 SELECT * FROM EXP_TABLE WHERE 2+COL2 < 1;
-FAILURE
+2 | 2 | -2 | 5.5 | 1
+ID | COL1 | COL2 | COL3 | COL4
 SELECT * FROM EXP_TABLE WHERE COL1*COL2 < 0;
-FAILURE
+2 | 2 | -2 | 5.5 | 1
+ID | COL1 | COL2 | COL3 | COL4

order-by: result file difference(`-` is yours and `+` is base)
 3. PRIMARY ORDER BY
 SELECT * FROM T_ORDER_BY ORDER BY ID;
-FAILURE
+1 | 2 | B
+3 | 1 | A
+3 | 2 | C
+3 | 2 | F
+3 | 3 | D
+3 | 4 | C
+4 | 3 | C
+ID | SCORE | NAME

select-tables: result file difference(`-` is yours and `+` is base)
 1 | 18 | A | 1 | 20 | A | 1 | 35 | A
 1 | 18 | A | 1 | 20 | A | 2 | 37 | A
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3 WHERE SELECT_TABLES_1.ID=SELECT_TABLES_2.ID AND SELECT_TABLES_3.RES=35;
 1 | 18 | A | 1 | 20 | A | 1 | 35 | A
 2 | 15 | B | 2 | 21 | C | 1 | 35 | A
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3 WHERE SELECT_TABLES_1.AGE<18 AND SELECT_TABLES_2.U_NAME='C' AND SELECT_TABLES_3.RES=35 AND SELECT_TABLES_1.ID=SELECT_TABLES_2.ID AND SELECT_TABLES_2.ID=SELECT_TABLES_3.ID;
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT SELECT_TABLES_2.AGE FROM SELECT_TABLES_1,SELECT_TABLES_2 WHERE SELECT_TABLES_1.AGE<18 AND SELECT_TABLES_2.U_NAME='C' AND SELECT_TABLES_1.ID=SELECT_TABLES_2.ID;
+21
 SELECT_TABLES_2.AGE

join-tables: result file difference(`-` is yours and `+` is base)
 JOIN_TABLE_2.NUM
 SELECT * FROM JOIN_TABLE_1 INNER JOIN JOIN_TABLE_2 ON JOIN_TABLE_1.ID=JOIN_TABLE_2.ID INNER JOIN JOIN_TABLE_3 ON JOIN_TABLE_1.ID=JOIN_TABLE_3.ID;
 1 | A | 1 | 2 | 1 | 120
 JOIN_TABLE_1.ID | JOIN_TABLE_1.NAME | JOIN_TABLE_2.ID | JOIN_TABLE_2.NUM | JOIN_TABLE_3.ID | JOIN_TABLE_3.NUM2
 SELECT * FROM JOIN_TABLE_1 INNER JOIN JOIN_TABLE_2 ON JOIN_TABLE_1.ID=JOIN_TABLE_2.ID AND JOIN_TABLE_2.NUM>13 WHERE JOIN_TABLE_1.NAME='B';
 2 | B | 2 | 15
 JOIN_TABLE_1.ID | JOIN_TABLE_1.NAME | JOIN_TABLE_2.ID | JOIN_TABLE_2.NUM
 SELECT * FROM JOIN_TABLE_1 INNER JOIN JOIN_TABLE_2 ON JOIN_TABLE_1.ID=JOIN_TABLE_2.ID AND JOIN_TABLE_2.NUM>13 WHERE JOIN_TABLE_1.NAME='A';
 JOIN_TABLE_1.ID | JOIN_TABLE_1.NAME | JOIN_TABLE_2.ID | JOIN_TABLE_2.NUM
 SELECT * FROM JOIN_TABLE_1 INNER JOIN JOIN_TABLE_2 ON JOIN_TABLE_1.ID=JOIN_TABLE_2.ID AND JOIN_TABLE_2.NUM>23 WHERE JOIN_TABLE_1.NAME='B';
-2 | B | 1 | 2
-2 | B | 2 | 15
 JOIN_TABLE_1.ID | JOIN_TABLE_1.NAME | JOIN_TABLE_2.ID | JOIN_TABLE_2.NUM

join-tables: result file difference(`-` is yours and `+` is base)
 SELECT * FROM JOIN_TABLE_LARGE_1 INNER JOIN JOIN_TABLE_LARGE_2 ON JOIN_TABLE_LARGE_1.ID=JOIN_TABLE_LARGE_2.ID INNER JOIN JOIN_TABLE_LARGE_3 ON JOIN_TABLE_LARGE_1.ID=JOIN_TABLE_LARGE_3.ID INNER JOIN JOIN_TABLE_LARGE_4 ON JOIN_TABLE_LARGE_3.ID=JOIN_TABLE_LARGE_4.ID INNER JOIN JOIN_TABLE_LARGE_5 ON 1=1 INNER JOIN JOIN_TABLE_LARGE_6 ON JOIN_TABLE_LARGE_5.ID=JOIN_TABLE_LARGE_6.ID WHERE JOIN_TABLE_LARGE_3.NUM3 <10 AND JOIN_TABLE_LARGE_5.NUM5>90;
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 | 100 | 100 | 100
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 91 | 91 | 91 | 91
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 92 | 92 | 92 | 92
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 93 | 93 | 93 | 93
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 94 | 94 | 94 | 94
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 95 | 95 | 95 | 95
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 96 | 96 | 96 | 96
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 97 | 97 | 97 | 97
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 98 | 98 | 98 | 98
+1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 99 | 99 | 99 | 99
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 100 | 100 | 100 | 100
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 91 | 91 | 91 | 91
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 92 | 92 | 92 | 92
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 93 | 93 | 93 | 93
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 94 | 94 | 94 | 94
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 95 | 95 | 95 | 95
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 96 | 96 | 96 | 96
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 97 | 97 | 97 | 97
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 98 | 98 | 98 | 98
+2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 99 | 99 | 99 | 99
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 100 | 100 | 100 | 100
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 91 | 91 | 91 | 91
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 92 | 92 | 92 | 92
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 93 | 93 | 93 | 93
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 94 | 94 | 94 | 94
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 95 | 95 | 95 | 95
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 96 | 96 | 96 | 96
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 97 | 97 | 97 | 97
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 98 | 98 | 98 | 98
+3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 99 | 99 | 99 | 99
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 100 | 100 | 100 | 100
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 91 | 91 | 91 | 91
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 92 | 92 | 92 | 92
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 93 | 93 | 93 | 93
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 94 | 94 | 94 | 94
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 95 | 95 | 95 | 95
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 96 | 96 | 96 | 96
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 97 | 97 | 97 | 97
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 98 | 98 | 98 | 98
+4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 99 | 99 | 99 | 99
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 100 | 100 | 100 | 100
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 91 | 91 | 91 | 91
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 92 | 92 | 92 | 92
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 93 | 93 | 93 | 93
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 94 | 94 | 94 | 94
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 95 | 95 | 95 | 95
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 96 | 96 | 96 | 96
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 97 | 97 | 97 | 97
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 98 | 98 | 98 | 98
+5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 99 | 99 | 99 | 99
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 100 | 100 | 100 | 100
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 91 | 91 | 91 | 91
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 92 | 92 | 92 | 92
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 93 | 93 | 93 | 93
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 94 | 94 | 94 | 94
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 95 | 95 | 95 | 95
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 96 | 96 | 96 | 96
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 97 | 97 | 97 | 97
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 98 | 98 | 98 | 98
+6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 99 | 99 | 99 | 99
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 100 | 100 | 100 | 100
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 91 | 91 | 91 | 91
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 92 | 92 | 92 | 92
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 93 | 93 | 93 | 93
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 94 | 94 | 94 | 94
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 95 | 95 | 95 | 95
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 96 | 96 | 96 | 96
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 97 | 97 | 97 | 97
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 98 | 98 | 98 | 98
+7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 99 | 99 | 99 | 99
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 100 | 100 | 100 | 100
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 91 | 91 | 91 | 91
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 92 | 92 | 92 | 92
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 93 | 93 | 93 | 93
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 94 | 94 | 94 | 94
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 95 | 95 | 95 | 95
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 96 | 96 | 96 | 96
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 97 | 97 | 97 | 97
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 98 | 98 | 98 | 98
+8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 99 | 99 | 99 | 99
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 100 | 100 | 100 | 100
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 91 | 91 | 91 | 91
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 92 | 92 | 92 | 92
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 93 | 93 | 93 | 93
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 94 | 94 | 94 | 94
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 95 | 95 | 95 | 95
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 96 | 96 | 96 | 96
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 97 | 97 | 97 | 97
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 98 | 98 | 98 | 98
+9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 99 | 99 | 99 | 99
+JOIN_TABLE_LARGE_1.ID | JOIN_TABLE_LARGE_1.NUM1 | JOIN_TABLE_LARGE_2.ID | JOIN_TABLE_LARGE_2.NUM2 | JOIN_TABLE_LARGE_3.ID | JOIN_TABLE_LARGE_3.NUM3 | JOIN_TABLE_LARGE_4.ID | JOIN_TABLE_LARGE_4.NUM4 | JOIN_TABLE_LARGE_5.ID | JOIN_TABLE_LARGE_5.NUM5 | JOIN_TABLE_LARGE_6.ID | JOIN_TABLE_LARGE_6.NUM6

select-tables: result file difference(`-` is yours and `+` is base)
 1. MULTI-TABLE QUERY
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
-1 | 35 | A | 1 | 20 | A | 1 | 18 | A
-1 | 35 | A | 1 | 20 | A | 2 | 15 | B
-1 | 35 | A | 2 | 21 | C | 1 | 18 | A
-1 | 35 | A | 2 | 21 | C | 2 | 15 | B
-2 | 37 | A | 1 | 20 | A | 1 | 18 | A
-2 | 37 | A | 1 | 20 | A | 2 | 15 | B
-2 | 37 | A | 2 | 21 | C | 1 | 18 | A
-2 | 37 | A | 2 | 21 | C | 2 | 15 | B
-SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME
+1 | 18 | A | 1 | 20 | A | 1 | 35 | A
+1 | 18 | A | 1 | 20 | A | 2 | 37 | A
+1 | 18 | A | 2 | 21 | C | 1 | 35 | A
+1 | 18 | A | 2 | 21 | C | 2 | 37 | A
+2 | 15 | B | 1 | 20 | A | 1 | 35 | A
+2 | 15 | B | 1 | 20 | A | 2 | 37 | A
+2 | 15 | B | 2 | 21 | C | 1 | 35 | A
+2 | 15 | B | 2 | 21 | C | 2 | 37 | A
+SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT SELECT_TABLES_1.ID,SELECT_TABLES_2.U_NAME,SELECT_TABLES_3.RES FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
-35 | A | 1
-35 | A | 2
-35 | C | 1
-35 | C | 2
-37 | A | 1
-37 | A | 2
-37 | C | 1
-37 | C | 2
-SELECT_TABLES_3.RES | SELECT_TABLES_2.U_NAME | SELECT_TABLES_1.ID
+1 | A | 35
+1 | A | 37
+1 | C | 35
+1 | C | 37
+2 | A | 35
+2 | A | 37
+2 | C | 35
+2 | C | 37
+SELECT_TABLES_1.ID | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.RES
 SELECT SELECT_TABLES_1.RES FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
 FAILURE

date: result file difference(`-` is yours and `+` is base)
 2. COMPARE DATE DATA
 SELECT * FROM DATE_TABLE WHERE U_DATE>'2020-1-20';
-FAILURE
+1 | 2020-01-21
+2 | 2020-10-21
+9 | 2038-01-19
+ID | U_DATE
 SELECT * FROM DATE_TABLE WHERE U_DATE<'2019-12-31';
-FAILURE
+5 | 2019-12-21
+6 | 2016-02-29
+7 | 1970-01-01
+8 | 2000-01-01
+ID | U_DATE
 SELECT * FROM DATE_TABLE WHERE U_DATE='2020-1-1';
-FAILURE
+3 | 2020-01-01
+4 | 2020-01-01
+ID | U_DATE

aggregation-func: result file difference(`-` is yours and `+` is base)
 1. COUNT
 SELECT COUNT(*) FROM AGGREGATION_FUNC;
+COUNT(*)
+4

expression: result file difference(`-` is yours and `+` is base)
 SELECT ID,-(COL2*(-1)+1)+(COL4+2)*(COL1+COL3*2),(4+COL2)*COL3/2 FROM EXP_TABLE WHERE -(COL2*(-1)+1)+(COL4+2)*(COL1+COL3*2) > (4+COL2)*COL3/2;
+1 | 10.5 | 2.5
+2 | 36 | 5.5
+3 | 81 | 20
+ID | -(COL2*(-1)+1)+(COL4+2)*(COL1+COL3*2) | (4+COL2)*COL3/2
+select id,col1,col2,col3,col4,6-(col2*(1+col1))+(col4+2)/(1+col1*4+col3*2) from exp_table where 6-(col2*(1+col1))+(col4+2)/(1+col1*4+col3*2) > 5;
+2 | 2 | -2 | 5.5 | 1 | 12.15
+ID | COL1 | COL2 | COL3 | COL4 | 6-(COL2*(1+COL1))+(COL4+2)/(1+COL1*4+COL3*2)
+select id,col1,col2,col3,col4,3*col1/(col2+2) from exp_table where 3*col1/(col2+2) > 1;
+3 | 3 | 4 | 5 | 4 | 1.5
+ID | COL1 | COL2 | COL3 | COL4 | 3*COL1/(COL2+2)
+select id,3*col1/(col2+2) from exp_table where 3*col1/(col2+2)+1/0 > 1;
+ID | 3*COL1/(COL2+2)
+select * from exp_table where 1/0 = 1/0;
+ID | COL1 | COL2 | COL3 | COL4

null: result file difference(`-` is yours and `+` is base)
 SELECT * FROM NULL_TABLE WHERE NUM IS NOT NULL;
+1 | 18 | 10 | 2020-01-01
+3 | 12 | 30 | NULL
+4 | 15 | 30 | 2021-01-31
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM IS NULL;
+2 | NULL | 20 | 2010-01-11
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM = NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NULL = NUM;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM <> NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM > NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM < NULL;
-FAILURE
+ID | NUM | PRICE | BIRTHDAY

multi-index: result file difference(`-` is yours and `+` is base)
the result file is same as the base result file

null: result file difference(`-` is yours and `+` is base)
 SELECT * FROM NULL_TABLE WHERE NUM IS NOT NULL;
+1 | 18 | 10 | 2020-01-01
+3 | 12 | 30 | NULL
+4 | 15 | 30 | 2021-01-31
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM IS NULL;
+2 | NULL | 20 | 2010-01-11
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM = NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NULL = NUM;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM <> NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM > NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM < NULL;

null: result file difference(`-` is yours and `+` is base)
 SELECT * FROM NULL_TABLE WHERE NUM IS NOT NULL;
+1 | 18 | 10 | 2020-01-01
+3 | 12 | 30 | NULL
+4 | 15 | 30 | 2021-01-31
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM IS NULL;
+2 | NULL | 20 | 2010-01-11
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM = NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NULL = NUM;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM <> NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM > NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM < NULL;

null,complex-sub-query: result file difference(`-` is yours and `+` is base)
something error: diff: /test/dask/test-tmp/TaurusGGBOY/result/primary-null,complex-sub-query.result.tmp: No such file or directory
diff: /test/dask/miniob-test/result/primary-null,complex-sub-query.result: No such file or directory

null: result file difference(`-` is yours and `+` is base)
 SELECT * FROM NULL_TABLE WHERE NUM IS NOT NULL;
+1 | 18 | 10 | 2020-01-01
+3 | 12 | 30 | NULL
+4 | 15 | 30 | 2021-01-31
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM IS NULL;
+2 | NULL | 20 | 2010-01-11
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM = NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NULL = NUM;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM <> NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM > NULL;
 ID | NUM | PRICE | BIRTHDAY
 SELECT * FROM NULL_TABLE WHERE NUM < NULL;

aggregation-func: result file difference(`-` is yours and `+` is base)
 SELECT AVG(PRICE) FROM AGGREGATION_FUNC;
 AVG(PRICE)
-2.77873E+07
+22.5

select-tables: result file difference(`-` is yours and `+` is base)
 1. MULTI-TABLE QUERY
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
-1 | 35 | A | 1 | 20 | A | 1 | 18 | A
-1 | 35 | A | 1 | 20 | A | 2 | 15 | B
-1 | 35 | A | 2 | 21 | C | 1 | 18 | A
-1 | 35 | A | 2 | 21 | C | 2 | 15 | B
-2 | 37 | A | 1 | 20 | A | 1 | 18 | A
-2 | 37 | A | 1 | 20 | A | 2 | 15 | B
-2 | 37 | A | 2 | 21 | C | 1 | 18 | A
-2 | 37 | A | 2 | 21 | C | 2 | 15 | B
-SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME
+1 | 18 | A | 1 | 20 | A | 1 | 35 | A
+1 | 18 | A | 1 | 20 | A | 2 | 37 | A
+1 | 18 | A | 2 | 21 | C | 1 | 35 | A
+1 | 18 | A | 2 | 21 | C | 2 | 37 | A
+2 | 15 | B | 1 | 20 | A | 1 | 35 | A
+2 | 15 | B | 1 | 20 | A | 2 | 37 | A
+2 | 15 | B | 2 | 21 | C | 1 | 35 | A
+2 | 15 | B | 2 | 21 | C | 2 | 37 | A
+SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT SELECT_TABLES_1.ID,SELECT_TABLES_2.U_NAME,SELECT_TABLES_3.RES FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
-35 | A | 1
-35 | A | 2
-35 | C | 1
-35 | C | 2
-37 | A | 1
-37 | A | 2
-37 | C | 1
-37 | C | 2
-SELECT_TABLES_3.RES | SELECT_TABLES_2.U_NAME | SELECT_TABLES_1.ID
+1 | A | 35
+1 | A | 37
+1 | C | 35
+1 | C | 37
+2 | A | 35
+2 | A | 37
+2 | C | 35
+2 | C | 37
+SELECT_TABLES_1.ID | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.RES
 SELECT SELECT_TABLES_1.RES FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3;
 FAILURE

complex-sub-query: result file difference(`-` is yours and `+` is base)
 SELECT * FROM CSQ_1 WHERE FEAT1 <> (SELECT AVG(CSQ_2.FEAT2) FROM CSQ_2 WHERE CSQ_2.FEAT2 > CSQ_1.FEAT1);
 1 | 4 | 11.2
 2 | 2 | 12
-3 | 3 | 13.5
 ID | COL1 | FEAT1

group-by: result file difference(`-` is yours and `+` is base)
 5. MULTI TABLE
 SELECT T_GROUP_BY.ID, T_GROUP_BY.NAME, AVG(T_GROUP_BY.SCORE), AVG(T_GROUP_BY_2.AGE) FROM T_GROUP_BY, T_GROUP_BY_2 WHERE T_GROUP_BY.ID=T_GROUP_BY_2.ID GROUP BY T_GROUP_BY.ID, T_GROUP_BY.NAME;
-FAILURE
+1 | B | 2 | 10
+3 | A | 1 | 23.33
+3 | C | 3 | 23.33
+3 | D | 3 | 23.33
+3 | F | 2 | 23.33
+4 | C | 3 | 20
+T_GROUP_BY.ID | T_GROUP_BY.NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)

aggregation-func: result file difference(`-` is yours and `+` is base)
 8. ERROR WITH NON-EXISTENT COLUMNS
 SELECT COUNT(ID2) FROM AGGREGATION_FUNC;
-COUNT(ID2)
-4
+FAILURE
 SELECT MIN(ID2) FROM AGGREGATION_FUNC;
 FAILURE
 SELECT MAX(ID2) FROM AGGREGATION_FUNC;
 FAILURE
 SELECT AVG(ID2) FROM AGGREGATION_FUNC;
 FAILURE

multi-index: result file difference(`-` is yours and `+` is base)
the result file is same as the base result file

multi-index: result file difference(`-` is yours and `+` is base)
 DELETE FROM MULTI_INDEX3 WHERE ID = 4 AND COL1 = 1;
-FAILURE
+SUCCESS
 DELETE FROM MULTI_INDEX3 WHERE ID = 90 AND COL1 = 13;
 SUCCESS
 DELETE FROM MULTI_INDEX3 WHERE ID = 90 AND COL1 = 1;
 SUCCESS
 DELETE FROM MULTI_INDEX3 WHERE ID = 4 AND COL1 = 13;
-FAILURE
+SUCCESS
 DELETE FROM MULTI_INDEX3 WHERE ID = 3 AND COL1 = 1;
 SUCCESS
 DELETE FROM MULTI_INDEX3 WHERE ID = 3 AND COL1 = 1;
-FAILURE
+SUCCESS
 SELECT * FROM MULTI_INDEX3;
 4 | 2 | 12.2 | E | 2022-01-04 | 13 | 10
 5 | 3 | 14.2 | D | 2020-04-02 | 12 | 2
 ID | COL1 | COL2 | COL3 | COL4 | COL5 | COL6

select-table: result file difference(`-` is yours and `+` is base)
something error: diff: /test/dask/test-tmp/FLAYhhh/result/primary-select-table.result.tmp: No such file or directory
diff: /test/dask/miniob-test/result/primary-select-table.result: No such file or directory

select-tables: result file difference(`-` is yours and `+` is base)
 1 | 18 | A | 1 | 20 | A | 2 | 37 | A
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3 WHERE SELECT_TABLES_1.ID=SELECT_TABLES_2.ID AND SELECT_TABLES_3.RES=35;
 1 | 18 | A | 1 | 20 | A | 1 | 35 | A
 2 | 15 | B | 2 | 21 | C | 1 | 35 | A
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT * FROM SELECT_TABLES_1,SELECT_TABLES_2,SELECT_TABLES_3 WHERE SELECT_TABLES_1.AGE<18 AND SELECT_TABLES_2.U_NAME='C' AND SELECT_TABLES_3.RES=35 AND SELECT_TABLES_1.ID=SELECT_TABLES_2.ID AND SELECT_TABLES_2.ID=SELECT_TABLES_3.ID;
 SELECT_TABLES_1.ID | SELECT_TABLES_1.AGE | SELECT_TABLES_1.U_NAME | SELECT_TABLES_2.ID | SELECT_TABLES_2.AGE | SELECT_TABLES_2.U_NAME | SELECT_TABLES_3.ID | SELECT_TABLES_3.RES | SELECT_TABLES_3.U_NAME
 SELECT SELECT_TABLES_2.AGE FROM SELECT_TABLES_1,SELECT_TABLES_2 WHERE SELECT_TABLES_1.AGE<18 AND SELECT_TABLES_2.U_NAME='C' AND SELECT_TABLES_1.ID=SELECT_TABLES_2.ID;
 21
-AGE
+SELECT_TABLES_2.AGE

text: result file difference(`-` is yours and `+` is base)
 1. INSERT
 INSERT INTO TEXT_TABLE VALUES (1,'THIS IS A VERY VERY LONG STRING');
+SUCCESS
+insert into text_table values (2,'this is a very very long string2');
+SUCCESS
+insert into text_table values (3,'this is a very very long string3');
+SUCCESS
+select * from text_table;
+1 | THIS IS A VERY VERY LONG STRING
+2 | THIS IS A VERY VERY LONG STRING2
+3 | THIS IS A VERY VERY LONG STRING3
+ID | INFO