Matteo Kamm
Matteo Kamm
Running the following query on an empty database ``` RETURN sqrt(-9018766185607338000.0) ``` returns `NaN`. [The documentation](https://neo4j.com/docs/cypher-manual/current/functions/mathematical-logarithmic/#functions-sqrt) states that `sqrt` of any negative numerical expression should return `null` though. I guess...
The following ``` CREATE (:L {p:"test"}) MATCH (n:L) WHERE n.p STARTS WITH lTrim(n.p) RETURN COUNT(n) ``` returns ``` ╒══════════╕ │"COUNT(n)"│ ╞══════════╡ │1 │ └──────────┘ ``` When I then run the...
When I run the following two queries: ``` CREATE (:Q {p:false}), (:Q {p:false}), (:Q {p:true}), (:Q {p:false}) MATCH (n:Q) WHERE NOT ((n.p OR ("a"="")) XOR n.p) DELETE n ``` A...
[The documentation](https://neo4j.com/docs/cypher-manual/current/functions/string/#functions-left) of the `left(original, length)` function states that: > If length exceeds the size of original, original is returned. However, the following query throws an exception: ``` CREATE ({property:...
The documentation on duration values specifies that the unit-based format expects `n` to denote an arbitrarily large number: > The n denotes a numeric value which can be arbitrarily large....
When I run the following queries ``` CREATE INDEX FOR (n:L) ON (n.t) CREATE (:L {t:""}) MATCH (n:L) RETURN n.t < "*fo" MATCH (n:L) WHERE n.t < "*fo" RETURN COUNT(n)...
When I run the following queries ``` CREATE (:L) RETURN (null false) XOR true MATCH (n:L) WHERE (null false) XOR true RETURN COUNT(n) ``` I get the following result ```...
When I run the following queries ``` CREATE (iJnNiEn:Hx {tp:0/0}) CREATE INDEX FOR (n:Hx) ON (n.tp) MATCH (n:Hx) RETURN n.tp = 10 MATCH (n:Hx) WHERE n.tp = 10 RETURN COUNT(n)...
When I run the following queries ``` CREATE INDEX FOR (n:L) ON (n.p) MATCH (n:L) WHERE distance(point({ longitude: 8.076489, latitude: -58.167002 }), n.p)
When I run the following queries ``` CREATE INDEX FOR (n:L) ON (n.p) CREATE (:L { p:"" }) MATCH (n:L) RETURN "a" > n.p MATCH (n:L) WHERE "a" > n.p...