[jira] [Created] (IGNITE-26587) Sql. Scan with condition on float column can't use index.

["Andrey Mashenkov (Jira)" <ji...@apache.org>]

Andrey Mashenkov created IGNITE-26587:
-----------------------------------------

             Summary: Sql. Scan with condition on float column can't use index. 
                 Key: IGNITE-26587
                 URL: https://issues.apache.org/jira/browse/IGNITE-26587
             Project: Ignite
          Issue Type: Bug
          Components: sql ai3
            Reporter: Andrey Mashenkov


Assume, there is a table
{code:java}
CREATE TABLE test (id INT PRIMARY KEY, f FLOAT, d DOUBLE){code}
The next query can use index on float column, when a value passed to the condition as parameter
{code:java}
SELECT /*+ FORCE_INDEX(test_f_idx) */ f FROM test WHERE f > ?{code}
But when the value passed as literal - index can NOT be used.
{code:java}
SELECT /*+ FORCE_INDEX(test_f_idx) */ f FROM test WHERE f > 0.0::FLOAT{code}
Similar queries with using DOUBLE column works as expected in both cases (uses index).



--
This message was sent by Atlassian Jira
(v8.20.10#820010)