Bind parameters not recognized with PostgreSQL array syntax

[brankoradovanovic-mcom]

Description

When bind parameters are used with PostgreSQL array syntax (i.e. inside square brackets), they are not recognized and are not substituted.

DBeaver Version

CE 25.0.2

Operating System

Windows 11 Pro 24H2

Database and driver

PostgreSQL 13.16, JDBC driver 42.7.2

Steps to reproduce

1. Enter the following SQL text:
   select :p1, array[:p2]

2. Click on "Execute SQL query"

3. DBeaver displays the following dialog:

Unlike :p1, :p2 is not recognized as a parameter and is not substituted, so the execution will fail:

SQL Error [42601]: ERROR: syntax error at or near ":"

Both :p1 and :p2 should be recognized and substituted with the user-provided string in the Bind Parameter(s) dialog, so e.g. entering 'a' for :p2 should produce a single-member array in the second column when the above SQL statement is executed. This is very likely an SQL parsing issue.

[ged-yuko]

As a walkaround - extra whitespace after the square bracket and before the colon character helps:
select :p1, array[ :p2]

So it is something with about the [: sequence. Interesting. =)

[E1izabeth]

@brankoradovanovic-mcom, thanks for the bug report.
@ged-yuko, thanks for the investigation and workaround.

[ged-yuko]

Strangely enough, there is such a case: #5440
And there already was a discussion about it: #10390

[brankoradovanovic-mcom]

The correct parsing is indeed even trickier than it appears. Adding whitespace is a reasonable workaround.