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

Posted to issues@calcite.apache.org by "Zhuang (Jira)" <ji...@apache.org> on 2019/10/28 09:18:00 UTC

[jira] [Created] (CALCITE-3453) insert into postgresql doesn't commit the transaction

Zhuang created CALCITE-3453:
-------------------------------

             Summary: insert into postgresql doesn't commit the transaction
                 Key: CALCITE-3453
                 URL: https://issues.apache.org/jira/browse/CALCITE-3453
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.21.0
            Reporter: Zhuang


When insert into postgresql, no row inserted.

After inspect using wireshark, seems postgresql server rollback the insert when the connection is closing.

The problem code is in +org.apache.calcite.runtime.ResultSetEnumerable.java+.

In *+enumeratorBasedOnPreparedStatement+* the connection doesn't commit the transation. And in *+closeIfPossible+* the connection is also close without commit transation, so postgresql server rollback the insert.

Is this a bug, or a mis-config ??



--
This message was sent by Atlassian Jira
(v8.3.4#803005)