diff options
author | Paul McGuire <ptmcg@users.noreply.github.com> | 2018-07-14 16:43:34 -0500 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-07-14 16:43:34 -0500 |
commit | 8ce4af44a07e3fe2172fc570fa66856367d9d89e (patch) | |
tree | 4183e52a178180de6b564ad85ba611905c657992 /examples/select_parser.py | |
parent | 1d6c521a4120d252d6f3b08b2422fed44c60fffa (diff) | |
download | pyparsing-git-8ce4af44a07e3fe2172fc570fa66856367d9d89e.tar.gz |
Wrong expression grouping in select_parser.py
Results name "group_by_terms" was defined at the wrong level in the "having_expr", causing those names to be left out of the results.
Diffstat (limited to 'examples/select_parser.py')
-rw-r--r-- | examples/select_parser.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/examples/select_parser.py b/examples/select_parser.py index f969f02..b619173 100644 --- a/examples/select_parser.py +++ b/examples/select_parser.py @@ -101,7 +101,7 @@ result_column = "*" | table_name + "." + "*" | Group(expr + Optional(Optional(AS select_core = (SELECT + Optional(DISTINCT | ALL) + Group(delimitedList(result_column))("columns") +
Optional(FROM + join_source("from*")) +
Optional(WHERE + expr("where_expr")) +
- Optional(GROUP + BY + Group(delimitedList(ordering_term)("group_by_terms")) +
+ Optional(GROUP + BY + Group(delimitedList(ordering_term))("group_by_terms") +
Optional(HAVING + expr("having_expr"))))
select_stmt << (select_core + ZeroOrMore(compound_operator + select_core) +
|