OceanBase 大赛测试结果（增量） -2021/10/28 下午2

宁封 · 2021 年10 月 28 日 19:32

HNUDLG : all cases failed, commit id=3d708f7178cb8501434c3148410b79f94828da35, date=2021-10-28 15:22:12

Mikan-Team : passed basic, commit id=f147b0de2c2ec76ebbd88258dcdbe2d31fc64efd, date=2021-10-28 16:11:50

obcontest : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,join-tables,unique, commit id=5b7b6d8b51dea6cc5bd4743fcb7f0a72ffe626ef, date=2021-10-28 15:18:09

zhengbumingbai : passed basic,date,update,select-meta,aggregation-func,drop-table,insert,unique, commit id=e3bc338e0303d4cc11dd9724fa9c235e4b82c232, date=2021-10-28 17:28:41

watchpoints : passed basic,update,select-meta,drop-table, commit id=133b12feed7bbbccb1bef2a657bfea1c6fe8e263, date=2021-10-28 15:29:08

EmperorNiu : passed basic,select-meta,drop-table, commit id=1ca46497446f1c9c97685de038fa030a48c4b76b, date=2021-10-28 17:29:01

PaJir : passed basic,date,select-meta,drop-table, commit id=d553a968f4b9d44c44942b04b5afc4694de4df2b, date=2021-10-28 18:23:03

CaiyuhangC : passed basic, commit id=233fd89b47a3d0413b0e22887027edb472cd0e62, date=2021-10-28 17:16:54

RUC-Seed-No-59 : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=229e8c3f7fbd3c8c05713e62fa22e1d4eccfbe0d, date=2021-10-28 19:06:27

Ethanzjp : passed basic,update, commit id=513292a862a4ffa6e8c1f93f724c21991d237ae2, date=2021-10-28 17:39:51

rainays : passed basic,date,update,select-meta,drop-table,unique, commit id=015fa5f5987fd69b5c8ef05dbaddda8e774fb8b4, date=2021-10-28 15:25:37

agoodjuice : passed basic,date,update,select-meta,drop-table,insert, commit id=e3d32a57aebd3fd00c5ca8e7efb3523426382ae6, date=2021-10-28 17:36:04

S-1-T : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique, commit id=cd60c181a07337b9671a64d8d69791a80b456c32, date=2021-10-28 17:23:45

WangAShao : passed basic,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null, commit id=e72980740fe052edcb7fdb0b196bf591c7206725, date=2021-10-28 18:13:38

obmustac : passed basic,select-meta,drop-table, commit id=cae727eedec4b9283ba6f5a32fa0e3c7eb18126f, date=2021-10-28 18:12:56

DUXUCHONG : passed basic,date,update,select-meta,drop-table, commit id=50e95dc349428c27afa44c02132ff7050bf9e9d2, date=2021-10-28 17:36:01

Xylitol415 : passed basic,select-meta,drop-table, commit id=65524d3a171c14caab3795d9690d58afdac69df9, date=2021-10-28 18:56:24

J0kerMh : passed basic,date,update,select-meta,drop-table, commit id=0db73a7368f21b66628053bd298c4f73590ba0d6, date=2021-10-28 15:25:06

XorSum : all cases failed, commit id=f80edc15be36ef87825d11a74d0d9a6fb96b87cd, date=2021-10-28 16:40:40

b41sh : passed basic,update,select-meta,drop-table, commit id=71e17a1fa35b3909d93221fcc323c776c64c3271, date=2021-10-28 18:23:20

LLThomas : passed basic,date,update,select-meta,drop-table,insert, commit id=93ca93985439ed858d11460694283186d93cea11, date=2021-10-28 16:39:09

mikan-team : passed basic, commit id=f147b0de2c2ec76ebbd88258dcdbe2d31fc64efd, date=2021-10-28 16:11:50

Moonm3n : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=b13c70c1c9b955594eee2ea1e03ea9091e15d087, date=2021-10-28 17:17:09

DeepZheng : passed basic,update,select-meta,drop-table, commit id=43de04b014080112e7c9718433ea04a635b7b7c6, date=2021-10-28 18:46:41

ifIAmADJ : passed basic, commit id=b313aa3c47049cc849f652e34eb1c59d0e53219a, date=2021-10-28 15:05:31

caizj : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=8c2118f2ce6f71f32c02c9322313985aabb3a0d5, date=2021-10-28 15:07:49

Whorra : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=3f1d85d32619cdfcb3d46d6c086da94e14623d90, date=2021-10-28 15:47:34

tanruixiang : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=8e1117a0fc60578c78731b874e93e421ef806e74, date=2021-10-28 17:49:43

HumbleHunger : passed basic, commit id=825818223201a5ef544d4a062d1e9d1592d92553, date=2021-10-28 17:13:30

