OceanBase 大赛测试结果- 2021/10/29 下午2

宁封 · 2021 年10 月 29 日 17:54

jaingmengmeng : passed basic,update,select-meta,select-tables,drop-table,join-tables, commit id=8594f4d3831de870c70e8bd839755ed569fa080c, date=2021-10-29 16:01:32

JameyWoo : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=ce6b4830c454090f1d8d62e41d50e565bdfd6940, date=2021-10-29 15:08:09

Sunday361 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,group-by, commit id=cfed89f72d871283567455339ac6825649905490, date=2021-10-29 15:00:36

WangAShao : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique, commit id=b84887044118b735cc81cff084487ac4795b7ce6, date=2021-10-29 16:28:50

Whorra : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=ec8f7866d2a7c3da9b1bb41d301183a23424c28a, date=2021-10-29 17:03:31

5d1207 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by, commit id=02b804b7f67e788b4c94787a0d6bf492e45ea2cc, date=2021-10-29 16:37:54

lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=acc45451bb19ec2a3ce12ec6ff865123bb40b79e, date=2021-10-29 17:01:49

Windsrain : passed basic,select-meta,drop-table, commit id=c9b467d476cdd8053e6cbbe5e95188a5dad83c4e, date=2021-10-29 16:28:56

DUXUCHONG : passed basic,update,select-meta,select-tables,aggregation-func,drop-table, commit id=e9dcb569c104c11513d265acd981e4f080025144, date=2021-10-29 15:47:08

Alaska12719 : passed basic,date,update,select-meta,aggregation-func,drop-table,insert, commit id=fba12f837771fe878e1cca36df8320614d9a34a4, date=2021-10-29 17:28:48

fkuner : passed basic,date,update,select-meta,drop-table, commit id=385f47eb86270d37629b0ee842695a1fd7dcf4d4, date=2021-10-29 15:57:01

CardinalGuo : passed basic,update,select-meta,drop-table,insert, commit id=in, date=2021-10-29 15:16:02

pppy2012 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=64ecc05a15d0b44709f9a3d8b8c69d7a9f7e6357, date=2021-10-29 16:18:46

JayL-zxl : passed basic,update,select-meta,aggregation-func,drop-table,insert,unique, commit id=c21521c4472a71fb51b3f6e6b1f235b6b01d9f5c, date=2021-10-29 15:43:32

PaJir : passed basic,date,select-meta,drop-table, commit id=34cfa41d3bf7140b527a7c5994af8cf22b458ae0, date=2021-10-29 16:28:51

S-1-T : passed basic,date,update,select-meta,select-tables,drop-table,insert,join-tables,unique,order-by, commit id=019676451a115351869494806a9fc0c6bc0a1178, date=2021-10-29 16:22:31

ybzxw : passed basic,date,update,select-meta,drop-table, commit id=7f50ce521bd7d5aa941b338da10a15c621fbcd0d, date=2021-10-29 15:45:14

zhengbumingbai : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,multi-index, commit id=11b231645d5ca1bac0ada6831e1b607697d83890, date=2021-10-29 17:22:31

zjx1230 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=c5dccc391447e0516480e0a0b5ae57d756fc5e5b, date=2021-10-29 17:15:34

programmerwcn : passed basic,select-meta,drop-table, commit id=a4245039688654c2153f659fe92b894fa0243590, date=2021-10-28 23:45:15

XuhXie : passed basic, commit id=1520b4a221daf71ec7b1030a48621f9cf54f81c6, date=2021-10-29 17:01:43

Ichasethesun : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,order-by,group-by, commit id=6f8839af104120193df6e1d5db604a0ea07cfb0c, date=2021-10-29 16:16:47

rainays : passed basic,update,select-meta,drop-table,unique, commit id=72e047a7e94c0ebba26e82cf4afe519c41f64cbb, date=2021-10-29 12:42:41

RUC-Seed-No-59 : passed select-meta,aggregation-func,drop-table,insert, commit id=7dba45e2ea6419b7a46214dea1d55641d206a16b, date=2021-10-29 17:37:16

CRRRRR2016 : passed basic,date,select-meta,drop-table, commit id=864f63310cf2843e7eeaec2240acf918674c4df9, date=2021-10-29 15:38:20

EmperorNiu : passed basic,date,update,select-meta,drop-table, commit id=914baef7d6ab520154647bb846a4756aab7975b3, date=2021-10-29 15:46:22

obcontest : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,join-tables,unique,order-by, commit id=d5a08500cfa8f3b782e9b6a1f6e15a030fc26471, date=2021-10-29 15:55:35

宁封 · 2021 年10 月 29 日 17:55

dongzeyu 看起来是死循环

Thread 3 (Thread 0x7fd1cdffb700 (LWP 14035)):

#0 0x00007fd1de3f800c in intmalloc () from /lib64/libc.so.6

#1 0x00007fd1de3fb78c in malloc () from /lib64/libc.so.6

#2 0x00007fd1decf0518 in operator new (sz=sz@entry=64) at ../../.././libstdc++-v3/libsupc++/new_op.cc:50

#3 0x0000000000422191 in allocate (this=<optimized out>, __n=<optimized out>) at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/vector.tcc:413

#4 allocate (a=..., n=<optimized out>) at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/alloc_traits.h:436

#5 Mallocate (this=<optimized out>, __n=<optimized out>) at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/stl_vector.h:296

#6 std::vector<std::sharedptr<TupleValue>, std::allocator<std::sharedptr<TupleValue> > >::Mreallocinsert<std::sharedptr<TupleValue> const&> (this=0x7fd1cdff7600, position=..., args#0=...) at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/vector.tcc:427

#7 0x000000000042031b in emplaceback<std::sharedptr<TupleValue> const&> (this=this@entry=0x7fd1cdff7550) at /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/atomicity.h:96

#8 Tuple::add (this=this@entry=0x7fd1cdff7600, other=...) at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/tuple.cpp:53

#9 0x0000000000417e7d in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:315

#10 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#11 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#12 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#13 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#14 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#15 0x0000000000417f3f in backtrack(TupleSet&, std::vector<TupleSet, std::allocator<TupleSet> > const&, int, Tuple&, Selects const&, TupleSchema const&) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/execute_stage.cpp:325

#16 0x000000000041833b in dojoin(std::vector<TupleSet, std::allocator<TupleSet> > const&, Selects const&, char const*) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.cpp:343

#17 0x000000000041c25d in ExecuteStage::doselect(char const, Query, SessionEvent*) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.cpp:688

#18 0x000000000041d4c6 in ExecuteStage::handlerequest(common::StageEvent*) () at /test/dask/test-tmp/dongzeyu/miniob/src/observer/./event/sqlevent.h:33

#19 0x000000000041d8c5 in ExecuteStage::handleevent (this=0x1276be0, event=0x7fd1b020fc50) at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/executor/executestage.cpp:106

#20 0x00000000004239cb in OptimizeStage::handleevent (this=0x1276f90, event=0x7fd1b020fc50) at /test/dask/test-tmp/dongzeyu/miniob/src/observer/sql/optimizer/optimizestage.cpp:80

宁封 · 2021 年10 月 29 日 17:56

HNUDLG 程序无返回结果

江流洋 · 2021 年10 月 29 日 17:58

老师，想问一下，jaingmengmeng的date哪个没过啊，之前都没问题的，现在怎么还改错了呢？

Yangda · 2021 年10 月 29 日 17:59

CardinalGuo 的date怎么没过，我本地测试没有nodata的情况啊，谢谢老师

邹某人 · 2021 年10 月 29 日 17:59

zhengbumingbai 问问我们的null和超长字段卡在哪个用例了呢？

宁封 · 2021 年10 月 29 日 18:01

Xylitol415 : passed basic,date,select-meta,drop-table, commit id=88116c1b3ded95e526bc9ca466f9a3920165d78b, date=2021-10-29 17:29:48

b41sh : passed basic,update,select-meta,drop-table, commit id=f36c5f6a93d26465a5bf65ad8ee44f47d20b49fd, date=2021-10-29 17:53:15

宁封 · 2021 年10 月 29 日 18:01

SELECT * FROM DATETABLE WHERE UDATE>'2020-1-20'; 这个跪了

宁封 · 2021 年10 月 29 日 18:02

SELECT * FROM DATETABLE WHERE UDATE>'2020-1-20';

ID | U_DATE

SELECT * FROM DATETABLE WHERE UDATE<'2019-12-31';

NO DATA

SELECT * FROM DATETABLE WHERE UDATE='2020-1-1';

ID | U_DATE

宁封 · 2021 年10 月 29 日 18:06

SELECT AVG(NUM) FROM NULL_TABLE3;

AVG(NUM)

-NAN

fkuner · 2021 年10 月 29 日 18:06

来哥，想问一下aggregation哪里没过

fkuner : passed basic,date,update,select-meta,drop-table, commit id=385f47eb86270d37629b0ee842695a1fd7dcf4d4, date=2021-10-29 15:57:01

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

SELECT AVG(NUM) FROM AGGREGATION_FUNC;

NO DATA

SELECT AVG(PRICE) FROM AGGREGATION_FUNC;

NO DATA

SELECT MIN(*) FROM AGGREGATION_FUNC; 这个没有返回。正确应该返回FAILURE

WangAShao · 2021 年10 月 29 日 18:23

来哥，WangAShao/miniob的多列索引这次又是哪里挂了啊

WangAShao · 2021 年10 月 29 日 18:23

还有WangAShao的order by是哪里挂了

ybzxw · 2021 年10 月 29 日 19:09

老师，想问下ybzxw的select-tables有什么问题？

watchpoints · 2021 年10 月 29 日 19:13

可能是索引的事情.

westice · 2021 年10 月 29 日 19:33

麻烦来哥看看Coding-Hammer的date卡在哪个用例🙏

Coding-Hammer/miniob (github.com)

dongzy · 2021 年10 月 29 日 19:59

老师能帮忙看下哪个case挂掉了呢，本地复现不出来这个bug 。 https://github.com/dongzeyu/miniob

duneann · 2021 年10 月 29 日 21:17

https://github.com/rainays/OceanBase-competition 可以帮忙看一下date为啥没过吗，之前是过了的，还想看看insert和select-table是什么case没有过

huntsman · 2021 年10 月 30 日 16:04

老师，请问Wheeeel的drop table 和select-meta是哪里没有通过呀