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

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

RucOBTeamGo : passed basic,select-meta,drop-table, commit id=395f4b4b32ca19b3ae17be7757eff08ba2a07ac4, date=2021-10-27 10:37:05

Ichasethesun : passed basic,date,update,select-meta,drop-table, commit id=7df67084adb5d1981ba421b02b5cb2e2c1329cc2, date=2021-10-26 23:25:40

rawmaterials223 : passed basic,select-meta, commit id=8a6d751d8ac08823fc96ec2a8ed83a8c596c9458, date=2021-10-27 10:16:22

HNUDLG : passed basic, commit id=b079c9fcc3c316cf981580f473989e652d1cb8e1, date=2021-10-27 11:15:27

blazersEvan : passed basic,update,select-meta,drop-table,insert,unique, commit id=5b54d2c14cd4d0fe262ddf98afd5efef8220fb60, date=2021-10-27 02:09:58

EmperorNiu : passed basic,select-meta,drop-table, commit id=ce76377e9e21e4644416e3ec6cb3b2c25a70fc17, date=2021-10-27 12:17:34

zhengbumingbai : passed basic,date,select-meta,drop-table,insert,unique, commit id=620ca8105121134af34bf610389454a4a40e79d2, date=2021-10-27 11:50:45

tssunjingwu : passed basic,update,select-meta,drop-table, commit id=752a2756da5f8b9cfd49fec0b77f6f5702c57ee2, date=2021-10-27 08:15:30

ybzxw : passed basic,date,update,select-meta,drop-table, commit id=43370eb3dad42defa7122ab584054b42a1a5dda1, date=2021-10-26 22:11:24

Whorra : passed basic,update,select-meta,select-tables,drop-table, commit id=76aa289feeaf4fb1841fe703df20e03024653b76, date=2021-10-27 14:03:52

TaurusGGBOY : passed basic,update,select-meta,drop-table,unique,order-by, commit id=b72c5cb3f6a692eca41251acc92259012b041a75, date=2021-10-27 12:44:51

ccat3z : passed basic,date,update,select-meta,drop-table, commit id=20cb16dab72b5353244ba63eab5cda0a8158a9ae, date=2021-10-27 11:46:34

Coding-Hammer : passed basic,update,select-meta,drop-table, commit id=75c26adf896f2738e053255cd07844d8ef7c0dda, date=2021-10-27 12:11:11

Galaxy0106 : passed basic,select-meta,drop-table, commit id=092ade0193bb88ac5c004223074bf04bd74e4b09, date=2021-10-26 20:32:58

watchpoints : passed basic,select-meta,drop-table, commit id=32575e4e319468458a25e13adf393228ca4af592, date=2021-10-27 13:59:25

hbangq : passed basic,update,select-meta,drop-table, commit id=200947723ee0162c987640cd912e2d73d69b4fdb, date=2021-10-27 09:56:53

kktao : all cases failed, commit id=7062798823fc152ba8a86ccaeaa3c07d7902532a, date=2021-10-26 21:21:49

DBChat-OB : passed basic,select-meta,drop-table, commit id=da70fb3a6dc730951bd27f01e4a34f8b722fb7c4, date=2021-10-26 21:44:13

HUST-DDDD : passed basic,update,select-meta,select-tables,drop-table, commit id=467107c849342429f6f28145f0308531182ccc21, date=2021-10-27 10:49:17

WebsterEndymion : passed basic,date,select-meta,drop-table, commit id=caf42e986380ae1b3c207778cdb09aaa8e4d1a1c, date=2021-10-27 10:27:51

JayL-zxl : passed basic,select-meta,drop-table, commit id=72c5d4126380b4df492ce02e41b7f3571475394b, date=2021-10-27 13:03:17

lmjhh : passed basic,date,select-meta,drop-table, commit id=e3818385ecd6081ff541f8176db1b93086ab3c4a, date=2021-10-27 02:49:10

zhoulaiqing : passed basic,date,update,select-meta,select-tables,drop-table, commit id=12200f4058bb3ead39012d4633bf0727e03bd5f3, date=2021-10-27 11:19:45

lhcmaple : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,order-by,group-by, commit id=4c0e27268407d668d0cb7086c08801e5b88ac63f, date=2021-10-27 12:32:48

Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=2353b4a8b6e6c90ba2147ad3bdf2713909885d1e, date=2021-10-27 09:21:02

Alaska12719 : passed basic,date,select-meta,drop-table, commit id=1bca9384be062e18d98a3dfc56d1facedf1dc181, date=2021-10-27 12:06:10

idvzchusvol : passed basic,date,select-meta,select-tables,aggregation-func,drop-table,unique, commit id=9f407fdbfda16826c17355dba36dd6bb8e2fc42f, date=2021-10-27 01:14:21

caizj : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables, commit id=c98a1cc1ee11f659c1d478365e61e39aa833405b, date=2021-10-27 13:50:42

obcontest : passed basic,date,update,select-meta,drop-table,unique, commit id=2cfd190cf434e6278f061db467c37690e48ad1fd, date=2021-10-27 13:40:00

DATA-IS-POWER : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=09f2b768049dd32d4b800dacce68dae42f03eb03, date=2021-10-26 22:44:00

dongzeyu : passed select-meta, commit id=5e39ba3df4640923c4d119bd8b0b246c59b1d7cc, date=2021-10-27 11:47:59

Kaimary : passed basic,select-meta, commit id=567964ec87155628d3c09cb0f87defec053fe7b4, date=2021-10-27 13:00:49

WangAShao : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,null,unique, commit id=9187c00e69a0785cfa28b53e49fa9c1476ff7267, date=2021-10-27 09:18:48

1 个赞
#2 
Paoluers : passed basic,date,update,select-meta,drop-table, commit id=2a83c5911ed015a27c6b28d11e947a932b5c1da8, date=2021-10-27 09:20:28
XLC-2 : all cases failed, commit id=5e9f1e0da23967f8028cb32d6114c4832c0c8797, date=2021-10-27 10:16:41
Godroser : passed basic,drop-table, commit id=cd4d6867b2cc49b25766001c58de75b16e848108, date=2021-10-26 21:57:14
LLThomas : passed basic,update,select-meta,drop-table, commit id=4d1cb005575caab8b376fa3c8f71deaaaf2e3669, date=2021-10-27 13:04:21
OBserver-BUPT : passed basic,update,select-meta,drop-table, commit id=d7424d0e73d161e1100726aebfa4d506fa194bec, date=2021-10-26 20:23:45
CRRRRR2016 : passed basic,select-meta, commit id=c7933315c5e1da1f266aa17642841d2e5ccf4828, date=2021-10-26 21:47:56
zjx1230 : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=98a3ad428979184b65fffc67ef5eed4e427cb5c8, date=2021-10-26 20:31:54
ecnu-db-tianchi : passed basic,date,update,select-meta,drop-table,insert, commit id=8d5262eeef71fe1c975467d0036775078a0122ed, date=2021-10-27 10:02:57
coding01000 : passed basic,select-meta, commit id=f6c735061cf388518ed5d3b06995751917a6444f, date=2021-10-26 21:11:07
rehoboan : passed basic,select-meta,drop-table, commit id=0dfefa64351166d911646c7ce232ad5b427dea63, date=2021-10-26 21:38:04
abaaba-OB : passed basic,select-meta,drop-table, commit id=a7052cbfe0612d36b0726ba25a32ec8bd53ccd9f, date=2021-10-26 23:07:27
Leozki : passed basic,date,update,select-meta,drop-table, commit id=80acb9efdeeacfc1cd32fbaa053a797b7933a3bf, date=2021-10-26 23:05:29
My-OB-contest : all cases failed, commit id=5fa91a39042f0181852f3b57f9cba95585a90287, date=2021-10-27 14:03:01
NKU-EmbeddedSystem : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=95a2d7febb3d634ef92135662c197ad5708ccc21, date=2021-10-27 13:55:06
Panlisong : passed basic,select-meta,select-tables, commit id=5655836cbf38090c2566cd78d8546f65486bb535, date=2021-10-27 09:19:28
wangqiim : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,unique, commit id=6e51ebfa18d123030dd7d9ca965b6ac319d766ba, date=2021-10-26 23:28:45
mark15217 : passed basic,update, commit id=43cd33994f0d80594aafe4ae0bb06cb1477c7000, date=2021-10-26 23:00:06
Windsrain : passed basic, commit id=e803c599b5cc6dca92e07b770a67db92d4549c9e, date=2021-10-26 22:59:43
bxx-seu : passed basic, commit id=f5f878988a351dfa650fa1557bda17bf828e3152, date=2021-10-27 13:23:15
httdty : passed basic,select-meta,drop-table, commit id=c14955d729d6c4e4e6bf4e2884faf8b3a57cbc7e, date=2021-10-27 13:30:17
Angelia-Wang : passed basic,select-meta,drop-table, commit id=a418a33e5ee753080d87905a31cb9b31bb4f4455, date=2021-10-26 22:39:39
5d1207 : passed basic,date,update,select-meta,select-tables,aggregation-func,insert,unique, commit id=2bfc25cf68fe02168f85a31c0b8b841ef09587b3, date=2021-10-27 11:52:37
Moonm3n : passed basic,date,update,select-meta,drop-table,insert, commit id=855319ea1d635a6e0015d5d76008871cfb8cc5a3, date=2021-10-27 12:17:18
zhiyang0310 : passed basic,select-meta,drop-table, commit id=cd358f1b5e2294d36bc41f7d2521fd3b921d9dd4, date=2021-10-26 21:38:08
J0kerMh : passed basic,select-meta,drop-table, commit id=ac4c6a31ae97021449012e5adb3c150d13e2e50a, date=2021-10-26 21:15:38
yan-tingyun : passed basic,update,select-meta, commit id=f020b0d71e941f99133a219a759a51c7633feaf5, date=2021-10-26 21:08:28
123liuziming : passed select-meta, commit id=3a4dd8e639dff336a53f7f9f84ce31b64f017db7, date=2021-10-27 13:51:48
linweiwei : passed basic,select-meta,drop-table, commit id=ebccdd369e0ce7cac8ff863a2894d09ad4a9138d, date=2021-10-27 10:45:25
An-DJ : all cases failed, commit id=a34bf0c10f6931f8ec3791adeac218725d081b6c, date=2021-10-27 12:18:49
xiaoyong-z : passed basic,update,select-meta,drop-table, commit id=b6b704b405b4cec0ee5238ed9a36f6f6c5f01f5f, date=2021-10-26 22:22:11
DUXUCHONG : passed basic,date,update,select-meta,drop-table, commit id=1ffe60afe6fb082186ed0d657046eee03c93d018, date=2021-10-27 13:18:30
#3

https://github.com/blazersEvan/miniob，求老师看看date和聚合函数为啥不过，十分感谢！

#4

没看到 https://github.com/S-1-T/miniob 呢

#5

git clone git@github.com:5d1207/pushd.git 麻烦帮忙看下，droptable又出啥子问题了呀？

#8 
My-OB-contest : all cases failed, commit id=5fa91a39042f0181852f3b57f9cba95585a90287, date=2021-10-27 14:03:01
老师麻烦看看我们为什么all cases failed了，之前测过还通过了好几个点。

https://github.com/My-OB-contest/miniOB

#9

可以帮忙看下多表查询的问题吗？https://github.com/J0kerMh/2021OB

#10

王哥，没看到 https://github.com/agoodjuice/private-miniob

#11

之前队员传错代码，删过一些commit记录什么的

#12

我去嘞，date的插入都没有支持。

聚合里面的测试表，有date字段。

#13

已经钉钉回复。

#14

看起来是插入drop过的表，直接core了。

#16

麻烦看一下update,date 主要是update 失败case，自己都测试一遍了，不知道有什么遗漏 https://github.com/watchpoints/watchpoints。



#17

老师顺便帮忙看下这个  https://github.com/18703486960/miniob

#18

老师，麻烦看下date哪里有问题呢，https://github.com/Super-long/miniob

#19

看起来像是建表就coredump了。

#20

带条件的查询，直接coredump了。

#21 
agoodjuice 0 /test/dask/test-tmp/agoodjuice/miniob/src/observer/sql/executor/tuple.cpp: In member function ‘void TupleSchema::add(AttrType, const char*, const char*)’:\n/test/dask/test-tmp/agoodjuice/miniob/src/observer/sql/executor/tuple.cpp:88:1: error: version control conflict marker in file\n<<<<<<< HEAD\n^~~~~~~\ncompilation terminated due to -fmax-errors=1.\nmake[2]: *** [src/observer/CMakeFiles/observer_static.dir/sql/executor/tuple.cpp.o] Error 1\nmake[1]: *** [src/observer/CMakeFiles/observer_static.dir/all] Error 2\nmake[1]: *** Waiting for unfinished jobs....\n/test/dask/test-tmp/agoodjuice/miniob/src/observer/sql/executor/tuple.cpp: In member function ‘void TupleSchema::add(AttrType, const char*, const char*)’:\n/test/dask/test-tmp/agoodjuice/miniob/src/observer/sql/executor/tuple.cpp:88:1: error: version control conflict marker in file\n<<<<<<< HEAD\n^~~~~~~\ncompilation terminated due to -fmax-errors=1.\nmake[2]: *** [src/observer/CMakeFiles/observer.dir/sql/executor/tuple.cpp.o] Error 1\nmake[2]: *** Waiting for unfinished jobs....\nmake[1]: *** [src/observer/CMakeFiles/observer.dir/all] Error 2\nmake: *** [all] Error 2\n
#22

单行更新就失败了。自己测试的时候，加上索引啥的，表字段多加几个，各种类型的字段也都试一下。

#23

我们本地都是正常的，而且很奇怪的就是测试的commit id我们git上都查不到