Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-1393

Add support for special characters in database and table names

    XMLWordPrintable

    Details

    • Type: Story
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None

      Description

      At the moment special characters will confuse qserv. Example, if I create a database called `a@b*c$d`, and a table 'x', and I'll run "select * from x", I'll get:

      ERROR 4110 (Proxy): Qserv error: "NoSuchDb:Database 'a@b*c$d' does not exist."

      There are two ways to deal with it:
      a) simpler: detect that there is a special character in the name, and return a non-confusing error message saying that such name is disallowed
      b) proper: implement proper support, e.g., make sure database and table names are properly quoted everywhere.

      In the short term, until this is fixed, we will put in the documentation covering Qserv limitations that special characters are disallowed.

        Attachments

          Activity

          Show
          jbecla Jacek Becla added a comment - I documented it, see https://dev.lsstcorp.org/trac/wiki/db/ScalableArchSQL#DatabaseandTableNames
          Hide
          tjenness Tim Jenness added a comment -

          What happens with unicode?

          Show
          tjenness Tim Jenness added a comment - What happens with unicode?
          Hide
          jbecla Jacek Becla added a comment -

          Unicode has been only partly supported in mysql up until just a few years ago (see e.g. https://mathiasbynens.be/notes/mysql-utf8mb4). We are not requiring / not configuring mysqld to run with unicode at the moment, plus there is the issue of proper quoting throughout the code. Thus this story.

          Show
          jbecla Jacek Becla added a comment - Unicode has been only partly supported in mysql up until just a few years ago (see e.g. https://mathiasbynens.be/notes/mysql-utf8mb4 ). We are not requiring / not configuring mysqld to run with unicode at the moment, plus there is the issue of proper quoting throughout the code. Thus this story.
          Hide
          npease Nate Pease [X] (Inactive) added a comment -

          Ok Igor, I'm calling in my favor. Thanks for looking!

          Show
          npease Nate Pease [X] (Inactive) added a comment - Ok Igor, I'm calling in my favor. Thanks for looking!

            People

            Assignee:
            fritzm Fritz Mueller
            Reporter:
            fritzm Fritz Mueller
            Reviewers:
            Igor Gaponenko
            Watchers:
            Fritz Mueller, Igor Gaponenko, Nate Pease [X] (Inactive), Vaikunth Thukral
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Jenkins

                No builds found.