Skip to content

ClickHouse doesn't return affected rows via MySQL protocol for INSERT queries after 20.5+ #16605

@Slach

Description

@Slach

Describe the bug
ClickHouse doesn't return affected rows via MySQL protocol for INSERT queries after 20.5+

How to reproduce
i create clear docker-compose environment for reproduce behavior MySQL + clickhouse + php + python
https://gist.github.com/Slach/aa67440ce856a3a53f64f92eeddfbc1b

Queries to run that lead to unexpected result

INSERT INTO default.t1(n) SELECT * FROM numbers(1000)

Expected behavior
MySQL protocol shall return affected rows field for INSERT queries (it works successful in 20.3 and 20.4)
image

Actual behavior
image

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official release

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions