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

FireFly Filter syntax exposes internal error messages

    XMLWordPrintable

Details

    • Story
    • Status: Done
    • Resolution: Done
    • None
    • None
    • 0
    • SUIT Sprint 2018-03
    • 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

            loi Loi Ly added a comment -

            Fixed as part of ticket DM-13420

            loi Loi Ly added a comment - Fixed as part of ticket DM-13420

            People

              loi Loi Ly
              xiuqin Xiuqin Wu [X] (Inactive)
              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.