search

oceanbase / miniob

MiniOB is a compact database that assists developers in understanding the fundamental workings of a database.
https://oceanbase.github.io/miniob/
Mulan Permissive Software License, Version 2
2.86k stars 1.01k forks source link

miniob-test #7

Closed hnwyllmm closed 2 years ago

hnwyllmm commented 2 years ago

大家找一块自己的地方，在一个comment里面，可以重复提交测试，每次comment变更，都可以检测到。 在一个时间段内，一个团队的任务提交，只会有一个任务执行。 使用方法：

# 执行测试
test <your-github-name> [case1] [case2] ...

# 查看失败原因
view <your-github-name> <case1> [case2] ...

FAQ:

LLThomas commented 2 years ago

LLThomas:

LLThomas commented 2 years ago

LLThomas: score:10, passed: select-meta,join-tables,simple-sub-query, commit id=0ec5dcf8d93a3f8b1d47cc641f1242f2055caa3e, date=2021-11-21 03:47:41

fkuner commented 2 years ago

fkuner: score:240, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,simple-sub-query,multi-index,text,expression,complex-sub-query,order-by,group-by, commit id=c297c635c5fc129841e0c2995d31d9c3f9f3b8cc, date=2021-11-19 15:39:15

fkuner commented 2 years ago

fkuner: score:180, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,simple-sub-query,text,order-by,group-by, commit id=7582854007bb1463d6d7ffb411ca064e36cc4d70, date=2021-11-18 15:28:01

lcmcstc commented 2 years ago

BanBuDu0: all cases failed., commit id=375ba93fdb3376b105b7fd75dc638b7f9c545686, date=2021-11-09 19:27:23

lcmcstc commented 2 years ago

BanBuDu0:

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

Paoluers: score:190, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,text,order-by,group-by, commit id=2420aa2acefd2c51001298783cec51482af7fa94, date=2021-11-20 01:57:17

wangzekun2020 commented 2 years ago

Paoluers:

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
b41sh commented 2 years ago

b41sh: score:200, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,simple-sub-query,multi-index,text,order-by,group-by, commit id=0dcaead92b23a1cd63de500eac698977da98b1f8, date=2021-11-21 00:15:52

wangzekun2020 commented 2 years ago

Paoluers:

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
wangzekun2020 commented 2 years ago

Paoluers:

multi-index: result file difference(`-` is yours and `+` is base)
the result file is same as the base result file
sunyuhan19981208 commented 2 years ago

tanruixiang:

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;
XuYi-fei commented 2 years ago

SleepyLGod: score:40, passed: basic,date,select-meta,drop-table, commit id=d5cb24f405dec520321b5219230d56ec1d2cc1d3, date=2021-11-09 09:28:34

ybzxw commented 2 years ago

ybzxw: score:20, passed: join-tables, commit id=315bede8210d1fc80830f3efdb2c112a0b7e74f6, date=2021-11-09 19:46:49

ybzxw commented 2 years ago

ybzxw: score:140, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,order-by,group-by, commit id=2c00039d57bcc00a448d6cc32d6008efebe906ef, date=2021-11-17 23:56:48

sohardforaname commented 2 years ago

sohardforaname: all cases failed., commit id=7acbab6da962c53942e593308356aa7060784729, date=2021-11-09 17:48:54

sohardforaname commented 2 years ago

sohardforaname: all cases failed., commit id=7acbab6da962c53942e593308356aa7060784729, date=2021-11-09 17:48:54

Ichasethesun commented 2 years ago

Ichasethesun: score:170, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,text,order-by,group-by, commit id=b68fbe626794843874b82715264e5660995a7af4, date=2021-11-09 19:54:15

xishuaidelin commented 2 years ago

dongzeyu: all cases failed., commit id=3a854bcb3f0e02d2976ace92d563abf811503adf, date=2021-11-09 19:55:06

sunyuhan19981208 commented 2 years ago

tanruixiang:

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;
lcmcstc commented 2 years ago

BanBuDu0: score:10, passed: date, commit id=375ba93fdb3376b105b7fd75dc638b7f9c545686, date=2021-11-09 19:27:23

ybzxw commented 2 years ago

ybzxw: score:20, passed: join-tables, commit id=2dd8f533a10137daeda1891b1b5dce1f55645f8c, date=2021-11-09 20:06:41

ybzxw commented 2 years ago

ybzxw: score:120, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by, commit id=2dd8f533a10137daeda1891b1b5dce1f55645f8c, date=2021-11-09 20:06:41

geekpandaman commented 2 years ago

TaurusGGBOY:

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
jacklightChen commented 2 years ago

DATA-IS-POWER:

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;
946776018xx5288 commented 2 years ago

946776018xx5288: score:10, passed: select-tables, commit id=41c855652b14bc7bde1d064ff3812eb4edb6848b, date=2021-11-17 20:50:43

lcmcstc commented 2 years ago

BanBuDu0: all cases failed., commit id=ca7d99395ca28b0d2e4c52bd53bb060b53aa93de, date=2021-11-09 20:13:26

lcmcstc commented 2 years ago

BanBuDu0:

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

946776018xx5288: all cases failed., commit id=5da57d688fb6a2d16e8eec3343b7d0138ed724a6, date=2021-11-06 18:26:03

946776018xx5288 commented 2 years ago

946776018xx5288:

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
fkuner commented 2 years ago

fkuner: score:20, passed: group-by, commit id=95bee08564201fc4158385d1b81f36b23a7dc5b9, date=2021-11-18 09:12:40

linweiwei commented 2 years ago

linweiwei: score:10, passed: select-tables, commit id=bd3f1c9f5c70621d28c37b7d1b2ae823cfa57fa3, date=2021-11-09 17:03:36

geekpandaman commented 2 years ago

TaurusGGBOY:

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
fkuner commented 2 years ago

test fkuner group-by

fkuner commented 2 years ago

fkuner:

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)
hustwp123 commented 2 years ago

shameless3: score:60, passed: basic,date,update,select-meta,aggregation-func,drop-table, commit id=f357832d5f7031962ce19514cb8a34f5ac385277, date=2021-11-09 20:31:14

FLAYhhh commented 2 years ago

FLAYhhh: score:50, passed: basic,date,update,select-meta,drop-table, commit id=63061c186b856653042f6d9dd14ed811dca8c844, date=2021-11-07 17:27:30

FLAYhhh commented 2 years ago

test FLAYhhh

lcmcstc commented 2 years ago

BanBuDu0: all cases failed., commit id=3a79ca1c424fe71812e1958fecd0d0fa4a42c96f, date=2021-11-09 20:44:50

lcmcstc commented 2 years ago

BanBuDu0:

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
fishjohn commented 2 years ago

yangzecai: score:150, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,order-by,group-by, commit id=09c654726bfae37802bf5e75518713f463a9e81d, date=2021-11-09 20:46:31

geekpandaman commented 2 years ago

TaurusGGBOY: all cases failed., commit id=2f609ab256f36c7fc9858f38754af9986dc1aeab, date=2021-11-09 21:25:10

fishjohn commented 2 years ago

yangzecai:

multi-index: result file difference(`-` is yours and `+` is base)
the result file is same as the base result file
FLAYhhh commented 2 years ago

FLAYhhh: unknown error. maybe compile failed

FLAYhhh commented 2 years ago

FLAYhhh: score:50, passed: basic,date,update,select-meta,drop-table, commit id=9eb070c2ab50f2bd8bf4caa67531833f8dad98e9, date=2021-11-09 20:31:51

fishjohn commented 2 years ago

yangzecai: all cases failed., commit id=09c654726bfae37802bf5e75518713f463a9e81d, date=2021-11-09 20:46:31

fishjohn commented 2 years ago

yangzecai:

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
FLAYhhh commented 2 years ago

FLAYhhh:

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
FLAYhhh commented 2 years ago

FLAYhhh:

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
yqekzb123 commented 2 years ago

RUC-Seed-No-59:

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