When creating a parameterized view using clickhouse-jdbc, a query parsing error occurs

[com-exem-route7]

Description

Occasionally, when creating a parameterized view, the query does not get parsed correctly.

• ClickHouse Version: 24.5.1.1763 (2R-1S)
• ClickHouse JDBC Version: clickhouse-jdbc-0.6.2-all.jar

Create Parameterized View Statement

CREATE VIEW default.test
AS 
WITH    
    toDateTime({from:String}, 'Asia/Seoul') AS FROM,    
    date_add(FROM, INTERVAL 1 MINUTE) AS TO,    
    {target_id:String} AS TARGET_ID 
SELECT FROM, TO, TARGET_ID

Debug

Result

CREATE VIEW default.test
AS 
WITH    
    toDateTime({from:String}, 'Asia/Seoul') AS FROM,    
    date_add(FROM, INTERVAL 1 MINUTE) AS TO,    
    {target_id:String} AS TARGET_ID 
SELECT FROM, TO, TARGET_ID
;


SELECT * 
FROM system.query_log 
WHERE 
    event_date = '2024-09-10' 
    AND event_time >= toDateTime('2024-09-10 16:14:00', 'Asia/Seoul') 
    AND user = 'admin'
;

[mohaidoss]

Up ;)