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

宁封 · 2021 年10 月 27 日 18:07

Galaxy0106 : passed basic,select-meta,drop-table, commit id=9cbe620c06819d308bf14f125b8c01624ddb7bb8, date=2021-10-27 14:52:12
JayL-zxl : passed basic,update,select-meta,drop-table, commit id=b5aa15ca1d51248513cfcc03e2118f9d3ce79d5d, date=2021-10-27 17:05:27
tssunjingwu : passed basic,date,update,select-meta,drop-table, commit id=70bc2749a0a074dea21bacfc34c2dca744217982, date=2021-10-27 16:51:20
zhengbumingbai : passed basic,date,update,select-meta,drop-table,insert,unique, commit id=b4b39b72fe2f32ba9009b264d2fd6b783bb50d1e, date=2021-10-27 17:24:45
HUST-DDDD : passed select-meta, commit id=5cf8fd44b69e0ae6f97d8e99158f49010c875935, date=2021-10-27 16:04:00
zhoulaiqing : passed basic,date,update,select-meta,select-tables,drop-table, commit id=32a5009ad5c6311babfe425711d71bb5e4cd435e, date=2021-10-27 16:58:59
agoodjuice : passed basic,date,update,select-meta,drop-table,insert, commit id=0ee8f56e3c10de7d9dea74d0d6e8208d5116f7e9, date=2021-10-27 16:07:45
TaurusGGBOY : passed basic,update,select-meta,aggregation-func,drop-table,unique,order-by, commit id=348cfd3108d366aac785665e1a84978d36af32f1, date=2021-10-27 14:29:27
obcontest : passed basic,date,update,select-meta,aggregation-func,drop-table,unique, commit id=ed6df9b412015484544676e3570086d0f18c9608, date=2021-10-27 16:02:45
pppy2012 : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=cbee9afcd651c9eba12bde42fd0f6b835967f9e6, date=2021-10-27 17:01:28
caizj : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique, commit id=3abc43b18e26d8cecd24dcc433046ffd2882a9c8, date=2021-10-27 17:09:37
Xylitol415 : passed basic,select-meta,drop-table, commit id=89499c1818a59f89f7b1b3f07a657408e8d9181f, date=2021-10-27 16:22:53
123liuziming : passed select-meta, commit id=d0b53be215b67fb0497e0494498f37c52815c97c, date=2021-10-27 15:52:34
5d1207 : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=be36c574a169685686f4a822f5d634b3c9ac945f, date=2021-10-27 15:59:45
NickSkyyy : passed basic,date,select-meta,drop-table, commit id=28bf50c821f26a9b940dad45428f41f73531e666, date=2021-10-27 15:17:57
WangAShao : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique, commit id=4f3ed2e4df7fda5e627d2e0b4730bb514f59444c, date=2021-10-27 15:27:39
idvzchusvol : passed basic,date,select-meta,select-tables,aggregation-func,drop-table,unique, commit id=36432f5164b3625a8f5f85ecf8a0e852aa3e6aba, date=2021-10-27 14:57:33
My-OB-contest : passed date,update,select-meta,drop-table, commit id=7ce4ad525cb45fef16cb71361203da820dec19f6, date=2021-10-27 14:48:15
obmustac : passed basic,select-meta,drop-table, commit id=e188b89331cdaa3c7c45339359f4edbb9f755ab8, date=2021-10-27 16:28:39
lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,unique,order-by,group-by, commit id=abe5b41fc0b765bbea0ab844a83af3d8c00e197b, date=2021-10-27 17:36:14
I-m-so-sorry-for-come-to-ZJU : passed basic,select-meta,drop-table, commit id=8dc7e4f389912e5e2a9c0126dc7b6e38e5eea007, date=2021-10-27 14:46:30
wraymo : passed basic,select-meta,drop-table, commit id=98f798e9ea30c1239a36c9bc2437b05c0d097d4f, date=2021-10-27 14:05:57
18703486960 : passed basic,select-meta,drop-table, commit id=a546a28da05ba17a1b6f3cdb33c3e1114bc3519e, date=2021-10-27 17:08:24
Whorra : passed basic,update,select-meta,select-tables,drop-table, commit id=76aa289feeaf4fb1841fe703df20e03024653b76, date=2021-10-27 14:03:52
Paoluers : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=8328eff0cb5664434622fd52d7a02d2447edb1b4, date=2021-10-27 14:49:49
dongzeyu : passed select-meta, commit id=ecfd06bbce2573399d89917a667a40339a30e889, date=2021-10-27 17:33:52
coding01000 : passed basic,select-meta,drop-table, commit id=6a01e9ce4c7d82702b9126225e63599e3c552583, date=2021-10-27 17:33:46
J0kerMh : passed basic,update,select-meta,drop-table, commit id=ad351797fd6eea46b79282b8fa272c7ea2a1dbb4, date=2021-10-27 15:05:29
LLThomas : passed update,select-meta,drop-table, commit id=bbf9d3f9594323d2d2ce6e2dc6a717e5c7933035, date=2021-10-27 15:04:07
Moonm3n : passed basic,date,update,select-meta,drop-table,insert, commit id=6227ec42f637fc09e2eb9031c445eb9e8512aef0, date=2021-10-27 15:32:05
jaingmengmeng : passed basic,date,update,select-meta,select-tables,drop-table, commit id=6f411d6c7b4d491d86ba068c7d72422f5bc715f1, date=2021-10-27 15:22:04
DUXUCHONG : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=50e61588043a0fdc84419bb3596e4caf234cf6dc, date=2021-10-27 15:27:17

