summaryrefslogtreecommitdiff
path: root/examples/select_parser.py
diff options
context:
space:
mode:
authorPaul McGuire <ptmcg@users.noreply.github.com>2018-07-14 16:43:34 -0500
committerGitHub <noreply@github.com>2018-07-14 16:43:34 -0500
commit8ce4af44a07e3fe2172fc570fa66856367d9d89e (patch)
tree4183e52a178180de6b564ad85ba611905c657992 /examples/select_parser.py
parent1d6c521a4120d252d6f3b08b2422fed44c60fffa (diff)
downloadpyparsing-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.py2
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) +