Just tested my queries with M05. Now I get the result in 6.6sec instead of
10sec with M04. :) This is great! 30% improvement.
However, I might have found a regression. One of my earlier queries now
gives me a SystaxError Exception:
org.neo4j.cypher.SyntaxError: Don't know how to compare that. Left: 6;
Right: 8
at
org.neo4j.cypher.Comparer$class.compareValuesOfDifferentTypes(Comparer.scala
:44)
at
org.neo4j.cypher.commands.ComparableClause.compareValuesOfDifferentTypes(Com
parableClause.scala:25)
at org.neo4j.cypher.Comparer$class.compare(Comparer.scala:66)
at
org.neo4j.cypher.commands.ComparableClause.compare(ComparableClause.scala:25
)
at
org.neo4j.cypher.commands.ComparableClause.isMatch(ComparableClause.scala:32
)
at org.neo4j.cypher.commands.And.isMatch(Clause.scala:31)
at
org.neo4j.cypher.pipes.FilterPipe$$anonfun$foreach$1.apply(FilterPipe.scala:
31)
at
org.neo4j.cypher.pipes.FilterPipe$$anonfun$foreach$1.apply(FilterPipe.scala:
30)
at
scala.collection.TraversableLike$$anonfun$filter$1.apply(TraversableLike.sca
la:213)
at
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:
194)
at
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:
194)
at
scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:5
9)
at scala.collection.immutable.List.foreach(List.scala:45)
at
scala.collection.TraversableLike$class.map(TraversableLike.scala:194)
at scala.collection.immutable.List.map(List.scala:45)
at
org.neo4j.cypher.pipes.PatternPipe$$anonfun$foreach$1.apply(PatternPipe.scal
a:42)
at
org.neo4j.cypher.pipes.PatternPipe$$anonfun$foreach$1.apply(PatternPipe.scal
a:39)
at
org.neo4j.cypher.pipes.StartPipe$$anonfun$foreach$1.apply(StartPipe.scala:36
)
at
org.neo4j.cypher.pipes.StartPipe$$anonfun$foreach$1.apply(StartPipe.scala:35
)
at
scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.scala:5
9)
at scala.collection.immutable.List.foreach(List.scala:45)
at org.neo4j.cypher.pipes.StartPipe.foreach(StartPipe.scala:35)
at org.neo4j.cypher.pipes.PatternPipe.foreach(PatternPipe.scala:39)
at
scala.collection.TraversableLike$class.filter(TraversableLike.scala:212)
at org.neo4j.cypher.pipes.Pipe.filter(Pipe.scala:31)
at org.neo4j.cypher.pipes.FilterPipe.foreach(FilterPipe.scala:30)
at
org.neo4j.cypher.pipes.TransformPipe.foreach(TransformPipe.scala:36)
at
org.neo4j.cypher.pipes.ColumnFilterPipe.foreach(ColumnFilterPipe.scala:34)
at
scala.collection.TraversableLike$class.map(TraversableLike.scala:194)
at org.neo4j.cypher.pipes.Pipe.map(Pipe.scala:31)
at
org.neo4j.cypher.ExecutionResult$class.javaIterator(ExecutionResult.scala:43
)
at
org.neo4j.cypher.ExecutionEngine$$anon$1.javaIterator(ExecutionEngine.scala:
75)
at
org.neo4j.cypher.javacompat.ExecutionResult.iterator(ExecutionResult.java:51
)
The query in question was:
start c=(typeIndex,`node_type`,"1") match(c)-->(r) where (c.`node_name` =
"name") and (r.op_type = "8") return c,r
The "8" from the error message relates to the "8" in the where statement.
_______________________________________________
Neo4j mailing list
[email protected]
https://lists.neo4j.org/mailman/listinfo/user
