[jira] [Updated] (IGNITE-26420) Sql. ResultSetMetadata column name look up fails with IllegalArgumentException Malformed identifier

[Maksim Zhuravkov (Jira)]

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

Maksim Zhuravkov updated IGNITE-26420:
--------------------------------------
    Description: 
Reproducer: 

Result set's column names are col1, Col2, Col 3, resultset indexOf class 
IgniteNameUtils parseIdentifier and fails

{noformat}
 @Test
    public void test() {
        ResultSet<SqlRow> rs = igniteSql().execute(null, "SELECT 1 as col1, 2 
as \"Col2\", 3 as \"Col 3\"");
        ResultSetMetadata metadata = rs.metadata();
        
        for (var col : metadata.columns()) {
            System.err.println(col.name());
            System.err.println(metadata.indexOf(col.name())); 
        }
    }
{noformat}

Results:
{noformat}
 java.lang.IllegalArgumentException: Malformed identifier [identifier=Col 3, 
pos=3]
{noformat}



  was:
Reproducer: 

A result set column names are col1, Col2, Col 3, resultset indexOf class 
IgniteNameUtils parseIdentifier and fails

{noformat}
 @Test
    public void test() {
        ResultSet<SqlRow> rs = igniteSql().execute(null, "SELECT 1 as col1, 2 
as \"Col2\", 3 as \"Col 3\"");
        ResultSetMetadata metadata = rs.metadata();
        
        for (var col : metadata.columns()) {
            System.err.println(col.name());
            System.err.println(metadata.indexOf(col.name())); 
        }
    }
{noformat}

Results:
{noformat}
 java.lang.IllegalArgumentException: Malformed identifier [identifier=Col 3, 
pos=3]
{noformat}




> Sql. ResultSetMetadata column name look up fails with 
> IllegalArgumentException Malformed identifier
> ---------------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-26420
>                 URL: https://issues.apache.org/jira/browse/IGNITE-26420
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql ai3
>    Affects Versions: 3.0
>            Reporter: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> Reproducer: 
> Result set's column names are col1, Col2, Col 3, resultset indexOf class 
> IgniteNameUtils parseIdentifier and fails
> {noformat}
>  @Test
>     public void test() {
>         ResultSet<SqlRow> rs = igniteSql().execute(null, "SELECT 1 as col1, 2 
> as \"Col2\", 3 as \"Col 3\"");
>         ResultSetMetadata metadata = rs.metadata();
>         
>         for (var col : metadata.columns()) {
>             System.err.println(col.name());
>             System.err.println(metadata.indexOf(col.name())); 
>         }
>     }
> {noformat}
> Results:
> {noformat}
>  java.lang.IllegalArgumentException: Malformed identifier [identifier=Col 3, 
> pos=3]
> {noformat}



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