Thanks Wes, Issue 1734 created. On Tuesday, December 17, 2013 6:08:02 PM UTC, Wes Freeman wrote: > > 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]<javascript:> > > 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] <javascript:>>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] <javascript:>. >>> 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.
