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

F18 Improve Query Coverage in Qserv

    XMLWordPrintable

    Details

    • Type: Epic
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Epic Name:
      F18 Improve Query Coverage in Qserv
    • Story Points:
      87
    • WBS:
      02C.06.02.03
    • Team:
      Data Access and Database
    • Cycle:
      Fall 2018

      Description

      Currently Qserv supports only a limited subset of queries. We need to make sure it supports all queries that users need to run.

        Attachments

          Issue Links

          blocks

          Milestone - An overall project milestone DLP-823 DRP-ready Qserv Query Support

          • Major - Major loss of function.
          • Unplanned
          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. DM-1708 W16 Improve Query Coverage in Qserv

          • Done

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. DM-1721 S15 Improve Query Coverage in Qserv

          • Done

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. DM-2129 S19 Improve Query Coverage in Qserv

          • Done

          Stories in Epic (Custom Issue Matrix)

          Key Summary Story Points Assignee Status
           
          		DM-16532

          mysql proxy cannot do select on escaped schema/table name

          		 1 Nate Pease [X] (Inactive) Done
           
          		DM-16320

          change all qserv unit tests to use antlr4 and write parser expected failure unit test

          		 2 Nate Pease [X] (Inactive) Done
           
          		DM-15922

          Fix remaining unit test queries to execute using antlr4 parser

          		 16 Nate Pease [X] (Inactive) Done
           
          		DM-16015

          add support for MAX

          		0.5 Nate Pease [X] (Inactive) Done
           
          		DM-16218

          verify QSMySQLListener adapters handle or throw grammar possibilities

          		 6 Nate Pease [X] (Inactive) Done
           
          		DM-16060

          factor qserv code for choice between antlr v2 parser and antlr4 parser.

          		14 Nate Pease [X] (Inactive) Done
           
          		DM-15616

          add support for IS NULL and improve error message

          		 4 Nate Pease [X] (Inactive) Done
           
          		DM-15615

          handle exceptions thrown by antlr4 and return a sensible error message

          		 2 Nate Pease [X] (Inactive) Done
           
          		DM-16407

          Like should not be the same as NOT LIKE

          		 1 Nate Pease [X] (Inactive) Done
           
          		DM-14714

          Fix blob quoting problem in result aggregation

          		 6 Nate Pease [X] (Inactive) Done
           
          		DM-3696

          Gracefully catch incorrect syntax in "SELECT * AS x FROM t"

          		 Unassigned Done
           
          		DM-2902

          Fix problem with extra paranthesis in GROUP BY

          		 Unassigned Done
           
          		DM-1693

          Update czar for per-table overlap (Facade, RelationGraph)

          		 6 Andy Salnikov Done
           
          		DM-4779

          Queries with unrecognized function hang

          		 Unassigned Done
           
          		DM-4300

          Parser error kills czar

          		 Unassigned Done
           
          		DM-4203

          Query "SELECT count(*) as COUNT FROM Object WHERE objectId IN (500)" crash Qserv

          		 Unassigned Done
           
          		DM-2651

          Handle queries similar to "select 1"

          		 Unassigned Done
           
          		DM-16718

          add support for XOR

          		 6 Nate Pease [X] (Inactive) Invalid

            Activity

            There are no comments yet on this issue.

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              fritzm Fritz Mueller
              Reviewers:
              Nate Pease [X] (Inactive)
              Watchers:
              Fritz Mueller, Vaikunth Thukral
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.