Comments (2243)
CNLHC:
unknown error. maybe compile failed
from miniob.
xuhaoran1:
score:10, passed: basic, commit id=03aa15ca07a5f03c43d1527e10323c86bdcbe7e6, date=2021-11-17 17:15:10
from miniob.
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
from miniob.
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
from miniob.
view ligen131 aggregation-func
from miniob.
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
from miniob.
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
from miniob.
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
from miniob.
rehoboan:
all cases failed., commit id=c93656e14408546908855f9e736bef055547589e, date=2021-11-17 19:42:41
from miniob.
litterrookie:
score:40, passed: basic,update,select-meta,drop-table, commit id=27bb7a2b11e1dfe3d50b430734d5ae738309529f, date=2021-11-17 17:17:03
from miniob.
test cnissnzg
from miniob.
rehoboan:
all cases failed., commit id=c2a1e55f07806c4a4ceb310f9390a84273992a05, date=2021-11-17 19:52:31
from miniob.
test Super-long
from miniob.
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
from miniob.
xuhaoran1:
score:10, passed: basic, commit id=03aa15ca07a5f03c43d1527e10323c86bdcbe7e6, date=2021-11-17 17:15:10
from miniob.
FLAYhhh:
all cases failed., commit id=3d00d121697abfe475e3e8643b2720e00b20be14, date=2021-11-17 20:07:56
from miniob.
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
from miniob.
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
from miniob.
Super-long:
unknown error. maybe compile failed
from miniob.
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
from miniob.
Super-long:
unknown error. maybe compile failed
from miniob.
view FLAYhhh basic
from miniob.
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
from miniob.
Super-long:
score:10, passed: basic, commit id=e6a37dad37d5c0f137a07e70b1a5ae6cae93d8b4, date=2021-11-17 20:05:34
from miniob.
view Super-long join-tables
from miniob.
946776018xx5288:
unknown error. maybe compile failed
from miniob.
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
from miniob.
test ligen131
from miniob.
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
from miniob.
fkuner:
score:20, passed: text, commit id=8ce3dc295c01f5bb36e1f33c1c61e86725a48416, date=2021-11-17 19:59:22
from miniob.
zjx1230:
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=cd0f6e325c80e5c84b99dfe8fb65363322f5f53d, date=2021-11-17 20:45:55
from miniob.
view FLAYhhh null
from miniob.
Galaxy0106:
score:60, passed: basic,date,update,select-meta,select-tables,drop-table,insert,join-tables,null,unique,multi-index,expression,order-by,group-by, commit id=51763055b66c0f91cbb1195e9f1812b0b92f8c72, date=2021-11-17 20:57:15
from miniob.
fkuner:
score:170, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,simple-sub-query,text,group-by, commit id=8ce3dc295c01f5bb36e1f33c1c61e86725a48416, date=2021-11-17 19:59:22
from miniob.
view fkuner expression
from miniob.
zjx1230:
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=72b0f00c5b2fd8ef2a2dd6c4190a129f3044283e, date=2021-11-17 21:45:30
from miniob.
fkuner:
order-by: result file difference(`-` is yours and `+` is base)
SELECT * FROM T_ORDER_BY ORDER BY ID DESC, SCORE ASC, NAME DESC;
ID | SCORE | NAME
4 | 3 | C
3 | 1 | A
-3 | 2 | C
3 | 2 | F
+3 | 2 | C
3 | 3 | D
3 | 4 | C
1 | 2 | B
from miniob.
Galaxy0106:
aggregation-func: result file difference(`-` is yours and `+` is base)
SELECT AVG(PRICE) FROM AGGREGATION_FUNC;
AVG(PRICE)
-22
+22.5
from miniob.
FLAYhhh:
score:50, passed: update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,text,order-by, commit id=9a84c4a4a4908b50f50d987661eef6cdf7f074ab, date=2021-11-17 21:04:48
from miniob.
RUC-Seed-No-59:
all cases failed., commit id=68b485a89ab59b41526c92ef3d5d312ce6359fdb, date=2021-11-17 21:05:49
from miniob.
fkuner:
expression: result file difference(`-` is yours and `+` is base)
1. SELECT
SELECT * FROM EXP_TABLE WHERE 1 = 5/4;
+ID | COL1 | COL2 | COL3 | COL4
+select * from exp_table where col1-2 > 0;
+3 | 3 | 4 | 5 | 4
+ID | COL1 | COL2 | COL3 | COL4
+select * from exp_table where 2+col2 < 1;
+2 | 2 | -2 | 5.5 | 1
+ID | COL1 | COL2 | COL3 | COL4
+select * from exp_table where col1*col2 < 0;
+2 | 2 | -2 | 5.5 | 1
+ID | COL1 | COL2 | COL3 | COL4
from miniob.
FLAYhhh:
null: result file difference(`-` is yours and `+` is base)
SELECT * FROM NULL_TABLE WHERE 'A' IS NULL;
+ID | NUM | PRICE | BIRTHDAY
+SELECT * FROM null_table where 'a' is not 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 * FROM NULL_TABLE WHERE 'A' IS NOT NULL;
-ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE NULL='A';
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'=NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<NULL;
ID | NUM | PRICE | BIRTHDAY
from miniob.
test Galaxy0106 aggregation-func
from miniob.
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
from miniob.
FLAYhhh:
group-by: result file difference(`-` is yours and `+` is base)
4. WITH WHERE CONDITION
SELECT ID, AVG(SCORE) FROM T_GROUP_BY WHERE ID>2 GROUP BY ID;
+3 | 2.4
+4 | 3
+ID | AVG(SCORE)
from miniob.
wangqiim:
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=49b826fb67579779069f36ce7fc071708184c085, date=2021-11-17 20:10:22
from miniob.
xuhaoran1:
score:20, passed: basic,select-meta, commit id=fb921dafa18626feaeced44953835581adf27118, date=2021-11-17 20:52:25
from miniob.
ligen131:
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=9c35f77d49a52d9b58326b565f53340ed3a10632, date=2021-11-17 21:17:39
from miniob.
RUC-Seed-No-59:
all cases failed., commit id=149b9633e17a42580969c6a9a9da61900319fd40, date=2021-11-17 21:34:40
from miniob.
RUC-Seed-No-59:
select-tables: result file difference(`-` is yours and `+` is base)
INITIALIZATION
CREATE TABLE SELECT_TABLES_1(ID INT, AGE INT, U_NAME CHAR);
-FAILURE
+SUCCESS
CREATE TABLE SELECT_TABLES_2(ID INT, AGE INT, U_NAME CHAR);
-FAILURE
+SUCCESS
CREATE TABLE SELECT_TABLES_3(ID INT, RES INT, U_NAME CHAR);
-FAILURE
+SUCCESS
CREATE TABLE SELECT_TABLES_4(ID INT, AGE INT, U_NAME CHAR);
-FAILURE
+SUCCESS
CREATE TABLE SELECT_TABLES_5(ID INT, RES INT, U_NAME CHAR);
-FAILURE
+SUCCESS
from miniob.
DBChat-OB:
score:140, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=f7261262ef0ab3bb3cc643b963bc450a809c5439, date=2021-11-17 21:37:29
from miniob.
DBChat-OB:
null: result file difference(`-` is yours and `+` is base)
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
from miniob.
watchpoints:
text: result file difference(`-` is yours and `+` is base)
3. UPDATE
UPDATE TEXT_TABLE SET INFO='A TMP DATA' WHERE ID = 2;
-FAILURE
+SUCCESS
SELECT * FROM TEXT_TABLE;
-2 | THIS IS A VERY VERY LONG STRING2
+2 | A TMP DATA
3 | THIS IS A VERY VERY LONG STRING3
ID | INFO
from miniob.
FLAYhhh:
null: result file difference(`-` is yours and `+` is base)
SELECT * FROM NULL_TABLE WHERE 'A' IS NULL;
+ID | NUM | PRICE | BIRTHDAY
+SELECT * FROM null_table where 'a' is not 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 * FROM NULL_TABLE WHERE 'A' IS NOT NULL;
-ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE NULL='A';
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'=NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<NULL;
ID | NUM | PRICE | BIRTHDAY
from miniob.
view sohardforaname text
from miniob.
tanruixiang:
score:60, passed: basic,date,update,select-meta,select-tables,drop-table,join-tables,null,unique,order-by, commit id=8671323f608c767873a3cf52d7f3e1169bf6646a, date=2021-11-17 21:47:25
from miniob.
FLAYhhh:
null: result file difference(`-` is yours and `+` is base)
SELECT * FROM NULL_TABLE WHERE 'A' IS NULL;
+ID | NUM | PRICE | BIRTHDAY
+SELECT * FROM null_table where 'a' is not 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 * FROM NULL_TABLE WHERE 'A' IS NOT NULL;
-ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE NULL='A';
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'=NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'>NULL;
ID | NUM | PRICE | BIRTHDAY
SELECT * FROM NULL_TABLE WHERE 'A'<NULL;
ID | NUM | PRICE | BIRTHDAY
from miniob.
test shulanglhh select-meta
from miniob.
EmperorNiu:
all cases failed., commit id=4b9f5e822b58bfe4ddd21c776380a67fdbc7f482, date=2021-11-17 21:55:00
from miniob.
obcontest:
complex-sub-query: result file difference(`-` is yours and `+` is base)
1. SELECT
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));
-1
1 | 4 | 11.2
-2 | 2 | 12
-5
ID | COL1 | FEAT1
from miniob.
shulanglhh:
score:20, passed: basic,select-meta, commit id=bc63c9b2f85b59208f179e7c3c404f012fa66c38, date=2021-11-17 22:30:26
from miniob.
FLAYhhh:
all cases failed., commit id=70a3e70fd126189091ad4d9dcb6fcd2e1b7239c3, date=2021-11-17 22:34:50
from miniob.
test FLAYhhh null
from miniob.
ybzxw:
score:60, passed: basic,date,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,order-by,group-by, commit id=c3cc0e17bfb7920e13ab2442a63d4d55ccb4d6ee, date=2021-11-17 22:18:42
from miniob.
DBChat-OB:
score:140, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=f7261262ef0ab3bb3cc643b963bc450a809c5439, date=2021-11-17 21:37:29
from miniob.
DBChat-OB:
null: result file difference(`-` is yours and `+` is base)
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
from miniob.
TaurusGGBOY:
score:180, 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, commit id=f3b4781e364390d15faab4de6133ddb51398aba7, date=2021-11-17 22:59:26
from miniob.
ybzxw:
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
from miniob.
view RUC-Seed-No-59 date
from miniob.
RUC-Seed-No-59:
date: result file difference(`-` is yours and `+` is base)
INITIALIZATION
CREATE TABLE DATE_TABLE(ID INT, U_DATE DATE);
-FAILURE
+SUCCESS
CREATE INDEX INDEX_ID ON DATE_TABLE(U_DATE);
-FAILURE
+SUCCESS
from miniob.
RUC-Seed-No-59:
all cases failed., commit id=8edb051061834dbc63a07a8001b11714a082edf5, date=2021-11-17 22:50:51
from miniob.
RucHyy:
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';
+JOIN_TABLE_1.ID | JOIN_TABLE_1.NAME | JOIN_TABLE_2.ID | JOIN_TABLE_2.NUM
from miniob.
test wangqiim complex-sub-query
from miniob.
lsjy036:
score:40, passed: basic,update,select-meta,drop-table,insert, commit id=fb8afb4226cac1570727625aa84470ffb0ba4205, date=2021-11-17 23:17:33
from miniob.
lsjy036:
unique: result file difference(`-` is yours and `+` is base)
1. UNIQUE TEST
CREATE UNIQUE INDEX INDEX_ID ON UNIQUE_TABLE(ID);
SUCCESS
INSERT INTO UNIQUE_TABLE VALUES (2,1,1);
SUCCESS
CREATE UNIQUE INDEX INDEX_ID ON UNIQUE_TABLE(ID);
FAILURE
INSERT INTO UNIQUE_TABLE VALUES (3,2,1);
SUCCESS
INSERT INTO UNIQUE_TABLE VALUES (1,2,1);
-SUCCESS
+FAILURE
from miniob.
EmperorNiu:
all cases failed., commit id=1c4e32adf8c40644f8af6fdb9d5a9ca0bdcbe80b, date=2021-11-17 23:19:46
from miniob.
nihaoshijiea:
score:10, passed: basic, commit id=1f96f9bbd36de74b63ec33c136d67a97af7835c4, date=2021-11-17 21:55:33
from miniob.
EmperorNiu:
score:120, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,text,order-by, commit id=e4f2f5b5615b83d878641cb431d6421560b89d0e, date=2021-11-17 23:31:24
from miniob.
bbbearxyz:
score:60, passed: basic,date,update,select-meta,select-tables,drop-table,insert,join-tables,null,unique,multi-index,order-by, commit id=9df6fee6924b2cd5f37b1af2ecea3a0b8229fe9e, date=2021-11-18 00:10:53
from miniob.
test Coding-Hammer
from miniob.
bbbearxyz:
aggregation-func: result file difference(`-` is yours and `+` is base)
6. ERROR WITH REDUNDANT COLUMNS
SELECT COUNT(*,NUM) FROM AGGREGATION_FUNC;
-FAILED TO PARSE SQL: SELECT COUNT(*,NUM) FROM AGGREGATION_FUNC;, ERROR MSG: UNKNOWN ERROR
+FAILURE
SELECT MIN(NUM,PRICE) FROM AGGREGATION_FUNC;
FAILURE
SELECT MAX(NUM,PRICE) FROM AGGREGATION_FUNC;
FAILURE
SELECT AVG(NUM,PRICE) FROM AGGREGATION_FUNC;
FAILURE
from miniob.
bbbearxyz:
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;
1 | B | 2 | 10
-3 | A | 1 | 23.3333
-3 | C | 3 | 23.3333
-3 | D | 3 | 23.3333
-3 | F | 2 | 23.3333
+3 | A | 1 | 23.33
+3 | C | 3 | 23.33
+3 | D | 3 | 23.33
+3 | F | 2 | 23.33
4 | C | 3 | 20
-ID | NAME | AVG(SCORE) | AVG(AGE)
+T_GROUP_BY.ID | T_GROUP_BY.NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)
from miniob.
bbbearxyz:
group-b: result file difference(`-` is yours and `+` is base)
something error: diff: /test/dask/test-tmp/bbbearxyz/result/primary-group-b.result.tmp: No such file or directory
diff: /test/dask/miniob-test/result/primary-group-b.result: No such file or directory
from miniob.
coding01000:
all cases failed., commit id=a51415defb824b9fa3f8608ee9a22616ae26ea31, date=2021-11-18 00:39:58
from miniob.
bbbearxyz:
score:150, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,order-by, commit id=57a89fbdf964638b742bddddf07121f0da9e9fef, date=2021-11-18 00:29:47
from miniob.
xuhaoran1:
all cases failed., commit id=4cc08f8d0b5a6c2f4c5680e73af1753efe69001b, date=2021-11-18 00:26:40
from miniob.
bbbearxyz:
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;
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
-ID | NAME | AVG(SCORE) | AVG(AGE)
+T_GROUP_BY.ID | T_GROUP_BY.NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)
from miniob.
test coding01000 group-by
from miniob.
bbbearxyz:
score:150, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,order-by, commit id=0c9e43b8808b08606c7104b3ef635fb0433743f4, date=2021-11-18 00:42:33
from miniob.
bbbearxyz:
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;
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 | T_GROUP_BY.AVG(SCORE) | T_GROUP_BY_2.AVG(AGE)
+T_GROUP_BY.ID | T_GROUP_BY.NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)
from miniob.
Galaxy0106:
score:190, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,expression,order-by,group-by, commit id=87a5d88bc9de8b6105a565bd5699e8644bec40b9, date=2021-11-18 00:21:48
from miniob.
bbbearxyz:
score:150, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,order-by, commit id=42934203ab514e2df86f99aba41b951c7f54970b, date=2021-11-18 00:53:19
from miniob.
bbbearxyz:
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;
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
-ID | NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)
+T_GROUP_BY.ID | T_GROUP_BY.NAME | AVG(T_GROUP_BY.SCORE) | AVG(T_GROUP_BY_2.AGE)
from miniob.
Coding-Hammer:
score:20, passed: multi-index, commit id=fe221da6f8a756283244c2e4d8a08660cb4689ad, date=2021-11-18 11:35:06
from miniob.
bbbearxyz:
score:170, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique,multi-index,order-by,group-by, commit id=81d7f51fc5935d9ac9d691f824af442daa8f753c, date=2021-11-18 00:59:21
from miniob.
coding01000:
score:20, passed: group-by, commit id=bc63b9b73c1bcc4d6ce47c234f1479a129c2ef6a, date=2021-11-18 02:34:42
from miniob.
coding01000:
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;
-1 | 2 | B
-3 | 1 | A
-3 | 2 | C
-3 | 2 | F
-3 | 3 | D
-3 | 4 | C
-4 | 3 | C
-ID | SCORE | NAME
+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)
from miniob.
rainays:
complex-sub-query: result file difference(`-` is yours and `+` is base)
1. SELECT
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));
-FAILURE
+1 | 4 | 11.2
+ID | COL1 | FEAT1
from miniob.
coding01000:
score:140, passed: basic,date,update,select-meta,select-tables,aggregation-func,drop-table,join-tables,multi-index,order-by,group-by, commit id=d3500ddcb1d6554ce8a54c048cf96dc5d9e87388, date=2021-11-18 05:40:56
from miniob.
PaJir:
multi-index: result file difference(`-` is yours and `+` is base)
1 | 1 | 11.2 | A | 2021-01-02 | 1 | 1
ID | COL1 | COL2 | COL3 | COL4 | COL5 | COL6
SELECT * FROM MULTI_INDEX3 WHERE COL1 > 1 AND COL4 = '2021-01-02';
ID | COL1 | COL2 | COL3 | COL4 | COL5 | COL6
SELECT * FROM MULTI_INDEX3 WHERE COL1 <> 1 AND COL4 >= '2021-01-02';
4 | 2 | 12.2 | E | 2022-01-04 | 13 | 10
ID | COL1 | COL2 | COL3 | COL4 | COL5 | COL6
SELECT * FROM MULTI_INDEX3 WHERE COL2 < 15.0 AND COL4 <> '2021-01-02';
3 | 1 | 11.6 | H | 2023-01-02 | 10 | 17
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
from miniob.
Related Issues (20)
- 使用gcov统计单元测试覆盖率
- 将某些命令使用CmdExecutor方式实现
- 代码重构 HOT 1
- [BUG] github page 生成失败
- [BUG] unittest 执行失败
- 支持sysbench测试 HOT 1
- 配合最新的MVCC代码,合并持久化功能
- doxygen 文档支持
- [BUG] 第三方依赖必须放置在公共目录 HOT 1
- doxygen 文档优化
- [BUG] build relase failed HOT 1
- 使用ini替换jsoncpp HOT 1
- 需要发布最新版的docker镜像 HOT 4
- [enhancement] update Readme's link to oceanbase.github.io/miniob HOT 1
- 使用clang-tidy增强代码健壮性
- 优化readme
- [BUG] compile failed on gcc 12
- gcc/g++ 和 asan 使用静态链接库
- 记录管理部分的page_header_初始化的疑问 HOT 3
- build.sh init 增加flex和bison的安装 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from miniob.