[CALCITE-3453] insert into postgresql doesn't commit the transaction

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.21.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Zhuang
• Created: 28/Oct/19 09:17
• Updated: 29/Oct/19 23:11

Description

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 ??