miniob-test2

[hnwyllmm]

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

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

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

FAQ:

• 查看失败原因长时间没有返回结果
  如果返回的数据中包含二进制字符，即不是纯文本文件，那么执行结果无法反馈到github中，目前无法看到结果。

• 每个case的名称可以看这个链接
  https://oceanbase-partner.github.io/lectures-on-dbms-implementation/miniob-topics
  basic测试的名称就叫 basic

[hnwyllmm]

CNLHC:
unknown error. maybe compile failed

[hnwyllmm]

xuhaoran1:
score:10, passed: basic, commit id=03aa15ca07a5f03c43d1527e10323c86bdcbe7e6, date=2021-11-17 17:15:10

[BanBuDu0]

BanBuDu0:
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=ed7e6849e4f6a51f1325c9e0236924f352799198, date=2021-11-16 15:10:53

[cnissnzg]

cnissnzg:
score:110, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique,order-by, commit id=c4450c873ef6ac988981353f7bc0ce4996ca9e5d, date=2021-11-16 22:14:36

[ligen131]

view ligen131 aggregation-func

[cnissnzg]

cnissnzg:
score:110, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique,order-by, commit id=1c106ebd4902d4d483b3bb08bbf95ab056c64ea8, date=2021-11-17 19:22:29

[SmileEndymion]

CRRRRR2016:
score:120, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by, commit id=bfd777fb9079cf04ff348a8840560ae3921d6ca8, date=2021-11-17 20:16:42

[ligen131]

ligen131:
score:180, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,multi-index,text,order-by,group-by, commit id=2fda7a1995e2888bac29ba7ef6c2fea8f83f47b7, date=2021-11-17 19:40:11

[rehoboan]

rehoboan:
all cases failed., commit id=c93656e14408546908855f9e736bef055547589e, date=2021-11-17 19:42:41

[litterrookie]

litterrookie:
score:40, passed: basic,update,select-meta,drop-table, commit id=27bb7a2b11e1dfe3d50b430734d5ae738309529f, date=2021-11-17 17:17:03

[cnissnzg]

test cnissnzg

[rehoboan]

rehoboan:
all cases failed., commit id=c2a1e55f07806c4a4ceb310f9390a84273992a05, date=2021-11-17 19:52:31

[adlternative]

test Super-long

[cnissnzg]

cnissnzg:
score:110, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique,order-by, commit id=9e00dd6094308b245e9fbf58731a85285168efda, date=2021-11-17 19:49:38

[xuhaoran1]

xuhaoran1:
score:10, passed: basic, commit id=03aa15ca07a5f03c43d1527e10323c86bdcbe7e6, date=2021-11-17 17:15:10

[FLAYhhh]

FLAYhhh:
all cases failed., commit id=3d00d121697abfe475e3e8643b2720e00b20be14, date=2021-11-17 20:07:56

[xuhaoran1]

xuhaoran1:

select-meta: result file difference(`-` is yours and `+` is base)
 1. SELECT FROM A NON-EXISTENT TABLE
 SELECT * FROM NO_TABLE;
-NO DATA
+FAILURE

[FLAYhhh]

FLAYhhh:
score:50, passed: update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,text,order-by, commit id=3d00d121697abfe475e3e8643b2720e00b20be14, date=2021-11-17 20:07:56

[adlternative]

Super-long:
unknown error. maybe compile failed

[JacksonWang6]

WangAShao:
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=e25c8f4c24c10c487271f4f7b295803db74aa31c, date=2021-11-17 20:30:02

[adlternative]

Super-long:
unknown error. maybe compile failed

[FLAYhhh]

view FLAYhhh basic

[FLAYhhh]

FLAYhhh:

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

[adlternative]

Super-long:
score:10, passed: basic, commit id=e6a37dad37d5c0f137a07e70b1a5ae6cae93d8b4, date=2021-11-17 20:05:34

[adlternative]

view Super-long join-tables

[xin258]

946776018xx5288:
unknown error. maybe compile failed

[xin258]

946776018xx5288:
score:140, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=41c855652b14bc7bde1d064ff3812eb4edb6848b, date=2021-11-17 20:50:43

[ligen131]

test ligen131

[cnissnzg]

cnissnzg:
score:130, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique,multi-index,order-by, commit id=3c984dfc5abb9e39e8a9a2f3488db57e1df4bca3, date=2021-11-17 20:51:02

[BaiMoHan]

sohardforaname:
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=0b5552d9cc5d7ebf9d32030f453c26686754cf29, date=2021-11-21 12:35:18

[LNLT]

view LiyeeW order-by

[LNLT]

test LiyeeW

[LiyeeW]

LiyeeW:
score:100, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,order-by,group-by, commit id=fef0350e149f4e6f2414a71b8a72b6a627f73f2a, date=2021-12-07 09:51:35