> If the property op_type contains a Number, you can't compare it against a > string. Could that be the problem?
Yes, op_type is a number property. I'm wondering how to specify this in the query. And a different aspect of the query language concept: Why are you creating a new query language and not a simple query builder class? This could avoid all this parsing misunderstandings. In the future devs will create query builders for the query language anyway because they want to create queries on the fly. Why not save them this work? ;) How do you think about this? > > 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(Compar > er > > .scala > > :44) > > at > > > > > org.neo4j.cypher.commands.ComparableClause.compareValuesOfDifferent > Typ > > es(Com > > parableClause.scala:25) > > at org.neo4j.cypher.Comparer$class.compare(Comparer.scala:66) > > at > > > > > org.neo4j.cypher.commands.ComparableClause.compare(ComparableClaus > e.sc > > ala:25 > > ) > > at > > > > > org.neo4j.cypher.commands.ComparableClause.isMatch(ComparableClause. > sc > > ala:32 > > ) > > at org.neo4j.cypher.commands.And.isMatch(Clause.scala:31) > > at > > > > > org.neo4j.cypher.pipes.FilterPipe$$anonfun$foreach$1.apply(FilterPipe.scal > a: > > 31) > > at > > > > > org.neo4j.cypher.pipes.FilterPipe$$anonfun$foreach$1.apply(FilterPipe.scal > a: > > 30) > > at > > > > scala.collection.TraversableLike$$anonfun$filter$1.apply(TraversableLi > > ke.sca > > la:213) > > at > > > > > scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scal > a: > > 194) > > at > > > > > scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scal > a: > > 194) > > at > > > > scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.s > > cala: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(PatternPip > > e.scal > > a:42) > > at > > > > > org.neo4j.cypher.pipes.PatternPipe$$anonfun$foreach$1.apply(PatternPip > > e.scal > > a:39) > > at > > > > org.neo4j.cypher.pipes.StartPipe$$anonfun$foreach$1.apply(StartPipe.sc > > ala:36 > > ) > > at > > > > org.neo4j.cypher.pipes.StartPipe$$anonfun$foreach$1.apply(StartPipe.sc > > ala:35 > > ) > > at > > > > scala.collection.LinearSeqOptimized$class.foreach(LinearSeqOptimized.s > > cala: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.sc > > ala:43 > > ) > > at > > > > > org.neo4j.cypher.ExecutionEngine$$anon$1.javaIterator(ExecutionEngine.sc > ala: > > 75) > > at > > > > org.neo4j.cypher.javacompat.ExecutionResult.iterator(ExecutionResult.j > > ava: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 _______________________________________________ Neo4j mailing list [email protected] https://lists.neo4j.org/mailman/listinfo/user
