Uploaded image for project: 'Hybrid Cloud Console'
  1. Hybrid Cloud Console
  2. RHCLOUD-36713

StausBoard - error using or gabi script

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • 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.
         

              Unassigned Unassigned
              mveber@redhat.com Marek Veber
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: