OceanBase 大赛测试结果（增量） - 2021/10/26 晚上

社区活动 OceanBase 数据库大赛
#1 
Godroser : passed basic,drop-table, commit id=3792826b6ca7f774c8fbd18f6edd37b336b7aee2, date=2021-10-26 15:54:30
tanruixiang : passed basic,select-tables,drop-table, commit id=a68e6719913ed2b20039fee222fff6b0aaa19dae, date=2021-10-26 15:45:29
Sunday361 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=2efe11cf486f0819099d6982f726c8b27cca52a3, date=2021-10-26 18:33:07
zjx1230 : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=b25dc33a6bf7ca84a3af9c4c0503bb15fc8e6851, date=2021-10-26 19:07:11
lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,order-by, commit id=eac6f18bb42e75b8e7c0e3d6bbdb97a64523a8f1, date=2021-10-26 16:06:35
JameyWoo : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=8c143aa5bfd9a9c6d7639f2331aeee660b0f4520, date=2021-10-26 17:31:40
httdty : passed basic,select-meta, commit id=fd12a937890c829fd8f923b5b171cb1b379130cc, date=2021-10-26 18:21:25
DATA-IS-POWER : passed basic,date,update,select-meta,drop-table,insert, commit id=5c58e37bf852faa0333862368ca460ec487b83b2, date=2021-10-26 18:58:43
nautaa : passed basic,select-meta,drop-table, commit id=52031ebe7e1f10de452f289a646df618d4168939, date=2021-10-26 16:54:06
MoYuOB2021 : passed select-meta, commit id=77503f0b1a101f4bc954d5ba2a2ff67e3dc0e6cb, date=2021-10-26 15:52:30
penggan666 : passed basic,date,update,select-meta,drop-table, commit id=d4e5b4ed9725bd198ecb928e49cb1e6c36e0135b, date=2021-10-26 15:14:57
Leozki : passed basic,date,select-meta,drop-table, commit id=f504ba060e93122773ba3ab773078a7eeb359871, date=2021-10-26 15:50:01
Ichasethesun : passed basic,date,update,select-meta,drop-table, commit id=ff59cb62d59628e4939b32b1b56d59ff710e2b7a, date=2021-10-26 16:44:54
sWildGold : passed basic,select-meta,drop-table, commit id=e7aa4debdd380af590fe64f63acd4f698cb6fd27, date=2021-10-26 17:57:38
HUST-DDDD : passed basic,update,select-meta,drop-table, commit id=85091c6c6c8ab69761115862937bb0dd3a111c98, date=2021-10-26 16:33:52
shyuZzz : passed basic,date,select-meta,drop-table, commit id=789dc5e67a8366edc558ecdfca4cb56081e2b297, date=2021-10-26 16:06:15
HNUDLG : passed basic, commit id=2d35685727c814e13d96d69667288239d992d632, date=2021-10-26 16:47:55
JayL-zxl : passed basic,select-meta,drop-table, commit id=357a7b8577d53c3760178072c5a7e35002dcd50e, date=2021-10-26 16:50:39
BanBuDu0 : passed basic,date,update,select-meta,drop-table, commit id=37aad447d367c8c626f3375781bcf72549031c86, date=2021-10-26 16:21:24
tssunjingwu : passed basic,update,select-meta,drop-table, commit id=0806b8a9823316f42d249bb61fc51b2134e8b83d, date=2021-10-26 18:52:29
agoodjuice : passed basic,date,update,select-meta,drop-table, commit id=e5b63bb47bce92361885dbf17607208ae9faa909, date=2021-10-26 14:40:57
S-1-T : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=54626f667a4e1b3f18de88f54df5f58c6c150546, date=2021-10-26 18:03:47
zhengbumingbai : passed basic,date,select-meta,drop-table,insert,unique, commit id=6756f6f36451c21c2d275bc64002696633888233, date=2021-10-26 17:03:26
yangzecai : passed basic,date,update,select-meta,select-tables,drop-table, commit id=59c6033b7e5c7facf8e932db1d53c9aa1eed0747, date=2021-10-26 15:57:02
ingdex : passed basic,select-meta,drop-table, commit id=929442ac332fe9b56d712537644d5c78a02b2101, date=2021-10-26 17:24:01
Whorra : passed basic,update,select-meta,drop-table, commit id=4f219b4b9fac534e9a6e87f9064f1f9beda130b3, date=2021-10-26 16:03:22
123liuziming : passed basic, commit id=fb73660da58d6a5ac563517a5bc0527761df3996, date=2021-10-26 19:54:24
idvzchusvol : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=9bcd650bb699f47c17f2868420ce211132c75758, date=2021-10-26 19:06:54
CRRRRR2016 : passed basic,select-meta, commit id=bd651f8144a60dbee27f77b151b1fe7d67af8ce9, date=2021-10-26 19:13:17
Panlisong : passed basic,select-meta, commit id=39da00c0c3ee1a9b3560d56656217dae66c33012, date=2021-10-26 16:14:33
#2 
abaaba-OB : passed basic,select-meta,drop-table, commit id=2803b8dae0c314a8c4d92cc239334a67ce51859d, date=2021-10-26 16:23:57
jaingmengmeng : passed basic,date,update,select-meta,drop-table, commit id=e7deb65b5588d6d6929ef569dbc6b41eba9cffe4, date=2021-10-26 17:42:38
Xylitol415 : passed basic,select-meta,drop-table, commit id=59c8f451924b3f36e13911c9d67c77113b040839, date=2021-10-26 16:24:15
My-OB-contest : all cases failed, commit id=22bdf0ce017413c0d1080231bfbd102870b8b2be, date=2021-10-26 19:05:02
coding01000 : passed basic,select-meta, commit id=479fcbe4e9621fa67eae61e09cc92da5e79bb20f, date=2021-10-26 19:06:43
BaymaxHWY : passed basic, commit id=4b862d72741dfe44f1030b0c18bb59c568476b83, date=2021-10-26 14:12:00
RucHyy : passed basic,select-meta,drop-table, commit id=bdf17d2d5c644e215a659be653c42e07d67c6676, date=2021-10-26 16:03:17
watchpoints : passed select-meta,drop-table, commit id=fae5d12c13e406e0534507af955d9a3eb248b203, date=2021-10-26 19:42:08
wangqiim : passed date,update,select-meta,aggregation-func,drop-table,insert, commit id=8c3b45788918faf362b80474ca7c85976277129a, date=2021-10-26 18:52:05
Alaska12719 : passed basic,select-meta,drop-table, commit id=3f7262b392c6e696d08ce85d513d8a2679e38bec, date=2021-10-26 17:22:21
Wheeeel : passed basic,update, commit id=428f686f9e83b5cdbf2fb9f584d4a28bdcfc666b, date=2021-10-26 18:53:25
caizj : passed basic,date,update,select-meta,aggregation-func,drop-table,insert, commit id=d9e32e54a129d62a9cf7fb89db82f933325ba1f3, date=2021-10-26 15:29:03
hbangq : passed basic,update, commit id=c690dc70286ac340c54cae758cb3c1e79ebbe274, date=2021-10-26 19:18:54
Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=b9bce837f40160271f369dec3679975982f7c828, date=2021-10-26 15:50:45
DeepZheng : passed select-meta, commit id=3bf5d0c817e61bf5d85de917da913005c605872c, date=2021-10-26 17:04:24
NKU-EmbeddedSystem : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=d062396bbe0ee3242594e973110c77d7ddc07fce, date=2021-10-26 14:40:43
#3

