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

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

UPDATE UPDATETABLE1 SET TNAME='N01' WHERE IDFALSE=1;

更新不存在的字段，没有返回结果。

CHECK THE ACCURACY OF DROPPING TABLE

CREATE TABLE DROPTABLE3(ID INT, T_NAME CHAR);

SUCCESS

INSERT INTO DROPTABLE3 VALUES (1,'OB');

SUCCESS

SELECT * FROM DROPTABLE3;

1 | OB

ID | T_NAME

DROP TABLE DROPTABLE3;

SUCCESS

INSERT INTO DROPTABLE3 VALUES (1,'OB');

FAILURE

SELECT * FROM DROPTABLE3;

FAILURE

DELETE FROM DROPTABLE3 WHERE ID = 3;

FAILURE

CREATE TABLE DROPTABLE3(ID INT, T_NAME CHAR);

FAILURE

SELECT * FROM DROPTABLE3;

FAILURE

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

SELECT ID, AGE, NAME, SCORE FROM T_BASIC;

返回了FAILURE

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

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

ID | U_DATE

SELECT * FROM DATETABLE WHERE UDATE<'2019-12-31';

FAILURE

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

ID | U_DATE

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

我不能确定

宁封 · 2021 年10 月 28 日 16:57

CREATE INDEX I212 ON MULTI_INDEX2(COL1,COL2);

FAILURE

DylanNiu · 2021 年10 月 28 日 16:58

老师您好，下午似乎没有我们组的结果，我们是编译又出问题了吗。https://github.com/EmperorNiu/miniob

shihy · 2021 年10 月 28 日 16:58

谢谢！

咻咻xx · 2021 年10 月 28 日 16:58

老师能帮我看看drop table和update吗

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

宁封 · 2021 年10 月 28 日 16:59

SELECT AVG(NUM) FROM AGGREGATION_FUNC;

AVG(NUM)

60

结果不对啊，是不是没有除以行数？

kamiyo · 2021 年10 月 28 日 16:59

不可能啊老师，这个case我们本地跑很多遍了都没问题，而且各种表组合也都试过

miniob > SELECT * FROM stu1 INNER JOIN stu2 ON stu1.id=stu2.id;

stu1.id | stu1.old | stu2.id | stu2.name

1 | 20 | 1 | aaa

2 | 19 | 2 | bbb

3 | 22 | 3 | ccc

4 | 21 | 4 | ddd

宁封 · 2021 年10 月 28 日 17:00

SELECT * FROM SELECTTABLES1,SELECTTABLES2,SELECTTABLES3 WHERE SELECTTABLES1.AGE<18 AND SELECTTABLES2.UNAME='C' AND SELECTTABLES3.RES=35 AND SELECTTABLES1.ID=SELECTTABLES2.ID AND SELECTTABLES2.ID=SELECTTABLES_3.ID;

多表查询的错误语句。

多列索引的错误

SELECT * FROM MULTI_INDEX3 WHERE COL2 < 15 AND COL4 <> '2021-01-02';

宁封 · 2021 年10 月 28 日 17:01

DeepZheng 0 CMake Error at CMakeLists.txt:70 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "deps" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:71 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "src" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:72 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "unitest" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:73 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "test" which is not an existing directory.\n\n\n

宁封 · 2021 年10 月 28 日 17:02

[ 22%] Built target common

[ 45%] Built target common_static

[ 46%] Built target obclient

Consolidate compiler generated dependencies of target observer

[ 46%] Building CXX object src/observer/CMakeFiles/observer.dir/storage/common/table.cpp.o

/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp: 在成员函数‘RC Table::change_record(const char, const Value, Record*)’中:

/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: 错误：‘strcmp’不是‘std’的成员

if (std::strcmp(field->name(),attribute) == 0){

^~

/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: 附注：建议的替代：

In file included from /test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:16:

/usr/include/string.h:140:12: 附注： ‘strcmp’

extern int strcmp (const char _s1, const char *s2)

xishuai · 2021 年10 月 28 日 17:05

请问老师这次能正常显示了吗或者还有更多的信息吗我们用提交的代码本地测了这个语句也显示没有问题QAQ

laosanchen · 2021 年10 月 28 日 17:08

麻烦看一下zhengbumingbai的聚合错哪了，刚刚没回

宁封 · 2021 年10 月 28 日 17:09

CHECK THE ACCURACY OF DROPPING TABLE

CREATE TABLE DROPTABLE3(ID INT, T_NAME CHAR);

SUCCESS

INSERT INTO DROPTABLE3 VALUES (1,'OB');

SUCCESS

SELECT * FROM DROPTABLE3;

1 | OB

ID | T_NAME

DROP TABLE DROPTABLE3;

SUCCESS

INSERT INTO DROPTABLE3 VALUES (1,'OB');

FAILURE

SELECT * FROM DROPTABLE3;

NO DATA

DELETE FROM DROPTABLE3 WHERE ID = 3;

FAILURE

CREATE TABLE DROPTABLE3(ID INT, T_NAME CHAR);

SUCCESS

SELECT * FROM DROPTABLE3;

1 | OB

ID | T_NAME

宁封 · 2021 年10 月 28 日 17:10

UPDATE WITH INVALID VALUE

UPDATE UPDATETABLE1 SET COL1='N01' WHERE ID=1;

SUCCESS

宁封 · 2021 年10 月 28 日 17:14

#0 0x00007ffff66a23d7 in raise () from /lib64/libc.so.6

#1 0x00007ffff66a3ac8 in abort () from /lib64/libc.so.6

#2 0x00007ffff66e4f67 in __libc_message () from /lib64/libc.so.6

#3 0x00007ffff66eeb36 in intmalloc () from /lib64/libc.so.6

#4 0x00007ffff66f178c in malloc () from /lib64/libc.so.6

#5 0x00007ffff6fe6518 in operator new (sz=25) at ../../.././libstdc++-v3/libsupc++/new_op.cc:50

#6 0x000000000040c56f in std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >::_M_construct<char const*> (

this=this@entry=0x7fffe6ff95c0, beg=beg@entry=0x7fffd0004ee0 "JOINTABLE1JOINTABLE2", __end=<optimized out>)

at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/char_traits.h:350

#7 0x000000000041c3d5 in Mconstructaux<char const*> (end=<optimized out>, beg=0x7fffd0004ee0 "JOINTABLE1JOINTABLE_2", this=0x7fffe6ff95c0)

at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/char_traits.h:322

#8 Mconstruct<char const*> (end=<optimized out>, beg=0x7fffd0004ee0 "JOINTABLE1JOINTABLE2", this=0x7fffe6ff95c0)

at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_string.h:255

#9 basicstring (a=..., s=0x7fffd0004ee0 "JOINTABLE1JOINTABLE_2", this=0x7fffe6ff95c0)

at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_string.h:516

#10 JoinExeNode::init(Trx, _Condition const, int, char const, char const*, int) ()

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/executor/execution_node.cpp:99

#11 0x00000000004179c1 in ExecuteStage::do_select(char const, Query, SessionEvent*) ()

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/executor/execute_stage.cpp:528

#12 0x0000000000418c06 in ExecuteStage::handlerequest(common::StageEvent*) () at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/./event/sqlevent.h:33

#13 0x00000000004193b5 in ExecuteStage::handle_event (this=0x68fb90, event=0x7fffd0004180)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/executor/execute_stage.cpp:100

#14 0x0000000000424cdb in OptimizeStage::handle_event (this=0x68ff80, event=0x7fffd0004180)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/optimizer/optimize_stage.cpp:80

#15 0x0000000000428a94 in ParseStage::handle_event(common::StageEvent*) ()

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/parser/parse_stage.cpp:98

#16 0x000000000042bcfb in PlanCacheStage::handle_event (this=0x690b10, event=0x7fffd0003f40)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/plancache/plancache_stage.cpp:92

#17 0x000000000042ca6b in QueryCacheStage::handle_event (this=0x690ec0, event=0x7fffd0003f40)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/querycache/querycache_stage.cpp:91

#18 0x00000000004291bb in ResolveStage::handle_event (this=0x690720, event=0x7fffd0003f40)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/sql/parser/resolve_stage.cpp:83

#19 0x0000000000413fea in SessionStage::handle_request(common::StageEvent*) ()

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/session/session_stage.cpp:164

#20 0x0000000000414525 in SessionStage::handle_event (this=0x68f880, event=0x694b60)

at /test/dask/test-tmp/My-OB-contest/miniob/src/observer/session/session_stage.cpp:99

#21 0x00007ffff7bc3a66 in common::Threadpool::runthread (poolptr=0x68e780) at /test/dask/test-tmp/My-OB-contest/miniob/deps/common/seda/thread_pool.cpp:289

#22 0x00007ffff7972ea5 in start_thread () from /lib64/libpthread.so.0

宁封 · 2021 年10 月 28 日 17:15

是执行到这里的时候，coredump了。

宁封 · 2021 年10 月 28 日 17:16

扫帖子时间晚已经回复了。