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

          blocks

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-530 Table column names in new parser

          • Done

          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-4531

          add support for multiplication in the select statement

          		3 Fritz Mueller 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-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-2686

          Query parser/analysis/rewriting

          		Unassigned To Do
          DM-1393

          Add support for special characters in database and table names

          		13 Fritz Mueller To Do
          DM-905

          Improve JOIN syntax support

          		Unassigned 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-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-3361

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

          		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-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-3165

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

          		Unassigned Invalid
           
          		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

            Activity

            No work has yet been logged 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.