[DM-2881] Revisit Parser / IR - Jira

XML

Word

Printable

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

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

Ascending order - Click to sort in descending order

Jacek Becla created issue - 03/Jun/15 2:49 PM

Jacek Becla made changes - 03/Jun/15 2:49 PM

Field	Original Value	New Value
Team		Data Access and Database [ 10204 ]

Jacek Becla made changes - 03/Jun/15 2:50 PM

Description

Revisit the existing parser code
* consider reusing the code from maxscale or (antrl3) mysql parser from mysqlworkbench
* separate IR node productions from grammar

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

Jacek Becla made changes - 03/Jun/15 2:50 PM

WBS

02C.06.02.03

John Swinbank made changes - 09/Jul/15 10:33 AM

Epic Child

~~DM-3108~~ [ 18631 ]

John Swinbank made changes - 10/Jul/15 10:49 AM

Epic Child

~~DM-3108~~ [ 18631 ]

Jacek Becla made changes - 20/Jul/15 10:38 AM

Rank

Ranked lower

Jacek Becla made changes - 20/Jul/15 11:02 AM

Rank

Ranked higher

Jacek Becla made changes - 20/Jul/15 11:14 AM

Rank

Ranked higher

Jacek Becla made changes - 20/Jul/15 11:16 AM

Rank

Ranked higher

Jacek Becla made changes - 20/Jul/15 3:29 PM

Cycle

Summer 2017 [ 10805 ]

Jacek Becla made changes - 09/Nov/15 2:20 PM

Link

This issue relates to DLP-31 [ DLP-31 ]

Jacek Becla made changes - 12/Nov/15 2:15 PM

Summary

FY17 Revisit Qserv Parser

FY16 Revisit Qserv Parser

Jacek Becla made changes - 12/Nov/15 2:15 PM

Epic Name

FY17 Revisit Qserv Parser

FY16 Revisit Qserv Parser

Jacek Becla made changes - 12/Nov/15 2:15 PM

Cycle

Summer 2017 [ 10805 ]

Summer 2016 [ 10803 ]

Jacek Becla made changes - 12/Nov/15 2:17 PM

Summary

FY16 Revisit Qserv Parser

FY16 Revisit Parser / IR

Jacek Becla made changes - 12/Nov/15 2:17 PM

Epic Name

FY16 Revisit Qserv Parser

FY16 Revisit Qserv Parser / IR

Jacek Becla made changes - 12/Nov/15 2:38 PM

Summary

FY16 Revisit Parser / IR

S16 Revisit Parser / IR

Jacek Becla made changes - 12/Nov/15 2:38 PM

Epic Name

FY16 Revisit Qserv Parser / IR

S16 Revisit Qserv Parser / IR

Jacek Becla made changes - 12/Nov/15 11:00 PM

Story Points

Jacek Becla made changes - 12/Nov/15 11:00 PM

Story Points

Jacek Becla made changes - 12/Jan/16 11:27 AM

Epic Child

~~DM-1758~~ [ 15577 ]

Jacek Becla made changes - 12/Jan/16 11:28 AM

Epic Child

~~DM-3165~~ [ 18734 ]

Jacek Becla made changes - 12/Jan/16 11:29 AM

Epic Child

~~DM-4300~~ [ 21301 ]

Jacek Becla made changes - 12/Jan/16 11:30 AM

Epic Child

~~DM-4779~~ [ 22123 ]

Jacek Becla made changes - 12/Jan/16 11:30 AM

Epic Child

~~DM-2902~~ [ 18200 ]

Jacek Becla made changes - 12/Jan/16 11:31 AM

Epic Child

~~DM-2378~~ [ 16663 ]

Jacek Becla made changes - 12/Jan/16 11:32 AM

Epic Child

DM-2686 [ 17450 ]

Jacek Becla made changes - 12/Jan/16 11:32 AM

Epic Child

DM-3166 [ 18873 ]

Jacek Becla made changes - 12/Jan/16 11:33 AM

Epic Child

~~DM-3972~~ [ 20570 ]

Jacek Becla made changes - 12/Jan/16 2:51 PM

Epic Child

~~DM-1976~~ [ 16056 ]

Jacek Becla made changes - 12/Jan/16 2:52 PM

Epic Child

DM-2311 [ 16563 ]

Jacek Becla made changes - 12/Jan/16 2:59 PM

Epic Child

~~DM-2651~~ [ 17414 ]

Jacek Becla made changes - 12/Jan/16 3:00 PM

Epic Child

DM-3187 [ 18911 ]

Jacek Becla made changes - 12/Jan/16 3:01 PM

Story Points

Jacek Becla made changes - 12/Jan/16 3:01 PM

Assignee

Fritz Mueller [ fritzm ]

Jacek Becla made changes - 12/Jan/16 3:13 PM

Epic Child

DM-2860 [ 17826 ]

Jacek Becla made changes - 12/Jan/16 4:13 PM

Story Points

Jacek Becla made changes - 14/Jan/16 2:28 PM

Story Points

101

Jacek Becla made changes - 15/Jan/16 7:48 PM

Epic Child

DM-4531 [ 21736 ]

Jacek Becla made changes - 15/Jan/16 8:14 PM

Rank

Ranked higher

Jacek Becla made changes - 15/Jan/16 9:16 PM

Epic Child

~~DM-3420~~ [ 19378 ]

Jacek Becla made changes - 15/Jan/16 9:23 PM

Epic Child

DM-4211 [ 21070 ]

Jacek Becla made changes - 15/Jan/16 9:24 PM

Epic Child

~~DM-4203~~ [ 21057 ]

Jacek Becla made changes - 15/Jan/16 9:24 PM

Epic Child

~~DM-3696~~ [ 19856 ]

Jacek Becla made changes - 15/Jan/16 9:29 PM

Epic Child

DM-4017 [ 20712 ]

Jacek Becla made changes - 15/Jan/16 9:29 PM

Epic Child

~~DM-2888~~ [ 17997 ]

Jacek Becla made changes - 15/Jan/16 9:44 PM

Epic Child

DM-2296 [ 16530 ]

Jacek Becla made changes - 15/Jan/16 9:53 PM

Epic Child

~~DM-2410~~ [ 16724 ]

Jacek Becla made changes - 15/Jan/16 9:56 PM

Epic Child

~~DM-1693~~ [ 15453 ]

Jacek Becla made changes - 15/Jan/16 9:59 PM

Epic Child

DM-905 [ 13220 ]

Jacek Becla made changes - 15/Jan/16 10:05 PM

Epic Child

~~DM-2901~~ [ 18103 ]

Jacek Becla made changes - 15/Jan/16 11:24 PM

Epic Child

~~DM-1985~~ [ 16072 ]

Jacek Becla made changes - 15/Jan/16 11:25 PM

Link

This issue blocks ~~DM-530~~ [ ~~DM-530~~ ]

Jacek Becla made changes - 15/Jan/16 11:27 PM

Epic Child

~~DM-3361~~ [ 19204 ]

Jacek Becla made changes - 16/Jan/16 6:26 PM

Epic Child

DM-2894 [ 18066 ]

Jacek Becla made changes - 16/Jan/16 7:13 PM

Epic Child

~~DM-2394~~ [ 16708 ]

Jacek Becla made changes - 20/Jan/16 11:01 AM

Epic Child

DM-2859 [ 17825 ]

Jacek Becla made changes - 20/Jan/16 11:04 AM

Epic Child

~~DM-2874~~ [ 17851 ]

Kian-Tat Lim made changes - 02/Feb/16 10:56 PM

Component/s		Qserv [ 10722 ]
Component/s	qerv [ 12603 ]

Jacek Becla made changes - 03/Feb/16 10:39 PM

Story Points

101

Jacek Becla made changes - 23/Feb/16 11:23 PM

Epic Child

~~DM-5211~~ [ 22928 ]

Jacek Becla made changes - 01/Mar/16 10:45 PM

