Skip to content

PostgreSQL syntax highlighting doesn't recognize jsonb question mark (?) operator #1615

@BoykoAlex

Description

@BoykoAlex

Describe the bug
Syntax highlighting fails to recognize the following as a valid native query:

@Query(
  nativeQuery = true,
  value = """
  SELECT *
  FROM some_table
  WHERE jsonb_field ? 'some_key'
  """
)
void example();
Image

More information about the operator can be found at
https://www.postgresql.org/docs/9.5/functions-json.html#FUNCTIONS-JSONB-OP-TABLE

To Reproduce
Paste the example query into any JpaRepository interface.

I've currently set SQL_SYNTAX option from ERROR to HINT to get rid of the error.

VS Code Version: 1.102.3 (Universal)
All the extensions are up to date

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions