erickj opened a new issue #10619: URL: https://github.com/apache/druid/issues/10619
Please provide a detailed title: double quoting string values in SQL WHERE clauses result in a exception: "org.apache.calcite.tools.ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 1, column 49 to line 1, column 53:" single quoting the value yields the expected result. example below ### Affected Version 0.20.0 running in a standalone single-server ### Description Very strange issue here. I have a table (schema below) with a varchar 'ticker' column. When I run a query I must use single-quote characters around values for ticker. If I use double quotes I get the following error. Output copied from dsql: ``` dsql> SELECT count(*) FROM "stocks-5k" WHERE ticker = "AHH"; org.apache.calcite.tools.ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 1, column 49 to line 1, column 53: Column 'AHH' not found in any table dsql> SELECT count(*) FROM "stocks-5k" WHERE ticker = 'AHH'; ┌────────┐ │ EXPR$0 │ ├────────┤ │ 692 │ └────────┘ ``` table schema: ``` __time TIMESTAMP count BIGINT sum_adj_close DOUBLE sum_close DOUBLE sum_high DOUBLE sum_low DOUBLE sum_open DOUBLE sum_volume BIGINT ticker VARCHAR ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
