Iurii Gerzhedovich created IGNITE-23097:
-------------------------------------------
Summary: Sql. Invalid plan for IN with mix exact and approximate
numerics
Key: IGNITE-23097
URL: https://issues.apache.org/jira/browse/IGNITE-23097
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Iurii Gerzhedovich
We can't get a plan for execution a query like
{code:java}
SELECT c1 FROM T1 WHERE c1 IN (2.939049E38){code}
Where IN contains approximate numeric (FLOAT or DOUBLE) and c1 - it's a column
with any exact numeric type ( REAL, SMALLINT, INT, LONG, DECIMAL).
For aforementioned query I get
{code:java}
org.opentest4j.AssertionFailedError: Invalid plan (null):
TableScan(table=[[PUBLIC, T1]], tableId=[1], filters=[=(CAST($t0):DOUBLE,
2.939049E38)], requiredColumns=[{0}]): rowcount = 15000.0, cumulative cost =
IgniteCost [rowCount=100000.0, cpu=400000.0, memory=0.0, io=0.0, network=0.0],
id = 32{code}
See
org.apache.ignite.internal.sql.engine.planner.datatypes.NumericInTypeCoercionTest#literals
Let's investigate and fix it.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
