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

社区活动 OceanBase 数据库大赛
#1 
XorSum : all cases failed, commit id=21c945dcb02e8eccf07790a65503c6d7a1725f8a, date=2021-10-27 22:16:46
JINGE-ui : passed basic,select-meta,drop-table, commit id=293a076273bcdf4d1ade123888ded260d5ba1fd5, date=2021-10-28 02:10:25
LLThomas : passed basic,date,update,select-meta,drop-table,insert, commit id=4242d287c2113bbfe26ef27cb90f8e9b61506ca7, date=2021-10-28 11:27:15
mikan-team : passed basic, commit id=df50a1fa5def13756db0f1afe21c59beae39b6ae, date=2021-10-28 09:44:13
DUXUCHONG : passed basic,date,update,select-meta,drop-table, commit id=425b496ecd8e02ce6d898fe9c51b68a5188d35e8, date=2021-10-27 21:03:49
Leozki : passed basic,date,update,select-meta,drop-table, commit id=012452777dfa1fd8dea38c6a549e50f53d3319ec, date=2021-10-27 23:45:40
jaingmengmeng : passed basic,date,update,select-meta,select-tables,drop-table, commit id=17d04c29bbad1bf6719822198daf3a09417d590a, date=2021-10-27 21:21:03
Sunday361 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables, commit id=20d832b512653dd831bee4398c23b6efaae0b831, date=2021-10-28 01:04:26
Whorra : passed basic,update,select-meta,select-tables,drop-table, commit id=ea436cedae48f676cc77262a0c1726b932cfd39c, date=2021-10-27 22:31:05
My-OB-contest : passed date,update,select-meta,aggregation-func,drop-table, commit id=65e88895c41223aad3721a122c5b9d310b28dca5, date=2021-10-28 11:23:45
tanruixiang : passed basic,update,select-meta,select-tables,drop-table,insert, commit id=017225cb5c7113c4d9b6a71257f723299b8954bb, date=2021-10-28 01:15:16
Panlisong : passed select-meta,aggregation-func,join-tables, commit id=7dc28c772b8407c04ca0b12ec740aa93e3b87838, date=2021-10-28 10:40:19
HUST-DDDD : passed basic,date,update,select-meta,select-tables,drop-table, commit id=ba089c8a6ac36f99e3d4e08fbf18962152c714c1, date=2021-10-28 10:33:40
Issac-Newton : passed basic, commit id=ad372107c391e717eb22a243ee0e281d0650e437, date=2021-10-27 23:07:57
blazersEvan : passed basic,date,update,select-meta,aggregation-func,drop-table,insert,unique, commit id=7608cc1819feba643f6e1a18c9060f53c596f73c, date=2021-10-28 01:52:23
Galaxy0106 : passed basic,select-meta,drop-table, commit id=0ddc545ad23e7cf7897629fb9e889fa8a1c5c59b, date=2021-10-28 11:27:08
rawmaterials223 : passed basic,select-meta, commit id=eee8a4bc671dc6d4395030581d5ebba3da447f7c, date=2021-10-27 23:48:38
Ichasethesun : passed basic,date,update,select-meta,select-tables,drop-table, commit id=4f69219d42cdc34a1ae4d82b54f627441d603f1c, date=2021-10-27 23:16:40
TaurusGGBOY : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,unique,order-by, commit id=6dd5d04666d547d98c9d4de43d4b297e4c521e50, date=2021-10-28 10:52:36
JayL-zxl : passed basic,select-meta,drop-table,unique, commit id=74ec74d3ed60a00d7a2cd5e4499148b23e965a5b, date=2021-10-28 10:43:48
zhaoze95 : passed basic,select-meta, commit id=1010dc5954f75f6a62c4d10038fbfd6b27b798f8, date=2021-10-27 21:45:55
Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=da53d59c0900f8c7333a4b40a416515919a2df19, date=2021-10-28 10:15:57
rehoboan : passed basic,select-meta,drop-table, commit id=03c9dc37dd196f01aaf85e3adf09d8d74b5019c1, date=2021-10-28 01:17:29
zhengbumingbai : passed basic,date,update,select-meta,drop-table,insert,unique, commit id=a8637c992cca53514b997e83514caeb86e7a8f4d, date=2021-10-28 10:56:11
zhoulaiqing : passed basic,date,update,select-meta,select-tables,drop-table, commit id=8dd40ae05ad0e143cc4b3e8d328396aa012346f4, date=2021-10-27 22:32:50
DBChat-OB : passed drop-table, commit id=7faefb271d6ccf5ac0fdbd1de217c25ce455eada, date=2021-10-27 21:32:21
dongzeyu : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=97bc581eec0c55e7ec6d09ac9076d395ff25b1fa, date=2021-10-28 11:09:04
lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,order-by,group-by, commit id=956988690394acf4fadbfdfec9cec47ac03a7c46, date=2021-10-27 22:59:26
cyhw : passed basic,select-meta, commit id=61b96fc659a3c619402f7805c59f8ba6de7bc3a8, date=2021-10-27 22:53:26
Kaimary : passed basic,select-meta,drop-table, commit id=42842f7f6675d4e05d7ab86fc1899ef0e8023375, date=2021-10-27 21:41:46
#2 
123liuziming : all cases failed, commit id=48aac58bc004740011c1b51da4b29f62a3b6326e, date=2021-10-27 22:45:08
ifIAmADJ : passed basic, commit id=6b5bb3f480affd864740e842c5055da0fb5d36aa, date=2021-10-27 21:35:09
PaJir : passed basic,select-meta,drop-table, commit id=6b4f893ada9224e9ac8c2e2fab52bb6ab159ac12, date=2021-10-28 00:55:38
Wheeeel : passed basic,update, commit id=e7cd1a905ad1f8863c75e8fc1177321fde87c6bb, date=2021-10-28 01:35:12
Ethanzjp : passed basic, commit id=ce0e0fdc80c460322bc309a36b7b054ccfb76dc6, date=2021-10-28 00:02:35
xiaoyong-z : passed basic,update,select-meta,drop-table, commit id=f498368f106554d65fe1551126d72e8d5a73ca13, date=2021-10-28 08:51:19
WangAShao : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique, commit id=e2878dd5dc7911b90ec7818298d4ac83d4b68ba6, date=2021-10-28 01:04:50
abaaba-OB : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=9e817b66043636c07c08288a9557b6d2ac4982aa, date=2021-10-28 10:15:20
watchpoints : passed select-meta,drop-table, commit id=9d4c56b20dea739fe6583fbd5f9e9517eb5ddfc6, date=2021-10-28 00:31:32
DATA-IS-POWER : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=192a98e4164bff99196069a38db979afa2053cf9, date=2021-10-27 21:13:13
ingdex : passed basic,update,select-meta,drop-table, commit id=9e05eb92c3149ac56bc32eed76d8423c976d6703, date=2021-10-28 09:39:29
Paoluers : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=2bf91b2b495a95d64919966485fb4f965154cecf, date=2021-10-28 10:33:49
Maizesty : passed basic,date,select-meta,drop-table, commit id=a86a321849d7b4fe51e1d29f571fd32a344378a7, date=2021-10-28 10:39:40
obcontest : passed basic,date,update,select-meta,aggregation-func,drop-table,unique, commit id=81892b753a21efc0765ddfa314330ff388e328fe, date=2021-10-28 10:48:25
JameyWoo : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=04679809c3c478132af90b02246e0ecc93b73baa, date=2021-10-28 10:00:18
OBserver-BUPT : passed basic,update,select-meta,select-tables,drop-table, commit id=70b9268714e4fcdaa4e22af3784adcf8c9815b4e, date=2021-10-27 21:23:43
#3 
lmjhh 0 /test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp: 在成员函数‘void TupleSet::get_needattr(std::vector<std::__cxx11::basic_string<char> >&, int, std::vector<int>&) const’中:\n/test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:350:69: 错误：对‘find(std::vector<int>::iterator, std::vector<int>::iterator, int&)’的调用没有匹配的函数\nif (std::find(needattrlist.begin(), needattrlist.end(), flag) != needattrlist.end()){\n^\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/locale_facets.h:48,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_ios.h:37,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:44,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/istream:38,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/sstream:38,\nfrom /test/dask/test-tmp/lmjhh/miniob/src/observer/./sql/executor/tuple.h:20,\nfrom /test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/streambuf_iterator.h:368:5: 附注：candidate: ‘template<class _CharT2> typename __gnu_cxx::__enable_if<std::__is_char<_CharT2>::__value, std::istreambuf_iterator<_CharT> >::__type std::find(std::istreambuf_iterator<_CharT>, std::istreambuf_iterator<_CharT>, const _CharT2&)’\nfind(istreambuf_iterator<_CharT> __first,\n^~~~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/streambuf_iterator.h:368:5: 附注：  template argument deduction/substitution failed:\n/test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:350:69: 附注：  ‘__gnu_cxx::__normal_iterator<int*, std::vector<int> >’ is not derived from ‘std::istreambuf_iterator<_CharT>’\nif (std::find(needattrlist.begin(), needattrlist.end(), flag) != needattrlist.end()){\n^\n编译中止因为 -fmax-errors=1。\nmake[2]: *** [src/observer/CMakeFiles/observer_static.dir/sql/executor/tuple.cpp.o] 错误 1\nmake[2]: *** 正在等待未完成的任务....\n/test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp: 在成员函数‘void TupleSet::get_needattr(std::vector<std::__cxx11::basic_string<char> >&, int, std::vector<int>&) const’中:\n/test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:350:69: 错误：对‘find(std::vector<int>::iterator, std::vector<int>::iterator, int&)’的调用没有匹配的函数\nif (std::find(needattrlist.begin(), needattrlist.end(), flag) != needattrlist.end()){\n^\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/locale_facets.h:48,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basic_ios.h:37,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:44,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/istream:38,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/sstream:38,\nfrom /test/dask/test-tmp/lmjhh/miniob/src/observer/./sql/executor/tuple.h:20,\nfrom /test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/streambuf_iterator.h:368:5: 附注：candidate: ‘template<class _CharT2> typename __gnu_cxx::__enable_if<std::__is_char<_CharT2>::__value, std::istreambuf_iterator<_CharT> >::__type std::find(std::istreambuf_iterator<_CharT>, std::istreambuf_iterator<_CharT>, const _CharT2&)’\nfind(istreambuf_iterator<_CharT> __first,\n^~~~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/streambuf_iterator.h:368:5: 附注：  template argument deduction/substitution failed:\n/test/dask/test-tmp/lmjhh/miniob/src/observer/sql/executor/tuple.cpp:350:69: 附注：  ‘__gnu_cxx::__normal_iterator<int*, std::vector<int> >’ is not derived from ‘std::istreambuf_iterator<_CharT>’\nif (std::find(needattrlist.begin(), needattrlist.end(), flag) != needattrlist.end()){\n^\n编译中止因为 -fmax-errors=1。\nmake[2]: *** [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.cpp.o] 错误 1\nmake[2]: *** 正在等待未完成的任务....\nmake[1]: *** [src/observer/CMakeFiles/observer_static.dir/all] 错误 2\nmake[1]: *** 正在等待未完成的任务....\nmake[1]: *** [src/observer/CMakeFiles/observer.dir/all] 错误 2\nmake: *** [all] 错误 2\n
#4

Sunday361 老师，我得group by是什么问题呀

#5

https://github.com/tanruixiang/MiniOB 请问下老师聚合哪里出问题了

#6

老师，想问一下jaingmengmeng的inner join的出错了的查询语句。想找到问题在哪，为什么会出现重复的结果。谢谢老师～

#7

update 有没过,昨天用索引测试 一遍,float 也格式化显示了,麻烦看一下在那个case失败了,举个更新失败例子. https://github.com/watchpoints/miniob

#8

老师，我问一下，聚合函数有什么问题吗？麻烦看一下在那个case失败了。

项目地址：https://github.com/Whorra/OurBase

#9

来哥您好，能再帮忙看看DATA-IS-POWER的order by哪里出了问题，麻烦了。

#10

请问一下obcontest的多表是啥问题呢

#11

老师，想问下dongzeyu的date哪里没过啊？谢谢！ dongzeyu

#12

老师 请问下我们的date是什么问题呀 https://github.com/dongzeyu/miniob

#14

老师我们drop和update问题在哪里

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

#15

github.com/OBserver-BUPT/MiniOB  您好老师，想请问一下date和聚合又挂在哪里了。。。

#16

请问一下我们的聚集函数哪里有问题？

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

#17

哥，能再帮我们看一眼obcontest队伍的多表查询吗？我们已经调整了输出格式了应该对了才是。

#18

前辈您好，能麻烦帮忙看看JameyWoo的null字段添加问题在哪吗

#19

select id, name, avg(score) from tgroupby group by id, name;

失败了。

另外问一下，是否支持多表的group by

#20

COUNT 就挂了。你们建表是否太简单了


#21

Select jointable1.name from jointable1 inner join jointable2 on jointable1.id=jointable2.id;

就是看起来很普通的查询语句。