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
- 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']);
- 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);
- 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