If the property op_type contains a Number, you can't compare it against a string. Could that be the problem?
Andrés On Wed, Jun 29, 2011 at 8:38 AM, Adrian Stabiszewski < [email protected]> wrote: > 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 > _______________________________________________ Neo4j mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
