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

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created IGNITE-18365:
-------------------------------------------

             Summary: 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


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}





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