Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix(clickhouse): generate redundant aliases to workaround clickhouse naming behavior #9525

Conversation

cpcloud
Copy link
Member

@cpcloud cpcloud commented Jul 5, 2024

Found during #9508.

This PR works around an apparent upstream bug in ClickHouse where right-side join operand column references are not correctly recognized.

@@ -350,7 +351,7 @@ def test_create_table_no_syntax_error(con):


def test_password_with_bracket():
password = f'{os.environ.get("IBIS_TEST_CLICKHOUSE_PASSWORD", "")}['
password = f'{os.environ.get("IBIS_TEST_CLICKHOUSE_PASSWORD", "")}[]'
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I changed this because an unmatched [ messes with neovim indentation.

@cpcloud cpcloud added this to the 9.2 milestone Jul 5, 2024
@cpcloud cpcloud added bug Incorrect behavior inside of ibis clickhouse The ClickHouse backend labels Jul 5, 2024
@cpcloud cpcloud requested a review from gforsyth July 5, 2024 12:44
@cpcloud
Copy link
Member Author

cpcloud commented Jul 5, 2024

Reported upstream here: ClickHouse/ClickHouse#66133

@cpcloud cpcloud force-pushed the workaround-upstream-clickhouse-aliasing-bug branch 2 times, most recently from cce2f32 to 2d3a38a Compare July 6, 2024 11:31
@cpcloud cpcloud force-pushed the workaround-upstream-clickhouse-aliasing-bug branch from 2d3a38a to 3b4cfbe Compare July 9, 2024 16:07
Copy link
Member

@gforsyth gforsyth left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

:shipit:

@gforsyth gforsyth merged commit b44dac2 into ibis-project:main Jul 13, 2024
76 checks passed
@cpcloud cpcloud deleted the workaround-upstream-clickhouse-aliasing-bug branch July 13, 2024 18:04
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Incorrect behavior inside of ibis clickhouse The ClickHouse backend
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants