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

Qserv does not parse alias within SELECT expressions

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Templates:
    • Story Points:
      8
    • Team:
      Data Access and Database

      Description

      As reported on https://community.lsst.org/t/qserv-alias-in-select-using-arithmetic/3543.

      Queries such as the following produce an error

      select cutOn-cutOff as range from Filter;
       
      ERROR 4110 (Proxy): Query processing error: QI=?: Failed to instantiate query: ParseException:Failed to instantiate query: “select cutOn-cutOff as range from Filter”
      

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  npease Nate Pease
                  Reporter:
                  vaikunth Vaikunth Thukral
                  Watchers:
                  Colin Slater, Dominique Boutigny, Fritz Mueller, John Gates, Kian-Tat Lim, Vaikunth Thukral
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Summary Panel