You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2025/05/05 14:19:00 UTC

[jira] [Updated] (IGNITE-25297) Sql. Reject scripts that contain only COMMIT or only START TRANSACTION statements

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

Maksim Zhuravkov updated IGNITE-25297:
--------------------------------------
    Summary: Sql. Reject scripts that contain only COMMIT or only START TRANSACTION statements  (was: Sql. Reject scripts that contains only COMMIT or only START TRANSACTION statements)

> Sql. Reject scripts that contain only COMMIT or only START TRANSACTION statements
> ---------------------------------------------------------------------------------
>
>                 Key: IGNITE-25297
>                 URL: https://issues.apache.org/jira/browse/IGNITE-25297
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Priority: Major
>              Labels: ignite-3
>
> The SQL CLI uses SQL scripts for running SQL commands but following scripts are valid:
> {noformat}
> Connected to http://localhost:10300
> [node1]> sql
> sql-cli> COMMIT;
> Updated 0 rows.
> sql-cli> COMMIT;COMMIT;
> Updated 0 rows.
> Updated 0 rows.
> sql-cli> START TRANSACTION;
> Updated 0 rows.
> sql-cli> START TRANSACTION;
> Updated 0 rows.
> sql-cli> 
> {noformat}
> Let's reject such scripts because they do nothing and quite confusing.



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