search

tastott / jsoql

A SQL-like language for querying JSON data
http://tastott.github.io/jsoql
3 stars 1 forks source link

Math on aggregate functions is not working #74

Closed steven-dawkins closed 9 years ago

steven-dawkins commented 9 years ago 
SELECT MAX(EventDetails.EventProperties.value.System.TotalMemory)-MIN(EventDetails.EventProperties.value.System.TotalMemory)
FROM 'file://C:\Users\Steven.Dawkins\Documents\visual studio 2013\Projects\HermesToJsoql\HermesToJsoql\bin\Debug\Events\Hermes_20150403.jsonl'
WHERE SubCategory = 'Heartbeat'
Error: Parse error on line 1: ....System.TotalMemory)-MIN(EventDetails.Ev -----------------------^ Expecting 'EOF', '*', ']', ')', 'IS', 'IN', 'AND', 'OR', '=', '!=', '<', '>', '<=', '>=', '+', '-', '/', ',', '}', 'AS', 'JOIN', 'OVER', 'ASC', 'DESC', 'ORDERBY', 'WHERE', 'FROM', 'GROUPBY', 'HAVING', 'UNION', got 'Number'