Hans Zeller created TRAFODION-2736:
--------------------------------------
Summary: Missing predicates on salt columns when using an index
join
Key: TRAFODION-2736
URL: https://issues.apache.org/jira/browse/TRAFODION-2736
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.0-incubating
Environment: Any
Reporter: Hans Zeller
Assignee: Hans Zeller
When we have salted tables, the compiler is supposed to generate predicates on
the salt column automatically, based on predicates on the columns used for
salting.
Suresh and Benny found a case where we don't do that, related to index joins (a
join between an index and its base table). Here is an example:
{code}
create table tdi(service_id int not null,
user_number int not null,
start_time timestamp not null,
b int,
primary key(service_id, user_number, start_time))
division by (date_trunc('day', start_time))
salt using 4 partitions on (user_number);
create index tdix on tdi(user_number, start_time) salt like table;
control query shape join(cut,cut);
prepare s from
select * from tdi where user_number = 1234 and start_time between timestamp
'2017-01-01 00:00:00' and timestamp '2017-01-15 00:00:00';
explain s;
{code}
In the explain, we would expect a predicate on the salt column but there is
none.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
