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

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

b41sh : passed basic,update,select-meta,drop-table, commit id=a8b0d3e6fd3f727ecfa9a3f0bf1a7f0b5776f348, date=2021-10-28 12:02:25

Sunday361 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,group-by, commit id=9502ebd1df2eea0bc7cc6c5c53029c52d4b6baea, date=2021-10-28 14:18:30

mikan-team : passed basic, commit id=f01e4993ecb06317e165fca18a45cb3d663dbaf2, date=2021-10-28 14:55:53

Galaxy0106 : passed basic,update,select-meta,drop-table, commit id=ef76908f66327e6c123cf4b021992912902e1b39, date=2021-10-28 14:54:37

LLThomas : passed basic,date,update,select-meta,drop-table,insert, commit id=6793424cc20c4fed92da437c4b9ecd7ca6ef5659, date=2021-10-28 15:31:40

My-OB-contest : passed date,update,select-meta,aggregation-func,drop-table, commit id=7ad30018220f3c58b618557ef321a6fec7f4f357, date=2021-10-28 13:17:39

Panlisong : passed basic,select-meta,aggregation-func,insert,join-tables, commit id=3828bdb394071fc79efbf03fc864716d88da0bae, date=2021-10-28 14:05:38

tanruixiang : passed basic,update,select-meta,select-tables,drop-table,insert, commit id=94870be45c369a6efa7222462a0f6d9f0e38543e, date=2021-10-28 13:52:13

Maizesty : passed basic,date,select-meta,drop-table, commit id=a86a321849d7b4fe51e1d29f571fd32a344378a7, date=2021-10-28 10:39:40

penggan666 : passed basic,date,update,select-meta,drop-table, commit id=0763a35322c4b16d5813701c1d97a33eb5220749, date=2021-10-28 11:58:10

zjx1230 : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=17d7c6813412c2f44c09a0b75837355a621be556, date=2021-10-28 13:33:42

Whorra : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=4539983d2c762d960fd70301c4ec29ee0b0315e6, date=2021-10-28 12:59:53

Paoluers : passed basic,date,update,select-meta,aggregation-func,drop-table, commit id=2bf91b2b495a95d64919966485fb4f965154cecf, date=2021-10-28 10:33:49

HNUDLG : all cases failed, commit id=3d708f7178cb8501434c3148410b79f94828da35, date=2021-10-28 15:22:12

ifIAmADJ : passed basic, commit id=b313aa3c47049cc849f652e34eb1c59d0e53219a, date=2021-10-28 15:05:31

Ichasethesun : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=f0a346e1e6d78e2e0b0e4325f54254b832a36419, date=2021-10-28 12:45:01

WangAShao : passed basic,select-meta,select-tables,aggregation-func,drop-table,insert,null, commit id=6c1bb3565cd5fb85091ae0463bd9c44e1cfec108, date=2021-10-28 14:19:46

zhoulaiqing : passed basic,date,update,select-meta,select-tables,drop-table, commit id=8a8be745b66b95efb2cfe069586bc605693ca8ba, date=2021-10-28 12:08:00

Kaimary : passed basic,select-meta,drop-table, commit id=7c9dc72b3102f350ea4b8e89e374b892d9d25909, date=2021-10-28 12:13:37

Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert, commit id=19579938c7597a90302e8b7ed49a684ed8247e4c, date=2021-10-28 14:14:45

ecnu-db-tianchi : passed basic,date,update,select-meta,drop-table,insert,unique, commit id=1c003901651d5338f79a86d0a571a6380981e646, date=2021-10-28 13:45:24

DUXUCHONG : passed basic,date,update,select-meta,drop-table, commit id=1298627d60d5ad40de62bfb6ac086d0e01b7b838, date=2021-10-28 15:04:19

TaurusGGBOY : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,unique,order-by, commit id=6dd5d04666d547d98c9d4de43d4b297e4c521e50, date=2021-10-28 10:52:36

OBserver-BUPT : passed basic,date,update,select-meta,select-tables,drop-table, commit id=a41fa387b5805c3382922ad57f0d57f59b66347b, date=2021-10-28 14:42:36

dongzeyu : passed basic,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=6e06c1505f9baa9439ad056696a7903e87ceddef, date=2021-10-28 15:06:15

idvzchusvol : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,unique, commit id=b1e6da46713ac0d611ad5f3019275d726972cccf, date=2021-10-28 13:52:19

Xylitol415 : passed basic,select-meta,drop-table, commit id=67f2e918838fe849914f99f4822015a863948da3, date=2021-10-28 14:05:52

jaingmengmeng : passed date,update,select-meta,select-tables,drop-table,join-tables, commit id=00ac803c00d1a1dd898dab1ae02e621b8a9a403b, date=2021-10-28 14:33:58

obcontest : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,join-tables,unique, commit id=5b7b6d8b51dea6cc5bd4743fcb7f0a72ffe626ef, date=2021-10-28 15:18:09

randxie : passed basic,select-meta,drop-table, commit id=d567b156b0b7dae7133cffb3509f6a27b0657106, date=2021-10-28 12:41:17

#2

JameyWoo : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,order-by, commit id=04679809c3c478132af90b02246e0ecc93b73baa, date=2021-10-28 10:00:18

zhengbumingbai : passed basic,date,update,select-meta,drop-table,insert,unique, commit id=7ab1f5e204fdf6b29b1b797da227aa2f1cdc8a41, date=2021-10-28 15:07:49

Alaska12719 : passed basic,date,update,select-meta,drop-table, commit id=42707ce9627c4cc3eb223a009beec4ee47b26195, date=2021-10-28 11:09:00

caizj : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table,insert,join-tables,unique,order-by,group-by, commit id=8c2118f2ce6f71f32c02c9322313985aabb3a0d5, date=2021-10-28 15:07:49

DATA-IS-POWER : passed basic,date,update,select-meta,select-tables,drop-table,insert,unique, commit id=af82a16f405c4b6d4e3d344e920873605dddaca5, date=2021-10-28 13:51:42

watchpoints : passed basic,update,select-meta,drop-table, commit id=133b12feed7bbbccb1bef2a657bfea1c6fe8e263, date=2021-10-28 15:29:08

JayL-zxl : passed basic,update,select-meta,drop-table,unique, commit id=74ec74d3ed60a00d7a2cd5e4499148b23e965a5b, date=2021-10-28 10:43:48

abaaba-OB : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=9e817b66043636c07c08288a9557b6d2ac4982aa, date=2021-10-28 10:15:20

HUST-DDDD : passed basic,date,update,select-meta,select-tables,aggregation-func,drop-table, commit id=f406d59ff4e57882b50ef6d392edb4751b534e21, date=2021-10-28 14:08:39

Mikan-Team : passed basic, commit id=f01e4993ecb06317e165fca18a45cb3d663dbaf2, date=2021-10-28 14:55:53

rehoboan : passed basic,update,select-meta,drop-table, commit id=b234fcd804f9d3bc09d62cf43e1254cbb8e26ee9, date=2021-10-28 14:30:59

aijianchi : passed basic,update,select-meta,drop-table, commit id=fa91018540191aae6ec1bce45c631b2824a0c07c, date=2021-10-28 13:48:50

#3

My-OB-contest : passed date,update,select-meta,aggregation-func,drop-table, commit id=7ad30018220f3c58b618557ef321a6fec7f4f357, date=2021-10-28 13:17:39

可以看看多表和inner join哪里case 有问题吗？谢谢，改了好几次了，现在感觉都测了没啥问题

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

#4

你好 老师可以帮忙看下这次date是什么原因没过吗 本地测试一切都没问题QAQ https://github.com/dongzeyu/miniob

#5

idvzchusvol 可以看看inner join哪出错了吗

#6

Panlisong，老师你好，可以帮忙看下这次update和drop table是什么原因没过吗，本地测试找不出问题qwq

#7

请问是什么原因拉不下来代码，是我们仓库的原因还是因为什么

https://github.com/WebsterEndymion/Walking-on-the-Rainbow

#8

WebsterEndymion : passed basic,date,select-meta,aggregation-func,drop-table, commit id=c2dc983ce32ee4993a87606a767843d67162a86c, date=2021-10-28 14:15:15

#9

WebsterEndymion : passed basic,date,select-meta,aggregation-func,drop-table, commit id=c2dc983ce32ee4993a87606a767843d67162a86c, date=2021-10-28 14:15:15


我试了几次git pull都是超时


#10

能问一下DUXUCHONG : passed basic,date,update,select-meta,drop-table, commit id=1298627d60d5ad40de62bfb6ac086d0e01b7b838, date=2021-10-28 15:04:19

DUXUCHONG/miniob (github.com)

commit id不对啊，下午三点没有提交，是下午两点提交的。是怎么回事啊？

main分支最新的commit id是8ff88b9d5de4dd13a0f030e777b617bc1ece803c。

能麻烦看看是为什么吗？

#11

老师，能帮忙看一下jaingmengmeng的basic怎么没过，后面的测试都过了好几个了，结果basic没过？

#12

302    month[2] = ((y % 4 == 0 && y % 100 != 0) || y % 400 == 0) ? 29 : 28;

303    int m = 1;

304    while (m < day[1]) {

305     *formatted_day += month[m];

306    }


PaJir 代码有死循环

#13

老师您好，可以帮忙看一下rehoboan的date是什么问题吗。谢谢！

 

#14

是我们仓库的原因吗，我们自己pull是可以的

#15

老师您好,能帮忙看下https://github.com/WangAShao/miniob的多列索引是哪里有问题吗?

#16

麻烦帮忙看一下zhengbumingbai的聚合，多表查询和多列索引的问题

#17

看起来是执行这个语句时挂了

SELECT * FROM JOINTABLE1 INNER JOIN JOINTABLE2 ON JOINTABLE1.ID=JOINTABLE2.ID;

#18

看起来是这个挂了

SELECT * FROM DATETABLE WHERE UDATE>'2020-1-20';

#19

老师好，可以测一下https://github.com/DeepZheng/OceanBase2021 吗，我们中午提交了代码的

#20

JOINTABLELARGE1.ID | JOINTABLELARGE1.NUM1 | JOINTABLELARGE2.ID | JOINTABLELARGE2.NUM2 | JOINTABLELARGE3.ID | JOINTABLELARGE3.NUM3 | JOINTABLELARGE4.ID | JOINTABLELARGE4.NUM4 | JOINTABLELARGE5.ID | JOINTABLELARGE5.NUM5 | JOINTABLELARGE6.ID | JOINTABLELARGE6.NUM6

没有返回结果