OceanBase 大赛测试结果(增量) - 2021/10/27 下午

编译失败

18703486960 0 In file included from /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/tuple.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nIn file included from /test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/executionnode.h:20,\nfrom /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/executionnode.cpp:15:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/executionnode.cpp.o] Error 1\nIn file included from /test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/executionnode.h:20,\nfrom /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/executestage.cpp:29:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^\ncompilation terminated due to -fmax-errors=1.\nIn file included from /test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/executionnode.h:20,\nfrom /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/executestage.cpp:29:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/executestage.cpp.o] Error 1\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] Error 2\nmake[1]: Waiting for unfinished jobs....\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/executestage.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nIn file included from /test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/executionnode.h:20,\nfrom /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/executionnode.cpp:15:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/executionnode.cpp.o] Error 1\nIn file included from /test/dask/test-tmp/18703486960/miniob/src/observer/sql/executor/tuple.cpp:15:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h: In member function ‘void Tuple::reverse()’:\n/test/dask/test-tmp/18703486960/miniob/src/observer/./sql/executor/tuple.h:60:12: error: ‘reverse’ is not a member of ‘std’\nstd::reverse(values.begin(), values.end());\n^~~~~\ncompilation terminated due to -fmax-errors=1.\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.cpp.o] Error 1\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake: [all] Error 2\n

老师能帮忙看下 https://github.com/LLThomas/miniob date比较查询哪里有问题吗,我们自己测试,下面的都能过的

表结构:

查询:

哥,能再帮我们看一下聚合吗?我们按照官网的样例插入了数据,本地都是可以的:https://github.com/obcontest/miniob , commit :f18b3cd

日期比较查询没有数据啊。

还有2019-12-31 直接解析成非法日期了吗?

感觉是有什么东西在编译的时候有冲突,拉代码的时候,会做合并,我把你们的测试环境清理一下。

好的谢谢老师~


你的场景,比我们后台的还要复杂了。

有没有建索引?

字符串 min的时候,没有返回值

没有建索引,是需要考虑建索引的情况吗?

能问下条件是什么吗?在本地测了好多都没找到

浮点类型,没update,其他类型都测试了。

哥,请问你说的是这个commit id吗?f18b3cd,还是哪一次呢?min没有返回值怎么感觉是我昨晚的问题

之前我们队友传错过代码,后来回滚了然后删了一些commit记录。不知道和这个有没有关系。

老师如果重新清理后可以的话能不能帮我买再测一下,谢谢

https://github.com/My-OB-contest/miniOB

update:日期类型不做考察吧。日期边界case 没测试

好的好的。辛苦

https://github.com/CRRRRR2016/YCCCCRRR2021

可以帮我们看一下drop和date是什么地方没过吗

我也是这样的情况

好厉害啊,我这部分好多过不了

老师可以帮忙看下https://github.com/Galaxy0106/Oceanbase的update哪里没有过么 本地测试给的用例应该都通过了😭

可以帮忙看下多表查询的问题吗? https://github.com/ccat3z/miniob.git