Details
-
Type:
Story
-
Status: To Do
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: Qserv
-
Labels:None
-
Story Points:13
-
Epic Link:
-
Sprint:DB_F18_08, DB_F18_09, DB_F18_10
-
Team:Data Access and Database
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.
I documented it, see https://dev.lsstcorp.org/trac/wiki/db/ScalableArchSQL#DatabaseandTableNames