Description

It was OK in vsql or DbVisualizer but executed in DBeaver it failed with error messages "Missing a matching closing delimiter in statement " or "Syntax error at or near "n_Cnt" at character 7"

DBeaver Version

Community Edition 24.0.1.202403241413

Operating System

Windows 11

Database and driver

Database name: Vertica 23.4.0.7
Client: Vertica JDBC 23.4.0.7

Steps to reproduce

CREATE OR REPLACE PROCEDURE TEST1()
LANGUAGE PLvSQL AS 
$$
DECLARE
    i INT := 1;
BEGIN
    WHILE true LOOP
        IF i = 10 THEN
            EXIT;
        END IF;
    
        i := i + 1;
        
        RAISE NOTICE 'i [%]', i;
    END LOOP;
END;
$$;

--> Missing a matching closing delimiter in statement

CREATE OR REPLACE PROCEDURE TEST2()
LANGUAGE PLvSQL AS 
$$
DECLARE
        n_Cnt               INT;  
BEGIN 
        n_Cnt := 0;
        IF ( n_Cnt = 1 ) THEN
            RETURN  ;
        END IF;
END;
$$;

--> syntax error at or near "n_Cnt

Additional context

No response