You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dmitry Sysolyatin (Jira)" <ji...@apache.org> on 2023/04/26 09:39:00 UTC

[jira] [Commented] (CALCITE-5612) Babel parser should support PostgreSQL's SET TRANSACTION command

    [ https://issues.apache.org/jira/browse/CALCITE-5612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17716633#comment-17716633 ] 

Dmitry Sysolyatin commented on CALCITE-5612:
--------------------------------------------

[~julianhyde] I've created a PR for this task. In the PR, I addressed your comments from CALCITE-5403 and fixed a few bugs related to unparsing (e.g., RESET ALL and RESET "ALL" are not equal in PostgreSQL).
Please review PR, when you will have time.

> Babel parser should support PostgreSQL's SET TRANSACTION command
> ----------------------------------------------------------------
>
>                 Key: CALCITE-5612
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5612
>             Project: Calcite
>          Issue Type: Bug
>          Components: babel
>    Affects Versions: 1.34.0
>            Reporter: Dmitry Sysolyatin
>            Assignee: Dmitry Sysolyatin
>            Priority: Major
>              Labels: pull-request-available
>
> SET TRANSACTION — set the characteristics of the current transaction
> Specification [1]:
> {code}
> SET TRANSACTION transaction_mode [, ...]
> SET TRANSACTION SNAPSHOT snapshot_id
> SET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...]
> where transaction_mode is one of:
>     ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
>     READ WRITE | READ ONLY
>     [ NOT ] DEFERRABLE
> {code}
> [1] https://www.postgresql.org/docs/current/sql-set-transaction.html



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