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

new analyzer: Positional argument is out of bounds in distributed queries #62289

Closed
den-crane opened this issue Apr 4, 2024 · 0 comments · Fixed by #62362
Closed

new analyzer: Positional argument is out of bounds in distributed queries #62289

den-crane opened this issue Apr 4, 2024 · 0 comments · Fixed by #62362
Assignees
Labels
analyzer Issues and pull-requests related to new analyzer bug Confirmed user-visible misbehaviour in official release

Comments

@den-crane
Copy link
Contributor

https://fiddle.clickhouse.com/ba2e163f-644b-4a4c-b6f7-614aa285ca00

set allow_experimental_analyzer=0;

select 0 as x
from remote('127.0.0.{1,2}', system.one)
group by x
format Pretty;

   +---+
   | x |
   +---+
1. | 0 |
   +---+


set allow_experimental_analyzer=1;

select 0 as x
from remote('127.0.0.{1,2}', system.one)
group by x
format Pretty;

Received exception from server (version 24.3.2):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: 
Positional argument number 0 is out of bounds. Expected in range [1, 1]. 
In scope SELECT 0 AS x FROM system.one AS __table1 GROUP BY 0. (BAD_ARGUMENTS)
(query: select 0 as x
from remote('127.0.0.{1,2}', system.one)
group by x
format Pretty;)
@den-crane den-crane added the potential bug To be reviewed by developers and confirmed/rejected. label Apr 4, 2024
@den-crane den-crane changed the title new analyzer: Positional argument number 0 is out of bounds in Distrbiuted queries new analyzer: Positional argument is out of bounds in distrbiuted queries Apr 4, 2024
@nikitamikhaylov nikitamikhaylov added bug Confirmed user-visible misbehaviour in official release analyzer Issues and pull-requests related to new analyzer and removed potential bug To be reviewed by developers and confirmed/rejected. labels Apr 4, 2024
@den-crane den-crane changed the title new analyzer: Positional argument is out of bounds in distrbiuted queries new analyzer: Positional argument is out of bounds in distributed queries Apr 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
analyzer Issues and pull-requests related to new analyzer bug Confirmed user-visible misbehaviour in official release
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants