Thanks guys! On Dec 17, 2013 7:48 PM, "JDS" <[email protected]> wrote:
> 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]> 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. > -- 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.
