Skip to content

Ignore non-convertible values at any depth on the right side of the IN operator#7283

Merged
akuzm merged 1 commit intomasterfrom
aku/in-unconvertible
Oct 14, 2019
Merged

Ignore non-convertible values at any depth on the right side of the IN operator#7283
akuzm merged 1 commit intomasterfrom
aku/in-unconvertible

Conversation

@akuzm
Copy link
Copy Markdown
Contributor

@akuzm akuzm commented Oct 11, 2019

The values that are not convertible to the left argument type can't match anyway, so it is safe to discard them. We already do this for simple types, and this PR properly extends it to complex types: Array and Tuple.

Category (leave one):

  • Improvement

Short description (up to few sentences):
ClickHouse ignores values on the right side of IN operator that are not convertible to the left side type. Make it work properly for compound types -- Array and Tuple.

@akuzm akuzm force-pushed the aku/in-unconvertible branch from e45409f to 2172e2d Compare October 11, 2019 18:23
@akuzm akuzm added the pr-improvement Pull request with some product improvements label Oct 11, 2019
@alexey-milovidov
Copy link
Copy Markdown
Member

Please update the tests.

operator.

The values that are not convertible to the left argument type can't
match anyway, so it is safe to discard them.
@akuzm akuzm force-pushed the aku/in-unconvertible branch from 2172e2d to 160d8a6 Compare October 14, 2019 11:25
@akuzm akuzm merged commit 831fb2c into master Oct 14, 2019
@akuzm akuzm deleted the aku/in-unconvertible branch December 9, 2019 15:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

pr-improvement Pull request with some product improvements

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants