[jira] [Updated] (IGNITE-24372) Sql. Ability to check error codes in SqlLogic tests

["Iurii Gerzhedovich (Jira)" <ji...@apache.org>]

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

Iurii Gerzhedovich updated IGNITE-24372:
----------------------------------------
    Description: 
As of now, we can verify that any statements in SQLLogic tests have failed with an error and check the corresponding error message. It would be useful to also have the ability to check the error code returned by AI3.

for example:
{code:java}
statement error: IGN-SQL-8 Cast function cannot convert value of type CHAR(1) to type VARBINARY
SELECT CAST('0' AS VARBINARY);{code}

  was:
As of now, we can verify that any statements in SQLLogic tests have failed with an error and check the corresponding error message. It would be useful to also have the ability to check the error code returned by AI3.

for example:
{code:java}
statement error: Cast function cannot convert value of type CHAR(1) to type VARBINARY
error code: Sql.STMT_VALIDATION_ERR
SELECT CAST('0' AS VARBINARY);{code}


> Sql. Ability to check error codes in SqlLogic tests
> ---------------------------------------------------
>
>                 Key: IGNITE-24372
>                 URL: https://issues.apache.org/jira/browse/IGNITE-24372
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Iurii Gerzhedovich
>            Priority: Major
>              Labels: ignite-3
>
> As of now, we can verify that any statements in SQLLogic tests have failed with an error and check the corresponding error message. It would be useful to also have the ability to check the error code returned by AI3.
> for example:
> {code:java}
> statement error: IGN-SQL-8 Cast function cannot convert value of type CHAR(1) to type VARBINARY
> SELECT CAST('0' AS VARBINARY);{code}



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