jamesrayoub opened a new issue #16378:
URL: https://github.com/apache/superset/issues/16378
When filtering on a string dimension which contains an apostrophe (i.e.
family name - O'Brien), the sql engine generates a `WHERE` statement which uses
single quotes instead of double quotes which leads to:
`400 Syntax error: Parenthesized expression cannot be parsed as an
expression, struct constructor, or subquery`
### Expected results
`WHERE project_name IN ("Beverly O'Brien")`
### Actual results
`WHERE project_name IN ('Beverly O''Brien')`
### Notes
Using a BigQuery database connection
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
