Skip to content

Bug: Concatenate symbol || (vertical bars) is formatted incorrectly #1093

@jonjacs

Description

@jonjacs

Describe the bug

Describe the bug
When using "Format Query" it will incorrectly put a space between the vertical bars making the statement incorrect.

To Reproduce
Having

select info1 || ', ' || info2 from customer

and now doing "Format Query" will end up in:

SELECT
    info1 | | ', ' | | info2
FROM
    customer

Executing the query now results in....

ERROR:  operator does not exist: | unknown
LINE 2:     info1 | | ', ' | | info2
                    ^
HINT:  No operator matches the given name and argument type. You might need to add an explicit type cast.

Expected behavior
No extra space between the vertical bars should be added when formatting.

SELECT
    info1 || ', ' || info2
FROM
    customer

Screenshots

Image Image

Product

SQLPro Studio

App version

2025.76

Platform

macOS

Installation source

App Store

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions