[ https://issues.apache.org/jira/browse/PHOENIX-2263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maryann Xue updated PHOENIX-2263: --------------------------------- Description: This is not a bug in Phoenix, but is caused by CALCITE-890 and CALCITE-891. This does not happen with all join queries. For example, problem might occur with "select * from a join b on a.id = b.id" or "select * from a, b where a.id = b.id and a.col0 > 100", while it might work fine with "select * from a join b on a.id = b.id and a.col0 > 100". > Secondary index is not used in join queries in Phoenix/Calcite integration > -------------------------------------------------------------------------- > > Key: PHOENIX-2263 > URL: https://issues.apache.org/jira/browse/PHOENIX-2263 > Project: Phoenix > Issue Type: Bug > Reporter: Maryann Xue > Assignee: Maryann Xue > Labels: calcite > > This is not a bug in Phoenix, but is caused by CALCITE-890 and CALCITE-891. > This does not happen with all join queries. For example, problem might occur > with "select * from a join b on a.id = b.id" or "select * from a, b where > a.id = b.id and a.col0 > 100", while it might work fine with "select * from a > join b on a.id = b.id and a.col0 > 100". -- This message was sent by Atlassian JIRA (v6.3.4#6332)