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

Revisit Parser / IR

    XMLWordPrintable

    Details

    • Type: Epic
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Epic Name:
      Revisit Qserv Parser / IR
    • Story Points:
      94
    • WBS:
      02C.06.02.03
    • Team:
      Data Access and Database

      Description

      Revisit the existing parser code

      • consider reusing the code from maxscale or (antrl3) mysql parser from mysqlworkbench, or maybe reuse http://savage.net.au/SQL/sql-92.bnf.html and wrap in bison
      • separate IR node productions from grammar

        Attachments

          Issue Links

          Stories in Epic (Custom Issue Matrix)

          Key Summary Story Points Assignee Status
          DM-4017

          Support OR between SecondaryIndex and spatial lookup

          Unassigned To Do
          DM-2686

          Query parser/analysis/rewriting

          Unassigned To Do
          DM-2311

          Fix select expression ""SELECT *, NULL as poly"

          Unassigned To Do
          DM-2296

          Better error message for failed column name parses

          Fritz Mueller To Do
          DM-2059

          Clean up QuerySession-related code in czar

          8 Unassigned To Do
          DM-2859

          Return error for "SELECT a FROM T ORDER BY b" for has-chunks query

          4 Unassigned To Do
          DM-3187

          Add support for non-aliased fields in ORDER BY clause

          Unassigned To Do
          DM-3166

          Suppress merge query for non-chunked query

          Unassigned To Do
          DM-1393

          Add support for special characters in database and table names

          13 Fritz Mueller To Do
          DM-4531

          add support for multiplication in the select statement

          3 Fritz Mueller To Do
          DM-905

          Improve JOIN syntax support

          Unassigned To Do
          DM-4211

          Prevent use of secondary index for SQL predicate "objectId op val" if op is not '='

          Unassigned In Progress
           
          DM-2394

          Fix queries contaning fields names prefixed by a table name/alias

          Unassigned Done
           
          DM-2901

          Improve error message triggered by selecting unknown column

          Unassigned Done
           
          DM-2874

          Add support for polygon-based searches

          Unassigned Done
           
          DM-3420

          Fix problem with JOIN and LIMIT

          Unassigned Done
           
          DM-3361

          Fix czar crash and improve error message for queries that select "dec"

          Unassigned Done
           
          DM-2410

          Implement DOT-based graph vizualization for query IR

          Unassigned Won't Fix
           
          DM-2378

          Determine if MERGE_ERROR handling is correct

          John Gates Won't Fix
           
          DM-2888

          Allow OR after spatial constraint

          Unassigned Won't Fix
           
          DM-5211

          "SELECT y_flagNegative from Object where y_flagNegative != (1)" crash Qserv master

          Unassigned Invalid
           
          DM-1758

          Spatial restrictors on child tables are not handled properly

          Unassigned Invalid
           
          DM-3972

          Convert Qserv restrictor names to const int in C++ code

          Unassigned Invalid
           
          DM-1986

          Add support for queries involving qserv_area_spec on non-partitioned tables

          20 Nate Pease [X] (Inactive) Invalid
           
          DM-1985

          Reject queries involving qserv_areaSpec_box on non-partitioned tables

          Unassigned Invalid
           
          DM-1976

          Fix SQL using join and "select alias.fieldname"

          Unassigned Invalid
           
          DM-3165

          "SELECT DISTINCT foo FROM LSST.Filter AS f" shouldn't require a merge step

          Unassigned Invalid

            Activity

            There are no comments yet on this issue.

              People

              Assignee:
              fritzm Fritz Mueller
              Reporter:
              fritzm Fritz Mueller
              Watchers:
              Fritz Mueller, Serge Monkewitz
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.