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

Better error message for failed column name parses

    XMLWordPrintable

    Details

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

      Description

      The following query will break Qserv:

      SELECT objectId, objectId as o1.objectId FROM Object LIMIT 1
      

      ERROR 4005 (Proxy) at line 1: Cannot connect to Qserv master; 
      Exception in RPC call: ...tack/Linux64/lua/5.1.4/share/lua/5.1/xmlrpc/http.lua:41:
      connection refused
      

      Here is what vanilla MySQL does:

      ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual
      that corresponds to your MySQL server version for the right syntax to use near 
      '.objectId FROM   Object LIMIT 1' at line 1
      

        Attachments

          Issue Links

            Activity

            Hide
            fritzm Fritz Mueller added a comment -

            This appears to no longer crash Qserv, but returns a generic ParseException. It would still be good to improve the error message with at least an indication of where the parse failed.

            Show
            fritzm Fritz Mueller added a comment - This appears to no longer crash Qserv, but returns a generic ParseException. It would still be good to improve the error message with at least an indication of where the parse failed.

              People

              Assignee:
              fritzm Fritz Mueller
              Reporter:
              jammes Fabrice Jammes
              Watchers:
              Fritz Mueller, Nate Pease [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.