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

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-26420:
-----------------------------------------

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


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}





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