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

[宁封]

sourmi12k : all cases failed, commit id=f69128018a8d4a4f50be142d99dc411164301c34, date=2021-10-28 21:32:46

OceanbaseContest : passed basic, commit id=2517c15c02bd83a1ceb73bb9c03068d272596848, date=2021-10-28 21:41:47

Ichasethesun : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,order-by,group-by, commit id=5ff5584a36b02791caccfe07e0e2ca7db919b891, date=2021-10-29 10:55:44

abaaba-OB : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=3aa8ac6296ed76add0034e771a748d52f0f278b3, date=2021-10-28 21:44:21

ccat3z : passed basic,date,update,select-meta,drop-table, commit id=986382233e220566f2369f508daad5d11ff1323c, date=2021-10-28 22:52:28

DUXUCHONG : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=7901af8ea46c42d7a14488aa57ee4f923948500c, date=2021-10-29 10:59:49

Panlisong : passed basic,update,select-meta,aggregation-func,drop-table,insert,join-tables, commit id=80eaf26ec0b8828cb0d6164686263f65cdd527e3, date=2021-10-28 20:00:37

blazersEvan : passed basic,date,update,select-meta,aggregation-func,drop-table,insert,unique, commit id=506b2ad7be4d0940c2c5fd632fba91f469f739d2, date=2021-10-29 00:23:45

pppy2012 : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=57c65b82e15368cc0f7ed1db1bf73b2d006e011b, date=2021-10-29 09:40:37

JayL-zxl : passed basic,update,select-meta,drop-table,insert,unique, commit id=7296e9542d429f9f7425f29de2179b7935bb5698, date=2021-10-29 10:54:54

Issac-Newton : passed basic, commit id=285806d9778e553136781a3d784488ac9afaa532, date=2021-10-28 22:00:42

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

Godroser : passed basic,update,drop-table, commit id=4ddcb07104a203269e5e14e50ba715c80dfaf025, date=2021-10-28 23:40:26

Mikan-Team : passed basic, commit id=f2f32ddc7f51a7351f17fe3d61064a095de7050b, date=2021-10-28 22:52:35

Coding-Hammer : passed basic,update,select-meta,drop-table, commit id=59ed9c078034b6b106747f16ddf8a751bd60072d, date=2021-10-29 09:57:21

Galaxy0106 : passed basic,update,select-meta,select-tables,drop-table, commit id=2e7de7fa37fcb00166614cf0a28351f8ecd1aec0, date=2021-10-29 11:02:51

CardinalGuo : passed basic,select-meta,drop-table, commit id=in, date=2021-10-28 23:09:42

RucHyy : passed basic,select-meta,drop-table, commit id=8eb2cc5ae57baf5d769584ac2c72771eab09bc60, date=2021-10-29 00:38:42

waterme7on : passed basic,select-meta, commit id=64d18dfab4750ad8feeaf0c8f14a73101afd5550, date=2021-10-28 22:41:13

obmustac : passed basic,date,update,select-meta,drop-table, commit id=6b91a7ff6b68dc7ecb465b2926de4aeb668bf2f6, date=2021-10-29 01:16:49

linweiwei : passed basic,update,select-meta,drop-table, commit id=d5d5b93050c2291576c903cba4ebf384c1204cdf, date=2021-10-28 22:57:00

ifIAmADJ : passed basic,select-meta,drop-table, commit id=6338e8ab0f8c6306f94585a7fb4a88e423a8c548, date=2021-10-28 21:54:25

watchpoints : passed basic,update,select-meta,drop-table, commit id=ee074f998cb80ed9fde47663b0ca1ef9a19f8a50, date=2021-10-29 03:54:36

cyhw : passed basic,select-meta, commit id=36ddea4ddbec4ae9bb5998588251b8db1e7bdfdb, date=2021-10-28 23:23:44

TaurusGGBOY : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,order-by, commit id=637d22a62674723053df77d3f44d466f028b94a7, date=2021-10-29 00:26:25

[宁封]

RUC-Seed-No-59 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=1fc3fc0ce0a3ee85cdbb660ace08465fddd6f02b, date=2021-10-29 11:07:48

hbangq : passed basic,date, commit id=fe86269c53325d0c5781760d58e29888bd03da9f, date=2021-10-29 10:42:43

JameyWoo : passed basic,date,update,select-meta,select-tables,drop-table,insert,order-by, commit id=e5120cba5d5bee079633bad86352d639befc1240, date=2021-10-28 21:45:04

DBChat-OB : passed drop-table, commit id=046b358ce4bb7dca37327cfcc9d03982b8516fba, date=2021-10-28 22:06:08

HaoHaoTaTa : passed basic,update,select-meta,drop-table, commit id=b24ae5058af2f6eeef332f274cfc8c1d2f7a85b5, date=2021-10-29 06:54:40

ligen131 : passed basic, commit id=d70b93708e64a352b7d482fcf071adad420abc21, date=2021-10-28 23:55:00

Ethanzjp : passed basic,update,select-meta,drop-table, commit id=7eea5b30a7d8860e259d5a6c760ecd4e78b08953, date=2021-10-28 22:06:47

tanruixiang : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=db522fdcdcae40dce551d4cff395823422abbbf7, date=2021-10-28 21:48:12

WangAShao : passed basic,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,null,unique, commit id=5b3d8a8a20c97f48509567ff7d6c6c0a91b6e769, date=2021-10-29 10:22:06

I-m-so-sorry-for-come-to-ZJU : passed update,select-meta,drop-table, commit id=93fba9499a59db91d089275af4aa65f4d9728c98, date=2021-10-29 09:44:07

HUST-DDDD : passed basic,update,select-meta,select-tables,drop-table,insert, commit id=02954acc524fc827df33fbc1e54e79bd0cc3d811, date=2021-10-28 21:27:49

mikan-team : passed basic, commit id=f2f32ddc7f51a7351f17fe3d61064a095de7050b, date=2021-10-28 22:52:35

jaingmengmeng : passed basic,update,select-meta,select-tables,drop-table,join-tables, commit id=f4e2049bc52a4fa4906cfb463902e22c45d65a3f, date=2021-10-29 09:46:43

randxie : passed basic,update,select-meta,drop-table, commit id=1420aef2d6e03ce64e6af23fc3b3ea417656ba27, date=2021-10-29 07:36:41

lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique, commit id=349528b7e019d9f2964febb9f3f557a4cc0b441e, date=2021-10-28 21:33:04

WebsterEndymion : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=efe4850f89168001894f23d8a75af18274196ac1, date=2021-10-28 22:46:24

zhengbumingbai : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,multi-index, commit id=bea65e81a30a02d0f8571b1d1366edca7b3d547f, date=2021-10-29 10:04:25

yangzecai : passed basic,date,update,select-meta,select-tables,drop-table,join-tables, commit id=a079c1d6dd8f6b4efcb002fe68709b98beadd96a, date=2021-10-28 22:01:15

[laosanchen]

来哥，麻烦看一下zhengbumingbai 的NULL错再哪了

[曾经沧海]

来哥，麻烦看一下https://github.com/DATA-IS-POWER/miniob，在增量名单上但没结果？

[宁封]

wangqiim : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique, commit id=3c49becde58781ee3bc8b939e61fbc78327e871a, date=2021-10-28 20:51:18

watchpoints : passed basic,update,select-meta,drop-table, commit id=ee074f998cb80ed9fde47663b0ca1ef9a19f8a50, date=2021-10-29 03:54:36

obcontest : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,join-tables,unique, commit id=b48418143b0784716392655beef473fbc5089fd9, date=2021-10-29 11:11:47

dongzeyu : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=8526f6aa326cd2eb84f5d49b53580b13a07edb96, date=2021-10-29 11:33:45

[宁封]

SELECT NULLTABLE.NUM,NULLTABLE2.NUM,NULLTABLE.BIRTHDAY FROM NULLTABLE,NULLTABLE2 WHERE NULLTABLE.NUM=NULL_TABLE2.NUM;

18 | 18 | 2020-01-01

NULL | 18 | 2010-01-11

NULL | NULL | 2010-01-11

NULLTABLE.NUM | NULLTABLE2.NUM | NULL_TABLE.BIRTHDAY

[宁封]

