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

Confusing message about multiple CROSS/COMMA JOIN despite no CROSS JOINs #23188

Open
adrian17 opened this issue Apr 16, 2021 · 1 comment
Open
Assignees

Comments

@adrian17
Copy link

Reproduced on server 21.3.4.

WITH example as (select 'date' as date) # not needed for repro, just for a single-query repro
SELECT date
FROM example
LEFT JOIN 
(
    SELECT 'date' as date
) AS users ON example.date = users.date
LEFT JOIN 
(
    SELECT 'date' as date
) AS map USING date

Produces an error message

DB::Exception: Multiple CROSS/COMMA JOIN do not support USING

I'm okay with it being not supported with several JOINs, but the error message here makes no sense, as none of these are cross joins :)

@adrian17 adrian17 added the bug Confirmed user-visible misbehaviour in official release label Apr 16, 2021
@alexey-milovidov alexey-milovidov added usability and removed bug Confirmed user-visible misbehaviour in official release labels Apr 16, 2021
@vdimir
Copy link
Member

vdimir commented Jun 18, 2021

Related to #23881, but is not solved

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants