OceanBase 大赛测试结果 - 2021/10/25 上午

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

AR-Wang : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

BaymaxHWY : passed basic, commit id=285dd75974567cdfb4cfb35675130715a9e279d9, date=Fri Oct 22 22:32:00 2021 +0800

Alaska12719 : passed basic,select-meta,drop-table, commit id=ac4a891df069aab7d6da2f078a5589708d2ce569, date=Sun Oct 24 20:02:05 2021 +0800

BanBuDu0 : passed basic,select-meta,drop-table, commit id=aeead45f732c693a4907850ca53279822bd8d25a, date=Sun Oct 24 15:56:50 2021 +0800

antsuge : passed basic, commit id=2387a2aa2aa49e9c8bca43e4258258855a1b6ef8, date=Sat Oct 23 10:11:35 2021 +0800

b41sh : passed basic,update, commit id=44b092ab2647796548b4361752428d0ccc8fda0a, date=Sun Oct 24 23:26:35 2021 +0800

ADExxxxxx : passed basic, commit id=e2cfb0fb06ffeca6a5e5c17cd46bbb20e950fb07, date=Thu Oct 21 13:22:13 2021 +0800

Angelia-Wang : passed basic, commit id=cc60ebe7b0208622cd0edcf97f000bac22b8aeb1, date=Fri Oct 22 13:47:08 2021 +0800

awfeequdng : passed basic, commit id=fa8dfc2c1d8cd147cc85b76ab58f5cabe1658e29, date=Sun Oct 24 13:38:08 2021 +0800

agoodjuice : passed basic,update,select-meta,drop-table, commit id=4e683d838faaf8687a2779d4f5ecdccf29863fab, date=Sun Oct 24 16:18:23 2021 +0800

abietic : passed basic, commit id=0bb12f1faf3dee89a4b4f7113faff4b51951575d, date=Wed Oct 20 21:42:32 2021 +0800

An-DJ : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

abaaba-OB : passed basic,select-meta, commit id=51f1af370c62bb55ae46066323f59c37a4669074, date=Sun Oct 24 21:00:46 2021 +0800

1170300105 : passed basic, commit id=6ccb805b13b7b48c7fc953669846ccf23008be25, date=Sun Oct 17 21:22:11 2021 +0800

aijianchi : passed basic,drop-table, commit id=5767508cf8b8a511c14ce58d06099044b32fe96a, date=Fri Oct 22 10:19:37 2021 -0700

123liuziming : passed basic, commit id=1c72da28df1990f8f24a04e12285e59d9375bbf4, date=Tue Oct 19 21:32:10 2021 +0800

5d1207 : passed basic,update,select-meta,drop-table, commit id=1e2d4d042f58db394d8dc94caefab895e940f94d, date=Mon Oct 25 09:15:52 2021 +0800

18703486960 : passed basic,drop-table, commit id=6a5ced0117838e7ed2efdcd4f9a5af581e37d5b0, date=Sun Oct 24 23:36:44 2021 +0800

LightingMax : passed basic, commit id=b2e3b52b51e255e77c96af14b0fd5ea9f76d5869, date=Mon Oct 18 22:32:17 2021 +0800

ligen131 : passed basic, commit id=bdd4885909759d49484c5fd9a7c60206b631eef9, date=Wed Oct 20 13:53:05 2021 +0800

linweiwei : all cases failed, commit id=f73bf2dc2e306c791cdebf102e6c2a163290bf67, date=Sun Oct 24 20:26:15 2021 +0800

kangxiaoyan : passed basic, commit id=646edce1feb77e37e9e9c79581f6068065b7cbcd, date=Mon Oct 18 00:33:01 2021 +0800

landnow : passed basic, commit id=de3f87a4717545a7d69072d8c95aed2b7c79ee66, date=Sat Oct 16 18:48:29 2021 +0800

kustcn : passed basic, commit id=a64b36e5902cfcfcf66582ad203590847b258002, date=Fri Oct 15 22:03:06 2021 +0800

jizhongzhiji : passed basic, commit id=3d7ff13f4d24fcc395a023371881a8e47bcf1519, date=Fri Oct 15 23:02:47 2021 +0800

KenSporger : passed basic, commit id=2229764884fcc4509e8e1a0c5988fc3d99c2efba, date=Wed Oct 20 09:52:44 2021 +0800

Joycepy : passed basic, commit id=6326e873f134ab011445473109c73c9dade0f301, date=Sun Oct 24 04:49:43 2021 -0700

jaingmengmeng : passed basic,update,select-meta,drop-table, commit id=e8591c944971529c029768ea9720915fa3cf1f0c, date=Sun Oct 24 15:35:38 2021 +0800

jiliang0 : passed basic, commit id=e358a00faa1a105524f0d2efe83a611ab8e0f1ab, date=Sun Oct 24 22:41:40 2021 +0800

JayL-zxl : passed basic,update,drop-table, commit id=382624562701bb1e9b94fcac98d901dc94f2e1ad, date=Sun Oct 24 15:48:41 2021 +0800

2 个赞
#2

IwfWcf : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

J0kerMh : passed basic,select-meta,drop-table, commit id=3694f21fa3403113176a69da5966c57b66288441, date=Mon Oct 25 00:18:31 2021 +0800

infdahai : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

I-m-so-sorry-for-come-to-ZJU : passed basic, commit id=1b61b1f9f6dbd4b768aa48f10a7c9309bacd3c43, date=Sat Oct 23 12:10:48 2021 +0800

hzmciu : passed basic, commit id=d0c2d14bd6366088fbf7537f6c7526be52fafeed, date=Sun Oct 17 14:04:55 2021 +0000

ingdex : passed basic, commit id=333cf8b87f0cfc1392767e03e992b314db77fd66, date=Thu Oct 21 11:48:51 2021 +0800

ifIAmADJ : passed basic, commit id=05f5d38977b97ea1383a434feaecdf77012ba1fb, date=Fri Oct 22 23:41:17 2021 +0800

Escapekk : passed basic, commit id=efc4572c710b9f313ae4a9bf8cf87127ce69dcc3, date=Fri Oct 22 01:42:20 2021 +0800

caizj : passed basic,date,update,select-meta,select-tables,drop-table, commit id=c614f136f7a315c6eea5a52c075654ba41c17a87, date=Fri Oct 22 13:12:30 2021 +0800

fkuner : passed basic,update,drop-table, commit id=a7f41379ddbcacb97db2d3ffd6af15f7ec3e8b60, date=Mon Oct 25 10:49:12 2021 +0800

HumbleHunger : passed basic, commit id=9b6fc757100fdd2b70c247c5cb5d7af3af87800b, date=Sun Oct 24 19:10:31 2021 +0800

FullTimeOB : passed basic, commit id=5bb376790ff46b4b2a5d3be1c86806fb886457db, date=Sun Oct 24 17:25:58 2021 +0800

Galaxy0106 : passed basic,drop-table, commit id=d4b53e5ee2d2005d667c23eae1de01fbed864185, date=Sat Oct 23 18:13:13 2021 +0800

JameyWoo : passed basic,date,update,select-meta,select-tables,drop-table, commit id=cd890015f080021b874831ab81413f06528c9e1c, date=Sun Oct 24 15:01:35 2021 +0800

freetmf : passed basic, commit id=c1764f22eded281995de70431a7f5e74eab0cca7, date=Thu Oct 21 15:22:03 2021 +0800

ChiangYintso : passed basic, commit id=2def07ac069546c08b5f3d28d7ade5fc08a1d2dd, date=Sat Oct 16 14:10:23 2021 +0800

blazersEvan : passed basic,update,select-meta,drop-table, commit id=7261f586b7143b559e421466df1cde3664e0c6d3, date=Fri Oct 22 01:38:33 2021 +0800

CaiChenshu : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

DogDogTeam : passed basic, commit id=c4370fb12a59666e8d9e5d0f75ce58205541e15f, date=Fri Oct 15 20:44:25 2021 +0800

ccat3z : passed date,update,drop-table, commit id=7bf93a0abc92f4c11f95650b3af7595daff5976b, date=Mon Oct 25 00:53:13 2021 +0800

blacksungrass : passed select-meta,drop-table, commit id=b31eaef2ebaadd69944dcebf891989ec420e9f6d, date=Sat Oct 23 10:54:51 2021 -0400

Coding-Hammer : passed basic, commit id=95b06658ff58b3f2a056425828258a1e438be0f4, date=Fri Oct 22 22:15:54 2021 +0800

He-XiaoLong : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

hnjylwb : passed basic, commit id=4a91e878d098f4f5f553b0bf8cb63651b0fa84fa, date=Fri Oct 15 20:44:26 2021 +0800

eatmans : passed basic, commit id=dfe42ba147234d7b5dc6f3f446da45d7c5a66730, date=Sun Oct 17 01:10:27 2021 +0800

BlackSakura3C : passed basic, commit id=dec97f99859b7aefb72b737aad227d799afba2b4, date=Sun Oct 24 14:19:08 2021 +0800

Ichasethesun : passed basic,date,update,drop-table, commit id=35dc85da4abf56e69a9be4e1841a6c44b160df9c, date=Sun Oct 24 11:05:17 2021 +0800

esyc : passed basic, commit id=656086422ce851f0342648114a510d3c8736fbdf, date=Sun Oct 17 22:05:48 2021 +0800

DeepZheng : passed basic,update,select-meta,drop-table, commit id=5e945dd54705f8f65c9e7721d5906f9ac0680fa3, date=Fri Oct 22 20:22:41 2021 +0800

CaiyuhangC : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

HUST-DDDD : passed basic, commit id=845ea78ee455fccbdf0bdc8a55b4e698994bc0b4, date=Fri Oct 22 18:19:13 2021 +0800

Deep-bug : passed basic, commit id=03435d285b614c8d2c926f40809fb91663573792, date=Thu Oct 21 14:14:14 2021 +0800

idvzchusvol : passed basic,update,select-meta,drop-table, commit id=6828d85fb92f0b73421396ae7761e14f4c1f6e5c, date=Sun Oct 24 19:02:06 2021 +0800

BigFatSugar : passed basic, commit id=00eee6a3b406f8d686f30faa3c0a659d690813e7, date=Fri Oct 22 16:17:50 2021 +0800

KurisuSaber : passed basic, commit id=c611d5fe878382116b6a329418b37d6a66daa2e1, date=Fri Oct 15 20:01:34 2021 +0800

#3

先发一部分测试结果

#4

周五2次测试都没有结果，麻烦留意一下是否 报错。https://github.com/watchpoints/miniob

#5

能麻烦看下Update 和多表查询吗，用户名是这个 J0kerMh

#6

你的测试很奇怪。没有更新的行，被更新了。看看是不是更新A行的时候，把B行数据也更新掉了。

1 个赞
#7

老师能帮忙看一下select-meta，date和多表查询为什么没过吗？本地测试是可以的

fkuner : passed basic,update,drop-table, commit id=a7f41379ddbcacb97db2d3ffd6af15f7ec3e8b60, date=Mon Oct 25 10:49:12 2021 +0800


#8

emm可以的话，date和聚合的结果也能给我一下吗🙏

#9

更新的时候不是更新如何where条件的行嘛，你的意思是我更新了没有符合条件的行？

#10

麻烦能帮忙看下drop-table为什么没过吗？https://github.com/Joycepy/OceanBase

#12

能麻烦看一下basic什么case没过吗?谢谢

https://github.com/ccat3z/miniob

#13

前辈好,麻烦帮忙看看JameyWoo 地址 https://github.com/JameyWoo/miniob 这个一次插入多条数据哪里有问题

图片上我本地这个测试可以,而且插入的多条数据若有一条不能正确插入,其他的几条也会rollback

而且好像测试的这个commit不是最新的,好像是之前的一个commit

JameyWoo : passed basic,date,update,select-meta,select-tables,drop-table, commit id=cd890015f080021b874831ab81413f06528c9e1c, date=Sun Oct 24 15:01:35 2021 +0800

#14

你好噢，周五的时候经提醒我们上传了build，这次我们删掉了，但是仍然没有在测试结果中找到我们，不知道上传的代码还有什么问题吗   https://github.com/CRRRRR2016/YCCCCRRR2021

#15

已经找到问题了

#16

https://github.com/idvzchusvol/miniob 可以帮忙看看date为什么没过吗？卡了好几天了

#17

meta 确认下where条件中的数据有没有校验；

date 看下删除操作是否可以正确执行；

多表查询注意输出字段的顺序要与输入的顺序保持一致啊

#18

date: 比较查询返回结果不正确

条件查询好像挂了（猜测是coredump）

#19

看起来是的。where条件匹配的是行A，但是行B也被更新了。

#20

表删掉，再重建，数据还存在

#21

列名输出顺序不符合要求