[
https://issues.apache.org/jira/browse/IGNITE-25297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov updated IGNITE-25297:
--------------------------------------
Description:
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 useful from a user standpoint
and look quite confusing.
was:
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 look quite confusing.
> 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 useful from a user
> standpoint and look quite confusing.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
