Some more examples of why it would seem it "should" be fine: neo4j-sh (?)$ START n=node(0) RETURN 1 / 60 / 60; +-------------+ | 1 / 60 / 60 | +-------------+ | 0 | +-------------+ 1 row 7 ms neo4j-sh (?)$ START n=node(0) RETURN count(n) / 1; +--------------+ | count(n) / 1 | +--------------+ | 1 | +--------------+ 1 row 13 ms
On Tuesday, December 17, 2013 5:58:55 PM UTC, JDS 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.
