Skip to content

PostgreSQL array slice syntax misinterpreted as variable placeholder #461

@ouariachi

Description

@ouariachi

When executing a SQL query containing an array slice expression like:

SELECT a[1:array_length(a,1)-1] FROM (SELECT ARRAY[1,2,3] AS a) t;

Outerbase Studio incorrectly detects the : as the start of a variable placeholder (e.g., :array_length) and prompts the user to input a value.

Expected behavior

The : inside PostgreSQL array slice syntax should be parsed as part of the SQL expression, not as a parameter placeholder.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions