Double quote is unsupported

[nkavian]

When trying this command SELECT * FROM objects WHERE _object="Event" LIMIT 4; I get Objects: no response;

But when trying SELECT * FROM objects WHERE _object='Event' LIMIT 4;, it works fine.

If double quotes are not supported, the error message should match accordingly.

[dai-chen]

@nkavian Thanks for reporting the issue! We don't support double quotes in legacy engine. In new SQL engine, double quoted text is treated as identifier: https://github.com/opendistro-for-elasticsearch/sql/blob/develop/docs/user/general/identifiers.rst#delimited-identifiers.

We may support MySQL-like ANSI_MODE so you can configure if double quotes are for literal or identifier. Need to evaluate this.

[nkavian]

Understood, it's okay if double quotes are not supported. I'm hoping that the error message could be more descriptive. Also, when I tried searching the documentation for double quotes, I didn't find anything that could help me understand what kind of quotes were supported. So my first experience using this plugin was difficult. Thanks.

[dai-chen]

Understood, it's okay if double quotes are not supported. I'm hoping that the error message could be more descriptive. Also, when I tried searching the documentation for double quotes, I didn't find anything that could help me understand what kind of quotes were supported. So my first experience using this plugin was difficult. Thanks.

@nkavian Thanks for your feedback! We've improved the error message for Run/Explain in Workbench here: #872. Closing this issue. Feel free to reopen if needed. Thanks!