Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MATCH (n) RETURN n throws AssertionError #371

Closed
gkorland opened this issue Sep 25, 2023 · 8 comments
Closed

MATCH (n) RETURN n throws AssertionError #371

gkorland opened this issue Sep 25, 2023 · 8 comments

Comments

@gkorland
Copy link
Contributor

Created by: @llooFlashooll
Source: RedisGraph/RedisGraph#2930
We discovered a bug that MATCH (n) RETURN n throws AssertionError.

  • RedisGraph version: 2.10.4
  • Operating system: macOS 13.2.1
  • API/Driver: Java

I first randomly create a graph. Then when I run the following query: MATCH (n) RETURN n is thrown without further message to identify the root cause. I think this query is definitely correct, but I keep triggering this kind of problem.
In the stack trace, I also cannot identify what kinds of problem of this. Is this caused related to my created graph data?

Expected behavior:

No exception should be expected to throw.

Actual behavior:

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

Caused by: java.lang.NumberFormatException: For input string: "-nan"
	at java.base/jdk.internal.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054)
	at java.base/jdk.internal.math.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
	at java.base/java.lang.Double.parseDouble(Double.java:651)
	at java.base/java.lang.Double.valueOf(Double.java:614)
	at redis.clients.jedis.util.DoublePrecision.parseFloatingPointNumber(DoublePrecision.java:15)
	at redis.clients.jedis.BuilderFactory$8.build(BuilderFactory.java:121)
	at redis.clients.jedis.BuilderFactory$8.build(BuilderFactory.java:118)
	at redis.clients.jedis.graph.ResultSetBuilder.deserializeScalar(ResultSetBuilder.java:263)
	at redis.clients.jedis.graph.ResultSetBuilder.deserializeGraphEntityProperties(ResultSetBuilder.java:243)
	at redis.clients.jedis.graph.ResultSetBuilder.deserializeNode(ResultSetBuilder.java:191)
	at redis.clients.jedis.graph.ResultSetBuilder.deserializeScalar(ResultSetBuilder.java:271)
	at redis.clients.jedis.graph.ResultSetBuilder.parseRecords(ResultSetBuilder.java:154)
	at redis.clients.jedis.graph.ResultSetBuilder.build(ResultSetBuilder.java:59)
	at redis.clients.jedis.graph.ResultSetBuilder.build(ResultSetBuilder.java:20)
	at redis.clients.jedis.Response.build(Response.java:62)
	at redis.clients.jedis.Response.get(Response.java:38)
	at redis.clients.jedis.TransactionBase.exec(TransactionBase.java:136)
	at redis.clients.jedis.Transaction.exec(Transaction.java:47)
	at ch.cypherchecker.redis.RedisConnection.execute(RedisConnection.java:38)
	at ch.cypherchecker.redis.RedisQuery.executeAndGet(RedisQuery.java:52)
	... 3 more

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:

CREATE (izetzWlI9q:ws {UTl0:"&gD"}), (tQZ:XnR6 {HZ6z:NOT(((toJSON(6207639607455856316))+(("(I")+(0.16108179092407227)))ENDS WITH((replace(null,"","9y^H|*~"))+(-(-5313351691280665162)))), e:point({ longitude: -131.520371, latitude: -0.596690 }), a04DCGNtt:point({ longitude: -122.582789, latitude: 79.670162 })}), (izetzWlI9q)-[xJabz:xk {n4NG8VEX8r:((((((toInteger(0.9294711947441101))%((-4519137833977264008)+(9223372036854775807)))<>(sign(0.36971592903137207)))XOR((-((0.08333808183670044)%(-8550396751739628544)))=(+((0.1543474793434143)+(-9091053027802413842)))))AND((point({ longitude: 98.932616, latitude: 28.946046 })) IS NULL))OR(((right("",-928388035443212193))+((8508952725203759513)*(-3006172213657430753)))ENDS WITH((toString(false))+(pow(6753094210416440301,-8082680317733075491)))))XOR(NOT(NOT(("")ENDS WITH(""))))}]->(izetzWlI9q), (tQZ)-[p:MNM01 {k9QOhh:-((toInteger(-4633941864589389551))+(-((7881008834095489121)%(-5127092128978416082)))), f2X:(((("")ENDS WITH("|*V5BL4"))OR((((true)OR(true))OR(false))XOR(false)))AND((point({ longitude: 83.675846, latitude: -50.634958 })) IS NOT NULL)) IS NULL, aC2o7wI:(abs(sqrt(3644831198369004318)))<(floor(sqrt(0.2377183437347412))), CyIG0v8:floor(+(+(287378640743900093)))}]->(izetzWlI9q), (tQZ)-[YtB:MNM01 {k9QOhh:2086357037129330785, CyIG0v8:794564020981787365}]->(tQZ) RETURN DISTINCT p.k9QOhh AS Tq6YboGGD , izetzWlI9q.rP AS xfIlT , YtB.k9QOhh AS gG , tQZ.HZ6z AS yVqp 
CREATE (EpQV:XnR6 {HZ6z:(sqrt(-(0.06708383560180664))) IS NOT NULL, e:point({ longitude: -23.607937, latitude: -12.506296 }), a04DCGNtt:point({ longitude: -147.757181, latitude: -56.050511 }), gUPRe5iFG:false}), (S:TdH2q {UYxEiwWd:-(-((floor(0.49703431129455566))-(abs(-82327124245259921))))}), (s6E:XnR6 {HZ6z:false, e:point({ longitude: 60.155766, latitude: 68.976797 }), a04DCGNtt:point({ longitude: 169.846090, latitude: 57.930618 })}), (EpQV)-[GSFI3t:MNM01 {k9QOhh:+((floor(-4777739109453254370))%(floor(-277367248981698733))), f2X:false, aC2o7wI:true, CyIG0v8:floor(-(sign(-1166084765794657043)))}]->(S), (S)-[eE:MNM01 {f2X:true}]->(EpQV), (S)-[cZ:vtcNLWJK {k9HEEEdx:-4692390968352620701, Rok_ssa:point({ longitude: -78.415532, latitude: 44.127657 })}]->(S), (S)-[B:MNM01 {CyIG0v8:ceil((abs(-4749172197487330602))*(+(293055412684937757)))}]->(s6E), (s6E)-[too4l:xk {n4NG8VEX8r:false}]->(EpQV) RETURN DISTINCT eE , EpQV.e , B.k9QOhh , s6E.gUPRe5iFG AS Fk886e , S , cZ , too4l , GSFI3t ORDER BY S , B.k9QOhh , cZ , EpQV.e , too4l , GSFI3t DESCENDING , s6E.gUPRe5iFG  LIMIT 8227870779856324178
MATCH (n:sGp) WHERE (n.Uv59dUS) IS NULL DELETE n
CREATE (u:TdH2q {T:point({ longitude: 92.372717, latitude: -40.445231 }), uCb:false, UYxEiwWd:+(-(((-7969312398970734018)-(0.9335674047470093))^(pow(-1607932876342683082,650324737238333012))))}), (zMR:XnR6 {HZ6z:false, e:point({ longitude: -108.011039, latitude: 87.508201 }), a04DCGNtt:point({ longitude: 160.063036, latitude: -22.926882 })}), (u)-[qtxfs:vtcNLWJK {k9HEEEdx:((((-5252087812681604319)-(7038375597243511422))-(toInteger(45985928380205690)))-(sign(0.15259039402008057)))*(-(sign(0.8631184697151184))), Rok_ssa:point({ longitude: 93.409498, latitude: -37.439554 }), mXvI:point({ longitude: -45.774493, latitude: -72.278833 })}]->(zMR), (zMR)-[qA:vtcNLWJK {k9HEEEdx:toInteger(+((0.6694547533988953)-(0.25520265102386475))), Rok_ssa:point({ longitude: 144.216415, latitude: -76.860980 }), mXvI:point({ longitude: 178.342863, latitude: -11.577678 })}]->(u), (zMR)-[mpQLswq:vtcNLWJK {DY:point({ longitude: 42.350886, latitude: -37.200538 })}]->(zMR)
CREATE (mvu:TdH2q {T:point({ longitude: -106.987993, latitude: 74.076906 }), uCb:((toUpper("6"))+(sign(0.35593360662460327)))STARTS WITH(toJSON(-(0.8954700231552124)))}), (pL2:TdH2q {T:point({ longitude: 39.835717, latitude: -13.986436 })}), (sAuqu:ws {UTl0:substring(lTrim("[.E9YS/\\"),(-(-3316882933742994530))*(floor(-4449772671089612987)),+(size("b")))}), (bk:TdH2q {uCb:(-((-(-9220706042409462471))-(+(5356757857756164244))))<>(abs((1081915074601656891)+(-6795264090704022996)))}), (pL2)-[n77:vtcNLWJK {k9HEEEdx:+((size("sT"))-(((-1639531048027100247)*(1406722424517695856))*(-(-3702086803066923402)))), DY:point({ longitude: 138.770602, latitude: -17.523844 }), Rok_ssa:point({ longitude: -40.503254, latitude: 4.799485 }), mXvI:point({ longitude: -127.064916, latitude: 2.820584 })}]->(sAuqu), (sAuqu)-[Ud60_n:MNM01 {aC2o7wI:true, CyIG0v8:-3383740037081922676}]->(sAuqu), (sAuqu)-[H:xk {n4NG8VEX8r:(((("GZ4dq(eWB")+(1978326651401761797))CONTAINS(left("",-3996039996960005775)))XOR(NOT(NOT(true))))<>((toJSON(true))<(substring("a",3516946390446570765,-4144738908453796658)))}]->(mvu), (mvu)-[k0k3XlVOoZ:vtcNLWJK {DY:point({ longitude: -162.109975, latitude: 61.541901 }), k9HEEEdx:7914997656790518821, Rok_ssa:point({ longitude: -79.691168, latitude: 52.397368 })}]->(pL2), (mvu)-[X:MNM01 {k9QOhh:1891595471416706948, f2X:((trim("{I5"))+(floor(0.8764269948005676)))ENDS WITH(((substring("1#y",-3578007480900353861,8326775257026373841))+(+(4990425583402931169)))+(substring("",-7756363765606998576,6128383418824488546))), aC2o7wI:true, CyIG0v8:4818193812707933678}]->(bk), (mvu)-[HLu1UXZrb:xk {n4NG8VEX8r:true}]->(mvu)
CREATE (Ab:XnR6 {HZ6z:NOT((((5539073940226454489)%(-8679369839601371357))-(+(2073359092217677351)))=(-((-2589237158958262549)*(1357181538199983485)))), a04DCGNtt:point({ longitude: -116.472259, latitude: 67.997244 }), gUPRe5iFG:true}), (Ab)-[vi8:vtcNLWJK {k9HEEEdx:84027375641814394, DY:point({ longitude: -146.718037, latitude: 59.167621 }), Rok_ssa:point({ longitude: -15.082840, latitude: 60.700495 }), mXvI:point({ longitude: 115.044563, latitude: 80.812473 })}]->(Ab)
CREATE (x:GJO8RqW5J {a:true, v:0.3626631498336792}), (o94w8Uy2ul:TdH2q {T:point({ longitude: 168.589136, latitude: 67.920912 }), uCb:(("[0GCH\n")+(((-6714433022251779630)%(6884525309463951042))%(floor(6956419135508337181))))ENDS WITH(left(("!Yc")+(3139050054077377409),-(5882166012157411073))), UYxEiwWd:0.5906493067741394}), (n_:GJO8RqW5J {v:+(abs((0.7644559144973755)+(0.8834467530250549)))}), (n_)-[qTB:vtcNLWJK {k9HEEEdx:+(-(-(+(-4153092680833992155)))), DY:point({ longitude: -148.861413, latitude: -58.677673 }), Rok_ssa:point({ longitude: -96.115221, latitude: -75.299327 }), mXvI:point({ longitude: -40.380274, latitude: 65.402539 })}]->(n_), (o94w8Uy2ul)-[yn:MNM01 {f2X:false}]->(x), (x)-[J8drvh:MNM01 {f2X:true, aC2o7wI:false, CyIG0v8:7849435405459776857}]->(x) RETURN * 
CREATE (uT:sGp {ceK:((-((8035985461883139887)*(2965273323133785031)))-(ceil(5065593953964860823)))%(-(floor(-7268951553956363552))), UoxEFK3h:point({ longitude: 68.509138, latitude: 67.941523 }), Uv59dUS:(+(-(+(0.026869773864746094))))+(+(((-376062824555905715)+(-3457308072486071219))-(+(0.6771562695503235)))), O:-5163278343547748100}), (PR:GJO8RqW5J {a:false}), (adSx:GJO8RqW5J {a:false, v:0.28822559118270874}), (h9:XnR6 {HZ6z:(ceil((5635490593685198771)+(3783500396322939541)))>=((-(sign(-8130992982735965440)))*(-((6151714773695467181)+(8493497680415464965)))), e:point({ longitude: -178.114043, latitude: -44.135061 }), a04DCGNtt:point({ longitude: 40.180536, latitude: 33.579632 }), gUPRe5iFG:(((substring("",6311296356431014703,-4127626050090850244))+(left("pZf",5367927191784166769)))+(((5719144501284334023)-(5868340921833155122))*(+(7269002301805507827)))) IS NOT NULL}), (rbDqH:sGp {ceK:7015995178857270072, UoxEFK3h:point({ longitude: 77.703506, latitude: -60.175426 })}), (h9)-[bR0TNu9QQ:MNM01 {k9QOhh:2596637378484881020, f2X:false, aC2o7wI:true, CyIG0v8:5379142404449223887}]->(h9), (h9)-[Jg:xk {n4NG8VEX8r:(((toJSON(point({ longitude: 164.307279, latitude: 47.454848 })))+(-(9029710356481659320)))ENDS WITH((replace("8%[Ap ma","K+B7wKD","a"))+((0.25096601247787476)*(0.4809865355491638))))XOR(((("")+(6519496408423305955))+(+(6299297493111860229)))>(((">qrtf+2\t*")+("yART'"))+(+(0.9228200912475586))))}]->(PR), (h9)-[gJ:xk {n4NG8VEX8r:false}]->(rbDqH), (PR)-[N3X:vtcNLWJK {k9HEEEdx:ceil((size("7s"))*(sign(486597194754589263))), Rok_ssa:point({ longitude: -110.814797, latitude: 24.718737 })}]->(PR), (PR)-[rG415ZrY:xk {n4NG8VEX8r:(((floor(0.8742225170135498))*((-8712527219873970439)-(7676367863875223247)))-(+((0.4037414789199829)%(-7308668461990970172))))>(-(ceil(0.6535826325416565)))}]->(adSx), (uT)-[SU:xk {n4NG8VEX8r:((-(ceil(0.9820500612258911)))*(pow(-7868318378966247186,-5679356779553887014))) IS NOT NULL}]->(PR), (uT)-[u:MNM01 {k9QOhh:floor(-(floor(4719108927694231087)))}]->(adSx), (uT)-[cB8sr7Lb5:vtcNLWJK {DY:point({ longitude: -167.902675, latitude: 58.801712 }), k9HEEEdx:3594353679668347837, Rok_ssa:point({ longitude: 128.600285, latitude: 33.278821 }), mXvI:point({ longitude: 169.916020, latitude: -57.905124 })}]->(uT), (uT)-[D:vtcNLWJK {DY:point({ longitude: -83.096083, latitude: 13.948980 }), mXvI:point({ longitude: -28.916738, latitude: 47.890374 })}]->(rbDqH), (rbDqH)-[Tft:xk {n4NG8VEX8r:false}]->(rbDqH)
DROP INDEX ON :MNM01(CyIG0v8)
CALL db.idx.fulltext.drop('XnR6')
CREATE (j9bm:GJO8RqW5J {a:true, v:abs(sqrt(0.7686391472816467)), n:point({ longitude: -120.971356, latitude: 85.770851 })})
MATCH (n:sGp) WHERE NOT(NOT((("zx")>=("j"))XOR((false) IS NOT NULL))) DELETE n
CREATE (i:ws {UTl0:toLower((("(")+(-7032946332137465612))+(size("d")))}), (i)-[cx5eayYFqm:xk {n4NG8VEX8r:(((sqrt(0.988921046257019))-(ceil(0.5925529599189758)))%((+(0.49883681535720825))%(-(-6693873438238266690))))<=(floor((0.41150355339050293)-(-67057676486819680)))}]->(i)
CREATE (Xds96AQ:TdH2q {T:point({ longitude: -129.965795, latitude: -30.195568 }), uCb:true}), (Xds96AQ)-[wkJL4:MNM01 {f2X:(NOT(NOT(("")>("}"))))>=((NOT(("\\7l")STARTS WITH("JEIJ\tOX?L")))XOR((lTrim("*WZ")) IS NOT NULL)), CyIG0v8:-(+(ceil(6831143810992086744))), aC2o7wI:true}]->(Xds96AQ)
CREATE (J:GJO8RqW5J {a:false, v:0.9507065415382385, n:point({ longitude: 2.327159, latitude: -43.073210 })}), (Uxnm3oL5w:GJO8RqW5J {a:false, v:0.5083168745040894, n:point({ longitude: 37.145803, latitude: -42.080765 })}), (c5DK:sGp {O:floor((floor(-5614022771845259683))%(abs(2507041366214960956)))}), (c5DK)-[F:xk {n4NG8VEX8r:true}]->(Uxnm3oL5w), (Uxnm3oL5w)-[NKOf:vtcNLWJK {k9HEEEdx:476890624248127729, DY:point({ longitude: -79.979475, latitude: -84.678621 }), Rok_ssa:point({ longitude: 64.217222, latitude: 53.630103 }), mXvI:point({ longitude: -94.036537, latitude: -86.842918 })}]->(c5DK), (J)-[Ju:MNM01 {k9QOhh:-7848758489286137728, f2X:false, CyIG0v8:null, aC2o7wI:((((-(round(4660490564633259306)))>(sqrt(-5748192085317289498)))XOR((lTrim("wE"))<((("_")+("qtZ~w"))+(("JgL")+("7iJ!Jlgt")))))XOR(((("")+(0.38006001710891724)) IS NULL)AND((toJSON(point({ longitude: 114.642663, latitude: 43.983012 })))STARTS WITH(toLower("O")))))AND((toJSON(0.7573166489601135))STARTS WITH(toUpper("8f6n")))}]->(Uxnm3oL5w), (J)-[Cq:vtcNLWJK {DY:point({ longitude: 117.552675, latitude: -16.003923 }), Rok_ssa:point({ longitude: 154.536582, latitude: -59.192142 }), mXvI:point({ longitude: 126.498027, latitude: -67.504743 })}]->(J) RETURN DISTINCT NKOf , c5DK , Uxnm3oL5w , F.n4NG8VEX8r , J.a , Ju.k9QOhh , Cq.Rok_ssa AS iAd ORDER BY F.n4NG8VEX8r DESC 
MATCH (n:sGp) WHERE (((((("\\s\n_\n^jC") IS NULL)OR(NOT(false)))AND(("7")CONTAINS("LfDC\ndmo")))AND((n.UoxEFK3h) IS NOT NULL))>((NOT(true))XOR(NOT(false)))) IS NULL SET n.O = NULL RETURN n ORDER BY n.ceK DESC 
MATCH (n:TdH2q) WHERE n.uCb SET n.UYxEiwWd = NULL RETURN n AS HqtlLFave ORDER BY n 
MATCH (n:TdH2q) WHERE (n.UYxEiwWd)<>(n.UYxEiwWd) SET n.uCb = NULL
CREATE (vaW4:ws {UTl0:"H", rP:true}), (W5eVh7XP_0:GJO8RqW5J {a:true, v:-((+(-(0.32618433237075806)))%(+(round(3581102308559872931)))), n:point({ longitude: 171.347414, latitude: 77.297914 })}), (C:TdH2q {T:point({ longitude: -27.899743, latitude: 3.577515 }), UYxEiwWd:(floor(+(0.9920158386230469)))*(+(((-4672615701472807230)%(4673091155196200522))-(-(0.9056271910667419))))}), (RT:TdH2q {T:point({ longitude: -66.686971, latitude: 22.141293 }), uCb:false, UYxEiwWd:0.3400592803955078}), (W5eVh7XP_0)-[D8M4LF6:MNM01 {aC2o7wI:true}]->(C), (W5eVh7XP_0)-[Y0kvQfUowl:xk {n4NG8VEX8r:true}]->(vaW4), (RT)-[ERw7:MNM01 {f2X:true}]->(RT), (C)-[fNM7MJhwM6:xk {n4NG8VEX8r:false}]->(W5eVh7XP_0), (C)-[KKcYrfXq:vtcNLWJK {k9HEEEdx:-6512120217602153079, mXvI:point({ longitude: -122.501713, latitude: -87.406864 })}]->(C), (vaW4)-[I:MNM01 {k9QOhh:(toInteger((-1103850574723712145)%(4255171067020514459)))+(-(abs(3226267941955680551))), f2X:((abs(0.5490460395812988))-(+(+(0.21435445547103882))))>=(((+(0.9072961807250977))^((-2373534735401269719)-(632710450273223028)))-((toInteger(0.8984941840171814))+(+(-4937941746353753494)))), aC2o7wI:true, CyIG0v8:7638365163672523409}]->(W5eVh7XP_0) RETURN * ORDER BY W5eVh7XP_0, fNM7MJhwM6.n4NG8VEX8r DESC , C.uCb , KKcYrfXq, D8M4LF6, Y0kvQfUowl.n4NG8VEX8r DESC  LIMIT 5467774641408577339
CREATE (J3X07Ievpj:sGp {ceK:7761637931251428031, UoxEFK3h:point({ longitude: -107.075035, latitude: -12.821313 }), O:3209853605139620223}), (i0l:TdH2q {uCb:(ceil((0.052101075649261475)%(2348124979588956937)))<=(abs((0.5526219010353088)+(-7841686485257540912))), UYxEiwWd:-(+(+(+(0.4567616581916809))))}), (sQZHlU2mp:ws {UTl0:"", rP:(right(lTrim(""),-(-7420736969058299827))) IS NULL}), (J3X07Ievpj)-[Gk6wwUH9:MNM01 {k9QOhh:(+((toInteger(-2018950816728066756))+(+(1604881595520542279))))%(size(("My")+("j6}")))}]->(i0l), (i0l)-[l53n5I:xk {n4NG8VEX8r:false}]->(J3X07Ievpj), (i0l)-[QXNZB:MNM01 {k9QOhh:2580620685034387859, f2X:false, CyIG0v8:((((-6697150019468155011)-(7440415610308100160))+(sign(0.1580803394317627)))+(+((7318635678528123738)-(1905821480633417275))))*(-(ceil(-2688094637167137081))), aC2o7wI:(reverse(("")+("}")))=((reverse(">?!&>ue"))+(pow(4403988157072410369,-1568878365302611013)))}]->(i0l), (i0l)-[K3F:vtcNLWJK {Rok_ssa:point({ longitude: -108.988504, latitude: 26.825088 })}]->(sQZHlU2mp), (sQZHlU2mp)-[Vvb69E8d1:xk {n4NG8VEX8r:((size("?"))%(+(-(6528332819982796659))))<=(-(((3238865657098007896)*(6575970956994446607))%(+(-3990891973402641040))))}]->(sQZHlU2mp) RETURN *  LIMIT 6508398444982882224
CREATE (k:ws {UTl0:(lTrim(("")+("t")))+(+((+(3055365041698755469))/(+(0.6630492210388184))))}) RETURN * 
CREATE (OGH:GJO8RqW5J {a:((round(2732787583036370110))<=(floor(0.03177529573440552))) IS NOT NULL, v:((((-1985116866472879450)-(-5179071110766955002))%((8905607205807694758)+(0.5848819613456726)))+(ceil(0.5988814234733582)))%(abs((0.17218464612960815)+(0.6717012524604797))), n:point({ longitude: 110.120220, latitude: 67.515738 })}) RETURN DISTINCT OGH 
MATCH (n:TdH2q) WHERE n.uCb DELETE n RETURN n AS n  LIMIT 2019354856349815682
CALL db.idx.fulltext.createNodeIndex('ws', 'UTl0')
CREATE (YuFndPali:TdH2q {T:point({ longitude: -13.528771, latitude: -10.114356 }), uCb:false, UYxEiwWd:0.010305345058441162}), (lc:GJO8RqW5J {a:false, v:+((((5076261484070490038)+(-7299193644597183863))*((-2339014947059043766)*(5161067548294475730)))/(+((0.27850574254989624)+(0.10737746953964233))))}), (DAMAEnniU:TdH2q {uCb:true}), (p:GJO8RqW5J {a:(ceil(floor(8842477303975016890))) IS NULL, v:+(sqrt(toInteger(-189137747252289046))), n:point({ longitude: 22.979106, latitude: -48.381238 })}), (p)-[ACw5R:xk {n4NG8VEX8r:NOT(((("")+(0.9361605644226074))+(-(-6820007323023068912)))STARTS WITH((("#8x9|lp")+("I"))+((7119099706584565632)%(985633178718061540))))}]->(YuFndPali), (DAMAEnniU)-[wJJ2w:MNM01 {k9QOhh:7942490951469084503, f2X:(((("d\n[Mt\\+6w")+("Bx,"))+(-(6033321359156325200)))+(-((-3410369938017447206)*(-7342583640097545871))))>=(trim(("%!2r},XJ")+(5320203669466317398))), aC2o7wI:true, CyIG0v8:5261602242440558311}]->(p), (DAMAEnniU)-[sgAkmL9:vtcNLWJK {mXvI:point({ longitude: -30.892327, latitude: -15.236754 })}]->(YuFndPali), (lc)-[DAk7Roo:vtcNLWJK {k9HEEEdx:ceil(floor(-1109911109029060450)), DY:point({ longitude: -16.030688, latitude: 58.987827 }), Rok_ssa:point({ longitude: -16.476171, latitude: 46.604503 }), mXvI:point({ longitude: 32.681833, latitude: 74.581137 })}]->(YuFndPali), (YuFndPali)-[TN:MNM01 {CyIG0v8:7375807040717079141}]->(YuFndPali)
MATCH (n:GJO8RqW5J) WHERE n.a SET n.a = NULL
CREATE (GFGgkvnX:TdH2q {T:point({ longitude: -119.913144, latitude: 11.987866 })}) RETURN * 
MATCH (n:TdH2q) WHERE ((toString(point({ longitude: 73.198625, latitude: -4.220042 })))+((toString("!**"))+(replace("\r~TE5","e|zjZ","AU"))))ENDS WITH(trim(replace("","/UCS\\&(",">nme V\n)"))) SET n.T = NULL RETURN * ORDER BY n.T DESC  LIMIT 3527022369202012688
CREATE (XSz:XnR6 {HZ6z:false, e:point({ longitude: 45.364546, latitude: -87.266882 }), a04DCGNtt:point({ longitude: 26.782145, latitude: 24.857719 }), gUPRe5iFG:NOT(((toJSON(-8845498144112394663))+(("tY")+(0.5716280341148376))) IS NOT NULL)})
CALL db.idx.fulltext.createNodeIndex('ws', 'UTl0')
CREATE (f7LLeMUQgO:XnR6 {HZ6z:false, e:point({ longitude: 137.719346, latitude: 17.598474 }), a04DCGNtt:point({ longitude: 91.374681, latitude: 26.616240 }), gUPRe5iFG:(replace(substring("Ry~iky\\{)",2696950563133501678,-85176976910524460),("")+("yZ9s"),("")+(-1973948009254980621)))STARTS WITH(replace(toLower(""),right("2|w*",7898899962400731929),("")+(0.772626519203186)))}), (nkk:sGp {ceK:-(-(+((6025972067665677631)%(1101792289908447987)))), UoxEFK3h:point({ longitude: 161.401982, latitude: -22.116339 }), Uv59dUS:pow(+(+(-9152774039396459463)),size("("))}), (ORmo:XnR6 {HZ6z:true, a04DCGNtt:point({ longitude: -166.893837, latitude: -36.858087 }), gUPRe5iFG:true}), (SV:GJO8RqW5J {a:true, v:(+(-((-3545423851066999470)*(-7416560274805343841))))/(round(sqrt(0.5825283527374268)))}), (ORmo)-[oDu:MNM01 {k9QOhh:+(floor(+(-2616831618992777753))), f2X:false, CyIG0v8:(size(toLower("T*[YtV~")))+(sign(+(0.8959589600563049)))}]->(ORmo), (ORmo)-[l:xk {n4NG8VEX8r:true}]->(SV), (ORmo)-[f_h:vtcNLWJK {k9HEEEdx:(ceil(+(-6591394616882047924)))+(+(size("w"))), Rok_ssa:point({ longitude: 168.444116, latitude: 60.518614 }), mXvI:point({ longitude: -102.684578, latitude: 52.204312 })}]->(f7LLeMUQgO), (ORmo)-[gdQ:MNM01 {k9QOhh:+(+(+(-(8517052089376048325)))), CyIG0v8:538579076852943566, aC2o7wI:false}]->(nkk), (SV)-[Lez:vtcNLWJK {mXvI:point({ longitude: -94.483377, latitude: -22.005450 })}]->(ORmo), (SV)-[XE:vtcNLWJK {k9HEEEdx:((((596639905889147547)+(4818924863463458882))-(sign(-1075325946982672543)))%(toInteger(0.009055018424987793)))*(ceil((-2244168950094271149)*(-9111613470350362795))), DY:point({ longitude: 102.826723, latitude: 13.681817 }), Rok_ssa:point({ longitude: 176.950599, latitude: 83.769209 }), mXvI:point({ longitude: 166.481816, latitude: 89.775605 })}]->(SV), (SV)-[XN:vtcNLWJK {DY:point({ longitude: -151.092869, latitude: -75.302214 }), Rok_ssa:point({ longitude: -152.648310, latitude: 50.504450 }), mXvI:point({ longitude: -119.216073, latitude: 79.470398 })}]->(f7LLeMUQgO), (f7LLeMUQgO)-[R5EhZn:MNM01 {k9QOhh:toInteger(left("",-3600674945847617357)), f2X:true, aC2o7wI:((substring("",-539408019596367813,-2544866559236230237))+(sign(0.9976891875267029)))CONTAINS(toUpper(toString(0.10201793909072876))), CyIG0v8:7760777987789881815}]->(SV), (f7LLeMUQgO)-[nRY:vtcNLWJK {DY:point({ longitude: 58.304268, latitude: 89.597139 }), k9HEEEdx:4227112574111283882, Rok_ssa:point({ longitude: -89.455714, latitude: -36.223481 }), mXvI:point({ longitude: 136.126901, latitude: 52.262386 })}]->(f7LLeMUQgO), (nkk)-[XX:MNM01 {k9QOhh:abs(-((-7036695706876069030)+(457504396671633513))), f2X:true, aC2o7wI:false, CyIG0v8:6968950724475877533}]->(ORmo)
CREATE (uwBT:ws {UTl0:"", rP:true}) RETURN DISTINCT uwBT ORDER BY uwBT DESCENDING  LIMIT 8455110273917014282
MATCH (n:GJO8RqW5J) WHERE (toLower(("\t")+("r")))CONTAINS((((")vhT hv.q")+(n.v))+(+(null)))+(n.v)) SET n.n = point({ longitude: 5.482803, latitude: 58.167492 })
CREATE (s0:XnR6 {e:point({ longitude: 160.689217, latitude: 67.432478 }), a04DCGNtt:point({ longitude: 163.797159, latitude: -5.348476 }), gUPRe5iFG:true}) RETURN DISTINCT s0  LIMIT 1322529762767467033
CALL db.idx.fulltext.createNodeIndex('ws', 'UTl0')
CREATE (M:ws {rP:false}), (WjFwBbazHZ:sGp {ceK:-716420761829066810})
DROP INDEX ON :XnR6(a04DCGNtt)
DROP INDEX ON :vtcNLWJK(mXvI)
CALL db.idx.fulltext.drop('TdH2q')
MATCH (n:ws) WHERE n.rP SET n.rP = ((right("",4325754216361333897))+(abs(-7102223497506946834))) IS NOT NULL
CREATE (B:TdH2q {T:point({ longitude: 31.634012, latitude: 69.163517 }), uCb:true, UYxEiwWd:0.9392237067222595}), (GGvupACjJ:GJO8RqW5J {v:0.3342571258544922, n:point({ longitude: -44.710699, latitude: 13.280102 })}), (B)-[z9fnV:vtcNLWJK {DY:point({ longitude: -158.263656, latitude: -51.533741 }), Rok_ssa:point({ longitude: -118.538065, latitude: -77.979371 }), mXvI:point({ longitude: 59.483628, latitude: 58.250092 })}]->(B), (B)-[buOq:vtcNLWJK {DY:point({ longitude: 88.590580, latitude: 12.668015 }), k9HEEEdx:4864226805139148602, Rok_ssa:point({ longitude: -93.915916, latitude: 67.131790 })}]->(GGvupACjJ), (GGvupACjJ)-[Gw:xk {n4NG8VEX8r:((((-6886836825358177152)*(0.1844332218170166))*(+(0.7666434049606323)))/(+(size("%#w")))) IS NOT NULL}]->(B) RETURN Gw , buOq , GGvupACjJ.a AS yYut 
MATCH (n:XnR6) WHERE (((n.HZ6z)AND(((-(-3474382780598563417)) IS NOT NULL) IS NOT NULL))OR(n.HZ6z))XOR(n.gUPRe5iFG) DELETE n
MATCH (n:sGp) WHERE (toJSON(("")STARTS WITH("A")))ENDS WITH(((("")+(0.5272387862205505))+(n.ceK))+(n.Uv59dUS)) SET n.O = NULL RETURN n  LIMIT 5308950852254464164
CREATE INDEX FOR ()-[n:MNM01]-() ON (n.CyIG0v8)
CREATE INDEX FOR ()-[n:xk]-() ON (n.n4NG8VEX8r)
CREATE (QMd:XnR6 {e:point({ longitude: 173.803006, latitude: 83.811665 })}), (kQ6i:sGp {ceK:-7226210958657070555, Uv59dUS:abs(pow(7407215017180783333,-1929043490809768642)), O:toInteger(sqrt(-29465841923660130))}), (kQ6i)-[K:vtcNLWJK {mXvI:point({ longitude: 66.687258, latitude: -71.131040 })}]->(kQ6i), (kQ6i)-[g3:xk {n4NG8VEX8r:true}]->(QMd), (QMd)-[F:xk {n4NG8VEX8r:((floor(0.6338183283805847))*(sign(4148301164285899703))) IS NULL}]->(kQ6i), (QMd)-[tDkQ:MNM01 {k9QOhh:sign((round(0.8148095607757568))/((8384396685274390688)*(7933291204649955083))), CyIG0v8:7858466427581602748}]->(QMd)
CREATE (F:sGp {ceK:-7821971092475888581, UoxEFK3h:point({ longitude: 66.876376, latitude: -32.406753 }), Uv59dUS:0.11293596029281616, O:4094123313064488089}), (T:ws {UTl0:"[Is<", rP:(substring(toJSON(0.37620848417282104),+(4792019106986444129),+(1333998547558981942))) IS NOT NULL}), (K:TdH2q {UYxEiwWd:0.2925545573234558}), (T)-[oav:xk {n4NG8VEX8r:false}]->(K), (F)-[g:xk {n4NG8VEX8r:NOT((rTrim(""))ENDS WITH(rTrim("pc3St6rP")))}]->(F), (K)-[c1:MNM01 {k9QOhh:-8744523428363243160, f2X:false, CyIG0v8:-697303298057242956}]->(F)
CREATE (wIOW:ws {UTl0:"U\\eD", rP:((rTrim("Xhg"))<>(replace("","(","\r,")))OR(NOT((("C")+(8987402868303645098))STARTS WITH("")))}), (FPeS:XnR6 {gUPRe5iFG:((replace("k.","^gZ","\\"))+(-(-(3545649164262817448))))ENDS WITH(toLower(toJSON(-6749107731537312490)))}), (Dc:sGp {ceK:((abs(-5474978076002238610))+(-((1779135972810795359)+(-7102412403198710156))))+(+((+(-3436711323881044658))*((-4867878986654661606)%(-2953929576619136842)))), UoxEFK3h:point({ longitude: 153.738127, latitude: -14.182989 }), O:-6630152308313900982}), (BE6DC7r:ws {rP:(right(toUpper("^~d}-"),size("4")))ENDS WITH(toJSON(((false)AND(false))OR(false)))}), (N:ws {UTl0:" jo", rP:(substring(("|")+(0.15900319814682007),size("'"),(5016473085414370197)-(-787616601286321440)))STARTS WITH(replace(left("Qc9NL",-2108950758881508787),left("r8",6194242919192330499),("")+("N/S,&'u")))}), (FPeS)-[CoHrA:vtcNLWJK {k9HEEEdx:-1805765515183699978}]->(N), (wIOW)-[n:xk {n4NG8VEX8r:NOT(((rTrim("Us"))STARTS WITH(("")+(0.22868949174880981))) IS NULL)}]->(Dc), (N)-[aXuCyuUq:MNM01 {k9QOhh:+((-(+(604479320885224148)))*(((2857226873735836121)*(684539753570839618))+((-1446181430684484830)%(372622766058223161)))), f2X:false, aC2o7wI:true}]->(N), (N)-[h:vtcNLWJK {k9HEEEdx:(-(((8676477343128964206)-(9079529433576984849))*((-6770401489311969555)%(-3837513304911765653))))-(+(-(+(54278137475959441)))), DY:point({ longitude: -124.879787, latitude: 36.003334 }), Rok_ssa:point({ longitude: -165.748087, latitude: -27.932325 }), mXvI:point({ longitude: 162.638071, latitude: -13.562733 })}]->(BE6DC7r), (BE6DC7r)-[uTv5ioL9:vtcNLWJK {k9HEEEdx:-7713152414984418019, Rok_ssa:point({ longitude: -149.608161, latitude: -2.907624 }), mXvI:point({ longitude: 87.981931, latitude: -58.277499 })}]->(FPeS), (BE6DC7r)-[rDda4fJo1d:vtcNLWJK {Rok_ssa:point({ longitude: 36.715887, latitude: 26.765936 })}]->(N), (BE6DC7r)-[R:vtcNLWJK {DY:point({ longitude: -36.538721, latitude: 66.362975 }), Rok_ssa:point({ longitude: 130.946149, latitude: -16.777921 })}]->(BE6DC7r) RETURN * 
CREATE (qG9b2yv:GJO8RqW5J {a:false, v:-(+(pow(8750504407795040639,5955341685275508941))), n:point({ longitude: -178.492551, latitude: -4.526516 })}), (qG9b2yv)-[YZMWSKtE9E:MNM01 {k9QOhh:(-(floor(-3285310853240833966)))*(((+(-5722210002704729284))+((-8408833737710904593)-(516510525801014987)))+(((2246247218056447457)+(5264441520015751610))-((9135346116605810791)-(-8481616583987116227)))), aC2o7wI:NOT(((toLower("Fb"))STARTS WITH(toString(0.6059719324111938))) IS NOT NULL)}]->(qG9b2yv)
MATCH (n:ws) WHERE (((n.UTl0)+(n.UTl0))+(+(sqrt(0.6266269683837891))))<(n.UTl0) DETACH DELETE n
CREATE (L6qpP:XnR6 {HZ6z:(-(abs(-7450900381408739095)))<>(+(-(-(-2662003333447729554)))), e:point({ longitude: -43.985190, latitude: 74.034464 }), a04DCGNtt:point({ longitude: 15.797341, latitude: 69.229390 }), gUPRe5iFG:true}), (DQpji:XnR6 {HZ6z:true, a04DCGNtt:point({ longitude: 63.200708, latitude: -16.317508 }), gUPRe5iFG:(-((sqrt(0.8646107912063599))-(abs(0.6870909333229065))))>(-(-(floor(0.07926273345947266))))}), (DQpji)-[q9i:vtcNLWJK {mXvI:point({ longitude: -83.472647, latitude: 14.635152 })}]->(DQpji), (L6qpP)-[wM:xk {n4NG8VEX8r:true}]->(L6qpP)
CREATE (GLst8TRRgs:XnR6 {gUPRe5iFG:(toUpper(rTrim("SlA<1Cd?")))ENDS WITH(substring(("M")+(0.5949969291687012),-(638774485582603386),+(3281304489064297206)))}) RETURN * 
CALL db.idx.fulltext.createNodeIndex('ws', 'UTl0')
CREATE (wZNxA:sGp {ceK:-118281369914969305, UoxEFK3h:point({ longitude: -80.841177, latitude: 55.310448 }), Uv59dUS:(+((-(0.7881773114204407))*(ceil(0.19711297750473022))))%((+(-(232737132079682416)))*((ceil(7787349783754083923))-(+(-7702378916760316060)))), O:-4540206333798047514}), (fWQ:TdH2q {T:point({ longitude: 5.612696, latitude: -20.215165 }), uCb:true, UYxEiwWd:0.7825216054916382}), (UQN5mrjn:ws {UTl0:"Gt~0[n!\r\r"}), (ytVqKex:GJO8RqW5J {a:true, n:point({ longitude: -2.150734, latitude: 33.319256 })}), (OeY:ws {UTl0:toString(true), rP:NOT((toLower("?"))ENDS WITH((("&NW{U4")+("-1W&O"))+(ceil(-3383570180387356327))))}), (fWQ)-[fbVaR8kYM6:xk {n4NG8VEX8r:true}]->(fWQ), (fWQ)-[Rz_apa4:MNM01 {f2X:(+((+(0.9301930069923401))^(abs(0.09243988990783691))))>((-((0.5472446084022522)^(8892206834968602245)))-(-((-6377503053831528100)+(-2804571591090512819)))), aC2o7wI:true}]->(UQN5mrjn), (fWQ)-[FJYp:vtcNLWJK {k9HEEEdx:+(+(floor(-6670427372895455991))), Rok_ssa:point({ longitude: 137.340468, latitude: -16.668985 })}]->(ytVqKex), (OeY)-[zgf1:vtcNLWJK {DY:point({ longitude: 5.182460, latitude: 23.210244 }), k9HEEEdx:((ceil(7672364937858305965))%(((4597024089703064426)+(-4782177915731791416))-((-4055618541227430671)%(-7302131695139880696))))-(sign(+(1084501233901964258))), mXvI:point({ longitude: 15.748347, latitude: -5.622790 })}]->(fWQ), (OeY)-[r:xk {n4NG8VEX8r:true}]->(UQN5mrjn), (wZNxA)-[ga7tXdZM:vtcNLWJK {DY:point({ longitude: -154.780213, latitude: 35.232445 }), k9HEEEdx:-2814201839116768609, mXvI:point({ longitude: -22.043715, latitude: 22.813584 })}]->(OeY), (wZNxA)-[nS_o_jg5:xk {n4NG8VEX8r:true}]->(wZNxA), (wZNxA)-[ZI:xk {n4NG8VEX8r:(((("z")+(0.10682928562164307))+(pow(3022107596269874402,-11214508951279841)))+(ceil(0.38222575187683105)))STARTS WITH(((("")+(0.5216662883758545))+(replace("|?d2*c#O","","")))+(floor(-1848557903835784740)))}]->(ytVqKex), (UQN5mrjn)-[higs:vtcNLWJK {k9HEEEdx:-((size(""))-((floor(-3029893549071021877))-(-(2568423801216341932)))), DY:point({ longitude: -148.014633, latitude: 51.081893 }), Rok_ssa:point({ longitude: -162.792591, latitude: -47.602840 }), mXvI:point({ longitude: -23.790418, latitude: -29.334379 })}]->(OeY), (UQN5mrjn)-[q:xk {n4NG8VEX8r:false}]->(UQN5mrjn), (UQN5mrjn)-[Lt:MNM01 {k9QOhh:8869829450639046391, f2X:false}]->(ytVqKex), (ytVqKex)-[ajc:vtcNLWJK {DY:point({ longitude: -107.921445, latitude: 59.274436 }), Rok_ssa:point({ longitude: -125.585068, latitude: -55.658478 }), mXvI:point({ longitude: 131.095509, latitude: 70.549137 })}]->(fWQ) RETURN fWQ , wZNxA , nS_o_jg5.n4NG8VEX8r , Lt , UQN5mrjn , FJYp 
MATCH (n:ws) WHERE n.rP DELETE n
CREATE INDEX FOR ()-[n:MNM01]-() ON (n.CyIG0v8)
CREATE (Wm7P:GJO8RqW5J {a:("8Jk'F")STARTS WITH(trim(right("",2162737355953610813))), n:point({ longitude: 178.802093, latitude: -42.392422 })}), (XUiE:TdH2q {T:point({ longitude: 135.215502, latitude: 34.027669 }), uCb:((-((-4397390666815513803)*(511504912203568494)))+((-(2926367697037458919))%(-98920817135769401)))>=(floor(toInteger("'}<?g><")))}), (Fng:sGp {ceK:(floor(+(7569433719997885502)))-(abs(+(3598554767406278653))), Uv59dUS:floor(-(sqrt(-7870514957689399942)))}), (XUiE)-[HxetO:MNM01 {CyIG0v8:2233906662994662742, aC2o7wI:false}]->(XUiE), (XUiE)-[YI:vtcNLWJK {k9HEEEdx:+(size(toLower("5H"))), mXvI:point({ longitude: -152.267296, latitude: 55.626876 })}]->(Wm7P), (XUiE)-[U:vtcNLWJK {k9HEEEdx:-(+((ceil(440062782116737729))-((null)%(-3527071788087194852)))), Rok_ssa:point({ longitude: -33.902289, latitude: -80.589804 }), mXvI:point({ longitude: -130.259561, latitude: 52.596228 })}]->(Fng), (Wm7P)-[MsQ:xk {n4NG8VEX8r:(left((" ")+("J(x|xJA"),-(1847615733413348337)))STARTS WITH((lTrim(""))+(toInteger(0.5875349044799805)))}]->(Fng), (Fng)-[hMS5Yh:xk {n4NG8VEX8r:false}]->(XUiE), (Fng)-[FM4:vtcNLWJK {Rok_ssa:point({ longitude: -139.331789, latitude: 40.998096 })}]->(Wm7P) RETURN * 
@gkorland
Copy link
Contributor Author

Origin comment by: @LiorKogan
I suspect this is a Jedis issue, not RedisGraph.

@sazzad16 can you please check if these queries are handled correctly?

GRAPH.QUERY g "RETURN sqrt(-1)"
1) 1) "sqrt(-1)"
2) 1) 1) "-nan"

GRAPH.QUERY g "RETURN pow(100, 200)"
1) 1) "pow(100, 200)"
2) 1) 1) "inf"

GRAPH.QUERY g "RETURN -pow(100, 200)"
1) 1) "-pow(100, 200)"
2) 1) 1) "-inf"

@gkorland
Copy link
Contributor Author

Origin comment by: @sazzad16
@LiorKogan Jedis does not check -nan ATM. It checks nan, inf, -inf.

BTW, Java, even the latest Java, has no separate definition for negative NaN. So, what should Jedis do when it is a -nan? @uglide @chayim

@gkorland
Copy link
Contributor Author

Origin comment by: @LiorKogan
There is no notion of a "negative NaN" in IEEE-754 arithmetic.

RedisGraph currently returns a nonstandard "-nan" string instead of "nan".

@AviAvni @swilly22 Why do we do this? Can we fix it in 2.12?

@sazzad16 all RedisGraph versions out there return such nonstandard string. Can we add a manual check?

@gkorland
Copy link
Contributor Author

Origin comment by: @sazzad16

@sazzad16 all RedisGraph versions out there return such nonstandard string. Can we add a manual check?

@LiorKogan We can check. But, again, what can we do when it is found to be a -nan?

@gkorland
Copy link
Contributor Author

Origin comment by: @LiorKogan
@sazzad16 We should treat -nan as nan

@gkorland
Copy link
Contributor Author

Origin comment by: @nafraf

RedisGraph currently returns a nonstandard "-nan" string instead of "nan".

I don't see any special code in RedisGraph to print "-nan", it is the text returned by sprintf(str, "%.15g", d); when d is NaN.
Probably, we can add a manual check and print "nan".

@gkorland
Copy link
Contributor Author

@sazzad16
Copy link
Contributor

Since Jedis 4.4.0 (redis/jedis#3329), it accepts -nan and returns Double.NaN.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants