OceanBase 大赛测试结果(增量)- 2021/10/26 下午

RUC-Seed-No-59 : passed basic,date,update,select-meta,drop-table, commit id=7b89d9f6e2964b418d537eb1b747d895d4190846, date=2021-10-26 10:38:50
shyuZzz : passed basic,select-meta,drop-table, commit id=19dc2f496a767bb6badfa9d2a6c60a681091b28c, date=2021-10-26 11:29:43
waterme7on : passed basic,select-meta, commit id=a37eb2a46f8fc984978cc7f1640c4c2e93e514ea, date=2021-10-26 10:22:44
PaJir : passed basic,select-meta,drop-table, commit id=48a3ac9c9db6de53de7f98f66bfcb2e20ff21640, date=2021-10-26 13:10:31
ybzxw : passed basic,date,select-meta,drop-table, commit id=ad60bbea82a5e462a12229b382b8414545f304f4, date=2021-10-26 11:19:33
Wheeeel : passed basic,update, commit id=41de09f57c3b6433aa816f06bc2d6e3e075a8d82, date=2021-10-26 10:56:02
Leozki : passed basic,date,select-meta,drop-table, commit id=a84423c23bffc21b252a423f5b7fe71d08a1f9fc, date=2021-10-26 11:15:48
yangzecai : passed basic,date,update,select-meta,select-tables,drop-table, commit id=5165902784c3cbe4f2294626310e96c7b9bd06c5, date=2021-10-26 12:47:07
zhengbumingbai : passed basic,date,select-meta,drop-table,insert,unique, commit id=a3020bd7b02ee82ed8b3b166b57c88f1ce385708, date=2021-10-26 14:29:34
HUST-DDDD : passed basic,update,select-meta, commit id=6b4c942a36beefb695938f5543232b1f2461d448, date=2021-10-26 14:51:13
S-1-T : passed basic,date,update,select-meta,select-tables,drop-table, commit id=eb8d1533e1a03b795ee7987417640c90c19b0990, date=2021-10-26 10:51:45
TaurusGGBOY : passed basic,update,select-meta,drop-table,unique, commit id=92d0d8388790b482637f001b5078dac401d5bc24, date=2021-10-26 13:34:13
My-OB-contest : all cases failed, commit id=e3255215dfea139b0919139bde2c7704317cdaab, date=2021-10-26 14:52:55
coding01000 : passed basic, commit id=e72c46917525fd6fbe7f902e8faf0833d2c74829, date=2021-10-25 11:21:54
zjx1230 : passed basic,date,update,select-meta,drop-table, commit id=7adc08192d0e33025b3486cacfe392f51d87e6bc, date=2021-10-26 14:15:16
BaymaxHWY : passed basic, commit id=4b862d72741dfe44f1030b0c18bb59c568476b83, date=2021-10-26 14:12:00
BanBuDu0 : passed basic,update,select-meta,drop-table, commit id=bddf163b0367f3be7ce1dab88854c006966c5e70, date=2021-10-26 13:39:59
dongzeyu : passed basic,update,select-meta,aggregation-func,drop-table,insert, commit id=54ab7b45f28c2b9fa6e1de5ccf361256ecee59b4, date=2021-10-26 10:51:19
Sunday361 : passed basic,select-meta,select-tables,drop-table,insert, commit id=34ed4d0df767b3ae41320ddd890832ef7ae44c4f, date=2021-10-26 12:53:01
OBserver-BUPT : passed basic,update,select-meta,drop-table, commit id=1d96f48831b19c1eda41609eb87d2d6fa45c79fc, date=2021-10-26 12:04:29
jaingmengmeng : passed basic,date,update,select-meta,drop-table, commit id=5020308a1e86bf439b3b2483baa122e2c2c28054, date=2021-10-26 11:23:06
Alaska12719 : passed basic,select-meta,drop-table, commit id=bb52d97c7b219aee29060ecb25d5662c26282d91, date=2021-10-26 14:46:59
nautaa : passed basic,select-meta, commit id=0f90d963ffef66a1ef66e07c3dfe98c651cfd3cc, date=2021-10-26 10:33:41
Super-long : passed basic,update,select-meta,select-tables,aggregation-func,drop-table, commit id=aa15a076d530018083afa3af54a718903ebc7496, date=2021-10-26 14:50:26
ingdex : passed basic,select-meta, commit id=0bd9c1a7f5fdb78f71158d6086861e15e5d3bdd6, date=2021-10-26 12:13:29
agoodjuice : passed basic,date,update,select-meta,drop-table, commit id=e5b63bb47bce92361885dbf17607208ae9faa909, date=2021-10-26 14:40:57
wangqiim : passed basic,date,update,select-meta,drop-table, commit id=41d096453f79bcce9b71f7def8cbce2ec7d7b2ca, date=2021-10-26 11:35:12
NKU-EmbeddedSystem : passed basic,date,update,select-meta,select-tables,drop-table,insert, commit id=d062396bbe0ee3242594e973110c77d7ddc07fce, date=2021-10-26 14:40:43
agoodjuice : passed basic,date,update,select-meta,drop-table, commit id=e5b63bb47bce92361885dbf17607208ae9faa909, date=2021-10-26 14:40:57

老师能看一下https://github.com/HUST-DDDD/MiniOB/的drop table错在哪了吗?

https://github.com/zjx1230/miniob,老师,可以看下聚合错的地方吗?


https://github.com/wangqiim/miniob 老师帮看下多表查询出了什么问题?

删除表;

创建表

查询数据 : 能查出来数据

不存在的列,也能做聚合。

查询不存在的字段,没有报错

dongzeyu/miniob (github.com) 

老师,请问一下date和多表查询是哪里有问题呢,谢谢!

老师麻烦看下目前date有什么问题 https://github.com/Super-long/miniob

https://github.com/blazersEvan/miniob,求老师看看date和聚合运算有什么问题。

https://github.com/Angelia-Wang/miniob

麻烦老师看下select-meta和drop table错在哪儿了?

select-meta里面select和where中不存在的表和属性都考虑了。drop table里表删除后,再执行select也能返回FAILURE。

date 的比较查询直接导致程序coredump。

多表查询 执行条件查询时,也直接跪了。

条件查询没有返回结果。

github.com/OBserver-BUPT/MiniOB 老师能帮忙看看date错在哪了么?

https://github.com/wangqiim/miniob,求老师帮看看聚合运算有什么问题。

比较查询不能正常工作。

lectures-on-dbms-implementation (oceanbase-partner.github.io)

看一下这里的date

select -meta case调整了,把比较偏门的case去掉了,现在可以过了。

droptable :

drop t

create t

select from t; 应该返回空数据

where条件中的日期非法,直接返回failure

老师麻烦再看一眼Coding-Hammer的drop table

Coding-Hammer/miniob (github.com)

已经按照要求表不存在时返回FAILURE,无数据时返回表头了,感谢🙏

10  应该显示 10

不是1

把“多余”的0去掉,别把整数的0去掉啊