OBserver-BUPT 0 /test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/sql/executor/aggregation.cpp:10: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[1]: [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake[1]: Waiting for unfinished jobs....\n/test/dask/test-tmp/OBserver-BUPT/miniob/src/observer/sql/executor/aggregation.cpp:10: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/observerstatic.dir/all] Error 2\nmake: *** [all] Error 2\n



DUXUCHONG 0 /test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp: In member function ‘void TupleSet::print(std::ostream&, std::vector<char>) const’:\n/test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:241:28: error: ‘dynamicpointercast’ was not declared in this scope\nsum += dynamicpointercast<IntValue>(values[i])->getValue();\n^~\n/test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:241:28: note: suggested alternative:\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/memory:81,\nfrom /test/dask/test-tmp/DUXUCHONG/miniob/src/observer/./sql/executor/tuple.h:18,\nfrom /test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/sharedptr.h:511:5: note:  ‘std::dynamicpointercast’\ndynamicpointercast(const sharedptr<_Up>& r) noexcept\n^~\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observertatic.dir/sql/executor/tuple.cpp.o] Error 1\nmake[2]: * Waiting for unfinished jobs....\n/test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp: In member function ‘void TupleSet::print(std::ostream&, std::vector<char) const’:\n/test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:241:28: error: ‘dynamicointerast’ was not declared in this scope\nsum += dynamicointerast<IntValue>(values[i])->getValue();\n^~\n/test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:241:28: note: suggested alternative:\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/memory:81,\nfrom /test/dask/test-tmp/DUXUCHONG/miniob/src/observer/./sql/executor/tuple.h:18,\nfrom /test/dask/test-tmp/DUXUCHONG/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/sharedtr.h:511:5: note:  ‘std::dynamicointerast’\ndynamicointerast(const sharedtr<p>& r) noexcept\n^~\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.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/observertatic.dir/all] Error 2\nmake: [all] Error 2\n

#4

能看看Leozki的update错哪了吗

#5

更新索引和全表更新，没有成功

#6

zhengbumingbai, 想看看update 聚合 还有多列索引卡在哪了，update 我们原来过了 是被索引搞坏嘛？

#7

sWildGold,请问update错在哪里了，非常感谢

#9

更新单行都失败了...

多列索引，查询的时候，失败了。就是常规的查询。可以支持不等于查询吗 ？  比如 <>

查询还要考虑日期。

#10

更新单行的时候，程序挂了。

自测的时候，表不要太简单，搞个索引和多个字段的表。

#13

那聚合呢 有什么问题吗

#15

Sunday361，老师想请问一下，连接是还需要考虑聚合吗

#17

多表查询不用，但是inner join还是要的

#18

老师，能看一下hbangq的select-meta错在哪里吗，感谢

#19

FAILUR

FAILUR


返回值应该是 “FAILURE"

#20

请问 https://github.com/tanruixiang/MiniOB 更新date代码之后，前面select-meta、update、inserts这三个是哪些测试用例错误了

#21

Panlisong，请问drop table错在哪里了，谢谢老师

#22

可以帮忙看一下https://github.com/DeepZheng/OceanBase2021为什么只过了一个元数据校验么，之前drop update那些都过了，为啥加了一个 date 就出问题了嘞

#24

你好！可以帮忙看一下date和update一直过不了的原因吗，改了挺多次还是有问题，https://github.com/abaaba-OB/miniob，感谢！



#25

日期的插入处理有问题、比较查询也有问题；

select-meta在检查where条件字段时，出现了异常；

更新不存在的字段时，出现了异常。

insert 不能支持一次插入多行数据

#26

删除的表不能再创建