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

FireFly Filter syntax exposes internal error messages

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Story Points:
      0
    • Epic Link:
    • Sprint:
      SUIT Sprint 2018-03
    • Team:
      Science User Interface

      Description

      Syntax error in filter specifiction, e.g. "Observed Passband" > U results in internal message display to user:

      Failed to load table. Error: BadSqlGrammarException:StatementCallback; bad SQL grammar [CREATE TABLE data_cdef2ea665d681650c55ca43c18264db AS (select b.*, (ROWNUM-1) as ROW_NUM from (select "No.", "Observed Passband", "Photometry Measurement", "Uncertainty", "Units", "Frequency", "NED Photometry Measurement", "NED Uncertainty", "NED Units", "Refcode", "Significance", "Published frequency", "Frequency Mode", "Coordinates Targeted", "Spatial Mode", "Qualifiers", "Comments", ROW_IDX from data where ("No." < 4) and ("Observed Passband" > U) ) as b) WITH DATA]; nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: U from:null

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              loi Loi Ly
              Reporter:
              xiuqin Xiuqin Wu [X] (Inactive)
              Watchers:
              Loi Ly, Xiuqin Wu [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.