miniob-test #7
Comments
|
current task(s): [], task(s) in queue: [] |
|
xuhaoran1: |
|
hulu22: |
|
472455687: |
|
BanBuDu0: |
|
Sunday361: |
|
nautaa: |
|
zhengbumingbai: |
|
dongzeyu: |
|
Leozki: |
|
yunwei37: 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
|
|
NKU-EmbededSystem: |
|
DBChat-OB: |
|
yunwei37: |
|
RichardoMrMu: |
|
Godroser: |
|
xiw5: |
|
MingqiangZhao: |
|
lmjhh: |
|
NKU-EmbeddedSystem: 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
|
|
rainays: 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
|
|
TaurusGGBOY: |
|
DBChat-OB: |
|
rainays: 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
|
|
JINGE-ui: |
|
JINGE-ui: |
|
rainays: 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
|
|
JINGE-ui: |
|
DBChat-OB: 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
|
|
BanBuDu0: |
|
b41sh: |
|
BrianYi: |
|
LanSaber: complex-sub-query: result file difference(`-` is yours and `+` is base)
2. SELECT WITH EMPTY TABLE
SELECT * FROM CSQ_1 WHERE ID IN (SELECT CSQ_2.ID FROM CSQ_2 WHERE CSQ_2.ID IN (SELECT CSQ_3.ID FROM CSQ_3 WHERE 1=0));
ID | COL1 | FEAT1
SELECT * FROM CSQ_1 WHERE ID IN (SELECT CSQ_2.ID FROM CSQ_2 WHERE CSQ_2.ID IN (SELECT CSQ_3.ID FROM CSQ_3 WHERE 1=0) AND 1=0);
+ID | COL1 | FEAT1
+select * from csq_1 where col1 not in (select csq_2.col2 from csq_2 where csq_2.id not in (select csq_3.id from csq_3 where 1=0));
+1 | 4 | 11.2
+ID | COL1 | FEAT1
+select * from csq_1 where col1 not in (select csq_2.col2 from csq_2 where csq_2.id not in (select csq_3.id from csq_3) and 1=0);
+1 | 4 | 11.2
+2 | 2 | 12
+3 | 3 | 13.5
+ID | COL1 | FEAT1
+select * from csq_3 where feat3 < (select max(csq_2.feat2) from csq_2 where csq_2.id not in (select csq_3.id from csq_3 where 1=0));
+1 | 2 | 11
+ID | COL3 | FEAT3
+select * from csq_3 where feat3 < (select max(csq_2.feat2) from csq_2 where csq_2.id not in (select csq_3.id from csq_3 ) and 1=0);
+ID | COL3 | FEAT3
|
|
zyf2000: multi-index: result file difference(`-` is yours and `+` is base)
CREATE INDEX I_4_I7 ON MULTI_INDEX4(ID,COL7);
-SUCCESS
+FAILURE
CREATE INDEX I_4_78 ON MULTI_INDEX4(COL7,COL8);
-SUCCESS
+FAILURE
CREATE INDEX I_4_I78 ON MULTI_INDEX4(ID,COL7,COL8);
-SUCCESS
+FAILURE
|
|
freetmf: |
|
zyf2000: multi-index: result file difference(`-` is yours and `+` is base)
1. MULTI INDEX OF EMPTY TABLE
CREATE TABLE MULTI_INDEX(ID INT, COL1 INT, COL2 FLOAT, COL3 CHAR, COL4 DATE, COL5 INT, COL6 INT);
SUCCESS
CREATE INDEX I_1_12 ON MULTI_INDEX(COL1,COL2);
-FAILURE
+SUCCESS
CREATE INDEX I_1_345 ON MULTI_INDEX(COL3, COL4, COL5);
-FAILURE
+SUCCESS
CREATE INDEX I_1_56 ON MULTI_INDEX(COL5, COL6);
-FAILURE
+SUCCESS
CREATE INDEX I_1_456 ON MULTI_INDEX(COL4, COL5, COL6);
-FAILURE
+SUCCESS
SELECT * FROM MULTI_INDEX;
ID | COL1 | COL2 | COL3 | COL4 | COL5 | COL6
|
|
b41sh: |
|
litterrookie: |
1 similar comment
|
litterrookie: |
|
litterrookie: |
|
litterrookie: update: result file difference(`-` is yours and `+` is base)
6. UPDATE NON-EXISTENT TABLE
UPDATE UPDATE_TABLE_2 SET T_NAME='N01' WHERE ID=1;
+FAILURE
|
|
wangqiim: |
|
WangWangTeamInOceanbaseCompetition: |
|
WangWangTeamInOceanbaseCompetition: |
|
litterrookie: |
|
shyuZzz: |
|
litterrookie: |
|
litterrookie: |
|
httdty: |
|
zyf2000: |
|
XuhXie: |
|
RucOBTeamGo: |
|
zyf2000: |
|
litterrookie: update: result file difference(`-` is yours and `+` is base)
8. UPDATE WITH INVALID CONDITION
UPDATE UPDATE_TABLE_1 SET T_NAME='N01' WHERE ID_FALSE=1;
-SUCCESS
+FAILURE
|
|
shyuZzz: |
|
JINGE-ui: |
and others
大家找一块自己的地方，在一个comment里面，可以重复提交测试，每次comment变更，都可以检测到。
在一个时间段内，一个团队的任务提交，只会有一个任务执行。
使用方法：
FAQ:
查看失败原因长时间没有返回结果
如果返回的数据中包含二进制字符，即不是纯文本文件，那么执行结果无法反馈到github中，目前无法看到结果。
每个case的名称可以看这个链接
https://oceanbase-partner.github.io/lectures-on-dbms-implementation/miniob-topics
basic测试的名称就叫 basic
The text was updated successfully, but these errors were encountered: