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

社区活动 OceanBase 数据库大赛
#1

xxcisxxc : passed basic

kustcn : passed basic

mattisonchao : passed basic

IwfWcf : passed basic

HNUDLG : passed basic

hbangq : passed basic

HaoHaoTaTa : passed basic

FrankSzn : passed basic

My-OB-contest : passed basic

YANGGMM : passed basic

nnnnYue : passed basic

yunxu1630 : passed basic

An-DJ : passed basic

hzmciu : passed basic

DBChat-OB : passed basic

rehoboan : passed basic

wangqiim : passed basic,select-meta,drop-table

DATA-IS-POWER : all cases failed

conghuhu : passed basic

ccat3z : passed basic

pukun123 : passed basic

Maizesty : passed basic

AR-Wang : passed basic

Lodisaq : passed basic

S-1-T : passed basic,update,select-meta,drop-table

kangxiaoyan : passed basic

sciengineer-97 : passed basic

MoYuOB2021 : passed basic

yangzecai : passed basic

EmperorNiu : passed basic,select-meta

moxiaoling : passed basic

infdahai : passed basic

xiaoyong-z : passed basic

zjx1230 : passed basic

kustcn : passed basic

dongzeyu : all cases failed

watchpoints : passed basic,drop-table

ztygreat : passed basic

ztmail723 : passed basic

jaingmengmeng : passed basic

Windsrain : passed basic

He-XiaoLong : passed basic

httdty : passed basic

ligen131 : passed basic

blacksungrass : passed basic

Kaimary : passed basic

Sunday361 : passed basic

DBRookie : passed basic

waterme7on : passed basic

ybzxw : passed basic

zcysky : passed basic

miniOBgroupdase106 : passed basic

LLThomas : passed basic

yanchaomei : passed basic

obcontest : passed basic,update,select-meta,drop-table

bill-ginger : passed basic

zcysky : passed basic

pukun123 : passed basic

b41sh : passed basic

supmaster : passed basic

TomSms : passed basic

JameyWoo : passed basic,select-meta,drop-table

YANGGMM : passed basic

ptbxzrt : passed basic,update,select-meta,drop-table

nsedb : passed basic

obmustac : passed basic

Xinlong-Chen : passed basic

ycdzj : passed basic

JayL-zxl : passed basic

tssunjingwu : passed basic,drop-table

cnissnzg : passed basic

lmjhh : passed drop-table

TaurusGGBOY : passed basic,drop-table

shulanglhh : passed basic

ChaonanShen : passed basic,drop-table

RucOBTeamGo : passed basic,drop-table

XLC-2 : passed basic

raygift : passed basic

MerickBao : passed basic

miniODB : passed basic

SmokeyDays : passed basic

LightingMax : passed basic

fkuner : passed basic

18703486960 : passed basic

WHUPRJ : passed basic

gutousu : passed basic

Whorra : passed basic

YRREALLYCUTE : passed basic

KurisuSaber : passed basic

Alaska12719 : passed basic,drop-table

BaymaxHWY : passed basic

coding4a : passed basic

Issac-Newton : passed basic

MoCuishle28 : passed basic

DUXUCHONG : passed basic

BanBuDu0 : passed basic,select-meta

sourmi12k : passed basic

zhibin-huang : passed basic

Zouxxyy : passed basic

NKU-EmbeddedSystem : passed basic,select-meta

#2

OceanbaseContest : passed basic

ztmail723 : passed basic

ifIAmADJ : passed basic

sandexp : passed basic

zgqball : passed basic

Cerdore : passed basic

ChiangYintso : passed basic

zhiyang0310 : passed basic

TSFHD : passed basic

KenSporger : passed basic

yankaics : passed basic

hnjylwb : passed basic

wzru : passed basic

yangwuuu : passed basic

RucHyy : passed basic

cnissnzg : passed basic

FullTimeOB : passed basic

caizj : passed basic,drop-table

rawmaterials223 : passed basic

Smith-Cruise : passed basic

tianjinchengjian : passed basic

Morgan279 : passed basic

mark15217 : passed basic

ecnu-db-tianchi : passed basic

TrueAbc : all cases failed

mowang111 : passed basic

RUC-Seed-No-59 : passed basic,update

jizhongzhiji : passed basic

randxie : passed basic

Paoluers : passed basic

eatmans : passed basic

5d1207 : passed basic,update,select-meta,drop-table

Charlie17Li : passed basic

clark1013 : passed basic

aijianchi : passed basic,drop-table

pppy2012 : passed basic

raygift : passed basic

lhcmaple : passed basic,select-meta,drop-table

QQQQQu : passed basic

FLAYhhh : passed basic

wzr3016 : passed basic

J0kerMh : passed basic,drop-table

CaiChenshu : passed basic

Wheeeel : passed basic

Godroser : passed basic

MugenU : passed basic

luooofan : passed basic

blazersEvan : passed basic,update,select-meta,drop-table

XorSum : passed basic

Super-long : passed basic,select-meta,drop-table

PaJir : passed basic

lovelynewlife : passed basic

lusuon : passed basic

123liuziming : passed basic

lusuon : passed basic

name1e5s : passed basic,select-meta,drop-table

Joycepy : passed basic

zhoulaiqing : passed basic,update,drop-table

obcontest : passed basic,update,select-meta,drop-table

DeepZheng : passed basic

ysj1173886760 : passed basic

sWildGold : passed basic

tanruixiang : passed basic,update

Zhangjiabangpan : passed basic

StephenYany : passed basic

landnow : passed basic

tyn1998 : passed basic

HUSTERGS : all cases failed

zhengbumingbai : passed select-meta

Angelia-Wang : passed basic

TLZKSKS : passed basic

Xylitol415 : passed basic

agoodjuice : passed basic,select-meta,drop-table

SGZW : passed basic

Obscurepawn : passed basic

DogDogTeam : passed basic

mooleetzi : passed basic

yunxu1630 : passed basic

He-XiaoLong : passed basic

UUUnmei : passed basic

Leozki : passed basic

bbbearxyz : passed basic

1170300105 : passed basic

xiaoliou008 : passed basic

Obscurepawn : passed basic

sohardforaname : passed basic

PTTQ : passed basic

Moonm3n : passed basic

1 个赞
#3

编译失败：


mba1398 0 CMake Error at CMakeLists.txt:70 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "deps" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:71 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "src" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:72 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "unitest" which is not an existing directory.\n\n\nCMake Error at CMakeLists.txt:73 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "test" which is not an existing directory.\n\n\n

masternow 0 CMake Error at CMakeLists.txt:71 (ADDSUBDIRECTORY):\nADDSUBDIRECTORY given source "src" which is not an existing directory.\n\n\n

StrikeW 0 /test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp: In member function ‘RC Table::recordupdatercb(Record, void)’:\n/test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp:567:10: error: ‘memcpy’ is not a member of ‘std’\nstd::memcpy(record->data + fieldoffset, param->value->data, fieldlen);\n^~\n/test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp:567:10: note: suggested alternative: ‘memfn’\nstd::memcpy(record->data + fieldoffset, param->value->data, fieldlen);\n^~\nmemfn\nmake[2]: [src/observer/CMakeFiles/observer.dir/storage/common/table.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\n/test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp: In member function ‘RC Table::recordupdatercb(Record, void)’:\n/test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp:567:10: error: ‘memcpy’ is not a member of ‘std’\nstd::memcpy(record->data + fieldoffset, param->value->data, fieldlen);\n^~\n/test/dask/test-tmp/StrikeW/miniob/src/observer/storage/common/table.cpp:567:10: note: suggested alternative: ‘memfn’\nstd::memcpy(record->data + fieldoffset, param->value->data, fieldlen);\n^~\nmemfn\nmake[2]: [src/observer/CMakeFiles/observerstatic.dir/storage/common/table.cpp.o] Error 1\nmake[2]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake[1]: Waiting for unfinished jobs....\nmake[1]: [src/observer/CMakeFiles/observerstatic.dir/all] Error 2\nmake: [all] Error 2\n

LeeQueue513 0 CMake Error at cmake/Env.cmake:109 (message):\nCOMPILER NOT FOUND\nCall Stack (most recent call first):\nCMakeLists.txt:4 (include)\n\n\n

#4

可以再帮我测试一下吗? 我发现我白天给date和update fix的几个bug忘了push上去了, 谢谢~ 刚刚忘了放链接: https://github.com/JameyWoo/miniob


#5

https://github.com/lhcmaple/miniob

update，增加date字段，多表

#6

可以麻烦老师帮我看一下select-meta吗，我感觉好像select，from，where后面的表和列都考虑到了？https://github.com/J0kerMh/2021OB

#7

看起来还是core了。校验where 条件中的字段的时候。

#8

前辈您好，能麻烦看看https://github.com/ChaonanShen/miniob的select-meta和update的问题吗？多谢！

#9

你们怎么判断的 where 条件不存在？

比如这种有没有考虑

select * from t where notexistscols='234';

#10

JameyWoo : passed basic,update,select-meta,drop-table


正文数据就不更新了

#11

select-meta 参考一下 5楼的问题，你们的问题看起来是一样的。

#12

好的, 谢谢

#13

update问题考虑一下使用一种类型的值更新另一种类型字段的问题

#14

老师麻烦帮忙看下drop table

https://github.com/pppy2012/miniob

#15

select-meta:评测没通过，请给出一个case吗？哪里没通过，自己能想到的例子都想到了？

#16

这个是什么意思，where 条件里 没有匹配的内容 要返回失败吗？

#17

老师好，是有的呢~

#18

问：miniob > select * from t where t.id=100; 假如 i=100每个这个记录 返回失败吗？默认返回的 只有列 ，没有内容

#19

能帮忙跑一下https://github.com/lmjhh/MiniOB吗

#20

老师您好，可以帮忙再测一下https://github.com/DATA-IS-POWER/miniob嘛，下午忘push了，谢谢！