orientdb
orientdb copied to clipboard
Published
20 hours ago •
orientechnologies
orientechnologies
Gremlin: Unexcepted exception [java.lang.ClassCastException, java.lang.NumberFormatException] triggered by combining"order()" and predicate
OrientDB Version: orientdb-tp3-3.2.16
Java Version:
OS:
We execute the following gremlin query:
Gremlin1: g.V().where(__.both().values("prop17").max().is(lt(274424584))).count()
Result1: 10
Gremlin2: g.V().where(__.both().values("prop17").order().max().is(lt(274424584))).count()
Result2: java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Double
Expected Result: 10
Gremlin3 :g.V().where(__.both().values("prop17").order().max().is(lt(274424584.0))).count()
Result3: java.lang.NumberFormatException
Expected Result: 10
Expected behavior & Actual behavior
I wanted to bring to your attention an issue that we have encountered with Orientdb. When attempting to compare double-type properties which follow an "order()", we have received an unexpected exception [java.lang.NumberFormatException (with double-type constant), java.lang.ClassCastException (with int-type constant)]. Since inserting "order()" here has no influence on result, we believe that Orientdb should support this type of comparison, as other GDBs can execute similar Gremlin queries without encountering such exceptions.
Would it be possible for you to investigate this matter and provide a solution to this issue? We greatly appreciate your attention to this matter and thank you for your prompt response.
Steps to reproduce
The graph is created by the following gremlin statements, the same as #9929 :
g.addV("Vlabel1").property("prop16", Double.NaN).property("prop14", 61630181958359.16).property("prop27", "HCyThA4").property("prop29", Double.NEGATIVE_INFINITY).property("prop5", Double.POSITIVE_INFINITY).property("PersonalId", 1)
g.addV("Vlabel2").property("prop29", 2.8319071529274764e+16).property("prop14", -2.642760822214528e+18).property("prop24", -1129216680).property("prop13", Double.NaN).property("prop30", 1878690415).property("prop21", "fk0").property("prop23", 8462126434964226845).property("prop6", Double.NEGATIVE_INFINITY).property("prop2", true).property("prop17", Double.NaN).property("prop22", "PqOgUIStYKpwY2").property("prop28", 1.7772804328828436e+18).property("prop3", "rOVVFt3bx").property("prop20", -1949766713086176952).property("prop16", -6.926096871681423e+18).property("prop26", "WtzU59c24NeDeNLmq5AG").property("prop7", 2099206191).property("prop27", "8bsin2O1ZsDNlz6Xe").property("PersonalId", 2)
g.addV("Vlabel3").property("prop26", "X").property("prop18", 7889385628165619549).property("PersonalId", 3)
g.addV("Vlabel4").property("prop6", Double.NEGATIVE_INFINITY).property("prop25", "MFPRiQf").property("prop5", -1.4943928748028835e+17).property("prop27", "Y").property("prop29", Double.NaN).property("prop2", false).property("prop26", "aVm9fTtVafKD5BaEJ").property("prop3", "810DVoqz").property("prop24", -713661389).property("prop14", -6.032236861917631e+18).property("prop15", Double.NaN).property("prop17", Double.NaN).property("prop22", "mk3E94hh4gRT5Vv7bC1").property("prop19", Double.NEGATIVE_INFINITY).property("prop11", -3.054723382205422e+17).property("prop10", 1886494799).property("prop1", Double.POSITIVE_INFINITY).property("PersonalId", 4)
g.addV("Vlabel5").property("prop16", Double.NEGATIVE_INFINITY).property("prop1", -4.4113954541626977e+18).property("prop14", 1.8349481367911932e+16).property("prop21", "sQKvzU6hNGtDBRBAnUI").property("prop5", Double.POSITIVE_INFINITY).property("prop30", 1841394704).property("prop23", 7322835538732289622).property("prop29", -3.281798270910507e+17).property("prop28", Double.POSITIVE_INFINITY).property("prop25", "C").property("prop3", "tGcMOnS81ncWbZWA").property("PersonalId", 5)
g.addV("Vlabel4").property("prop6", -6.008432536403717e+18).property("prop25", "WsRRUUkmmGiMSH6").property("prop5", Double.NEGATIVE_INFINITY).property("prop27", "kwRLP").property("prop29", -5.596953294269636e+17).property("prop2", true).property("prop26", "7b").property("prop3", "PZvtyZ").property("prop24", 1166490279).property("prop14", -1.8445683589289772e+18).property("prop15", Double.NaN).property("prop17", -9.832692544044801e+17).property("prop22", "2oyExnvJcnsdP").property("prop19", Double.POSITIVE_INFINITY).property("prop11", -4.754730693049295e+18).property("prop10", -1359076327).property("prop1", Double.NaN).property("PersonalId", 6)
g.addV("Vlabel2").property("prop29", Double.NEGATIVE_INFINITY).property("prop14", Double.POSITIVE_INFINITY).property("prop24", 1000769620).property("prop13", -4.793490607911119e+18).property("prop30", -235633446).property("prop21", "iTSn5a5gmI30jERaMvt").property("prop23", 4235180201438938888).property("prop6", 1.9788384120109e+17).property("prop2", false).property("prop17", -7.099756962425486e+17).property("prop22", "BHRlMB").property("prop28", Double.NEGATIVE_INFINITY).property("prop3", "CHrw").property("prop20", -6452989069589911290).property("prop16", 1.5606283846818527e+18).property("prop26", "OoEqWIv8M5c").property("prop7", -1554091824).property("prop27", "jvvgMKD9TMG0HJZYF").property("PersonalId", 7)
g.addV("Vlabel4").property("prop6", Double.NaN).property("prop25", "40rvKb8MipO4ABTz").property("prop5", Double.NEGATIVE_INFINITY).property("prop27", "31THBoNo").property("prop29", 4.514023555504831e+17).property("prop2", true).property("prop26", "j3cMI9").property("prop3", "LsFwkyAV").property("prop24", -1253618141).property("prop14", Double.NEGATIVE_INFINITY).property("prop15", 3.531037708218838e+17).property("prop17", -4.4891174329153797e+18).property("prop22", "MAJNzXeUu8U").property("prop19", 3.07043888984091e+17).property("prop11", -1.750823554582363e+18).property("prop10", -2126014133).property("prop1", Double.NEGATIVE_INFINITY).property("PersonalId", 8)
g.addV("Vlabel2").property("prop29", 4.59906933366771e+18).property("prop14", -1.121283619546315e+17).property("prop24", -1300687982).property("prop13", Double.POSITIVE_INFINITY).property("prop30", 816519357).property("prop21", "DBGspJc").property("prop23", 5658989581677609023).property("prop6", Double.POSITIVE_INFINITY).property("prop2", true).property("prop17", Double.NaN).property("prop22", "r39YCCY9geJMg").property("prop28", -1.81153103104598e+17).property("prop3", "ItFvXyj8OG9K").property("prop20", 2092412882489365781).property("prop16", -3.6701431162705654e+18).property("prop26", "rt2Xy3p3").property("prop7", -784208416).property("prop27", "c9Rymgx8nr").property("PersonalId", 9)
g.addV("Vlabel2").property("prop29", Double.POSITIVE_INFINITY).property("prop14", Double.NEGATIVE_INFINITY).property("prop24", 419010603).property("prop13", Double.NEGATIVE_INFINITY).property("prop30", 1197700167).property("prop21", "T6T4IluSopoMxx").property("prop23", 6689117407439773750).property("prop6", 4.675698370274959e+18).property("prop2", true).property("prop17", -3.6681926220767386e+17).property("prop22", "xnBDzRdb10pM").property("prop28", Double.POSITIVE_INFINITY).property("prop3", "hOVUf4BHCFbDw0").property("prop20", 5485281501898197168).property("prop16", 2.0229550824144714e+18).property("prop26", "Twto").property("prop7", -653906228).property("prop27", "NIBEn").property("PersonalId", 10)
g.addE("Elabel10").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop29", 1.2703102866267554e+17).property("prop8", -1.4274451672501215e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop23", -295614041196640180).property("prop4", Double.POSITIVE_INFINITY).property("prop14", -6.49903447523184e+17).property("PersonalId", 1)
g.addE("Elabel6").from(__.V().where(__.values("PersonalId").is(eq(6)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop12", 3345707903766441485).property("prop4", 2.5773919376238797e+18).property("prop26", "L").property("prop25", "xQEIQcW5aO").property("prop1", Double.POSITIVE_INFINITY).property("prop29", 2.4157550503942943e+18).property("prop18", 5192445267913289245).property("PersonalId", 2)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(6)))).property("prop7", 584058702).property("prop26", "7CjmGX").property("prop11", 1.0125428084353318e+18).property("prop1", -1.6774424876729294e+16).property("prop15", Double.NaN).property("prop20", -4501951150908347687).property("prop13", Double.POSITIVE_INFINITY).property("prop9", Double.NEGATIVE_INFINITY).property("prop2", true).property("prop6", -3.9543806122989404e+18).property("prop14", Double.NaN).property("prop4", 3.256462205967117e+17).property("prop22", "9YfjQ5e").property("prop27", "Myuci01R4JK43FzSOC").property("prop29", Double.NEGATIVE_INFINITY).property("prop3", "BT6YfKAu").property("prop21", "nRtvK").property("prop23", -3259981201924053425).property("prop24", 1426355537).property("prop30", 767293463).property("prop25", "X").property("prop12", 4942959202291835903).property("prop10", 145342968).property("prop19", Double.NaN).property("prop18", 2232071205386432255).property("prop28", Double.POSITIVE_INFINITY).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", Double.POSITIVE_INFINITY).property("PersonalId", 3)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", 8744353835698768637).property("prop9", -2.416064189060547e+18).property("prop6", Double.NEGATIVE_INFINITY).property("prop11", Double.NaN).property("prop23", 2852365254923566948).property("prop21", "fqzwHG").property("prop25", "xIritmBwOtzs").property("prop30", -604906900).property("prop15", Double.NEGATIVE_INFINITY).property("prop26", "onPPCH6Gi").property("prop16", Double.NaN).property("prop1", Double.NEGATIVE_INFINITY).property("prop28", Double.NEGATIVE_INFINITY).property("prop22", "QHbNhg28vqz").property("prop17", Double.NaN).property("prop12", 1881465453019040381).property("prop13", -3.444921927044028e+17).property("PersonalId", 4)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(8)))).property("prop7", 1062556348).property("prop26", "hUPvgEBYLanF").property("prop11", -6.514878963259148e+18).property("prop1", Double.NEGATIVE_INFINITY).property("prop15", 5.486329643765865e+18).property("prop20", -2674034240007623960).property("prop13", Double.NaN).property("prop9", 2.2201399654504532e+18).property("prop2", false).property("prop6", Double.POSITIVE_INFINITY).property("prop14", 1.6982225599575926e+18).property("prop4", Double.NEGATIVE_INFINITY).property("prop22", "JKEwb4mirZRE30zn").property("prop27", "A5kSXoxpb").property("prop29", Double.NaN).property("prop3", "7FxFRb98UUdt4W5vTVoh").property("prop21", "BChjDQJ48atVsGBAc").property("prop23", 6883923694623070982).property("prop24", 1416752735).property("prop30", -1975843652).property("prop25", "UNdBdc9UL7us").property("prop12", 7851312673631272031).property("prop10", 1676841952).property("prop19", Double.NEGATIVE_INFINITY).property("prop18", -5106417029072786723).property("prop28", 5.647107764599236e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", -3.167069465520199e+16).property("PersonalId", 5)
g.addE("Elabel10").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop29", Double.POSITIVE_INFINITY).property("prop8", -3.1663344531177605e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop23", -5922933103926202774).property("prop4", -1.4930305641396124e+18).property("prop14", -5.266337135065513e+18).property("PersonalId", 6)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", -3316580138171222843).property("prop9", 5.240670577554265e+16).property("prop6", 5.998757848895173e+18).property("prop11", 2.696164912287722e+17).property("prop23", 6445046930812509342).property("prop21", "I1lomzcEivuemQc3znem").property("prop25", "mNAnqDMwxIofhgE").property("prop30", 917951894).property("prop15", -1.510495552124441e+18).property("prop26", "3d5LJrImS4U").property("prop16", -2.7764581602659834e+17).property("prop1", Double.NEGATIVE_INFINITY).property("prop28", -5.606226517436408e+18).property("prop22", "xyBRQSAlShvLgQU").property("prop17", -5.943893511517181e+18).property("prop12", 6765601002150940485).property("prop13", -5.212118945518441e+18).property("PersonalId", 7)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "sE9lH4EYcXl").property("prop7", 1857716043).property("prop21", "gA").property("prop18", 8205472037597202930).property("PersonalId", 8)
g.addE("Elabel10").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop29", 4.24831794024124e+18).property("prop8", Double.NaN).property("prop17", Double.POSITIVE_INFINITY).property("prop23", 4218376318040645153).property("prop4", -1.7257182800184714e+18).property("prop14", -1.2235757991130455e+18).property("PersonalId", 9)
g.addE("Elabel5").from(__.V().where(__.values("PersonalId").is(eq(10)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop10", 2040115033).property("prop20", -6052373812002076415).property("prop17", Double.NEGATIVE_INFINITY).property("prop14", -3.8561534566693473e+18).property("prop24", 1263631099).property("prop29", 4.494920566570059e+17).property("prop3", "9BY4QiMKYClaR5zjaxB").property("prop9", -3.6441494255539466e+18).property("prop12", -1798270216837086025).property("prop22", "n").property("prop21", "L7PYYsTx7woBUrvwP").property("prop5", -3.7032448709857e+17).property("prop4", Double.POSITIVE_INFINITY).property("prop16", 1.9104062459667878e+18).property("prop8", Double.NaN).property("prop11", Double.NaN).property("prop28", Double.NaN).property("prop7", 1613819998).property("prop26", "uDQTXRBMxqkh3").property("prop1", Double.NaN).property("prop27", "B").property("prop2", true).property("prop13", 1.3816627221202282e+17).property("prop30", -2144519450).property("prop15", Double.NEGATIVE_INFINITY).property("prop19", Double.NaN).property("prop23", 1966925651113693793).property("prop6", 5.492226505057543e+17).property("prop25", "0CnByaHdmKdiAxAePXYS").property("prop18", 7750574588982023786).property("PersonalId", 10)
g.addE("Elabel10").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop29", Double.POSITIVE_INFINITY).property("prop8", 1.9094439895336696e+18).property("prop17", Double.POSITIVE_INFINITY).property("prop23", -5213721342057976194).property("prop4", Double.NEGATIVE_INFINITY).property("prop14", 1.3826848801531704e+17).property("PersonalId", 11)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "ZqXjS8O").property("prop7", -1136189101).property("prop21", "qnWb3SpdmNy6aeo8ZGc").property("prop18", 4437884336684007172).property("PersonalId", 12)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(6)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", 170905147).property("prop9", Double.POSITIVE_INFINITY).property("prop16", 9.330699261916407e+17).property("prop3", "zmvk16").property("prop6", 4.739278670309343e+17).property("prop8", -1.6784883672595003e+18).property("prop25", "13").property("prop4", Double.POSITIVE_INFINITY).property("prop10", 560963008).property("prop30", 380194108).property("prop14", Double.NEGATIVE_INFINITY).property("prop17", Double.POSITIVE_INFINITY).property("prop22", "CkXHfkYV").property("prop19", -6.900260235683526e+17).property("prop20", 4055192830117265901).property("prop26", "57O9Ct7u6MxMIwO").property("prop23", -7926716180731580169).property("prop29", -1.6316177053016128e+17).property("prop12", -7726525874808230654).property("prop15", Double.NEGATIVE_INFINITY).property("PersonalId", 13)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(2)))).to(__.V().where(__.values("PersonalId").is(eq(2)))).property("prop19", Double.NaN).property("prop25", "WgS").property("prop18", -7908399740410346174).property("prop2", true).property("prop29", -4.998929634801442e+18).property("prop20", -3337206261458231655).property("prop1", Double.NaN).property("prop5", Double.POSITIVE_INFINITY).property("prop15", Double.NaN).property("prop3", "Boq3IUEkipQlVpvhxLTi").property("prop23", -7466279290036489426).property("PersonalId", 14)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", -2120407769).property("prop9", 4.644796631403213e+18).property("prop16", Double.NEGATIVE_INFINITY).property("prop3", "ti3lf7fgdhhc6nxF3f").property("prop6", -5.925345561807555e+16).property("prop8", Double.NEGATIVE_INFINITY).property("prop25", "deyLotis1aK6Bvph7Lw").property("prop4", Double.NaN).property("prop10", -1634916406).property("prop30", -229556642).property("prop14", -4.191581560738497e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop22", "BtOKzWUm7").property("prop19", Double.NaN).property("prop20", 7980864456074083708).property("prop26", "ayRv8iIlcaS").property("prop23", 6288129644370886767).property("prop29", Double.POSITIVE_INFINITY).property("prop12", -2115585509387139329).property("prop15", -2.4093995390245e+18).property("PersonalId", 15)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "jaZD").property("prop7", 614347401).property("prop21", "vDK1WcJhI").property("prop18", 3606798879305115052).property("PersonalId", 16)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", 1375576574).property("prop9", Double.NEGATIVE_INFINITY).property("prop16", Double.NaN).property("prop3", "F").property("prop6", Double.NEGATIVE_INFINITY).property("prop8", Double.NaN).property("prop25", "y").property("prop4", Double.NEGATIVE_INFINITY).property("prop10", 1605681983).property("prop30", 772480041).property("prop14", 1.4454643145906646e+17).property("prop17", -1.6122907247384192e+18).property("prop22", "f").property("prop19", Double.POSITIVE_INFINITY).property("prop20", 2542479340827520853).property("prop26", "sVwszF1iuANS5HqFYKX").property("prop23", 4579266746429328532).property("prop29", -1.185915879735899e+18).property("prop12", 5092621422076278084).property("prop15", -1.316164753529114e+18).property("PersonalId", 17)
g.addE("Elabel3").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(8)))).property("prop18", -3675125533398935946).property("prop7", 1232335742).property("prop30", 502521157).property("prop23", -1067072250874183930).property("prop4", 2.710428497064308e+18).property("prop12", 444412744661698232).property("prop9", -1.4806508597237996e+18).property("prop10", -1337061645).property("prop17", Double.NaN).property("prop6", Double.NaN).property("prop8", Double.NEGATIVE_INFINITY).property("prop16", Double.NEGATIVE_INFINITY).property("prop22", "dnAY8glK").property("prop20", 1688182367072279738).property("prop21", "VgYrf3pj6bu79R6g").property("prop2", true).property("prop3", "7FJwVsH3S5Hud").property("prop11", Double.POSITIVE_INFINITY).property("prop27", "uuyH4gAo").property("PersonalId", 18)
g.addE("Elabel6").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop12", -5935174318966076403).property("prop4", Double.POSITIVE_INFINITY).property("prop26", "FhglYOsBbGwCk").property("prop25", "bTfIvu3x").property("prop1", Double.POSITIVE_INFINITY).property("prop29", Double.POSITIVE_INFINITY).property("prop18", -2452337890487174465).property("PersonalId", 19)
g.addE("Elabel10").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop29", -5.9170450284196e+17).property("prop8", Double.NEGATIVE_INFINITY).property("prop17", -6.591100084209116e+17).property("prop23", 2622299195611517170).property("prop4", Double.POSITIVE_INFINITY).property("prop14", Double.POSITIVE_INFINITY).property("PersonalId", 20)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(7)))).to(__.V().where(__.values("PersonalId").is(eq(10)))).property("prop19", Double.NEGATIVE_INFINITY).property("prop25", "UFbdHXN").property("prop18", -4406206517757131403).property("prop2", false).property("prop29", 2.6286266293728394e+18).property("prop20", -4766168792242089785).property("prop1", Double.NEGATIVE_INFINITY).property("prop5", Double.NEGATIVE_INFINITY).property("prop15", Double.NaN).property("prop3", "RJjxQsG0wctei").property("prop23", 5643600321965083290).property("PersonalId", 21)
g.addE("Elabel6").from(__.V().where(__.values("PersonalId").is(eq(6)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop12", 4740928587329095357).property("prop4", Double.NEGATIVE_INFINITY).property("prop26", "FSesYNR3").property("prop25", "6eES").property("prop1", -5.286463313435056e+18).property("prop29", Double.POSITIVE_INFINITY).property("prop18", 199595556575725695).property("PersonalId", 22)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "trbz7h0HGubzvcypZYD").property("prop7", -1391380959).property("prop21", "TZoAh43JpRQjEYk3Tprn").property("prop18", -4742196013534875141).property("PersonalId", 23)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(8)))).property("prop7", -1065495510).property("prop26", "uay6L113u9").property("prop11", 3.5140894611589504e+18).property("prop1", 1.6951904265936275e+17).property("prop15", Double.POSITIVE_INFINITY).property("prop20", -2491724316121424715).property("prop13", Double.POSITIVE_INFINITY).property("prop9", Double.POSITIVE_INFINITY).property("prop2", false).property("prop6", 1.65219185710848e+18).property("prop14", Double.POSITIVE_INFINITY).property("prop4", -2.7067959657730224e+17).property("prop22", "xh").property("prop27", "2ksxbzN1NUvUaO9IRd5").property("prop29", -9.903422794494118e+17).property("prop3", "PJyuxn").property("prop21", "H9h6j2cI7W5hGYO").property("prop23", 1054301397782165942).property("prop24", -1226818988).property("prop30", -559215181).property("prop25", "3zatu1TkiXD85z5").property("prop12", 4620314969967745298).property("prop10", 38359626).property("prop19", Double.NaN).property("prop18", 3381910582005223969).property("prop28", -6.735861933809092e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", Double.NEGATIVE_INFINITY).property("PersonalId", 24)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(6)))).property("prop7", -1078445066).property("prop26", "FKD3WF").property("prop11", Double.POSITIVE_INFINITY).property("prop1", -4.149603157639486e+17).property("prop15", Double.POSITIVE_INFINITY).property("prop20", -7727164587782243285).property("prop13", Double.NEGATIVE_INFINITY).property("prop9", 2.3055038325845847e+18).property("prop2", true).property("prop6", -3.266794093420671e+17).property("prop14", 3.857992013886231e+17).property("prop4", -4.6047296467723514e+17).property("prop22", "gzDM4lxN").property("prop27", "RYiYxRU4kmAyDON").property("prop29", 4.646729025816408e+18).property("prop3", "oy7B6N9Us").property("prop21", "ZBIdB9z10K4r").property("prop23", 7622616415637660635).property("prop24", -45644407).property("prop30", -1474004545).property("prop25", "Vb4G1ZEpJ699ELNjN0qu").property("prop12", -7667870998248824238).property("prop10", 1743262269).property("prop19", Double.NEGATIVE_INFINITY).property("prop18", 7913025340794605884).property("prop28", Double.NaN).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", 1.7560353907482056e+18).property("PersonalId", 25)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(6)))).property("prop7", -999534034).property("prop26", "Xa").property("prop11", Double.NEGATIVE_INFINITY).property("prop1", Double.POSITIVE_INFINITY).property("prop15", Double.NEGATIVE_INFINITY).property("prop20", 6617725862029166487).property("prop13", 3.776554640192463e+17).property("prop9", Double.POSITIVE_INFINITY).property("prop2", false).property("prop6", -4.0207299772664744e+16).property("prop14", 2.8885367880373693e+18).property("prop4", -7.488228031877988e+17).property("prop22", "Sz").property("prop27", "OQupz01Xq").property("prop29", Double.NEGATIVE_INFINITY).property("prop3", "F4Sc7G").property("prop21", "hQ7x6IJUY27RM2cl8j").property("prop23", -1209191603945386109).property("prop24", -1918068445).property("prop30", -269085777).property("prop25", "s").property("prop12", -1730663012612752662).property("prop10", -1178056385).property("prop19", 4.664303817829246e+18).property("prop18", -2717457476765538042).property("prop28", -4.1970387649439877e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", Double.NEGATIVE_INFINITY).property("PersonalId", 26)
g.addE("Elabel5").from(__.V().where(__.values("PersonalId").is(eq(10)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop10", -1002702980).property("prop20", -5513141395208423568).property("prop17", Double.POSITIVE_INFINITY).property("prop14", Double.POSITIVE_INFINITY).property("prop24", -1097883982).property("prop29", Double.POSITIVE_INFINITY).property("prop3", "IHSNvHvDE").property("prop9", 2.3223155024376817e+18).property("prop12", 609544467937503554).property("prop22", "PKuM").property("prop21", "t").property("prop5", -2.8338323641443026e+18).property("prop4", Double.NaN).property("prop16", -2.6259467573084175e+18).property("prop8", 1.643875949077933e+18).property("prop11", 4.886939215530225e+18).property("prop28", 7.58088203463938e+18).property("prop7", -1520076074).property("prop26", "OGEBrLzP56xfIsAa8").property("prop1", -5.732795280703711e+18).property("prop27", "U7an4m7Pu3tGjeiLh").property("prop2", true).property("prop13", Double.POSITIVE_INFINITY).property("prop30", 104672256).property("prop15", Double.NEGATIVE_INFINITY).property("prop19", Double.NaN).property("prop23", 3741394875414485868).property("prop6", Double.NaN).property("prop25", "tKPNSV").property("prop18", 750106298940232987).property("PersonalId", 27)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", 311671883340285888).property("prop9", -1.0727114287252645e+18).property("prop6", Double.NEGATIVE_INFINITY).property("prop11", 3.5999479837435914e+18).property("prop23", -2637620856375528819).property("prop21", "9TYTDsq1iFSx8lOBNUc").property("prop25", "PVolATT").property("prop30", 1161210293).property("prop15", -1.6385920685067377e+18).property("prop26", "BtI").property("prop16", Double.POSITIVE_INFINITY).property("prop1", -2.818439916207983e+18).property("prop28", -3.1392872571210824e+18).property("prop22", "SR5").property("prop17", -4.5123866529850016e+17).property("prop12", -3297849676383340362).property("prop13", Double.NaN).property("PersonalId", 28)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", -5113856222106498543).property("prop9", Double.NaN).property("prop6", Double.NEGATIVE_INFINITY).property("prop11", 1.9221399604539898e+17).property("prop23", 9053895630705912422).property("prop21", "Qbj1uoCHRmsDhXku").property("prop25", "UW").property("prop30", 2045328806).property("prop15", -2.8597494201463616e+17).property("prop26", "z").property("prop16", 3.309334029442271e+18).property("prop1", 1.6835058280130747e+18).property("prop28", 1.875442423140474e+18).property("prop22", "5uM").property("prop17", 6.420718961203304e+17).property("prop12", 7533566514994653305).property("prop13", Double.POSITIVE_INFINITY).property("PersonalId", 29)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(6)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", -841931442).property("prop9", Double.NEGATIVE_INFINITY).property("prop16", -4.677296487614033e+18).property("prop3", "M1s9tfZJwVG5pV").property("prop6", -1.5084692455715476e+18).property("prop8", -2.0898405447698406e+18).property("prop25", "6pV").property("prop4", Double.NaN).property("prop10", -392204829).property("prop30", -1465983828).property("prop14", -1.9855054231065866e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop22", "lvwcDEoRYQaPW0DX").property("prop19", Double.NaN).property("prop20", 2454352598544191984).property("prop26", "DhDMniGhlrM").property("prop23", 8814298531671507735).property("prop29", 7.054755935228035e+18).property("prop12", 329300158545755877).property("prop15", 5.582195049761452e+18).property("PersonalId", 30)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(2)))).to(__.V().where(__.values("PersonalId").is(eq(7)))).property("prop19", Double.NaN).property("prop25", "T8FS4OMREspjCM36B").property("prop18", -8115129131102545365).property("prop2", true).property("prop29", Double.POSITIVE_INFINITY).property("prop20", -1148143476847563847).property("prop1", 1.616629527539082e+17).property("prop5", Double.NEGATIVE_INFINITY).property("prop15", 2307831328432730.0).property("prop3", "QevuvOsKKR17zP").property("prop23", -4862835759889341396).property("PersonalId", 31)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", 1472407900).property("prop9", 6.213444801163448e+17).property("prop16", 4.2408078669871616e+18).property("prop3", "9jnK9V76").property("prop6", Double.POSITIVE_INFINITY).property("prop8", -1.5313060327745505e+18).property("prop25", "P2f").property("prop4", 6.002508760823732e+17).property("prop10", -1192211166).property("prop30", 913139110).property("prop14", Double.POSITIVE_INFINITY).property("prop17", Double.POSITIVE_INFINITY).property("prop22", "wKZIlOeus").property("prop19", 2.8807677630770867e+18).property("prop20", 8916730402801401243).property("prop26", "eFIRJoE55").property("prop23", -6164658248618671268).property("prop29", 2.5969703639436186e+18).property("prop12", 4443097266032770258).property("prop15", -4.37176980897402e+17).property("PersonalId", 32)
g.addE("Elabel7").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop7", -207570164).property("prop9", Double.NaN).property("prop16", 3.9018826571114906e+18).property("prop3", "gO").property("prop6", Double.NEGATIVE_INFINITY).property("prop8", Double.NEGATIVE_INFINITY).property("prop25", "zLkraOvWY1kB").property("prop4", Double.NaN).property("prop10", -53334303).property("prop30", -1226018025).property("prop14", 2.0412955918430764e+18).property("prop17", Double.NEGATIVE_INFINITY).property("prop22", "087uQu6PAapKubLd8").property("prop19", 5.899760793572686e+18).property("prop20", 7413833789975871153).property("prop26", "dlFwLJdhr0YXo").property("prop23", 7004555903519097122).property("prop29", Double.NEGATIVE_INFINITY).property("prop12", 2835462553264505708).property("prop15", -5.537281735034979e+17).property("PersonalId", 33)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", -5984891807792818077).property("prop9", Double.NaN).property("prop6", 1.1564077862846853e+18).property("prop11", Double.NEGATIVE_INFINITY).property("prop23", 2908913109100338918).property("prop21", "IAz4").property("prop25", "8").property("prop30", -215387011).property("prop15", -1.5230250683563884e+18).property("prop26", "LHH").property("prop16", Double.NEGATIVE_INFINITY).property("prop1", -6.815923690245777e+18).property("prop28", Double.NaN).property("prop22", "i0m0wqHV9Bj7SGbJ").property("prop17", Double.NEGATIVE_INFINITY).property("prop12", 7034145265241935836).property("prop13", Double.NEGATIVE_INFINITY).property("PersonalId", 34)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(8)))).to(__.V().where(__.values("PersonalId").is(eq(8)))).property("prop7", 1888807576).property("prop26", "8ffT1lOnFz9MQpe2mxvA").property("prop11", 2.313881938514619e+16).property("prop1", -3.0160570609798784e+17).property("prop15", -2.621107615503102e+17).property("prop20", -2829835892953952931).property("prop13", Double.NEGATIVE_INFINITY).property("prop9", 3.8270716005703506e+18).property("prop2", true).property("prop6", Double.NaN).property("prop14", 1.3816111495667694e+18).property("prop4", Double.POSITIVE_INFINITY).property("prop22", "kNGZRR").property("prop27", "cgz8").property("prop29", Double.POSITIVE_INFINITY).property("prop3", "8p2KFBZViLRTL").property("prop21", "wuonHWEDonJd").property("prop23", 8842545031144197257).property("prop24", -1090000991).property("prop30", 688249725).property("prop25", "KFIe5CAs8").property("prop12", 579187541607605409).property("prop10", -131079683).property("prop19", Double.POSITIVE_INFINITY).property("prop18", 3421311186860168519).property("prop28", 3.256865292319222e+18).property("prop17", Double.POSITIVE_INFINITY).property("prop5", -8.905278675417011e+16).property("PersonalId", 35)
g.addE("Elabel5").from(__.V().where(__.values("PersonalId").is(eq(9)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop10", -63500514).property("prop20", -3957533748331343709).property("prop17", Double.NaN).property("prop14", 5.074737005354874e+18).property("prop24", 1399799424).property("prop29", 2.5077776398685256e+18).property("prop3", "r05b3XEqRD38tRGZ0I").property("prop9", Double.NaN).property("prop12", -7404682584942225734).property("prop22", "NKwU8pyZmqFg").property("prop21", "oK3S").property("prop5", Double.POSITIVE_INFINITY).property("prop4", -3.042549402241591e+18).property("prop16", 8.10865972005096e+17).property("prop8", Double.NaN).property("prop11", 7.243289435891775e+18).property("prop28", Double.POSITIVE_INFINITY).property("prop7", 820994470).property("prop26", "hZZWuBO").property("prop1", Double.NEGATIVE_INFINITY).property("prop27", "y").property("prop2", true).property("prop13", Double.NEGATIVE_INFINITY).property("prop30", 1616690679).property("prop15", Double.NEGATIVE_INFINITY).property("prop19", Double.NEGATIVE_INFINITY).property("prop23", -3508627739242074951).property("prop6", Double.POSITIVE_INFINITY).property("prop25", "ndfW").property("prop18", -3794337864278584508).property("PersonalId", 36)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(9)))).to(__.V().where(__.values("PersonalId").is(eq(7)))).property("prop19", 6.386795489570339e+18).property("prop25", "7dLDDefu8Bxqs5").property("prop18", -2930756870536731234).property("prop2", false).property("prop29", Double.NEGATIVE_INFINITY).property("prop20", 4634356952214406438).property("prop1", 3.058997263647014e+18).property("prop5", 1.29713647098428e+18).property("prop15", Double.POSITIVE_INFINITY).property("prop3", "xNxpyyq").property("prop23", 8031341679865384422).property("PersonalId", 37)
g.addE("Elabel3").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(8)))).property("prop18", -8887718309240829082).property("prop7", 1651961962).property("prop30", -1550801296).property("prop23", -5650675896272197138).property("prop4", Double.POSITIVE_INFINITY).property("prop12", 1999647711540598974).property("prop9", -3.153168261070024e+18).property("prop10", -1154081621).property("prop17", -3.4353740056075745e+18).property("prop6", Double.POSITIVE_INFINITY).property("prop8", -1.6283572464204083e+18).property("prop16", Double.POSITIVE_INFINITY).property("prop22", "VJ1fb4kMgxt").property("prop20", 6320057511163370208).property("prop21", "H7zmesJE1yu4nM8bm1P4").property("prop2", false).property("prop3", "hwtWd2q5Zqbxn9fM").property("prop11", Double.POSITIVE_INFINITY).property("prop27", "O024zlxSf7").property("PersonalId", 38)
g.addE("Elabel2").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(9)))).property("prop14", Double.NEGATIVE_INFINITY).property("prop16", Double.NaN).property("prop12", -638731437114337793).property("prop10", 2110083501).property("prop28", -5.014774097681223e+18).property("prop8", Double.NaN).property("prop4", Double.POSITIVE_INFINITY).property("PersonalId", 39)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(7)))).to(__.V().where(__.values("PersonalId").is(eq(7)))).property("prop19", Double.NEGATIVE_INFINITY).property("prop25", "Ph5iHiUf1").property("prop18", -7467753866027221764).property("prop2", true).property("prop29", Double.NaN).property("prop20", -6199281432683975606).property("prop1", Double.NEGATIVE_INFINITY).property("prop5", Double.NaN).property("prop15", 7.44079805658561e+16).property("prop3", "MdDeo4BXZ9gK4X").property("prop23", 4960059128294022809).property("PersonalId", 40)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", -2125534425594914880).property("prop9", 1.6372695532564045e+17).property("prop6", Double.NEGATIVE_INFINITY).property("prop11", 1.6945745404467656e+18).property("prop23", 8265582805460808449).property("prop21", "4").property("prop25", "8YRBKZOEjVRkYaIcE").property("prop30", 1504152992).property("prop15", 1.8322027042698747e+18).property("prop26", "TdcVkrGiQ2dhqipZ3Xkx").property("prop16", Double.NEGATIVE_INFINITY).property("prop1", 4.745483171794322e+18).property("prop28", -3.352087372947321e+18).property("prop22", "l7M8bIlpMTjfaN").property("prop17", Double.POSITIVE_INFINITY).property("prop12", -4139307426501880696).property("prop13", Double.NaN).property("PersonalId", 41)
g.addE("Elabel5").from(__.V().where(__.values("PersonalId").is(eq(7)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop10", -208735873).property("prop20", -5349874884847456833).property("prop17", Double.NaN).property("prop14", 1.4105418614802066e+18).property("prop24", 1586599169).property("prop29", Double.POSITIVE_INFINITY).property("prop3", "Vz2Ug62QxYExIZszA").property("prop9", Double.NEGATIVE_INFINITY).property("prop12", -3520569848546150308).property("prop22", "r29Yau6LAfp").property("prop21", "ajcZT6NN0LYlfeH").property("prop5", Double.NEGATIVE_INFINITY).property("prop4", Double.NEGATIVE_INFINITY).property("prop16", Double.POSITIVE_INFINITY).property("prop8", Double.POSITIVE_INFINITY).property("prop11", 2.482963415829778e+18).property("prop28", Double.POSITIVE_INFINITY).property("prop7", 1949083235).property("prop26", "NwWOglx8QcKf").property("prop1", -1.9575763698728938e+17).property("prop27", "WJilC1UkfZURuQzU").property("prop2", true).property("prop13", -4.556201945323016e+18).property("prop30", 636317044).property("prop15", Double.NaN).property("prop19", 2.393729923172165e+18).property("prop23", 7017128113324503970).property("prop6", Double.POSITIVE_INFINITY).property("prop25", "Yh5dRbmHdkWO").property("prop18", 392984894095650718).property("PersonalId", 42)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "5vIu").property("prop7", -1313579199).property("prop21", "lIaBvAm").property("prop18", -2952289958074630375).property("PersonalId", 43)
g.addE("Elabel8").from(__.V().where(__.values("PersonalId").is(eq(3)))).to(__.V().where(__.values("PersonalId").is(eq(3)))).property("prop3", "hkbc").property("prop7", 779804509).property("prop21", "SvIhVeyF").property("prop18", -2677445536655361702).property("PersonalId", 44)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(7)))).to(__.V().where(__.values("PersonalId").is(eq(10)))).property("prop19", Double.NEGATIVE_INFINITY).property("prop25", "7Z4x7").property("prop18", 387652135862120879).property("prop2", false).property("prop29", 1.0400703635650865e+18).property("prop20", -736541492872645411).property("prop1", Double.POSITIVE_INFINITY).property("prop5", Double.POSITIVE_INFINITY).property("prop15", 1.7168327386416525e+17).property("prop3", "UvjBedGKcTseoRC3o").property("prop23", 6757577229859340478).property("PersonalId", 45)
g.addE("Elabel4").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop18", -3037732848513714538).property("prop9", Double.NaN).property("prop6", Double.POSITIVE_INFINITY).property("prop11", Double.NaN).property("prop23", -6937155153759528893).property("prop21", "96HfaF").property("prop25", "EHGz1").property("prop30", -1026286750).property("prop15", Double.NaN).property("prop26", "IbB").property("prop16", 1.5103866504029852e+18).property("prop1", Double.NaN).property("prop28", Double.NaN).property("prop22", "H").property("prop17", 4.20245035824804e+16).property("prop12", 3398706933248213535).property("prop13", 2.624689123191146e+18).property("PersonalId", 46)
g.addE("Elabel1").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(4)))).property("prop7", 693550433).property("prop26", "uN5qL").property("prop11", -4.090379828646171e+18).property("prop1", Double.NEGATIVE_INFINITY).property("prop15", -3.789147664253613e+18).property("prop20", -5649528442288893114).property("prop13", -6.067814610839027e+18).property("prop9", Double.NEGATIVE_INFINITY).property("prop2", false).property("prop6", Double.NaN).property("prop14", 1.2314238146154865e+18).property("prop4", 3.265202061935033e+18).property("prop22", "GKk1oqaKSzFha").property("prop27", "awtZZEQ83AMLQ9W3S9e").property("prop29", Double.POSITIVE_INFINITY).property("prop3", "0hAWiyy2jzeTKI").property("prop21", "sdG5").property("prop23", 7377482966406312966).property("prop24", -803826327).property("prop30", 540454926).property("prop25", "kXkib3KbaMWqTGsMF0p").property("prop12", -9191498865551421658).property("prop10", 843088763).property("prop19", Double.NaN).property("prop18", -2809307036641053972).property("prop28", Double.POSITIVE_INFINITY).property("prop17", Double.NEGATIVE_INFINITY).property("prop5", 9.244811144261144e+16).property("PersonalId", 47)
g.addE("Elabel9").from(__.V().where(__.values("PersonalId").is(eq(9)))).to(__.V().where(__.values("PersonalId").is(eq(7)))).property("prop19", 4.5991089197431864e+18).property("prop25", "pTa99FYiMHAA2VIHST").property("prop18", -2060056340619989012).property("prop2", true).property("prop29", -1.9710605754959977e+18).property("prop20", -7745160567000020378).property("prop1", -7.885432545614482e+17).property("prop5", -2.2480174254637734e+17).property("prop15", 1.1775929807088424e+17).property("prop3", "9").property("prop23", 6871056000879181760).property("PersonalId", 48)
g.addE("Elabel2").from(__.V().where(__.values("PersonalId").is(eq(5)))).to(__.V().where(__.values("PersonalId").is(eq(9)))).property("prop14", -1.904517700739666e+17).property("prop16", Double.NEGATIVE_INFINITY).property("prop12", 4447239848424386183).property("prop10", -1924912636).property("prop28", Double.NEGATIVE_INFINITY).property("prop8", -1.7284512446304773e+18).property("prop4", Double.NEGATIVE_INFINITY).property("PersonalId", 49)
g.addE("Elabel6").from(__.V().where(__.values("PersonalId").is(eq(4)))).to(__.V().where(__.values("PersonalId").is(eq(1)))).property("prop12", -5083327041446586991).property("prop4", Double.NEGATIVE_INFINITY).property("prop26", "vkS9BGnXw8DOW").property("prop25", "vNc").property("prop1", Double.NEGATIVE_INFINITY).property("prop29", -1.1995434159961994e+17).property("prop18", -246691878137024800).property("PersonalId", 50)
Hi,
This problem probably come from the upstream gremlin, since 3.2.18 we update to the last gremlin release, could you double check this cases with this release or newer ?
As well I do suggest to report this problem upstream this may be common to other gremlin implementations.
Bye
Thank you very much for your valuable assistance.
I have discovered that it is possible to order vertices/edges using the key of a missing property in TinkerGraph, and this behavior is acceptable. TinkerGraph will simply ignore any vertices/edges that are missing the specified property key when using the order() method. Would it be possible for you to further investigate it?