idvzchusvol : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,unique, commit id=3b875e0eedb78335161fbc2a6193ffc550c3ca18, date=2021-10-28 16:47:54

DATA-IS-POWER : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=9e19a141791859e299227a25652842e1aede3b5c, date=2021-10-28 16:44:48

Kaimary : passed basic,select-meta,drop-table, commit id=65b97fe095998917c73b7be80589acf4e806ccf6, date=2021-10-28 16:04:07

jaingmengmeng : passed basic,date,update,select-meta,select-tables,drop-table,join-tables, commit id=89033e74ec37c0940d4557a24bf76e52daf3008a, date=2021-10-28 17:22:47

宁封 · 2021 年10 月 28 日 19:32

JayL-zxl 0 lex.yy.c:657:5: 错误：未知的类型名‘YYSTYPE’\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/parser/lex.yy.c.o] 错误 1\nmake[2]: 正在等待未完成的任务....\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/sql/executor/tuple.cpp:85:6: 错误：no declaration matches ‘void TupleSchema::addifnotexists(AttrType, const char, const char, bool, AggreType)’\nvoid TupleSchema::addifnotexists(AttrType type, const char tablename, const char fieldname, bool isaggre, AggreType aggretype) {\n^\nIn file included from /test/dask/test-tmp/JayL-zxl/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/./sql/executor/tuple.h:106:8: 附注：备选是： ‘void TupleSchema::addifnotexists(AttrType, const char, const char)’\nvoid addifnotexists(AttrType type, const char tablename, const char fieldname);\n^\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/./sql/executor/tuple.h:100:7: 附注：‘class TupleSchema’ defined here\nclass TupleSchema {\n^\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/tuple.cpp.o] 错误 1\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] 错误 2\nmake[1]: 正在等待未完成的任务....\nlex.yy.c:657:5: 错误：未知的类型名‘YYSTYPE’\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/parser/lex.yy.c.o] 错误 1\nmake[2]: 正在等待未完成的任务....\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/sql/executor/tuple.cpp:85:6: 错误：no declaration matches ‘void TupleSchema::addifnotexists(AttrType, const char, const char, bool, AggreType)’\nvoid TupleSchema::addifnotexists(AttrType type, const char tablename, const char fieldname, bool isaggre, AggreType aggretype) {\n^\nIn file included from /test/dask/test-tmp/JayL-zxl/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/./sql/executor/tuple.h:106:8: 附注：备选是： ‘void TupleSchema::addifnotexists(AttrType, const char, const char)’\nvoid addifnotexists(AttrType type, const char tablename, const char field_name);\n^\n/test/dask/test-tmp/JayL-zxl/miniob/src/observer/./sql/executor/tuple.h:100:7: 附注：‘class TupleSchema’ defined here\nclass TupleSchema {\n^~~~~\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.cpp.o] 错误 1\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] 错误 2\nmake: [all] 错误 2

宁封 · 2021 年10 月 28 日 19:33

Ichasethesun 0 /test/dask/test-tmp/Ichasethesun/miniob/src/observer/sql/parser/parsestage.cpp: 在成员函数‘common::StageEvent ParseStage::handlerequest(common::StageEvent)’中:\n/test/dask/test-tmp/Ichasethesun/miniob/src/observer/sql/parser/parsestage.cpp:128:1: 错误：version control conflict marker in file\n<<<<<<< HEAD\n^\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/parser/parsestage.cpp.o] 错误 1\nmake[2]: 正在等待未完成的任务....\n/test/dask/test-tmp/Ichasethesun/miniob/src/observer/sql/parser/parsestage.cpp: 在成员函数‘common::StageEvent ParseStage::handlerequest(common::StageEvent)’中:\n/test/dask/test-tmp/Ichasethesun/miniob/src/observer/sql/parser/parsestage.cpp:128:1: 错误：version control conflict marker in file\n<<<<<<< HEAD\n^~~~~\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/parser/parsestage.cpp.o] 错误 1\nmake[2]: 正在等待未完成的任务....\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] 错误 2\nmake[1]: 正在等待未完成的任务....\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] 错误 2\nmake: [all] 错误 2\n

宁封 · 2021 年10 月 28 日 19:33

