[
https://issues.apache.org/jira/browse/PHOENIX-6224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
chenglei updated PHOENIX-6224:
------------------------------
Description:
Given following tables :
{code:java}
create table item
(item_id varchar not null primary key,
name varchar,
price integer,
discount1 integer,
discount2 integer,
supplier_id varchar,
description varchar)
create table order
( order_id varchar not null primary key,
customer_id varchar,
item_id varchar,
price integer,
quantity integer,
date timestamp)
{code}
for the
SELECT item_id, name FROM item i WHERE i.item_id IN
(SELECT item_id FROM order o where o.price = i.price) ORDER BY name
was:
For following table :
> Support Correlated-Subquery for In Clause
> ------------------------------------------
>
> Key: PHOENIX-6224
> URL: https://issues.apache.org/jira/browse/PHOENIX-6224
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0
> Reporter: chenglei
> Priority: Major
> Fix For: 5.1.0, 4.16.0
>
>
> Given following tables :
> {code:java}
> create table item
> (item_id varchar not null primary key,
> name varchar,
> price integer,
> discount1 integer,
> discount2 integer,
> supplier_id varchar,
> description varchar)
>
> create table order
> ( order_id varchar not null primary key,
> customer_id varchar,
> item_id varchar,
> price integer,
> quantity integer,
> date timestamp)
> {code}
> for the
> SELECT item_id, name FROM item i WHERE i.item_id IN
> (SELECT item_id FROM order o where o.price = i.price) ORDER BY name
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
