René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : ClickHouse : Parametric type Nullable(Decimal(p, s)) not supported as CAST target","articleBody":"  ## Failing SQL Feature\n\n  ClickHouse supports parametric (constructor-style) data types as the target of a `CAST`, including nested ones such as `Nullable(Decimal(10, 2))`. Here `Decimal(10, 2)` declares a decimal with precision 10 and scale 2, and `Nullable(...)` wraps it so the column can also hold NULL. JSQLParser fails to parse this type expression when it is used as the target type of a `CAST(... AS ...)`.\n\n  See the ClickHouse docs:\n  - https://clickhouse.com/docs/en/sql-reference/data-types/nullable\n  - https://clickhouse.com/docs/en/sql-reference/data-types/decimal\n\n  ## Full SQL Example\n  \n  ```\nCREATE TABLE cast_demo (id UInt32, x Float64) ENGINE = MergeTree ORDER BY id;\n  INSERT INTO cast_demo (id, x) VALUES (1, 10.5), (2, 3.14159), (3, 1234567.891), (4, 0);\n  SELECT CAST(x AS Nullable(Decimal(10, 2))) FROM cast_demo;\n```\n\n  ## Parsing Error\n\n```\nParseException: Encountered: \u003cOPENING_BRACKET\u003e / \"(\", at line 3, column 25, in lexical state DEFAULT.\nWas expecting one of these terminals within expansion starting at 9127:5:\n    \u003cK_FORMAT\u003e (inside 9125:5) ...\n    \u003cCLOSING_BRACKET\u003e (inside 9127:5) \n```\n\nTested with ClickHouse version: 25.8","author":{"url":"https://github.com/tomershay","@type":"Person","name":"tomershay"},"datePublished":"2026-07-12T13:26:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2441/JSqlParser/issues/2441"}