Issue 1:
We discovered a bug that Match query throws a QueryExecutionException

Neo4j version: 5.4.0

Operating system: macOS 13.2.1

API/Driver: Java

When I run the following query: MATCH (n:P) WHERE isNaN((-(n.CwNLh))%(n.CwNLh)) RETURN COUNT(n).

A QueryExecutionException is thrown without further message to identify the root cause.

In the stack trace, it reports the code locations at at org.neo4j.cypher.internal.runtime.interpreted.commands.expressions.IsNaNFunction.apply(MathFunction.scala:249), but I still don't know the reasons. This might be a duplicate of #13060 but the query is different inside the isNaN() so I reported it just in case.

Expected behavior:

No exception should be expected to throw.

Actual behavior:

A QueryExecutionException is thrown. And I'm not really sure whether this problem should happen so I report this.

Caused by: org.neo4j.graphdb.QueryExecutionException
at org.neo4j.kernel.impl.query.QueryExecutionKernelException.asUserException(QueryExecutionKernelException.java:32)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.converted(ResultSubscriber.java:355)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.assertNoErrors(ResultSubscriber.java:342)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.fetchResults(ResultSubscriber.java:311)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.nextFromSubscriber(ResultSubscriber.java:286)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.fetchNextOrNull(ResultSubscriber.java:262)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.fetchNextOrNull(ResultSubscriber.java:57)
at org.neo4j.internal.helpers.collection.PrefetchingIterator.peek(PrefetchingIterator.java:56)
at org.neo4j.internal.helpers.collection.PrefetchingIterator.hasNext(PrefetchingIterator.java:44)
at java.base/java.util.Iterator.forEachRemaining(Iterator.java:132)
at java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1845)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
at ch.cypherchecker.neo4j.Neo4JConnection.execute(Neo4JConnection.java:44)
at ch.cypherchecker.neo4j.Neo4JQuery.executeAndGet(Neo4JQuery.java:52)
... 3 more
Caused by: org.neo4j.kernel.impl.query.QueryExecutionKernelException
... 20 more
Caused by: org.neo4j.exceptions.ArithmeticException
at org.neo4j.cypher.operations.CypherMath.modulo(CypherMath.java:210)
at org.neo4j.cypher.internal.runtime.interpreted.commands.expressions.Modulo.calc(Modulo.scala:27)
at org.neo4j.cypher.internal.runtime.interpreted.commands.expressions.Arithmetics.applyWithValues(Expression.scala:86)
at org.neo4j.cypher.internal.runtime.interpreted.commands.expressions.Arithmetics.apply(Expression.scala:80)
at org.neo4j.cypher.internal.runtime.interpreted.commands.expressions.IsNaNFunction.apply(MathFunction.scala:249)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.CoercedPredicate.isMatch(Predicate.scala:720)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.CompositeBooleanPredicate.$anonfun$isMatch$2(Predicate.scala:141)
at scala.util.Try$.apply(Try.scala:210)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.CompositeBooleanPredicate.$anonfun$isMatch$1(Predicate.scala:141)
at org.neo4j.cypher.internal.util.NonEmptyList.foldLeftLoop(NonEmptyList.scala:281)
at org.neo4j.cypher.internal.util.NonEmptyList.foldLeft(NonEmptyList.scala:202)
at org.neo4j.cypher.internal.util.NonEmptyList.foldLeft$(NonEmptyList.scala:201)
at org.neo4j.cypher.internal.util.Fby.foldLeft(NonEmptyList.scala:358)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.CompositeBooleanPredicate.isMatch(Predicate.scala:136)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.Predicate.apply(Predicate.scala:101)
at org.neo4j.cypher.internal.runtime.interpreted.commands.predicates.Predicate.apply(Predicate.scala:98)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.FilterPipe.$anonfun$internalCreateResults$1(FilterPipe.scala:34)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.FilterPipe.$anonfun$internalCreateResults$1$adapted(FilterPipe.scala:34)
at org.neo4j.cypher.internal.runtime.ClosingIterator$$anon$3.innerHasNext(ClosingIterator.scala:185)
at org.neo4j.cypher.internal.runtime.ClosingIterator.hasNext(ClosingIterator.scala:135)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.EagerAggregationPipe.internalCreateResults(EagerAggregationPipe.scala:39)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.computeDecoratedResult(Pipe.scala:92)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.createResults(Pipe.scala:81)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.computeDecoratedResult(Pipe.scala:91)
at org.neo4j.cypher.internal.runtime.interpreted.pipes.PipeWithSource.createResults(Pipe.scala:81)
at org.neo4j.cypher.internal.runtime.interpreted.PipeExecutionResult.request(PipeExecutionResult.scala:74)
at org.neo4j.cypher.internal.result.StandardInternalExecutionResult.request(StandardInternalExecutionResult.scala:103)
at org.neo4j.cypher.internal.result.ClosingExecutionResult.request(ClosingExecutionResult.scala:149)
at org.neo4j.cypher.internal.javacompat.ResultSubscriber.fetchResults(ResultSubscriber.java:310)
... 17 more
Caused by: java.lang.ArithmeticException

Steps to reproduce:

We feel sorry that because the database schema and data values are randomly generated by strings, it will cause inconvenience to your reviewing, but we believe the problem does exist.

Following the following graph data generation query, we can reproduce the bugs:

SHOW TRANSACTION
CREATE INDEX fY FOR ()-[n:co]-() ON (n.t)
CREATE RANGE INDEX IWQ_C9r IF NOT EXISTS FOR (n:P) ON (n.CwNLh, n.c7)
CREATE (HTouLcTfX2:ZYz5OC {E3:7300717894004568771}), (p:ZYz5OC {E3:0o653746405225641211040}), (k5zxeZl:ZYz5OC {E3:0x1e6b3a43a50f63c5}), (z:ZYz5OC {E3:-2131916019273757358}), (k5zxeZl)-[RRf5y:e {iV4:"HRjvRy", DkPC:-((HTouLcTfX2.E3)*((toFloat(3768513907540076124))/(toInteger(k5zxeZl.E3)))), L:-0x25309a1df6b4dfbd}]->(p), (k5zxeZl)-[jHY:co {t:point({ x: 0.535308, y: 0.303586 })}]->(HTouLcTfX2), (HTouLcTfX2)-[no:co {t:point({ x: 0.674609, y: 0.383579 })}]->(p), (HTouLcTfX2)-[CKb:co {t:point({ x: 0.052915, y: 0.348082, z: 0.474722 })}]->(HTouLcTfX2), (HTouLcTfX2)-[E:e {iV4:RRf5y.iV4, DkPC:RRf5y.DkPC, L:0x2a3379bc35f48d28}]->(z), (z)-[jMlf:iFFO {Pl:true}]->(HTouLcTfX2)
MATCH (n:ZYz5OC) WHERE (lTrim("CH"))+((("KN#sZMW.|")+(0.31646037101745605))+(+(-0o107142667013753563525)))=~((left("en>T",-0o720450300650630014725))+(reverse("")))+((sqrt(n.E3))*(-(0.8254148364067078))) DETACH DELETE n RETURN * ORDER BY n DESC LIMIT 7760065480060580233
MATCH (n:P) WHERE (n.OgvI)CONTAINS((n.OgvI)+(n.OgvI)) DETACH DELETE n RETURN n.c7 AS lLh LIMIT 4848482254051623497
CREATE RANGE INDEX sHf FOR ()-[n:iFFO]-() ON (n.Pl)
CREATE (mpFCNH:P {CwNLh:-0o737004306660635266726, OgvI:trim((("")+(0.7383421659469604))+(("^4{w/\\5")+(0.2968929409980774)))}), (mpFCNH)-[Tg:iFFO {Pl:NOT(toBooleanOrNull(mpFCNH.OgvI))}]->(mpFCNH) RETURN DISTINCT Tg.Pl AS cvHmiH2 LIMIT 1720270616996771554
SHOW BUILT IN FUNCTIONS
CREATE (k:EpU2NXnO {cX:0.8627445101737976}), (l:ZYz5OC {E3:-1586027226659482586})
CREATE INDEX f FOR (n:P) ON (n.CwNLh, n.c7)
CREATE RANGE INDEX P FOR ()-[n:co]-() ON (n.t)
CREATE TEXT INDEX Nn IF NOT EXISTS FOR (n:P) ON (n.OgvI)
DROP INDEX Nn
CREATE (bD:EpU2NXnO {cX:0.1145673394203186})
SHOW PROCEDURES
CREATE (qjE3Wgq:ZYz5OC {E3:abs(toInteger(false))}), (KT:EpU2NXnO {cX:-(e())}), (Q0flYK:ZYz5OC {E3:-0x1a2e00606968e1b4}), (KT)-[xJN:co {t:point({ x: 0.729786, y: 0.340750 })}]->(KT), (KT)-[faZnJlN:e {iV4:substring((left(null,qjE3Wgq.E3))+((6857018376931932372)+(-949170582961163820)),-(qjE3Wgq.E3),qjE3Wgq.E3), DkPC:exp(toIntegerOrNull(0.7380544543266296)), L:-6909081157034300736}]->(qjE3Wgq), (Q0flYK)-[k:co {t:point({ x: 0.028206, y: 0.840548 })}]->(Q0flYK), (qjE3Wgq)-[Jh:co {t:xJN.t}]->(KT), (qjE3Wgq)-[evEFSMCK3:iFFO {Pl:false}]->(Q0flYK) RETURN faZnJlN.DkPC , k.t , Q0flYK.E3 AS Y , qjE3Wgq , xJN.t , evEFSMCK3 ORDER BY k.t , Q0flYK.E3 DESCENDING , qjE3Wgq.E3 DESC , evEFSMCK3.Pl DESC LIMIT 6933320970096258151
CREATE (x:EpU2NXnO {cX:0.11941075325012207}), (U:P {CwNLh:-0xeffd3225c6c2a46, c7:date('0261-02-16'), OgvI:""}), (Y:ZYz5OC {E3:0x28a096935fd0f2f7}), (Kro:EpU2NXnO {cX:x.cX}), (t:ZYz5OC {E3:-0o17041470746444236361}), (t)-[lUmzsoE:e {iV4:"", DkPC:0.7443311214447021, L:0x1}]->(U), (t)-[a:e {iV4:"A-", DkPC:lUmzsoE.DkPC}]->(x), (t)-[nnm4kAfn:e {DkPC:-(abs(lUmzsoE.DkPC)), L:abs(a.L)}]->(Y), (t)-[M:iFFO {Pl:true}]->(Kro), (U)-[sH:iFFO {Pl:false}]->(t), (U)-[e:iFFO {Pl:true}]->(U), (x)-[vJ:e {iV4:"\nu"}]->(t), (x)-[LW:e {iV4:vJ.iV4, DkPC:lUmzsoE.DkPC}]->(U), (x)-[u:e {DkPC:null, L:-0x5a5400ad0f0312b3}]->(x), (x)-[i93:e {iV4:"~", DkPC:a.DkPC}]->(Kro), (Y)-[DcbRrsMLD:iFFO {Pl:e.Pl}]->(t), (Y)-[J62L:e {iV4:"?BiO-\tq,T", DkPC:vJ.DkPC, L:(u.L)+((lUmzsoE.L)/(a.L))}]->(U), (Y)-[w_:iFFO {Pl:false}]->(Y), (Y)-[G:iFFO {Pl:true}]->(Kro), (Kro)-[Qiv4Ezy2:iFFO {Pl:true}]->(U), (Kro)-[xG:e {iV4:lTrim(trim(U.OgvI)), DkPC:nnm4kAfn.DkPC, L:toIntegerOrNull(t.E3)}]->(x) RETURN DISTINCT a.DkPC AS Z5aW , i93 , vJ.iV4 , lUmzsoE , G.Pl , Kro.cX AS SGZ , LW.DkPC LIMIT 7658082956079736455
SHOW FUNCTION
DROP INDEX index_343aff4e
CREATE (Rz:ZYz5OC {E3:(+(-(size("j"))))-(toIntegerOrNull(duration.between(date('09650717'),date('02370203'))))}), (EHThdw5hB:P {c7:date('08010516'), OgvI:""}), (T:ZYz5OC {E3:-1241684806799114213}), (pA3ePC6:ZYz5OC {E3:Rz.E3}), (OqbJV_4Zo:ZYz5OC {E3:abs(EHThdw5hB.CwNLh)}), (pA3ePC6)-[t_bO7:co {t:point({ x: 0.659914, y: 0.244511 })}]->(OqbJV_4Zo), (pA3ePC6)-[d:co {t:point({ x: 0.122210, y: 0.514815 })}]->(EHThdw5hB), (OqbJV_4Zo)-[cjFPN:e {iV4:EHThdw5hB.OgvI, L:+(EHThdw5hB.CwNLh)}]->(OqbJV_4Zo), (OqbJV_4Zo)-[kaR6uio:iFFO {Pl:true}]->(EHThdw5hB), (OqbJV_4Zo)-[rtQwPZti:iFFO {Pl:kaR6uio.Pl}]->(Rz), (T)-[LJJ_TOWeB:co {t:point({ x: 0.470423, y: 0.621261, z: 0.928014 })}]->(pA3ePC6), (T)-[AoW:iFFO {Pl:false}]->(OqbJV_4Zo), (T)-[TZ:e {iV4:"*VUG", DkPC:0.833169162273407}]->(EHThdw5hB), (EHThdw5hB)-[m:e {iV4:null, DkPC:0.912303626537323}]->(pA3ePC6), (EHThdw5hB)-[Kc:e {DkPC:m.DkPC, L:-0x6f98429a3e1c748a}]->(T), (Rz)-[QOiPN:co {t:LJJ_TOWeB.t}]->(OqbJV_4Zo), (Rz)-[xElQ:e {DkPC:0.8469249606132507}]->(EHThdw5hB), (Rz)-[h:e {iV4:substring((("")+(0x19da2e122e47764c))+(TZ.DkPC),(cjFPN.L)+((0x1ec5dd911a5ca196)%(0x4c59e8d2050f5577)),TZ.L), DkPC:-(TZ.DkPC), L:pA3ePC6.E3}]->(Rz)
CREATE (k:EpU2NXnO {cX:0.08460235595703125}), (k)-[FORAw:iFFO {Pl:true}]->(k)
CREATE (T:P {CwNLh:-0o262771604277714165250, c7:date('04091102'), OgvI:""}), (ES:P {c7:date('02661106')}), (T)-[nw:e {iV4:"LN"}]->(ES), (ES)-[wKDNbf:co {t:point({ x: 0.036183, y: 0.383503, z: 0.130585 })}]->(T), (ES)-[Ew:co {t:wKDNbf.t}]->(ES)
DROP INDEX fY
CREATE (VlajiLF:ZYz5OC {E3:((-(-(-0o355102771455237566136)))-((+(0o40745160540566406123))%(4564996777616947370)))/(toInteger(right("jv",-7154722361075349433)))}), (am3g:ZYz5OC {E3:0o10574727054012105073}), (VlajiLF)-[CH:iFFO {Pl:(point({ x: 0.047835, y: 0.821334 }))>=(point({ x: 0.673008, y: 0.794131 }))}]->(am3g), (VlajiLF)-[qGMl:co {t:point({ x: 0.404346, y: 0.109111, z: 0.278707 })}]->(VlajiLF)
CREATE (Cd82HSMEs:EpU2NXnO {cX:toFloatOrNull(log10(0.10405534505844116))}), (ZoM:EpU2NXnO {cX:0.3272091746330261}), (QS:EpU2NXnO {cX:ZoM.cX}), (QS)-[fAfL8:co {t:point({ x: 0.730815, y: 0.475613, z: 0.480843 })}]->(QS), (QS)-[TOCvzarfN:co {t:point({ x: 0.010697, y: 0.033710, z: 0.305635 })}]->(ZoM), (Cd82HSMEs)-[SLpRpFd0:iFFO {Pl:(right(substring("h",4214006909140400610,528415623255195681),0o346644731145014375006)) IS NULL}]->(Cd82HSMEs) RETURN DISTINCT QS , TOCvzarfN.t AS O5 , ZoM.cX , Cd82HSMEs ORDER BY QS DESCENDING , TOCvzarfN.t LIMIT 2344726027123102365
CREATE (nvl:EpU2NXnO {cX:-(+(+((7007619624324590098)/(0.6899406313896179))))}), (Oj:P {CwNLh:-4388548993651414269, c7:date('02320611'), OgvI:toLower(toString("]y"))}), (rSW_:ZYz5OC {E3:size(rTrim(Oj.OgvI))}), (nvl)-[q:e {iV4:toUpper(reverse("")), DkPC:0.8354463577270508, L:abs(Oj.CwNLh)}]->(rSW_), (Oj)-[uA:co {t:point({ x: 0.369129, y: 0.048290 })}]->(rSW_), (rSW_)-[hD:co {t:point({ x: 0.887720, y: 0.342037 })}]->(nvl), (rSW_)-[tRvUx3pZ2n:e {DkPC:0.4346691966056824, L:+(q.L)}]->(Oj), (rSW_)-[PH:co {t:hD.t}]->(rSW_)
MATCH (n:P) WHERE NOT((NOT((-370618961404126214)=(n.CwNLh)))AND((isNaN(6857329177346389602))XOR((-0x6367fefb43e0a562) IS NULL))) SET n.OgvI = (toStringOrNull(duration.inMonths(date('0336-06-28'),date('0824-02-28'))))+((+(sign(0x622d7e73b4633626)))%(abs(0o134201607340507647050))) RETURN n.CwNLh AS I LIMIT 2548407708564014131
CREATE (U9xHxbJ0R:EpU2NXnO {cX:0.3342136740684509}), (V:EpU2NXnO {cX:0.9122530221939087}), (elr:EpU2NXnO {cX:V.cX}), (X8cE:ZYz5OC {E3:size(toString(duration('P641869682Y296231178M1757215060WT1696282240H296457190S')))}), (M:P {CwNLh:-0x52dcabe4d5b1ce28, c7:date('0643-12-23'), OgvI:(toStringOrNull(date('0794-03-15')))+((((",HsBu(v")+(V.cX))+((elr.cX)*(0.2693525552749634)))+(abs(0.8909910917282104)))}), (U9xHxbJ0R)-[hFeOksL5:e {iV4:"", DkPC:U9xHxbJ0R.cX}]->(V), (U9xHxbJ0R)-[E:iFFO {Pl:(((NOT(hFeOksL5.iV4=~M.OgvI))OR((duration.inDays(M.c7,M.c7)) IS NULL))OR(NOT(((hFeOksL5.iV4)+(elr.cX))ENDS WITH(M.OgvI))))AND(NOT(NOT(hFeOksL5.iV4=~M.OgvI)))}]->(M), (V)-[ggib:co {t:point({ x: 0.796162, y: 0.112496 })}]->(V), (elr)-[te:co {t:point({ x: 0.490570, y: 0.730673 })}]->(elr), (elr)-[B87:e {iV4:hFeOksL5.iV4, DkPC:0.6507062911987305, L:0o77315716721420633143}]->(M), (X8cE)-[wHPY:e {iV4:hFeOksL5.iV4, DkPC:0.06029552221298218, L:B87.L}]->(U9xHxbJ0R), (X8cE)-[T7XP:co {t:point({ x: 0.280545, y: 0.430728 })}]->(V), (M)-[J:co {t:point({ x: 0.780763, y: 0.956522, z: 0.596332 })}]->(U9xHxbJ0R), (M)-[Qc:e {L:B87.L}]->(M) RETURN *
CREATE (XlhLr0:EpU2NXnO {cX:0.5597010254859924}), (G3Fm:EpU2NXnO {cX:0.5031657218933105}), (XlhLr0)-[qCXqhBQz:iFFO {Pl:false}]->(XlhLr0)
CREATE RANGE INDEX pPlzf FOR (n:EpU2NXnO) ON (n.cX)
CREATE (o9eZP:ZYz5OC {E3:-9213886704174309772}), (DfNv:P {CwNLh:o9eZP.E3, c7:date('0455-03-05'), OgvI:(left(("9riw")+(0.0515446662902832),o9eZP.E3))+(o9eZP.E3)}), (aAIVeUW9Bs:ZYz5OC {E3:o9eZP.E3}), (mg:ZYz5OC {E3:+(o9eZP.E3)}), (hZM01:EpU2NXnO {cX:+((toFloat(0.7445787191390991))^(floor(0o670704763511460402130)))}), (aAIVeUW9Bs)-[h2J:e {iV4:"Pss0'u5w", DkPC:(toFloat(DfNv.OgvI))^(+(+((hZM01.cX)*(0x1999a4c4060453cd)))), L:-(aAIVeUW9Bs.E3)}]->(DfNv), (o9eZP)-[QK:co {t:point({ x: 0.316767, y: 0.538710, z: 0.164717 })}]->(o9eZP), (o9eZP)-[Sd:iFFO {Pl:false}]->(DfNv), (o9eZP)-[Rrh:e {iV4:"", L:abs((size(h2J.iV4))*(-(o9eZP.E3)))}]->(mg), (mg)-[biw0:e {DkPC:0.3925507664680481, L:5255921400448572661}]->(aAIVeUW9Bs), (mg)-[mStcj:e {iV4:"7"}]->(DfNv), (hZM01)-[o2:co {t:point({ x: 0.880973, y: 0.165524, z: 0.492346 })}]->(o9eZP), (hZM01)-[r:co {t:point({ x: 0.725407, y: 0.019832 })}]->(DfNv), (hZM01)-[bo:iFFO {Pl:Sd.Pl}]->(hZM01)
CREATE (H4nPCH:ZYz5OC {E3:((toInteger(0.649202287197113))-(size("\\v2,J(")))-(toIntegerOrNull(point({ x: 0.412012, y: 0.653443, z: 0.188877 })))}), (uX5b2Q:ZYz5OC {E3:(H4nPCH.E3)/(H4nPCH.E3)}), (qk:EpU2NXnO {cX:0.10441416501998901}), (uX5b2Q)-[tCj:e {iV4:(replace(("?")+(-0xc1210feb925cef4),left(" ",-0x7d78401908a782f8),("")+(-432032097381593621)))+(-(-(toFloat("6W")))), DkPC:(qk.cX)^(qk.cX), L:0x563885cf793da6e1}]->(uX5b2Q), (qk)-[o:e {iV4:"wNt", DkPC:0.8685114979743958, L:6455683831742945670}]->(uX5b2Q), (qk)-[GjJLLeOBih:iFFO {Pl:((tCj.iV4)+(toInteger(tCj.iV4)))+(o.L)=~left(tCj.iV4,tCj.L)}]->(H4nPCH), (H4nPCH)-[jL:co {t:point({ x: 0.628412, y: 0.862287 })}]->(uX5b2Q)
CREATE (qLIJvxPWcB:ZYz5OC {E3:-0o132212077534723042422}), (Srsi:P {CwNLh:(qLIJvxPWcB.E3)/(sign(qLIJvxPWcB.E3)), OgvI:"k%J7*"}), (LA_0:EpU2NXnO {cX:round(ceil(0.14619570970535278))}), (Srsi)-[jH:co {t:point({ x: 0.407852, y: 0.707393 })}]->(LA_0), (LA_0)-[Lpcrc5S:iFFO {Pl:toBooleanOrNull(duration.inSeconds(Srsi.c7,date('0595-03-19')))}]->(LA_0), (LA_0)-[GuTJmzi:e {iV4:" 'u-JC8jE", DkPC:(qLIJvxPWcB.E3)-(LA_0.cX), L:(((qLIJvxPWcB.E3)+(-(qLIJvxPWcB.E3)))*((Srsi.CwNLh)%(qLIJvxPWcB.E3)))*(abs(-(-0x73e8e85075629cd1)))}]->(qLIJvxPWcB), (qLIJvxPWcB)-[qszd_Qd:co {t:point({ x: 0.915254, y: 0.411624 })}]->(Srsi)
SHOW TRANSACTION
CREATE (a07Ni:P {CwNLh:0o232162607264546360727, OgvI:((toUpper("Sbo"))+((+(-6680491062627791269))+((-0x60f6484ad62af5a1)%(0o326460254146224716526))))+(lTrim(("a,")+("f>")))}), (SGysqvVhZ:ZYz5OC {E3:a07Ni.CwNLh}), (r:EpU2NXnO {cX:null}), (hj:ZYz5OC {E3:SGysqvVhZ.E3}), (fzZ:ZYz5OC {E3:+(sign((0o417525005742373403141)*(0o312674605011005407570)))}), (r)-[h_B902d6j:e {iV4:a07Ni.OgvI, DkPC:0.006037712097167969, L:0o546102657723772227613}]->(a07Ni), (hj)-[aJ:iFFO {Pl:(a07Ni.CwNLh) IS NULL}]->(r), (hj)-[j:co {t:point({ x: 0.297208, y: 0.409401 })}]->(SGysqvVhZ), (hj)-[IxC:iFFO {Pl:isNaN((h_B902d6j.L)+(h_B902d6j.L))}]->(fzZ), (SGysqvVhZ)-[beUU2lmN:co {t:point({ x: 0.892277, y: 0.506380 })}]->(r), (SGysqvVhZ)-[Z2e:e {iV4:"P", DkPC:0.3996778726577759}]->(SGysqvVhZ), (SGysqvVhZ)-[i:e {iV4:"m", DkPC:Z2e.DkPC}]->(fzZ), (fzZ)-[O:iFFO {Pl:true}]->(hj), (fzZ)-[MCv:co {t:point({ x: 0.722437, y: 0.289709 })}]->(SGysqvVhZ), (fzZ)-[ptmn:iFFO {Pl:true}]->(fzZ), (fzZ)-[U:co {t:point({ x: 0.512585, y: 0.203627, z: 0.558271 })}]->(a07Ni) RETURN * ORDER BY h_B902d6j, MCv, r.cX , SGysqvVhZ, Z2e
CREATE (SP2Ro:ZYz5OC {E3:-0o663516474134702522600}), (XMM:EpU2NXnO {cX:0.28107428550720215}), (H:EpU2NXnO {cX:XMM.cX}), (HEsD8:EpU2NXnO {cX:0.42518532276153564}), (SP2Ro)-[jC_UABdy:co {t:point({ x: 0.359511, y: 0.973037 })}]->(SP2Ro), (SP2Ro)-[a4fLt4tD:e {iV4:"#", L:(-(abs(SP2Ro.E3)))-(SP2Ro.E3)}]->(HEsD8), (H)-[DR9:co {t:point({ x: 0.694689, y: 0.746411 })}]->(XMM), (XMM)-[U:iFFO {Pl:false}]->(SP2Ro), (XMM)-[hs:iFFO {Pl:(+(H.cX))<((toIntegerOrNull(time('18:50')))/(a4fLt4tD.DkPC))}]->(H), (XMM)-[un92WKm:e {DkPC:H.cX, L:a4fLt4tD.L}]->(HEsD8) RETURN DISTINCT jC_UABdy.t AS lP0 , SP2Ro.E3 AS FvE , H.cX AS DsfGFTXe , XMM , DR9.t AS qB4di7p , un92WKm ORDER BY jC_UABdy.t DESCENDING , DR9.t , SP2Ro.E3 DESCENDING , XMM DESC , H.cX DESC , un92WKm DESCENDING
CREATE (pci8vy:P {CwNLh:+((-(size("K")))*((-(null))-(sign(0x4ab2f777653554f1))))})
SHOW PROCEDURES
SHOW TRANSACTION
CREATE TEXT INDEX Eekm0Gc FOR (n:P) ON (n.OgvI)
CREATE (x:ZYz5OC {E3:(+(((-6162992536193107593)*(727320474966577191))%((1067331305541837802)*(-0x120169af45dac213))))-(abs(sign(0.7391791939735413)))}), (kjJljzxuH:ZYz5OC {E3:-4823646063027875721}), (v:EpU2NXnO {cX:0.7329034805297852}), (e:EpU2NXnO {cX:0.549163818359375}), (RD:EpU2NXnO {cX:0.9240144491195679}), (RD)-[u9:iFFO {Pl:(toBooleanOrNull(toStringOrNull(time('00:45:57,14364133'))))XOR(toBoolean(("ZTl.{C\rv")+(kjJljzxuH.E3)))}]->(e), (kjJljzxuH)-[uu9:iFFO {Pl:true}]->(e), (kjJljzxuH)-[G:iFFO {Pl:false}]->(v), (e)-[zOpKXafs:co {t:point({ x: 0.925790, y: 0.824358 })}]->(e), (e)-[Pb:co {t:zOpKXafs.t}]->(v), (e)-[p7:e {DkPC:0.8643138408660889, L:x.E3}]->(x), (v)-[CO:co {t:Pb.t}]->(e), (x)-[VuyyLnTq:co {t:Pb.t}]->(kjJljzxuH), (x)-[lFF:iFFO {Pl:(uu9.Pl)OR(u9.Pl)}]->(e), (x)-[onzbw_jg8:e {DkPC:v.cX, L:sign(-(e.cX))}]->(v)
CREATE (O0aa:P {OgvI:""}), (tZ8e:ZYz5OC {E3:O0aa.CwNLh}), (f:ZYz5OC {E3:-0x7e2e3a10fde880cb}), (byjpdNJ:EpU2NXnO {cX:0.2214605212211609}), (jLPkXe7:P {CwNLh:0o731351510761421440360, c7:date('06940118'), OgvI:O0aa.OgvI}), (jLPkXe7)-[lpttkP2XC:iFFO {Pl:(time('13')) IS NOT NULL}]->(jLPkXe7), (jLPkXe7)-[hu4:co {t:point({ x: 0.481220, y: 0.253081, z: 0.647598 })}]->(O0aa), (jLPkXe7)-[IVl0fx:co {t:hu4.t}]->(tZ8e), (byjpdNJ)-[jj:e {iV4:(jLPkXe7.OgvI)+(left(lTrim(jLPkXe7.OgvI),jLPkXe7.CwNLh)), DkPC:0.17286914587020874, L:-0x134290b4fb3fc2e0}]->(jLPkXe7), (byjpdNJ)-[Bb:co {t:point({ x: 0.986309, y: 0.495286, z: 0.993960 })}]->(O0aa), (byjpdNJ)-[T:co {t:point({ x: 0.949604, y: 0.224657, z: 0.686049 })}]->(tZ8e), (O0aa)-[UEkQLO:e {DkPC:-(byjpdNJ.cX)}]->(jLPkXe7), (O0aa)-[M5:co {t:point({ x: 0.274628, y: 0.050542 })}]->(O0aa), (O0aa)-[Mkdan:e {DkPC:0.9174498319625854}]->(f), (tZ8e)-[OV:iFFO {Pl:lTrim(reverse(jj.iV4))=~toUpper(O0aa.OgvI)}]->(O0aa), (tZ8e)-[f4mQ:co {t:T.t}]->(f), (f)-[O0E:e {iV4:"~", DkPC:0.46781909465789795, L:jLPkXe7.CwNLh}]->(O0aa), (f)-[gWGs:co {t:point({ x: 0.311745, y: 0.041749 })}]->(tZ8e), (f)-[u:iFFO {Pl:OV.Pl}]->(f)
CREATE (g:P {CwNLh:+((+(abs(0o761023254217437162152)))-(size("Dc")))}), (uzb2yKShI:EpU2NXnO {cX:-(((abs(-4803149093317411764))-(toFloatOrNull(date('0516-02-23'))))^(g.CwNLh))}), (Flk:EpU2NXnO {cX:0.9439091086387634}), (Flk)-[nJ:co {t:point({ x: 0.061240, y: 0.153236 })}]->(Flk), (uzb2yKShI)-[zN:e {iV4:"G", L:0o657113025453675416736}]->(uzb2yKShI) RETURN Flk.cX AS aHt , g , uzb2yKShI
SHOW TRANSACTIONS
CREATE (So:P {CwNLh:-323007206167118399}), (b8L1:EpU2NXnO {cX:0.019205331802368164}), (Bl:ZYz5OC {E3:0x7fa3485d6ab23d9b}), (Bl)-[U:e {iV4:So.OgvI, L:-0x30d9c118ea7f8b21}]->(b8L1), (Bl)-[T37f9:e {L:0o670665431650715242742}]->(Bl), (Bl)-[HX5xi:co {t:point({ x: 0.464563, y: 0.521971, z: 0.921250 })}]->(So), (So)-[S:iFFO {Pl:false}]->(b8L1) RETURN * ORDER BY S, b8L1, So.OgvI DESCENDING LIMIT 9102002316187532310
CREATE (cp:ZYz5OC {E3:(size(("UKc5G9")+(0x57f0dfeb57f4fc76)))%(toIntegerOrNull(duration.between(date('08060102'),date('0562-10-31'))))}), (U50C1P:P {CwNLh:abs(toInteger(false))}), (FpK:ZYz5OC {E3:cp.E3}), (FpK)-[NDhLPGojO:iFFO {Pl:true}]->(cp), (FpK)-[WGEJ8:e {DkPC:+((U50C1P.CwNLh)%(-((0.6062139868736267)+(0.28530192375183105)))), L:U50C1P.CwNLh}]->(U50C1P), (cp)-[wILN:iFFO {Pl:((NDhLPGojO.Pl) IS NOT NULL)AND(NDhLPGojO.Pl)}]->(FpK), (cp)-[TCh6h6CJu4:iFFO {Pl:false}]->(cp), (cp)-[vKAqJ6:iFFO {Pl:NDhLPGojO.Pl}]->(U50C1P), (U50C1P)-[yGdoTGXvp:co {t:point({ x: 0.266854, y: 0.035959, z: 0.353186 })}]->(cp)
CREATE INDEX A FOR (n:P) ON (n.CwNLh, n.c7, n.OgvI)
CREATE (M:EpU2NXnO {cX:0.631371021270752}), (Jv6b:P {CwNLh:toInteger((log(-0o446765557606011231745))%(toFloat("&+o"))), c7:date('0748-01-01'), OgvI:"H*|Y"}), (L4Fcf:P {OgvI:"cpt\n"}), (d:ZYz5OC {E3:L4Fcf.CwNLh}), (L4Fcf)-[Y21:iFFO {Pl:false}]->(d), (L4Fcf)-[zfT1:e {iV4:Jv6b.OgvI}]->(L4Fcf), (Jv6b)-[a:e {iV4:(((zfT1.iV4)+(zfT1.DkPC))+((zfT1.iV4)+(-(0.9728259444236755))))+((size("l|Z-m'"))%(M.cX)), DkPC:zfT1.DkPC}]->(d), (Jv6b)-[jISk:co {t:point({ x: 0.666873, y: 0.341822 })}]->(L4Fcf), (M)-[IK:iFFO {Pl:(jISk.t)>=(point({ x: 0.251838, y: 0.164769, z: 0.215805 }))}]->(L4Fcf), (M)-[W2:iFFO {Pl:true}]->(Jv6b), (M)-[q0b:e {iV4:"", DkPC:0.4544864296913147}]->(M) RETURN zfT1 , q0b.iV4 AS k9 , d.E3 , jISk.t AS BVQkBz8s , L4Fcf.CwNLh , W2.Pl , M ORDER BY d, L4Fcf.CwNLh , jISk.t DESCENDING
CREATE (i:ZYz5OC {E3:9160505613575784487}), (Fo:P {CwNLh:7425172132128439671}), (R:EpU2NXnO {cX:0.5843978524208069}), (GP8Zj:ZYz5OC {E3:-0x3b4b6c203c705bd3}), (R)-[g:e {iV4:"6LI", L:+((Fo.CwNLh)-(GP8Zj.E3))}]->(GP8Zj), (R)-[pB:e {iV4:"aPau4R'", DkPC:((log10(-0o100340513577223122162))^(g.DkPC))-(+(GP8Zj.E3))}]->(i), (R)-[M:iFFO {Pl:NOT((-(pB.DkPC))<=(g.DkPC))}]->(Fo), (GP8Zj)-[IU:co {t:point({ x: 0.449324, y: 0.931785 })}]->(R), (i)-[Mr:co {t:point({ x: 0.651353, y: 0.556770, z: 0.361115 })}]->(GP8Zj), (i)-[tabQQjZgZ:iFFO {Pl:((Fo.OgvI)+(R.cX))ENDS WITH(Fo.OgvI)}]->(Fo), (Fo)-[oA:iFFO {Pl:M.Pl}]->(R), (Fo)-[X:e {iV4:"~CbbD,", DkPC:0.35543328523635864, L:i.E3}]->(GP8Zj), (Fo)-[Np:e {L:-0o741575547444240154301}]->(i), (Fo)-[ABJSN1:co {t:point({ x: 0.850180, y: 0.587141, z: 0.436976 })}]->(Fo) RETURN * ORDER BY pB, ABJSN1, oA, IU
CREATE (q:P {CwNLh:+(+((sign(-3507891070015720599))%(-(2887167250804253419)))), c7:date('06530119'), OgvI:"Fb8a{~1"}), (Cmr:ZYz5OC {E3:q.CwNLh}), (q)-[v5ZadD:e {iV4:"{V", L:q.CwNLh}]->(q), (Cmr)-[dn:e {L:q.CwNLh}]->(q), (Cmr)-[YEZ:iFFO {Pl:toBooleanOrNull((floor(-0x7dfcb4f3890e1437))%(dn.DkPC))}]->(Cmr)
CREATE (k1:ZYz5OC {E3:-((size("]VxY7kG"))-(-(-(-0x4abfaae4ed9ccee6))))}), (K:EpU2NXnO {cX:point.distance(point({ x: 0.658095, y: 0.291749, z: 0.491394 }),point({ x: 0.156574, y: 0.607691 }))}), (L:EpU2NXnO {cX:0.013190150260925293}), (nytCNqlB:ZYz5OC {E3:0x18efbac8f6dc1cc}), (c3js:EpU2NXnO {cX:(k1.E3)^(-(((0x2a4b343c9b0edef3)/(-0o121271432046260117456))+((k1.E3)^(0.16088122129440308))))}), (c3js)-[qEV1pOM:e {DkPC:0.14683592319488525}]->(c3js), (c3js)-[k9fNM:e {L:(nytCNqlB.E3)*(qEV1pOM.L)}]->(K), (c3js)-[Q:iFFO {Pl:false}]->(L), (k1)-[q:co {t:point({ x: 0.705102, y: 0.565876, z: 0.715991 })}]->(nytCNqlB), (k1)-[lT1m1:iFFO {Pl:((isNaN(+(-0o433151276570641616113)))AND(Q.Pl))XOR(Q.Pl)}]->(K), (nytCNqlB)-[Ms:iFFO {Pl:true}]->(k1), (nytCNqlB)-[n:iFFO {Pl:true}]->(nytCNqlB), (nytCNqlB)-[osTub4:iFFO {Pl:false}]->(K), (K)-[no:e {iV4:"", DkPC:0.45066922903060913}]->(k1), (K)-[F3pE:e {iV4:no.iV4, DkPC:0.426443874835968, L:-0o233511653354414504306}]->(nytCNqlB), (K)-[r:e {iV4:k9fNM.iV4, DkPC:0.2570047378540039, L:no.L}]->(K), (L)-[Yp:co {t:point({ x: 0.067128, y: 0.069605, z: 0.187028 })}]->(k1), (L)-[Qg2DXPy:co {t:point({ x: 0.900755, y: 0.786468, z: 0.171571 })}]->(nytCNqlB), (L)-[LkOB:co {t:point({ x: 0.104669, y: 0.421625, z: 0.698180 })}]->(L) RETURN * LIMIT 27792772945005081
CREATE (L:P {CwNLh:(toIntegerOrNull(date('02861204')))%(sign(toIntegerOrNull(date('07530630')))), c7:date('0473-01-07'), OgvI:(((toUpper("jP0"))+(+(-0o653201342603640411347)))+(toString(date('0384-08-10'))))+(toString(time('02')))}), (L)-[A:e {L:-7181225490279710646}]->(L)
CREATE INDEX mnEp FOR (n:ZYz5OC) ON (n.E3)
CREATE RANGE INDEX XN9RPpHJ5 IF NOT EXISTS FOR (n:EpU2NXnO) ON (n.cX)
DROP INDEX pPlzf IF EXISTS

Issue 2:
Hi,

I'm currently working with "Neo4j community version 3.3.3" with a server with the following configurations: Debian GNU/Linux version 9 with 500GB of RAM and 56 cores. (for research purposes)

I am importing a large dataset into Neo4j.

I use four files for this import:

edges.csv which contains about 1.46B edges (25GB)

nodes.csv which I created using a basic python script to extract nodes from edges.csv (40M nodes, 16GB) (I did not bother removing all duplicates from this file)

nodes_header.csv > "userId:ID"

rel_header.csv > ":START_ID (tab) :END_ID"

When I run the command: "./neo4j-admin import --ignore-duplicate-nodes ... " the import process freezes after a couple of minutes when attempting to deduplicate the nodes.

I tested the import with small sample files which worked. I then modified my script to eliminate duplicates and I observed drastic performance improvement.

For a little more than 10M nodes in nodes.csv and 10M relationships in edges.csv total import time went from: 3 minutes with duplicates to > 18 seconds without duplicates to > 16 seconds if I leave out the command "--ignore-duplicate-nodes"

Hopefully there is a solution to improve the --ignore-duplicate-nodes command and stop it from freezing with large datasets.