宁封 · 2021 年10 月 27 日 18:07

abaaba-OB : passed basic,date,update,select-meta,drop-table, commit id=6bb978103009428cb5b5503e330ea26ac8d7077d, date=2021-10-27 16:26:11

ingdex : passed basic,select-meta,drop-table, commit id=b4d2c949479664f5f51d5f2e600bbadf28478969, date=2021-10-27 17:03:56

An-DJ : passed select-meta, commit id=d7331654b9af148e5cd68cea786741a0a7f1bf92, date=2021-10-27 16:00:33

HoniiTro19 : passed basic,select-meta,drop-table, commit id=8c31f157120e585ad117254274b5fe663801a194, date=2021-10-27 15:38:03

宁封 · 2021 年10 月 27 日 18:07

EmperorNiu 0 /test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp: In member function ‘RC Table::changerecord(const char, const Value, Record)’:\n/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: error: ‘strcmp’ is not a member of ‘std’\nif (std::strcmp(field->name(),attribute) == 0){\n^~\n/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: note: suggested alternative:\nIn file included from /test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:16:\n/usr/include/string.h:140:12: note: ‘strcmp’\nextern int strcmp (const char s1, const char s2)\n^~\nmake[2]: [src/observer/CMakeFiles/observer.dir/storage/common/table.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\n/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp: In member function ‘RC Table::changerecord(const char, const Value, Record)’:\n/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: error: ‘strcmp’ is not a member of ‘std’\nif (std::strcmp(field->name(),attribute) == 0){\n^~\n/test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:294:14: note: suggested alternative:\nIn file included from /test/dask/test-tmp/EmperorNiu/miniob/src/observer/storage/common/table.cpp:16:\n/usr/include/string.h:140:12: note: ‘strcmp’\nextern int strcmp (const char s1, const char s2)\n^~\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/storage/common/table.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake[1]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] Error 2\nmake: [all] Error 2\n

DATA-IS-POWER 0 In file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_string.h:6400,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/string:52,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/locale_classes.h:40,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/ios_base.h:41,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:42,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ostream:38,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/iostream:39,\nfrom /test/dask/test-tmp/DATA-IS-POWER/miniob/src/observer/sql/executor/execute_stage.cpp:17:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h: In function ‘_Ret gnu_cxx::stoa(_TRet (*)(const _CharT*, _CharT, _Base ...), const char*, const _CharT*, std::size_t*, _Base ...)’:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h:84:25: error: ‘ERANGE’ was not declared in this scope\nelse if (errno == ERANGE\n^~~~~~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h:84:25: note: suggested alternative: ‘EBADE’\nelse if (errno == ERANGE\n^~~~~~\nEBADE\ncompilation terminated due to -fmax-errors=1.\nmake[2]: * [src/observer/CMakeFiles/observer_static.dir/sql/executor/execute_stage.cpp.o] Error 1\nmake[2]: * Waiting for unfinished jobs....\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_string.h:6400,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/string:52,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/locale_classes.h:40,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/ios_base.h:41,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:42,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ostream:38,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/iostream:39,\nfrom /test/dask/test-tmp/DATA-IS-POWER/miniob/src/observer/sql/executor/execute_stage.cpp:17:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h: In function ‘_Ret gnu_cxx::stoa(_TRet (*)(const _CharT*, _CharT, _Base ...), const char*, const _CharT*, std::size_t*, _Base ...)’:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h:84:25: error: ‘ERANGE’ was not declared in this scope\nelse if (errno == ERANGE\n^~~~~~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/string_conversions.h:84:25: note: suggested alternative: ‘EBADE’\nelse if (errno == ERANGE\n^~~~~~\nEBADE\ncompilation terminated due to -fmax-errors=1.\nmake[2]: * [src/observer/CMakeFiles/observer.dir/sql/executor/execute_stage.cpp.o] Error 1\nmake[2]: * Waiting for unfinished jobs....\nmake[1]: * Waiting for unfinished jobs....\nmake[1]: *** [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake: *** [all] Error 2

宁封 · 2021 年10 月 27 日 18:07

OBserver-BUPT 0 In file included from /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/tuple.h:23,\nfrom /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/aggregation.h:5,\nfrom /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/sql/executor/aggregation.cpp:1:\n/test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/value.h:18:10: fatal error: bits/types/timet.h: No such file or directory\n#include <bits/types/timet.h>\n^\ncompilation terminated.\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/aggregation.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nIn file included from /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/tuple.h:23,\nfrom /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/aggregation.h:5,\nfrom /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/sql/executor/aggregation.cpp:1:\n/test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/./sql/executor/value.h:18:10: fatal error: bits/types/timet.h: No such file or directory\n#include <bits/types/timet.h>\n^~~~~\ncompilation terminated.\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/aggregation.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake[1]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] Error 2\nmake: [all] Error 2\n

邹某人 · 2021 年10 月 27 日 18:10

zhengbumingbai 的多表还是查询返回结果不对吗？

lvskiller · 2021 年10 月 27 日 18:29

HUST-DDDD : passed select-meta, commit id=5cf8fd44b69e0ae6f97d8e99158f49010c875935, date=2021-10-27 16:04:00

https://github.com/HUST-DDDD/MiniOB/

这个已经过的drop table，多表查询还有update咋都挂了

dongzy · 2021 年10 月 27 日 18:29

老师能帮忙看下挂在哪里了呢？https://github.com/dongzeyu/miniob

wsh · 2021 年10 月 27 日 18:35

git clone git@github.com:5d1207/pushd.git的聚合下午的第一次增量测试过了，现在的没有过，现在是什么问题呢？

宁封 · 2021 年10 月 27 日 18:49

多表查询只查一个字段时，输出表头信息的时候，表名字也要带上。

比如select t1.a from t1,t2;

t1.a

1

宁封 · 2021 年10 月 27 日 18:50

drop table中查询的时候，输出的列的个数是对的，但是数据行，多了一列

比如select a,b from t;

输出是这样的

a | b

1 | c | c

宁封 · 2021 年10 月 27 日 18:50

哪个case呢

宁封 · 2021 年10 月 27 日 18:51

只显示表头信息，但是没有数据输出啊

dongzy · 2021 年10 月 27 日 18:54

本来 basic,update,select-meta,aggregation-func,drop-table,insert这些都过了，现在只有select-meta过了，想问下是什么原因？

邹某人 · 2021 年10 月 27 日 18:54

那多列索引卡在哪个用例了呢？

曾经沧海 · 2021 年10 月 27 日 18:57

您好，能帮忙看一下DATA-IS-POWER现在能编译通过嘛，之前不知道为啥没编过？

宁封 · 2021 年10 月 27 日 18:58

日期的不等于查询

宁封 · 2021 年10 月 27 日 18:59

输出格式不对。

col1 | col2

a | b 你的输出，在a 后面有两个空格

宁封 · 2021 年10 月 27 日 19:01

现在可以编译通过了，但是我没有时间去测试了，等下次测试。

kamiyo · 2021 年10 月 27 日 19:01

My-OB-contest

https://github.com/My-OB-contest/miniOB可以帮忙看看聚合、多表、join错误的case吗

六点八二四 · 2021 年10 月 27 日 19:06

老师你好想问下TaurusGGBOY的date/多表。date还是1970年1年1月现实错误吗？多表是执行未完成还是？

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

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