dongzeyu 0 In file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.h:21,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/init.cpp:32:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/init.cpp.o] 错误 1\nmake[2]: 正在等待未完成的任务....\nIn file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.h:21,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.cpp:18:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^\nIn file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.h:21,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.cpp:18:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^\nIn file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.h:21,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/init.cpp:32:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/executestage.cpp.o] 错误 1\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] 错误 2\nmake[1]: 正在等待未完成的任务....\nIn file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/executionnode.h:21,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executionnode.cpp:15:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/executestage.cpp.o] 错误 1\nmake[2]: 正在等待未完成的任务....\nmake[2]: [src/observer/CMakeFiles/observer.dir/init.cpp.o] 错误 1\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/executionnode.cpp.o] 错误 1\nIn file included from /test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/tuple.h:26,\nfrom /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/tuple.cpp:16:\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:132:8: 错误：‘bool FloatValue::isnull() const’ cannot be overloaded with ‘bool FloatValue::isnull() const’\nbool isnull() const override\n^\n/test/dask/test-tmp/dongzeyu/miniob/src/observer/./sql/executor/value.h:128:8: 附注：previous declaration ‘bool FloatValue::isnull() const’\nbool isnull() const override {\n^~~~~\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.cpp.o] 错误 1\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] 错误 2\nmake: [all] 错误 2\n

宁封 · 2021 年10 月 28 日 19:33

My-OB-contest

死循环

149	  vector<Frame*> getFlushFrames(int file_desc) {
150	    vector<Frame*> vf;
151	    Node* cur = head;
152	    while(cur!= nullptr){
153	      if(cur->frame->file_desc == file_desc){
154	        vf.push_back(cur->frame);
155	        Node *node = cur;
156	        cur = cur->next;
157	        delNode(node);
(gdb)
158	        allocated_size--;
159	      }
160	    }
161	    return vf;
162	  }
163
164	  RC moveToHead(Node* node){
165	    if(node == head){
166	      return RC::SUCCESS;
167	    }

yjt233 · 2021 年10 月 28 日 19:36

老师, 想问下penggan666/miniob (github.com)多表查询的错误, 以及想问下多表查询结果顺序有特别要求吗, 以及下面第一条sql这种是否需要去重?

郑小配 · 2021 年10 月 28 日 19:36

https://github.com/DeepZheng/OceanBase2021 想问一下 date 挂在哪里了呀

hukaikai · 2021 年10 月 28 日 19:38

能问一下聚合函数和多表查询哪里错了吗？昨天聚合函数还是对的，合了多表的分支就错了

DUXUCHONG/miniob (github.com)

小潘同学 · 2021 年10 月 28 日 19:39

https://github.com/tanruixiang/MiniOB 请问聚合函数挂在了什么用例上面，另外表头输出有规范吗

sunflower · 2021 年10 月 28 日 19:44

https://github.com/ifIAmADJ/obminer，老师可以测试一下meta-select 哪里不通过吗？

宁封 · 2021 年10 月 28 日 19:51

顺序没有要求，也不要去重。

SELECT SELECTTABLES2.AGE FROM SELECTTABLES1,SELECTTABLES2 WHERE SELECTTABLES1.AGE<18 AND SELECTTABLES2.UNAME='C' AND SELECTTABLES1.ID=SELECTTABLES_2.ID;

这个已经测试通过了？

宁封 · 2021 年10 月 28 日 19:52

SELECT * FROM DATETABLE WHERE UDATE>'2020-1-20';

这个语句返回少了一行数据。

1 | 2020-01-21

SELECT * FROM DATETABLE WHERE UDATE='2020-1-1';

返回没有查出来数据

宁封 · 2021 年10 月 28 日 19:53

SELECT MIN(NUM),MAX(NUM),AVG(NUM) FROM AGGREGATION_FUNC;

没有返回结果

咻咻xx · 2021 年10 月 28 日 19:54

老师我们drop为什么没通过

https://github.com/Ethanzjp/miniob-contest

宁封 · 2021 年10 月 28 日 19:55

COUNT

SELECT COUNT(*) FROM AGGREGATION_FUNC;

COUNT --> count(*)

4

SELECT COUNT(NUM) FROM AGGREGATION_FUNC;

COUNT --> COUNT(num)

4

MIN

SELECT MIN(NUM) FROM AGGREGATION_FUNC;

NUM --> MIN(NUM)

12

输出都不区分大小写的，无所谓。但是仅仅输出一部分就不行了。

hukaikai · 2021 年10 月 28 日 19:55

多表哪里错了呢？

宁封 · 2021 年10 月 28 日 19:55

SELECT * FROM NO_TABLE;

FAILUR

少了一个 'E'

郑小配 · 2021 年10 月 28 日 19:55

好的，谢谢老师

宁封 · 2021 年10 月 28 日 19:56

SELECT * FROM DROPTABLE6;

NO DATA

不存在的表，要返回 FAILURE

kamiyo · 2021 年10 月 28 日 19:57

谢谢老师～我们不小心merge错分支了，刚才回滚了merge。可能你那还需要再清理下环境。之前我们回滚后出现过你那拉测试代码异常的问题

My-OB-contest

https://github.com/My-OB-contest/miniOB