Skip to content

CSV Extract is not giving updated rows count depending on the client #12

@mageddo

Description

@mageddo

Given an statement like this

CSV2J COPY (
  SELECT * FROM TMP
)
TO '/tmp/csv.csv'
WITH CSV HEADER DELIMITER ';'

It wont return to the IDE like squirrel or dbeaver how many records were updated , maybe because they are trying to get the updated rows by executing

2023-02-16T02:42:48.087054 ProxiedStatement: getResultSet
2023-02-16T02:42:48.087227 ProxiedStatement: getMoreResults
2023-02-16T02:41:39.528735 ProxiedStatement: ProxiedStatement
2023-02-16T02:41:39.529160 ProxiedStatement: setFetchSize
2023-02-16T02:41:39.529411 ProxiedStatement: setMaxRows
2023-02-16T02:41:39.529659 ProxiedStatement: getMaxRows
2023-02-16T02:41:39.530363 ProxiedStatement: getConnection
2023-02-16T02:41:40.230132 m=streamSelect, sql=SELECT * FROM TMP, autoCommit=true
2023-02-16T02:41:40.251840 m=streamSelect, status=executed, sql=SELECT * FROM TMP
2023-02-16T02:42:48.085736 m=getWarnings
2023-02-16T02:42:48.086107 m=clearWarnings
2023-02-16T02:42:48.086320 ProxiedStatement: getWarnings
2023-02-16T02:42:48.086503 ProxiedStatement: clearWarnings
2023-02-16T02:42:48.086680 m=getMetaData
2023-02-16T02:42:48.086866 ProxiedStatement: getUpdateCount
2023-02-16T02:42:48.087054 ProxiedStatement: getResultSet
2023-02-16T02:42:48.087227 ProxiedStatement: getMoreResults
2023-02-16T02:42:48.088942 ProxiedStatement: close

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions