You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[BUG] JSQLParser 5.4-SNAPSHOT : ClickHouse : Tuple positional access via .N not supported in SELECT #2442
ClickHouse supports accessing tuple elements by their 1-based position using a .N suffix, such as tuple(1, 2, 3).2 which returns 2. The .N acts like a member accessor but with an integer index rather than a name. JSQLParser fails to parse this positional tuple access, treating the .2 as a floating-point token instead of an element accessor.
CREATE TABLE tuple_demo (id UInt32) ENGINE = MergeTree ORDER BY id;
INSERT INTO tuple_demo (id) VALUES (1);
SELECT tuple(1, 2, 3).2 FROM tuple_demo;
Parsing Error
ParseException: Encountered: <S_DOUBLE> / ".2", at line 1, column 22,
in lexical state DEFAULT.
Was expecting one of these terminals within expansion starting at 1753:23:
<EOF> (inside 1753:23)
<ST_SEMICOLON> (inside 1753:23)
Activity