SQL: Introduce driver option to automatically escape meta patterns

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine

https://www.elastic.co/products/elasticsearch

Other

1k stars 24.82k forks source link

SQL: Introduce driver option to automatically escape meta patterns #40640

Open costin opened 5 years ago

costin commented 5 years ago

It looks like a number of consumers use the ODBC/JDBC metadata APIs incorrectly by not escaping the special _ and % chars in string patterns. Thus test_emp instead of being sent as test\_emp is being sent as is effectively meaning test?emp. As it is unclear when and if this issue will be solved, adding an option into the driver seems like a quicker way forward.

elasticmachine commented 5 years ago

Pinging @elastic/es-search

costin commented 5 years ago

/cc @bpintea

bpintea commented 5 years ago

/cc @bpintea

Implemented for ODBC in https://github.com/elastic/elasticsearch-sql-odbc/pull/143

matriv commented 4 years ago

@elastic/es-ql

elasticsearchmachine commented 2 years ago

Pinging @elastic/es-ql (Team:QL)

elasticsearchmachine commented 9 months ago

Pinging @elastic/es-analytical-engine (Team:Analytics)