[jira] [Updated] (IGNITE-18365) Sql. class java.lang.Integer cannot be cast to class java.lang.String in ORDER BY with CAST

[Yury Gerzhedovich (Jira)]

     [ 
https://issues.apache.org/jira/browse/IGNITE-18365?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yury Gerzhedovich updated IGNITE-18365:
---------------------------------------
    Description: 
Actions leads to exception:
{code:java}
CREATE TABLE strings(a VARCHAR);
CREATE TABLE integers(i INTEGER);
INSERT INTO integers VALUES (3), (4), (NULL);
INSERT INTO strings SELECT * FROM integers;
{code}
{code:java}
Caused by: java.lang.ClassCastException: class java.lang.Integer cannot be cast 
to class java.lang.String (java.lang.Integer and java.lang.String are in module 
java.base of loader 'bootstrap')
        at 
org.apache.ignite.internal.schema.row.RowAssembler.writeValue(RowAssembler.java:228)
        at 
org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.updateTuple(IgniteTableImpl.java:421)
        at 
org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.toModifyRow(IgniteTableImpl.java:314)
{code}

  was:
Actions leads to exception:
{code:java}
CREATE TABLE strings(a VARCHAR);
CREATE TABLE integers(i INTEGER);
INSERT INTO integers VALUES (3), (4), (NULL);
INSERT INTO strings SELECT * FROM integers;
SELECT * FROM strings ORDER BY cast(a AS INTEGER);
{code}

{code:java}
Caused by: java.lang.ClassCastException: class java.lang.Integer cannot be cast 
to class java.lang.String (java.lang.Integer and java.lang.String are in module 
java.base of loader 'bootstrap')
        at 
org.apache.ignite.internal.schema.row.RowAssembler.writeValue(RowAssembler.java:228)
        at 
org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.updateTuple(IgniteTableImpl.java:421)
        at 
org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.toModifyRow(IgniteTableImpl.java:314)
{code}




> Sql. class java.lang.Integer cannot be cast to class java.lang.String in 
> ORDER BY with CAST
> -------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-18365
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18365
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 3.0.0-beta1
>            Reporter: Evgeny Stanilovsky
>            Priority: Major
>              Labels: ignite-3
>
> Actions leads to exception:
> {code:java}
> CREATE TABLE strings(a VARCHAR);
> CREATE TABLE integers(i INTEGER);
> INSERT INTO integers VALUES (3), (4), (NULL);
> INSERT INTO strings SELECT * FROM integers;
> {code}
> {code:java}
> Caused by: java.lang.ClassCastException: class java.lang.Integer cannot be 
> cast to class java.lang.String (java.lang.Integer and java.lang.String are in 
> module java.base of loader 'bootstrap')
>       at 
> org.apache.ignite.internal.schema.row.RowAssembler.writeValue(RowAssembler.java:228)
>       at 
> org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.updateTuple(IgniteTableImpl.java:421)
>       at 
> org.apache.ignite.internal.sql.engine.schema.IgniteTableImpl.toModifyRow(IgniteTableImpl.java:314)
> {code}



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