Field names with a ' ' (space) character in them don't seem to work in the WHERE clause

[zeigernz]

Plugin version: 6.3.2.0
Elasticsearch version: 6.3.2

It looks like when there is a ' ' (space) character in the field name in the where clause, it doesn't match any document.

Test:
Step 1. Index a document (this will automatically create an index as well)

curl -X PUT \
  http://localhost:9200/foobarbaz/quux/12345 \
  -H 'Content-Type: application/json' \
  -d '{
	"name": "foo",
	"last name": "bar"
}'

Step 2. Query documents with the query:

select * from foobarbaz where `last name` = 'bar'

curl -X GET \
  'http://localhost:9200/_sql?sql=select%20%2A%20from%20foobarbaz%20where%20`last%20name`%20=%20%27bar%27'

Step 2 should return 1 hit (the document that we indexed in step 1). But it doesn't.

[shi-yuan]

http://localhost:9200/_sql?sql=SELECT%20*%20FROM%20test%20WHERE%20%5B'last%20name'%5D%3D'bar'

[zeigernz]

Thank you. That resolves the problem.

How does this test pass though?

elasticsearch-sql/src/test/java/org/nlpcn/es4sql/QueryTest.java

Line 65 in 38ad264

public void selectFieldWithSpace() throws IOException, SqlParseException, SQLFeatureNotSupportedException {

It (and other similar tests) should be updated and some documentation added around this.

[shi-yuan]

Thanks!