100 Star 332 Fork 294

openLooKeng / hetu-core

 / 详情

'show index' one partition column when create btree for 2 partition columns

Done
Defect 成员
创建于  
2021-03-29 20:06

Software Environment:

  • openLooKeng version (source or binary):
    openlooKeng1.1.0RC6

  • OS platform & distribution (eg., Linux Ubuntu 16.04):
    Two coordinator

  • Java version:

Describe the current behavior

Create btree index for 2 partition columns, show index has one partition columns

Describe the expected behavior

Create btree index for 2 partition columns, show index has two partition columns

Steps to reproduce the issue

  1. Create two tables
    create table tb_test1(p1 int,p2 int,p3 int) with (partitioned_by=array['p3']);
    create table tb_test2(p1 int,p2 int,p3 int) with (partitioned_by=array['p3']);
  2. Insert data into tables
    insert into tb_test1 values(1,1,1);
    insert into tb_test1 values(2,2,2);
    insert into tb_test1 values(3,3,3);
    insert into tb_test2 values(1,1,1);
    insert into tb_test2 values(2,2,2);
    insert into tb_test2 values(3,3,3);
  3. create index for one table and show index
    create index idx1 using btree on tb_test1(p1) where p3=1;
    create index idx1 using btree on tb_test1(p1) where p3=2;
    输入图片说明
    4.create index for another table and show index
    create index idx2 using btree on tb_test2(p1) where p3=1;
    输入图片说明

Related log/screenshots

Step3:Create index for 2 partition column, but there is only one partition column in ‘show index’
Step4:After create another index for another table,the index of Step3 show 2 partition column created

Special notes for this issue

评论 (1)

@yumei You have not selected a milestone,please select a milestone.After setting the milestone, you can use the /check-milestone command to remove the needs-milestone label.

yumei 创建了缺陷Defect
yumei 关联仓库设置为openLooKeng/hetu-core
i-robot 添加了
 
needs-milestone
标签
yumei 修改了标题
yumei 修改了描述
yumei 修改了描述
yumei 修改了描述
lshcpu 通过openlookeng/hetu-core Pull Request !922任务状态待办的 修改为已完成
展开全部操作日志

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(2)
Java
1
https://gitee.com/openlookeng/hetu-core.git
git@gitee.com:openlookeng/hetu-core.git
openlookeng
hetu-core
hetu-core

搜索帮助