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
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
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
Sunday361 老师,我得group by是什么问题呀
https://github.com/tanruixiang/MiniOB 请问下老师聚合哪里出问题了
老师,想问一下jaingmengmeng的inner join的出错了的查询语句。想找到问题在哪,为什么会出现重复的结果。谢谢老师~
update 有没过,昨天用索引测试 一遍,float 也格式化显示了,麻烦看一下在那个case失败了,举个更新失败例子. https://github.com/watchpoints/miniob
老师,我问一下,聚合函数有什么问题吗?麻烦看一下在那个case失败了。
项目地址:https://github.com/Whorra/OurBase
来哥您好,能再帮忙看看DATA-IS-POWER的order by哪里出了问题,麻烦了。
请问一下obcontest的多表是啥问题呢
老师,想问下dongzeyu的date哪里没过啊?谢谢! dongzeyu
老师 请问下我们的date是什么问题呀 https://github.com/dongzeyu/miniob
老师我们drop和update问题在哪里
https://github.com/Ethanzjp/miniob-contest
github.com/OBserver-BUPT/MiniOB 您好老师,想请问一下date和聚合又挂在哪里了。。。
请问一下我们的聚集函数哪里有问题?
https://github.com/HUST-DDDD/MiniOB.git
哥,能再帮我们看一眼obcontest队伍的多表查询吗?我们已经调整了输出格式了应该对了才是。
前辈您好,能麻烦帮忙看看JameyWoo的null字段添加问题在哪吗
select id, name, avg(score) from tgroupby group by id, name;
失败了。
另外问一下,是否支持多表的group by
COUNT 就挂了。你们建表是否太简单了
Select jointable1.name from jointable1 inner join jointable2 on jointable1.id=jointable2.id;
就是看起来很普通的查询语句。