DATA-IS-POWER 0 In file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basicstring.h:6400,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/string:52,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/localeclasses.h:40,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/iosbase.h:41,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:42,\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/DATA-IS-POWER/miniob/src/observer/sql/executor/executestage.cpp:17:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h: 在函数‘Ret gnucxx::stoa(TRet ()(const CharT, CharT, Base ...), const char, const CharT, std::sizet, Base ...)’中:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h:84:25: 错误：‘ERANGE’在此作用域中尚未声明\nelse if (errno == ERANGE\n^~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h:84:25: 附注：suggested alternative: ‘EBADE’\nelse if (errno == ERANGE\n^~\nEBADE\nIn file included from /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/basicstring.h:6400,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/string:52,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/localeclasses.h:40,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/bits/iosbase.h:41,\nfrom /test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ios:42,\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/DATA-IS-POWER/miniob/src/observer/sql/executor/executestage.cpp:17:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h: 在函数‘Ret gnucxx::stoa(TRet ()(const CharT, CharT, Base ...), const char, const CharT, std::sizet, Base ...)’中:\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h:84:25: 错误：‘ERANGE’在此作用域中尚未声明\nelse if (errno == ERANGE\n^~\n/test/dask/gcc-bin-8.3.0/include/c++/8.3.0/ext/stringconversions.h:84:25: 附注：suggested alternative: ‘EBADE’\nelse if (errno == ERANGE\n^~\nEBADE\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observer.dir/sql/executor/executestage.cpp.o] 错误 1\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] 错误 2\nmake[1]: 正在等待未完成的任务....\n编译中止因为 -fmax-errors=1。\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/sql/executor/executestage.cpp.o] 错误 1\nmake[2]: 正在等待未完成的任务....\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] 错误 2\nmake: *** [all] 错误 2\n

[pppy2012]

老师麻烦帮看一下select-tables

https://github.com/pppy2012/miniob

[watchpoints]

date没有测试过,看来还有问题,麻烦看一下 哪里没通过 https://github.com/watchpoints/miniob

在索引下部分测试

miniob > update t set birthday="2021-11-11" where birthday="2021-11-11";

SUCCESS

miniob > select * from t where birthday ="2021-11-11";

id | age | name | birthday

2 | 33 | a | 2021-11-11

miniob > update t set  birthday ="2021-11-11";

SUCCESS

miniob > select * from t where birthday ="2021-11-11";

id | age | name | birthday

1 | 11 | a | 2021-11-11

2 | 33 | a | 2021-11-11

[ligen131]

来哥能否帮忙看看drop-table哪个case挂了？https://github.com/ligen131/miniob

[周小伦]

https://github.com/JayL-zxl/miniob 来哥麻烦看看data、笛卡尔积、还有聚合。。我们本地已经修改了三四天了。。实在找不到问题了谢谢

[周小伦]

date

[lvskiller]

HUST-DDDD : passed basic,update,select-meta,select-tables,drop-table,insert, commit id=02954acc524fc827df33fbc1e54e79bd0cc3d811, date=2021-10-28 21:27:49

为啥这个的date还有聚合函数都挂掉了，不是说只有测了前面的才测后面的吗

[江流洋]

老师能帮忙看一下jaingmengmeng的inserts插入多条哪个case没过吗？

[lyxiong]

https://github.com/dongzeyu/miniob

请问我们的null是哪里有问题呢

[努力成为专业人士]

麻烦前辈帮忙看下JameyWoo聚合和null哪里有问题，之前聚合是过的，看样子是加了null把聚合给干掉了

[duneann]

https://github.com/rainays/OceanBase-competition 麻烦看一下为啥在增量名单但是没有，是编译没过吗

[Gone222]

你好！能帮我们看看ordey by的问题吗？谢谢啦  https://github.com/obcontest/miniob

[宁封]

 67 SELECT * FROM SELECTTABLES1,SELECTTABLES2,SELECTTABLES3 WHERE SELECTTABLES1.UNAME=SELECTTABLES2.UNAME AND SELECTTABLES2.UNAME=SELECTTABLES3  .UNAME;

 68 1 | 18 | A | 1 | 20 | A | 1 | 35 | A

 69 1 | 18 | A | 1 | 20 | A | 2 | 37 | A

 70 1 | 18 | A | 2 | 21 | C | 1 | 35 | A

 71 1 | 18 | A | 2 | 21 | C | 2 | 37 | A

 72 2 | 15 | B | 1 | 20 | A | 1 | 35 | A

 73 2 | 15 | B | 1 | 20 | A | 2 | 37 | A

 74 2 | 15 | B | 2 | 21 | C | 1 | 35 | A

 75 2 | 15 | B | 2 | 21 | C | 2 | 37 | A

[宁封]

INSERT INTO DATE_TABLE VALUES (13,'2017-11-31');

SUCCESS

SELECT * FROM DATETABLE WHERE UDATE='2017-11-31';

ID | U_DATE