New issue 212: query: improve error message for invalid syntax

Martin Michlmayr:

I accidentally added a WHERE clause after ORDER BY instead of before and got:

beancount> select date, narration, account, position, cost(sum(position)) WHERE 
account ~ "Exp" AND currency ~ 'USD' GROUP BY account, date, narration, 
position AND date > 2014-07-12
ERROR: All non-aggregates must be covered by GROUP-BY clause in aggregate query.

This error message doesn't make sense since all non-aggregates are covered.

You received this message because you are subscribed to the Google Groups 
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
To post to this group, send email to
To view this discussion on the web visit
For more options, visit

Reply via email to