OceanBase 大赛测试结果- 2021/11/01 下午 增量

[宁封]

sourmi12k : all cases failed, commit id=6a56fe5c72b37f8830f3fe73c551c1ea6acf3abd, date=2021-11-01 14:17:39

BanBuDu0 : passed basic,update,select-meta,drop-table, commit id=0483ae377a4a2d09e45bb923870244c2a3f5536e, date=2021-11-01 14:48:28

fkuner : passed date,update,drop-table,insert, commit id=d4ac2bcbca49d4694607f0d920d9445b6a0bb7d2, date=2021-11-01 09:51:35

PaJir : passed basic,date,update,select-meta,select-tables,drop-table, commit id=f3b599193fb788a6596cf9d297cf8feabe051ebb, date=2021-11-01 12:17:29

Sunday361 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,group-by, commit id=2c25c95161633805ce1fed74846efe895818702f, date=2021-11-01 15:16:48

rainays : passed basic,date,update,select-meta,aggregation-func,drop-table,insert,unique, commit id=07428e2cdfb4de9ce4208763d39e20bc2afc7909, date=2021-11-01 11:27:07

caizj : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,multi-index,order-by,group-by, commit id=fdad7575bb9e03779fb82ef4ae26d5b6fb748587, date=2021-11-01 12:25:42

Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by,group-by, commit id=2708b43e7833b777a0b801925d5af0b92e2400d6, date=2021-11-01 14:28:33

Windsrain : passed basic,update,select-meta,drop-table, commit id=0dcb06526017f52a17c36e7eee08d46a8824b1bd, date=2021-11-01 14:58:08

nautaa : passed basic,date,update,select-meta,drop-table, commit id=c6e337527904e1009ada92c2c1b4302a98c30496, date=2021-11-01 12:05:13

Ichasethesun : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,order-by,group-by, commit id=a01483b7333eff3e39fdc1072b9835da2392b297, date=2021-11-01 14:55:26

zjx1230 : passed date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,order-by, commit id=ac5a43f9fad10a80b5c4b96ec7726fb8df9620f8, date=2021-11-01 13:23:52

watchpoints : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=474f2f22b69f2bdd52bb14e519158278eb25e720, date=2021-11-01 15:30:45

TaurusGGBOY : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,order-by, commit id=24537bad2b355d2c09f650e1f06e7db021aead94, date=2021-11-01 14:00:40

dongzeyu : passed date,update,select-meta,aggregation-func,drop-table,insert,unique,order-by,group-by, commit id=c80152a83d6a9d25c5985b8c2c3700bdd5f6edb6, date=2021-11-01 09:57:11

HUSTERGS : passed basic, commit id=0fcac56cbaf172d11db036eb1e0f30c18db0404f, date=2021-11-01 10:57:38

My-OB-contest : passed date,select-meta,drop-table,insert,unique, commit id=3feeb2b0edca6b358827542276295cc1d4c90f1f, date=2021-11-01 15:33:58

penggan666 : passed basic,date,update,select-meta,drop-table, commit id=1396236f0457e9b4d5ffe60e5c5ed3375e10f255, date=2021-11-01 10:24:53

lmjhh : passed basic,date,select-meta,drop-table, commit id=8c1c6984daf44701aa566416d4d054bef3bfcab3, date=2021-11-01 15:24:22

Kaimary : passed basic,update,select-meta,drop-table, commit id=a9fdf9494bdc9f613286fafbb0c6a376b2b9ab5b, date=2021-11-01 14:53:08

obcontest : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by, commit id=c7be419b08613eafcabbcfd82426091be406b784, date=2021-11-01 11:32:43

linweiwei : passed basic,update,select-meta,drop-table, commit id=4466ab6e47f42cbb10f86e4012b36bf1e32b4e3e, date=2021-11-01 09:52:57

abaaba-OB : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=27830177e71e3be9c37d9fe48538f2502e2b8cbe, date=2021-11-01 13:51:15

Panlisong : passed basic,select-meta,drop-table,join-tables, commit id=157b3753560ceb7f8c592c7d4547f8bd1b0bc909, date=2021-10-29 22:23:51

idvzchusvol : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=5df590cdb7173a9d6938caf5c3deb05ba24e3c85, date=2021-11-01 12:33:17

HUST-DDDD : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=68b5fcc9bb3f54ab6a90050c6d9afce4fb97794f, date=2021-11-01 15:29:38

[宁封]

uniqueFranky : passed basic,select-meta,drop-table, commit id=f0b44348f65d7f4e1e328d395657238345ef28ad, date=2021-11-01 13:11:08

Moonm3n : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=d59f99dba2df0247efec08df52d6a720bb6b20e4, date=2021-11-01 14:12:09

Maizesty : passed basic,date,update,select-meta,drop-table, commit id=338513910eb05db5433811b66aaf666fe45721bf, date=2021-11-01 11:36:58

jaingmengmeng : passed basic,date,update,select-meta,select-tables,drop-table,insert,join-tables,order-by, commit id=eaa76ec6c11d172fb00bee838a5084e3d66d87db, date=2021-11-01 13:05:35

Whorra : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique,order-by, commit id=efcff5a23c8f643e7348b5e06bb60254673ad673, date=2021-11-01 12:20:56

XorSum : all cases failed, commit id=03dfe2afceb3bc4d1124b7071c97e2f76af630f5, date=2021-11-01 09:03:51

DBChat-OB : passed basic,select-meta,drop-table, commit id=1c48d987f8fc1691ad8d7b0545da44076077487c, date=2021-11-01 14:49:07

Galaxy0106 : passed basic,update,select-meta,select-tables,drop-table, commit id=fa3c87c96ba3e673ca77eb54678aa38efdd3fd09, date=2021-11-01 11:27:20

JameyWoo : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,order-by, commit id=275e38f9fdb57c37e0a576ceb1457a9d23350f9c, date=2021-11-01 11:14:29

WebsterEndymion : passed basic,date,update,select-tables,aggregation-func,insert,join-tables,unique, commit id=4e10f28b73919d4b798966377e7ac1be78b7cdb1, date=2021-11-01 12:04:57

JayL-zxl : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique, commit id=9a8b19c0608e1e7bcdc19867f8f7fafe33ff6b34, date=2021-11-01 14:16:18

ccat3z : passed basic,date,update,select-meta,select-tables,drop-table, commit id=bc457dba08b2c7175a88b2f6b67901420812cb53, date=2021-11-01 10:09:09

RUC-Seed-No-59 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=750623181440ec0377c05363bf52ac2b197bb1d4, date=2021-11-01 07:56:06

bbbearxyz : passed basic,date,update,select-meta,drop-table, commit id=2ede7dcf8e2be339ce572af1532d685dcc8e37f9, date=2021-11-01 13:10:43

lhcmaple : passed basic,date,update,select-meta,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=19c2cd5c9e6249d33898baa99ca5fc93d2d8ad05, date=2021-11-01 11:18:53

5d1207 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by, commit id=0488f8a97aa6cdc12dc4a091d18484f977ac788f, date=2021-11-01 11:17:32

[江流洋]

想请问一下jaingmengmeng的聚合函数哪个case没过？

[Sudazzle]

idvzchusvol  老师可以帮忙看看null为什么没过吗

[ddz]

老师，没看到我们HoniiTro19

[zjx_coder]

https://github.com/zjx1230/miniob, 老师，麻烦看一下basic是哪个地方没过

[破晓]

老师帮忙看一下，inner join有什么问题吗？哪个case出问题了？

地址：https://github.com/Whorra/OurBase.git

[水饺包]

Sunday361 texts还是因为最后select没有返回值嘛？

[李浩]

运来大哥，可以帮忙看一下超长字段出现什么问题了吗？想看看输出

https://github.com/5d1207/pushd.git

[tzh]

来哥帮忙看下我们的null怎么还没过JayL-zxl

[watchpoints]

问：join-table 

• 需要考虑三个表联合查询
• 和select t1.*,t2.age from t1,t2 where t1.id =t2.id; 多查询一个t2.id 字段应该不合法吧？

这2个case吧？

[周小伦]

老师帮忙看一下 date出什么问题了https://github.com/JayL-zxl/miniob 

孩子真的急死了😭

[pengtianxiang]

老师能帮忙看下聚合操作哪个case过不了吗，谢谢！

https://github.com/NKU-EmbeddedSystem/miniob

[zjx_coder]

https://github.com/zjx1230/miniob,为啥英雄榜看不到我的队，之前还有的

[宁封]

SELECT AVG(NUM) FROM AGGREGATION_FUNC;

没有返回结果

[lyxiong]

老师，请问一下dongzeyu的多表和inner join是哪里出问题了呢

[维度]

老师你好，我想问一下我的date测试为什么没过？账号是 linweiwei

[宁封]

SELECT MIN(NUM) FROM NULL_TABLE3;

MIN(NUM)

2147483647

SELECT MAX(NUM) FROM NULL_TABLE3;

MAX(NUM)

-2147483648

应该返回NULL的。

[uniqueFranky]

老师，我想问下update的思路是什么啊？我试了先delete record再insert record，但这样索引好像会出现问题

[宁封]

Consolidate compiler generated dependencies of target observer

[ 48%] Building CXX object src/observer/CMakeFiles/observer.dir/storage/common/meta_util.cpp.o

/test/dask/test-tmp/HoniiTro19/miniob/src/observer/storage/common/metautil.cpp: 在函数‘bool checkdate(char*)’中:

/test/dask/test-tmp/HoniiTro19/miniob/src/observer/storage/common/meta_util.cpp:26:11: 错误：‘strlen’在此作用域中尚未声明

  int n = strlen(str);

      ^~

/test/dask/test-tmp/HoniiTro19/miniob/src/observer/storage/common/meta_util.cpp:26:11: 附注：‘strlen’ is defined in header ‘<cstring>’; did you forget to ‘#include <cstring>’?

/test/dask/test-tmp/HoniiTro19/miniob/src/observer/storage/common/meta_util.cpp:15:1:

+#include <cstring>

/test/dask/test-tmp/HoniiTro19/miniob/src/observer/storage/common/meta_util.cpp:26:11:

  int n = strlen(str);

      ^~

编译中止因为 -fmax-errors=1。