Summary

S16 Revisit Parser / IR

F16 Revisit Parser / IR

Jacek Becla made changes - 01/Mar/16 10:45 PM

Epic Name

S16 Revisit Qserv Parser / IR

F16 Revisit Qserv Parser / IR

Fritz Mueller made changes - 24/May/16 12:30 AM

Epic Name	F16 Revisit Qserv Parser / IR	Revisit Qserv Parser / IR
Cycle	Fall 2016 [ 10803 ]
Summary	F16 Revisit Parser / IR	Revisit Parser / IR

Fritz Mueller made changes - 24/May/16 12:38 AM

Rank

Ranked lower

Fritz Mueller made changes - 21/Nov/16 7:17 PM

Rank

Ranked lower

Fritz Mueller made changes - 23/May/17 2:53 PM

Reporter

Jacek Becla [X] [ jbecla ]

Fritz Mueller [ fritzm ]

Fritz Mueller made changes - 07/Dec/18 5:16 PM

Epic Child

~~DM-1693~~ [ 15453 ]

Fritz Mueller made changes - 07/Dec/18 5:17 PM

Watchers

Fritz Mueller, Jacek Becla, Serge Monkewitz [ Fritz Mueller, Jacek Becla, Serge Monkewitz ]

Fritz Mueller, Serge Monkewitz [ Fritz Mueller, Serge Monkewitz ]

Nate Pease [X] (Inactive) made changes - 07/Dec/18 5:19 PM

Epic Child

~~DM-4203~~ [ 21057 ]

Nate Pease [X] (Inactive) made changes - 07/Dec/18 5:37 PM

Epic Child

~~DM-4779~~ [ 22123 ]

Fritz Mueller made changes - 07/Dec/18 6:19 PM

Epic Child

~~DM-4300~~ [ 21301 ]

Fritz Mueller made changes - 07/Dec/18 6:23 PM

Link

This issue duplicates ~~DM-4300~~ [ ~~DM-4300~~ ]

Fritz Mueller made changes - 07/Dec/18 6:24 PM

Link

This issue duplicates ~~DM-4300~~ [ ~~DM-4300~~ ]

Fritz Mueller made changes - 07/Dec/18 6:25 PM

Epic Child

~~DM-2651~~ [ 17414 ]

Fritz Mueller made changes - 07/Dec/18 6:29 PM

Rank

Ranked higher

Nate Pease [X] (Inactive) made changes - 07/Dec/18 6:29 PM

Epic Child

~~DM-3696~~ [ 19856 ]

Nate Pease [X] (Inactive) made changes - 07/Dec/18 6:31 PM

Epic Child

~~DM-2902~~ [ 18200 ]

Fritz Mueller made changes - 07/Dec/18 7:28 PM

Rank

Ranked higher

Fritz Mueller made changes - 07/Dec/18 7:45 PM

Epic Child

~~DM-1986~~ [ 16073 ]

Fritz Mueller made changes - 07/Dec/18 7:45 PM

Epic Child

DM-1393 [ 14482 ]

Fritz Mueller made changes - 08/Jun/19 2:25 AM

Rank

Ranked lower

Fritz Mueller made changes - 18/Dec/19 3:53 AM

Rank

Ranked lower

Fritz Mueller made changes - 01/Apr/20 4:13 PM

Epic Child

DM-2894 [ 18066 ]

Fritz Mueller made changes - 07/Apr/20 11:48 PM

Epic Child

DM-2860 [ 17826 ]

Fritz Mueller made changes - 02/Dec/20 4:52 PM

Epic Child

DM-2059 [ 16197 ]

People

Assignee:: Fritz Mueller

Reporter:: Fritz Mueller

Watchers:: Fritz Mueller, Serge Monkewitz

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 03/Jun/15 2:49 PM

Updated:: 02/Dec/20 4:52 PM

Jenkins

No builds found.

Data Management

Details

Description

Attachments

Issue Links

Stories in Epic (Custom Issue Matrix)

Activity

People

Dates

Jenkins