[jira] [Created] (IGNITE-19358) Sql. PrepareServiceImpl prepareDML cache does not take dynamic parameters into account

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

Maksim Zhuravkov created IGNITE-19358:
-----------------------------------------

             Summary: Sql. PrepareServiceImpl prepareDML cache does not take dynamic parameters into account
                 Key: IGNITE-19358
                 URL: https://issues.apache.org/jira/browse/IGNITE-19358
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0.0-alpha2
            Reporter: Maksim Zhuravkov


PrepareService prepareDml cache does not take dynamic parameters into account which may leads to runtime errors when different queries reuse the same plan:

{code:java}
 @Test
    public void test() {
        sql("SELECT ? + 1", 1);
        sql("SELECT ? + 1", 'X');
    }
{code}

Error:

{code:java}
IGN-CMN-65535 TraceId:028c3d10-1840-4fa4-bad2-d1ed8498654a class java.lang.Character cannot be cast to class java.lang.Integer (java.lang.Character and java.lang.Integer are in module java.base of loader 'bootstrap')
org.apache.ignite.lang.IgniteException: IGN-CMN-65535 TraceId:028c3d10-1840-4fa4-bad2-d1ed8498654a class java.lang.Character cannot be cast to class java.lang.Integer (java.lang.Character and java.lang.Integer are in module java.base of loader 'bootstrap')
{code}

Expected behaviour: dml plan cache should take dynamic parameters/types of dynamic parameters into account.






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