For a workaround, you can get the aggregation first and then do the calculation:
START n=node(0) WITH count(n) as count RETURN count/60/60 Wes On Tue, Dec 17, 2013 at 1:06 PM, Wes Freeman <[email protected]> wrote: > This is definitely a bug, you should report on github issues. > > Wes > > > On Tue, Dec 17, 2013 at 12:58 PM, JDS <[email protected]> wrote: > >> Sorry, doesn't have to be 60/60, it can be any number divided by the same >> number which should of course just equal 1. >> >> >> On Tuesday, December 17, 2013 5:57:33 PM UTC, JDS wrote: >>> >>> I stumbled on this by accident but it looks like a bug to me, dividing >>> an aggregation function result by 60 twice causes an exception. I narrowed >>> it down to the easiest repeatable process (server is Neo4j 2.0.0 stable). >>> Shouldn't START n=node(0) RETURN count(n) / 60 / 60 return 0? >>> >>> neo4j-sh (?)$ START n=node(0) RETURN count(n) AS count; >>> +-------+ >>> | count | >>> +-------+ >>> | 1 | >>> +-------+ >>> 1 row >>> 10 ms >>> neo4j-sh (?)$ START n=node(0) RETURN count(n) / 60; >>> +---------------+ >>> | count(n) / 60 | >>> +---------------+ >>> | 0 | >>> +---------------+ >>> 1 row >>> 16 ms >>> neo4j-sh (?)$ START n=node(0) RETURN count(n) / 60 / 60; >>> SyntaxException: Unknown identifier `n`. >>> Unknown identifier ` UNNAMED????????`. >>> neo4j-sh (?)$ START n=node(0) RETURN count(n) / 60 / 25; >>> +--------------------+ >>> | count(n) / 60 / 25 | >>> +--------------------+ >>> | 0 | >>> +--------------------+ >>> 1 row >>> 14 ms >>> >>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "Neo4j" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
