[IGNITE-21002] Document the ability to execute SQL multi-statement queries.

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: documentation
• Labels: ignite-3
• Epic Link: Basic Multi Statement Support
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Pavel Pereslegin
• Created: 30/Nov/23 16:42
• Updated: 18/Oct/24 12:09

Description

We need to add documentation about the ability to execute SQL scripts.

One thing to remember to mention is that if the user leaves an open transaction initiated by the script, it will be rolled back after the script completes execution.
For example:

CREATE TABLE TEST(ID INT);
START TRANSACTION;
INSERT INTO TEST(1);

Since the transaction remains open, all changes made within it will be undone when the script completes.

Another thing is that COMMIT does nothing without an open script transaction.

CREATE TABLE TEST(ID INT);
COMMIT;
COMMIT;

Script must be executed without errors.

JDBC

TX control statements do not supported in non autocommit mode (see IGNITE-21020).

At the moment AI3 executes statements only in lazy mode, and this mode does not quite fit the jdbc standard (see IGNITE-21133).

Issue Links

• is blocked by: IGNITE-20463 Sql. Integration of TX-related statements into sql script processor
• is blocked by: IGNITE-20661 JDBC. Support multi statement queries by JDBC
• links to: GitHub Pull Request #4597