Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
mageddo opened this issue Feb 16, 2023 · 0 comments
Open

Comments

@mageddo
Copy link
Member

mageddo commented Feb 16, 2023

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
@mageddo mageddo changed the title CSV Extract is not giving updated rows count CSV Extract is not giving updated rows count depending on the client Feb 16, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant