ClickHouse / ClickHouse/clickhouse-odbc

Detect the number of affected rows by INSERT/UPDATE/DELETE.

Closed
#335 1 comment 3 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
285
Forks
105
Avg merge
3h 56m
Merged PRs (30d)
3

Description

As mentioned in

https://github.com/ClickHouse/clickhouse-odbc/issues/324#issuecomment-724233892

comment we need the clickhouse ODBC driver to be able to detect the number of affected rows by INSERT/UPDATE/DELETE (to return correct result for SQLRowCount function).
This is for developing ETL on informatica powercenter that connects to clickhouse with ODBC.
Without this feature Informatica gets 0 as return value from SQLRowCount function when inserting data to clickhouse through ODBC. Informatica then decides that 0 rows have been inserted and repeats insert. So this inserting repeats infinitely.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.