[
https://issues.apache.org/jira/browse/ASTERIXDB-1520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu updated ASTERIXDB-1520:
---------------------------------
Priority: Critical (was: Major)
Description:
To reproduce, uncheck execute query, check show optimized plan and run the
following:
drop dataverse test if exists;
create dataverse test;
use dataverse test;
create type AuxiliaryType as open {
id:int32,
num:int32
}
create type LineType as open {
}
create dataset Book(LineType) with meta(AuxiliaryType)
primary key meta().id;
create index NumIndex1 on Book(meta().num);
create index NumIndex2 on Book(linenum:int32) enforced;
create index NumIndex3 on Book(count1:int32) enforced;
create index NumIndex4 on Book(count2:int32) enforced;
for $t1 in dataset Book
where $t1.linenum < 10
order by $t1.linenum
return {
"linenum1": $t1.linenum,
"count1":$t1.count1,
"t2info": for $t2 in dataset Book
where $t1.count1 /* +indexnl */= $t2.count2
order by $t2.linenum
return {"linenum2": $t2.linenum,
"count2":$t2.count2}
};
-- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
{
-- AGGREGATE |LOCAL|
-- STREAM_SELECT |LOCAL|
-- NESTED_TUPLE_SOURCE |LOCAL|
}
will show incorrectly as:
{
-- AGGREGATE |LOCAL|
-- STREAM_SELECT |LOCAL|
-- NESTED_TUPLE_SOURCE |LOCAL|
}
-- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
was:
To reproduce, uncheck execute query, check show optimized plan and run the
following:
drop dataverse test if exists;
create dataverse test;
use dataverse test;
create type AuxiliaryType as open {
id:int32,
num:int32
}
create type LineType as open {
}
create dataset Book(LineType) with meta(AuxiliaryType)
primary key meta().id;
create index NumIndex1 on Book(meta().num);
create index NumIndex2 on Book(linenum:int32) enforced;
create index NumIndex3 on Book(count1:int32) enforced;
create index NumIndex4 on Book(count2:int32) enforced;
for $t1 in dataset Book
where $t1.linenum < 10
order by $t1.linenum
return {
"linenum1": $t1.linenum,
"count1":$t1.count1,
"t2info": for $t2 in dataset Book
where $t1.count1 /* +indexnl */= $t2.count2
order by $t2.linenum
return {"linenum2": $t2.linenum,
"count2":$t2.count2}
};
-- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
{
-- AGGREGATE |LOCAL|
-- STREAM_SELECT |LOCAL|
-- NESTED_TUPLE_SOURCE |LOCAL|
}
will show incorrectly as:
{
-- AGGREGATE |LOCAL|
-- STREAM_SELECT |LOCAL|
-- NESTED_TUPLE_SOURCE |LOCAL|
}
-- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
> Preclustered Group by is displayed incorrectly in the web UI
> ------------------------------------------------------------
>
> Key: ASTERIXDB-1520
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1520
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: Web Interface
> Reporter: Abdullah Alamoudi
> Assignee: Yingyi Bu
> Priority: Critical
>
> To reproduce, uncheck execute query, check show optimized plan and run the
> following:
> drop dataverse test if exists;
> create dataverse test;
> use dataverse test;
> create type AuxiliaryType as open {
> id:int32,
> num:int32
> }
> create type LineType as open {
> }
> create dataset Book(LineType) with meta(AuxiliaryType)
> primary key meta().id;
> create index NumIndex1 on Book(meta().num);
> create index NumIndex2 on Book(linenum:int32) enforced;
> create index NumIndex3 on Book(count1:int32) enforced;
> create index NumIndex4 on Book(count2:int32) enforced;
> for $t1 in dataset Book
> where $t1.linenum < 10
> order by $t1.linenum
> return {
> "linenum1": $t1.linenum,
> "count1":$t1.count1,
> "t2info": for $t2 in dataset Book
> where $t1.count1 /* +indexnl */= $t2.count2
> order by $t2.linenum
> return {"linenum2": $t2.linenum,
> "count2":$t2.count2}
> };
> -- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
> {
> -- AGGREGATE |LOCAL|
> -- STREAM_SELECT |LOCAL|
> -- NESTED_TUPLE_SOURCE |LOCAL|
> }
> will show incorrectly as:
> {
> -- AGGREGATE |LOCAL|
> -- STREAM_SELECT |LOCAL|
> -- NESTED_TUPLE_SOURCE |LOCAL|
> }
> -- PRE_CLUSTERED_GROUP_BY[$$19] |PARTITIONED|
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
