ClickHouse / ClickHouse/clickhouse-odbc
Detect the number of affected rows by INSERT/UPDATE/DELETE.
Closed
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
Assessment
This issue has not been assessed yet.