-
Story
-
Resolution: Unresolved
-
Undefined
-
None
-
None
-
None
-
False
-
-
False
-
None
-
-
When the query (using scripts/gabi) contains the character " then the query fails
See e.g.:
wr-prod=> select users."email" from users where id in (select user_id from slack_users where slack_id='U02L1L0HTD0'); HTTP/400 returned: invalid character 'e' after object key:value pair
The same query without the apostrophes works:
wr-prod=> select users.email from users where id in (select user_id from slack_users where slack_id='U02L1L0HTD0');
email
------
mveber@redhat.com
TODO:
- Escape the apostrophes in the SQL queries the right way.