ClickHouse/clickhouse-js

There is no way to get number of inserted rows

gorshkov-leonid opened this issue · 0 comments

Describe the bug

When I insert rows in some client

INSERT INTO device_values(*)
   WITH
    (
        ....
    ) AS device_id
    SELECT ....
    WHERE device_id != 0

I can see result like

1 row(s) modified.

As the result value can be inserted or vice versa - not inserted.
I did not found any way how to handle it in clickhouse-js. "1 row" is what I want to get after execution. I could check before insert and did not make insert but it would be not so atomic operation.