Skip to content

SQL: allow spaces in escape sequences #47401

Closed
@bpintea

Description

@bpintea

Elasticsearch/SQL now supports JDBC/ODBC escape sequences at server level.
However, the current parser requires the { escape begin character to be followed by the escape discriminator with no white space allowed in-between. Example: FUNCTION_ESC: '{FN';.
The BNF specification suggests white spaces would be allowed (maybe an ABNF would have made that explicit) and in support for that, other DBs supporting these escape sequences at server level do allow for spaces too (like MSSQL, DB2, MariaDB/MySQL).
Furhermore, also some applications - like PowerBI - generate escape sequences with spaces:
select { fn name(params) } etc.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions