Evgeny Stanilovsky created IGNITE-22260:
-------------------------------------------
Summary: 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
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(
"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
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
