[
https://issues.apache.org/jira/browse/IGNITE-22260?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-22260:
----------------------------------------
Description:
{noformat}
@Test
@WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
public void test0() {
sql("CREATE TABLE tbl_ProductSales (ColID int, Product_Category
varchar(64), Product_Name varchar(64), TotalSales int);");
sql("CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT,
col5 INT, col6 INT, col7 INT, col8 INT);");
sql("INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo
Game',200),(2,'Game','PKO
Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);");
sql("INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8),
(11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888),
(1111,2222,3333,4444,5555,6666,7777,8888);");
List<List<Object>> res = sql(
"SELECT CASE WHEN 1 IN (SELECT MAX(col7) UNION ALL (SELECT
MIN(ColID) FROM tbl_ProductSales INNER JOIN another_T t2 ON t2.col5 = t2.col1))
THEN 2 ELSE NULL END FROM another_T t1;");
res.get(0);
}
{noformat}
{noformat}
expected=[[null]], actual=[[null], [null], [null], [null]]]
{noformat}
this statement is a part of:
test_grouped_correlated_subquery.test_ignore
was:
{noformat}
@Test
@WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
public void test0() {
sql("CREATE TABLE tbl_ProductSales (ColID int, Product_Category
varchar(64), Product_Name varchar(64), TotalSales int);");
sql("CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT,
col5 INT, col6 INT, col7 INT, col8 INT);");
sql("INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo
Game',200),(2,'Game','PKO
Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);");
sql("INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8),
(11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888),
(1111,2222,3333,4444,5555,6666,7777,8888);");
List<List<Object>> res = sql(
"SSELECT CASE WHEN 1 IN (SELECT MAX(col7) UNION ALL (SELECT
MIN(ColID) FROM tbl_ProductSales INNER JOIN another_T t2 ON t2.col5 = t2.col1))
THEN 2 ELSE NULL END FROM another_T t1;");
res.get(0);
}
{noformat}
{noformat}
expected=[[null]], actual=[[null], [null], [null], [null]]]
{noformat}
this statement is a part of:
test_grouped_correlated_subquery.test_ignore
> Sql. Unexpected results with CASE query.
> ----------------------------------------
>
> Key: IGNITE-22260
> URL: https://issues.apache.org/jira/browse/IGNITE-22260
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta1
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
>
> {noformat}
> @Test
> @WithSystemProperty(key = "IMPLICIT_PK_ENABLED", value = "true")
> public void test0() {
> sql("CREATE TABLE tbl_ProductSales (ColID int, Product_Category
> varchar(64), Product_Name varchar(64), TotalSales int);");
> sql("CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT,
> col5 INT, col6 INT, col7 INT, col8 INT);");
> sql("INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo
> Game',200),(2,'Game','PKO
> Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100);");
> sql("INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8),
> (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888),
> (1111,2222,3333,4444,5555,6666,7777,8888);");
> List<List<Object>> res = sql(
> "SELECT CASE WHEN 1 IN (SELECT MAX(col7) UNION ALL (SELECT
> MIN(ColID) FROM tbl_ProductSales INNER JOIN another_T t2 ON t2.col5 =
> t2.col1)) THEN 2 ELSE NULL END FROM another_T t1;");
> res.get(0);
> }
> {noformat}
> {noformat}
> expected=[[null]], actual=[[null], [null], [null], [null]]]
> {noformat}
> this statement is a part of:
> test_grouped_correlated_subquery.test_ignore
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
