[New cypher engine] Vector index + Unwind + params + create errors, treating unwind variable as a string (str = variable name) instead of reading the variable value #3154
Description
Hello,
using commit HEAD~1
Query that fails :
UNWIND $batch AS BatchEntry
MATCH (b:CHUNK) WHERE ID(b) = BatchEntry.destRID
CREATE (p:CHUNK_EMBEDDING {vector: BatchEntry.vector})
CREATE (p)-[:embb]->(b)Params sample :
{"batch": [{"vector": [-0.0159912109375, 0.020538330078125, -0.028778076171875, 0.0081634521484375, -0.0149993896484375, -0.044219970703125, 0.0160064697265625, 0.0028247833251953125, -0.006366729736328125, 0.0203399658203125, 0.0175628662109375, 0.005779266357421875, -0.0599365234375, 0.00620269775390625, 0.02374267578125, 0.0228729248046875, 0.0095367431640625, -0.00597381591796875, 0.0071563720703125, -0.01032257080078125, -0.037200927734375, -0.0208587646484375, 0.037445068359375, 0.0246124267578125, 0.0026912689208984375, 0.01119232177734375, 0.004169464111328125, -0.041015625, -0.0246124267578125, 0.0333251953125, -0.0235137939453125, 0.01180267333984375, -0.02862548828125, -0.0489501953125, 0.0015773773193359375, 0.0286407470703125, 0.02392578125, 0.01071929931640625, -0.02911376953125, -0.0001571178436279297, 0.035125732421875, 0.025421142578125, 0.0160980224609375, -0.0184783935546875, 0.05181884765625, -0.01094818115234375, -0.00659942626953125, -0.017974853515625, -0.025390625, -0.06646728515625, -0.0099029541015625, -0.0008597373962402344, 0.0233917236328125, -0.01520538330078125, 0.029205322265625, 0.01403045654296875, -0.040863037109375, -0.037261962890625, -0.08221435546875, 0.029022216796875, -0.050567626953125, 0.0177001953125, -0.0247955322265625, -0.050201416015625, 0.042327880859375, 0.024444580078125, -0.016754150390625, -0.003200531005859375, 0.0092926025390625, -0.0107269287109375, 0.01898193359375, 0.0008945465087890625, -0.043243408203125, -0.055938720703125, -0.07855224609375, -0.0251922607421875, 0.02301025390625, -0.01053619384765625, 0.0088958740234375, -0.0272979736328125, -0.0186309814453125, -0.00931549072265625, -0.041107177734375, 0.007480621337890625, -0.020172119140625, -0.021514892578125, -0.02471923828125, 0.05963134765625, 0.0260772705078125, -0.056243896484375, -0.07269287109375, -0.04339599609375, -0.027862548828125, -0.02471923828125, 0.005558013916015625, -0.02655029296875, -0.0634765625, 0.0255126953125, 0.00557708740234375, -0.0019178390502929688, 0.003742218017578125, 0.021697998046875, 0.018035888671875, -0.04486083984375, -0.01447296142578125, -0.020416259765625, -0.014892578125, 0.0254669189453125, -0.0248870849609375, -0.015625, -0.0034332275390625, 0.00907135009765625, 0.0250091552734375, 0.0379638671875, -0.00563812255859375, -0.0091094970703125, 0.038726806640625, -0.01038360595703125, 0.006927490234375, -0.0038299560546875, -0.0269927978515625, -0.0423583984375, 0.037567138671875, -0.01535797119140625, -0.0458984375, -0.0263519287109375, 0.0479736328125, 0.032501220703125, -0.03582763671875, 0.0185699462890625, 0.0295867919921875, -0.019073486328125, -0.036651611328125, 0.011322021484375, -0.071533203125, 0.00812530517578125, 0.0147705078125, -0.01352691650390625, 0.03839111328125, -0.0084228515625, 0.05023193359375, 0.037139892578125, -0.056732177734375, -0.0257110595703125, 0.0364990234375, 0.035491943359375, -0.00804901123046875, -0.01751708984375, -0.00569915771484375, 0.047698974609375, 0.001491546630859375, 0.0113677978515625, -0.032745361328125, 0.017120361328125, -0.00402069091796875, 0.037017822265625, -0.004364013671875, 0.00304412841796875, -0.07763671875, -0.01360321044921875, 0.0139617919921875, 0.0357666015625, 0.0135345458984375, -0.021270751953125, 0.0250091552734375, 0.030426025390625, -0.04132080078125, 0.019317626953125, -0.018341064453125, 0.051239013671875, 0.03192138671875, 0.01067352294921875, -0.0164642333984375, -0.039581298828125, 0.0069580078125, 0.007503509521484375, 0.06390380859375, 0.022216796875, -0.0328369140625, -0.043243408203125, -0.07366943359375, 0.016265869140625, 0.0008988380432128906, -0.02862548828125, -0.037139892578125, 0.0009918212890625, -0.036590576171875, -0.0233917236328125, 0.0035839080810546875, 0.0205535888671875, 0.01580810546875, -0.0286712646484375, 0.00618743896484375, 0.026214599609375, 0.0238037109375, -0.0011606216430664062, 0.0015077590942382812, -0.054473876953125, -0.00201416015625, -0.0029888153076171875, -0.055694580078125, -0.016937255859375, -0.02264404296875, 0.0299072265625, -0.05078125, -0.0101776123046875, -0.0555419921875, 0.0007929801940917969, -0.02142333984375, -0.0152740478515625, 0.004138946533203125, -0.003887176513671875, 0.003635406494140625, -0.024322509765625, -0.090576171875, 0.058807373046875, 0.0002989768981933594, -0.0250244140625, 0.01271820068359375, -0.05352783203125, -0.0262451171875, 0.03900146484375, -0.006256103515625, -0.001689910888671875, 0.0262451171875, 0.04571533203125, 0.0097503662109375, 0.040008544921875, 0.05377197265625, -0.037017822265625, 0.01165008544921875, 0.0167999267578125, -0.0007290840148925781, -0.024749755859375, 0.051971435546875, -0.0035858154296875, -0.0281982421875, -0.014434814453125, 0.0250244140625, -0.01053619384765625, 0.004512786865234375, -0.0457763671875, 0.023193359375, 0.00930023193359375, -0.016143798828125, 0.021697998046875, 0.01001739501953125, -0.0031795501708984375, -0.0197906494140625, -0.0240325927734375, -0.00785064697265625, 0.0197296142578125, -0.017547607421875, 0.0253753662109375, -0.002735137939453125, -0.01113128662109375, 0.005466461181640625, -0.0138397216796875, -0.005115509033203125, 1.2516975402832031e-06, -0.0277557373046875, 0.0050048828125, 0.0149383544921875, 0.01526641845703125, 0.0249786376953125, -0.0499267578125, -0.03173828125, 0.006389617919921875, 0.0027599334716796875, 0.04864501953125, -0.00786590576171875, 0.017303466796875, 0.01450347900390625, 0.01338958740234375, -0.0235137939453125, -0.004726409912109375, -0.005001068115234375, -0.0136566162109375, 0.0576171875, 0.0154876708984375, 0.025726318359375, 0.007366180419921875, -0.00870513916015625, -0.014007568359375, 0.021087646484375, 0.01548004150390625, -0.047210693359375, -0.009185791015625, 0.0181121826171875, -0.006107330322265625, 0.0118865966796875, -0.0699462890625, 0.0821533203125, -0.0306854248046875, -0.010009765625, 0.0026073455810546875, 0.00263214111328125, -0.1397705078125, -0.0458984375, -0.0041961669921875, 0.05096435546875, 0.000728607177734375, 0.007450103759765625, -0.0004494190216064453, -0.034576416015625, -0.0212554931640625, -0.01483154296875, -0.060394287109375, -0.06561279296875, -0.0435791015625, 0.0263671875, -0.0187835693359375, -0.01519012451171875, 0.013885498046875, 0.0228424072265625, 0.036041259765625, -0.025299072265625, -0.0182037353515625, -0.033233642578125, 0.061279296875, -0.05181884765625, 0.0153961181640625, -0.0006203651428222656, -0.036590576171875, -0.00922393798828125, -0.047607421875, -0.0247650146484375, 0.00665283203125, 0.010009765625, -0.005764007568359375, 0.0246734619140625, 0.0374755859375, 0.00882720947265625, 0.030975341796875, -0.0543212890625, -0.01007080078125, 0.0151519775390625, 0.0270538330078125, -0.01146697998046875, 0.0045318603515625, -0.0199127197265625, -0.003955841064453125, -0.0021076202392578125, -0.0222930908203125, 0.0235443115234375, -0.036712646484375, -0.00025653839111328125, 0.0112762451171875, 0.0012664794921875, 0.0042724609375, -0.0200958251953125, -0.007415771484375, -0.0430908203125, 0.0068817138671875, 0.048614501953125, -0.006755828857421875, -0.034576416015625, 0.004009246826171875, -0.0131378173828125, -0.00963592529296875, -0.043426513671875, -0.0179290771484375, -0.00556182861328125, 0.06573486328125, 0.0157470703125, 0.0008478164672851562, -0.0185394287109375, 0.005786895751953125, 0.015350341796875, -0.041961669921875, -0.020477294921875, -0.00026226043701171875, 0.06402587890625, -0.00811004638671875, -0.023040771484375, -0.038726806640625, -0.06524658203125, 0.047271728515625, -0.00438690185546875, 0.0200042724609375, 0.07257080078125, -0.00862884521484375, -0.0043487548828125, -0.00034427642822265625, 0.02410888671875, 0.042083740234375, 0.265380859375, -0.02716064453125, 0.02490234375, 0.005764007568359375, 0.03729248046875, -0.046661376953125, 0.0084381103515625, -0.02374267578125, 0.0269012451171875, -0.00528717041015625, -0.01311492919921875, 0.0208892822265625, 0.04351806640625, 0.0192718505859375, -0.007701873779296875, -0.027618408203125, -0.00794219970703125, 0.0498046875, 0.07080078125, -0.0019512176513671875, -0.0030574798583984375, 0.008514404296875, -0.038360595703125, 0.0004916191101074219, -0.04034423828125, -0.03387451171875, -0.01546478271484375, -0.004177093505859375, -0.024810791015625, 0.037353515625, -0.0221710205078125, -4.845857620239258e-05, 0.033721923828125, -0.025543212890625, -0.0210418701171875, -0.036590576171875, -0.012237548828125, 0.02911376953125, 0.037322998046875, -0.002231597900390625, -0.0199432373046875, -0.0435791015625, -0.01325225830078125, 0.0009603500366210938, 0.0292510986328125, -0.01021575927734375, 0.00036406517028808594, -0.006214141845703125, -0.037384033203125, -0.007480621337890625, -0.0360107421875, 0.01152801513671875, -0.020721435546875, 0.018524169921875, -0.00789642333984375, -0.047515869140625, -0.026611328125, -0.0271148681640625, -0.004009246826171875, 0.00015974044799804688, 0.06475830078125, -0.01528167724609375, -0.05029296875, 0.0252685546875, -0.029998779296875, 0.000988006591796875, 0.0286865234375, -0.042205810546875, -0.01458740234375, -0.0028095245361328125, -0.0007748603820800781, 0.0269012451171875, 0.0330810546875, 0.0247955322265625, 0.0157318115234375, -0.02264404296875, 0.030548095703125, 0.07183837890625, 0.01546478271484375, 0.00984954833984375, -0.0236663818359375, 0.000354766845703125, 0.0151214599609375, 0.01165771484375, 0.018707275390625, -0.031982421875, -0.0237274169921875, 0.0168914794921875, 0.008636474609375, -0.006809234619140625, -0.004962921142578125, 0.00803375244140625, 0.01514434814453125, -0.0009632110595703125, 0.04864501953125, -0.01146697998046875, 0.029815673828125, 0.0015125274658203125, -0.01605224609375, -0.0020503997802734375, 0.0289306640625, 0.025482177734375, 0.0191192626953125, -0.023223876953125, 0.032501220703125, -0.01114654541015625, -0.0213623046875, 0.0139617919921875, -0.0198822021484375, 0.0277862548828125, -0.0185394287109375, 0.01418304443359375, 0.0051727294921875, 0.035186767578125, 0.0305023193359375, -0.00589752197265625, 0.0097808837890625, 0.030364990234375, 0.06072998046875, 0.0223388671875, -0.0171966552734375, 0.00246429443359375, 0.02862548828125, -0.00989532470703125, 0.00664520263671875, -0.051910400390625, 0.0111083984375, -0.0338134765625, 0.0469970703125, 0.05316162109375, 0.01806640625, -0.0100555419921875, 0.042022705078125, -0.00177001953125, 0.0362548828125, -0.001285552978515625, -0.01056671142578125, 0.01068115234375, 0.04034423828125, 0.07318115234375, -0.00522613525390625, -0.0195465087890625, -0.03424072265625, -0.028289794921875, -0.0283203125, 0.042327880859375, -0.012420654296875, -0.00988006591796875, -0.01141357421875, 0.0037136077880859375, 0.0253448486328125, 0.0087432861328125, 0.0238494873046875, -0.034820556640625, 0.05804443359375, -0.01476287841796875, 0.0099029541015625, -0.012908935546875, 0.02252197265625, -0.007526397705078125, -0.029022216796875, 0.034515380859375, 0.052001953125, 0.113525390625, -0.01139068603515625, 0.055908203125, 0.036895751953125, 0.0139007568359375, 0.0084228515625, -0.01490020751953125, 0.0020885467529296875, -0.051116943359375, -0.0299224853515625, 0.01190948486328125, -0.01526641845703125, 0.005718231201171875, -0.038970947265625, 0.037994384765625, -0.01357269287109375, -0.0018968582153320312, 0.06719970703125, 0.00502777099609375, 0.0037136077880859375, -0.0364990234375, 0.0148162841796875, 0.03912353515625, 0.01885986328125, -0.0221405029296875, 0.007724761962890625, -0.036590576171875, 0.021820068359375, 0.001087188720703125, 0.00714111328125, -0.00940704345703125, 0.07342529296875, 0.02642822265625, 0.03765869140625, 0.02374267578125, 0.0164947509765625, 0.0267333984375, -0.02874755859375, 0.01470184326171875, 0.0271759033203125, -0.045745849609375, 0.00726318359375, -0.0166473388671875, 0.0011816024780273438, 0.018096923828125, -0.003902435302734375, -0.00098419189453125, 0.033721923828125, 0.067138671875, -0.01190948486328125, 0.0257110595703125, -0.0377197265625, -0.00518035888671875, -0.00601959228515625, -0.00738525390625, -0.00839996337890625, -0.037689208984375, 0.003192901611328125, -0.03326416015625, 0.0200958251953125, -0.052032470703125, 0.001041412353515625, -0.033355712890625, -0.01541900634765625, -0.0200347900390625, -0.0122222900390625, -0.02313232421875, 0.01474761962890625, -0.039093017578125, 0.005535125732421875, -0.005008697509765625, -0.01171112060546875, 0.02484130859375, -0.0217742919921875, 0.040130615234375, -0.0234222412109375, 0.0233917236328125, -0.033721923828125, -0.02740478515625, 0.01904296875, 0.0173797607421875, 0.035736083984375, 0.03350830078125, -0.00909423828125, -0.007415771484375, 0.054351806640625, 0.0660400390625, 0.051422119140625, -0.0201568603515625, -0.0345458984375, -0.004730224609375, 0.016937255859375, 0.018402099609375, 0.026397705078125, 0.00356292724609375, 0.02569580078125, -0.00862884521484375, -0.0177459716796875, -0.006023406982421875, 0.0001327991485595703, 0.01117706298828125, -0.0244598388671875, -0.04248046875, -0.00945281982421875, 0.0450439453125, -0.011566162109375, -0.01065826416015625, -0.0187835693359375, -0.00033020973205566406, -0.045684814453125, -0.02569580078125, 0.01326751708984375, -0.04034423828125, -0.0240478515625, 0.035064697265625, -0.00832366943359375, 0.048614501953125, 0.0160064697265625, -0.0162811279296875, 0.036712646484375, 0.027435302734375, 0.004314422607421875, 0.0024738311767578125, 0.03533935546875, 0.0251922607421875, 0.01210784912109375, -0.013671875, 0.040069580078125, -0.01210784912109375, -0.020355224609375, 0.020660400390625, -0.00940704345703125, -0.024078369140625, -0.037811279296875, 0.0175018310546875, -0.0011072158813476562, -0.00396728515625, -0.0153961181640625, 0.0174560546875, 0.020416259765625, -0.0198211669921875, 0.00569915771484375, 0.01568603515625, 0.00951385498046875, -0.033905029296875, -0.041900634765625, 0.0162353515625, -0.0400390625, -0.03369140625, 0.0214080810546875, 0.024078369140625, -0.00321197509765625, -0.0301513671875, 0.044097900390625, -0.01092529296875, -0.0245208740234375, 0.02215576171875, -0.00978851318359375, -0.00955963134765625, -0.0014581680297851562, 0.023101806640625, -0.033477783203125, 0.01346588134765625, -0.017822265625, -0.047637939453125, -0.04559326171875, 0.031280517578125, -0.022247314453125, 0.0031719207763671875, -0.03948974609375, -0.060821533203125, 0.0447998046875, -0.044677734375, 0.0232086181640625, 0.002338409423828125, 0.03265380859375, 0.00682830810546875, -0.035736083984375, -0.0223541259765625, 0.097412109375, 0.01441192626953125, 0.0261383056640625, -0.01397705078125, -0.028900146484375, 0.00537872314453125, 0.061859130859375, -0.00678253173828125, 0.007335662841796875, -0.00616455078125, 0.0093994140625, -0.0673828125, 0.0276641845703125, 0.01338958740234375, 0.00870513916015625, 0.02239990234375, -0.0166778564453125, -0.0081634521484375, -0.0207672119140625, 0.01486968994140625, -0.01224517822265625, 0.0181732177734375, -0.0014162063598632812, 0.0182037353515625, 0.00606536865234375, -0.0169525146484375, 0.039764404296875, -0.0017642974853515625, 0.049285888671875, 0.0239410400390625, -0.036102294921875, -0.005283355712890625, 0.0009794235229492188, 0.036346435546875, -0.02349853515625, -0.006420135498046875, 0.036224365234375, 0.0308837890625, -0.00695037841796875, -0.018951416015625, -0.054473876953125, -0.02423095703125, 0.01143646240234375, 0.01218414306640625, 0.017578125, 0.016143798828125, 0.0574951171875, -0.0245819091796875, 0.0006470680236816406, -0.01348876953125, -0.07916259765625, -0.025360107421875, -0.1278076171875, 0.0248870849609375, 0.018951416015625, -0.039154052734375, -0.036956787109375, 0.012359619140625, -0.035919189453125, 0.0155792236328125, 0.0228271484375, -0.041107177734375, -0.0207366943359375, -0.0230560302734375, 0.01160430908203125, -0.0167694091796875, 0.0218048095703125, 0.03753662109375, -0.034576416015625, -0.005870819091796875, 0.00738525390625, 0.05950927734375, -0.02874755859375, -0.01505279541015625, 0.01432037353515625, 0.0102691650390625, 0.054656982421875, -0.0288543701171875, 0.0063629150390625, 0.0301513671875, -0.028594970703125, -0.02252197265625, 0.01190185546875, 0.01715087890625, 0.0177764892578125, -0.01471710205078125, 0.013671875, 0.0135345458984375, 0.0008616447448730469, -0.01345062255859375, -0.040496826171875, 0.056854248046875, 0.00644683837890625, 0.007171630859375, -0.049835205078125, -0.005718231201171875, -0.02252197265625, 0.049072265625, -0.0232086181640625, -0.033416748046875, -0.058807373046875, -0.02398681640625, -0.0004405975341796875, 0.09942626953125, 0.01306915283203125, 0.01110076904296875, 0.0096435546875, -0.0072174072265625, 0.0180816650390625, 0.03271484375, -0.0377197265625, 0.05877685546875, -0.027435302734375, -0.021240234375, -0.044952392578125, -0.03564453125, -0.059783935546875, 0.0310516357421875, -0.06597900390625, 0.014190673828125, 0.01297760009765625, -0.00567626953125, 0.0004456043243408203, -0.04443359375, 0.00910186767578125, 0.00974273681640625, 0.0308685302734375, 1.3113021850585938e-05, -0.0037517547607421875, 0.004055023193359375, -0.033203125, -0.00553131103515625, -0.0008463859558105469, -0.03875732421875, -0.021575927734375, 0.004302978515625, 0.050750732421875, 0.0106353759765625, 0.0233917236328125, 0.0014657974243164062, -0.03021240234375, 0.0192108154296875, -0.08282470703125, -0.021331787109375, -0.0292205810546875, -0.025726318359375, -0.049224853515625, 0.045928955078125, -0.028106689453125, 0.0011835098266601562, -0.0104827880859375, -0.035125732421875, -0.034515380859375, 0.033843994140625, -0.01494598388671875, -0.040069580078125, -0.006298065185546875, -0.0209808349609375, 0.002685546875, -0.039794921875, 0.031524658203125, 0.003284454345703125, -0.01233673095703125, 0.0312347412109375, -0.056976318359375, -0.02813720703125, -0.05712890625, 0.0185699462890625, 0.01166534423828125, 0.04071044921875, -0.0394287109375, 0.03729248046875, 0.0095062255859375, 0.0169830322265625, -0.03375244140625, -0.021331787109375, 0.01129913330078125, -0.02978515625, 0.032562255859375, 0.0016241073608398438, 0.0198516845703125, 0.0163726806640625, 0.04949951171875, -0.052703857421875, -0.04315185546875, 0.022613525390625, 0.0623779296875, 0.0290374755859375, -0.0259857177734375, 0.01788330078125, 0.0102081298828125, -0.0577392578125, -0.039886474609375, 0.0165863037109375, 0.02789306640625, 0.0188446044921875, 0.00281524658203125, -0.01107025146484375, 0.0450439453125, 0.032318115234375, -0.013824462890625, -0.03271484375, -0.0016813278198242188, -0.007320404052734375, 0.0302581787109375, 0.006404876708984375, -0.01904296875, 0.0237274169921875, -0.0179595947265625, 0.00839996337890625, 0.0294952392578125, 0.045501708984375, -0.026885986328125, -0.0736083984375, -0.014739990234375, -0.02105712890625, -0.053192138671875, 0.017730712890625, -0.0031223297119140625, -0.0029811859130859375, -0.0249786376953125, -0.0234527587890625, -0.0232086181640625, 0.051116943359375, -0.025970458984375, 0.0023593902587890625, 0.0249786376953125, -0.03826904296875, 0.01898193359375, 0.046051025390625, 0.04693603515625, -0.012451171875, 0.0184478759765625, 0.016265869140625, 0.0295867919921875, -0.020111083984375, -0.044647216796875, -0.0251617431640625, -0.00797271728515625, 0.0513916015625, 0.016693115234375, -0.029052734375, -5.894899368286133e-05, -0.0015716552734375, 0.034881591796875, 0.01226806640625, 0.0684814453125, 0.0712890625, 0.0302581787109375, 0.02532958984375, -0.0248565673828125, 0.0435791015625, 0.00347137451171875, -0.03155517578125, 0.0181884765625, -0.0293121337890625, -0.09246826171875, 0.00933837890625, -0.013824462890625, 0.0092315673828125, -0.053466796875, 0.01202392578125, -0.01018524169921875, 0.009307861328125, 0.038055419921875, 0.041290283203125, -0.031402587890625, 0.01885986328125, 0.01200103759765625, 0.00395965576171875, 0.02215576171875, -0.0292816162109375, -0.01200103759765625, 0.01027679443359375, -0.0003616809844970703, -0.017425537109375, 0.02154541015625, -0.0157928466796875, 0.018798828125, 0.01165008544921875, 0.0188140869140625, 0.007476806640625, -0.01357269287109375, 0.005062103271484375, -0.007274627685546875, 0.0450439453125, 0.03350830078125, 0.040130615234375, 0.052032470703125, -0.0126800537109375, -0.01300811767578125, -0.02777099609375, 0.0011425018310546875, -0.01468658447265625, -0.0249786376953125, -0.04864501953125], "destRID": "#1:0"}]}Database dump :