GROUP BY does not allow multiple functions

jetstreamapp / soql-parser-js

Javascript SOQL parser

https://jetstreamapp.github.io/soql-parser-js/

MIT License

77 stars 20 forks source link

GROUP BY does not allow multiple functions #149

Closed paustint closed 3 years ago

paustint commented 3 years ago

[ ] Feature
[x] Bug

Description

Issue: Cannot mix/match GROUP BY fields and functions or have multiple functions

This query should be syntactically valid

SELECT UserId, COUNT(Id) loginCount, CALENDAR_MONTH(LoginTime) month
FROM LoginHistory
WHERE NetworkId != null
GROUP BY UserId, CALENDAR_MONTH(LoginTime) 
LIMIT 100