- Notifications
You must be signed in to change notification settings - Fork206
Open
Description
Environment
Memgraph Version: 3.7.1
Operating System: window 11
Installation Method: Docker
API: Docker
Steps to Reproduce
- Create the graph database:
CREATE (n0 :L1:L5{k11:733479159,k33:'0',k10:-1990693768,k32:true,k7:'H',k35:'d',k8:'i',k12:584271354,k34:true,k9:true,k37:-921388054,k36:'Zz',k38:true,id:0});CREATE (n0 :L0{k0:1643856205,k1:544858216,k2:-407171297,k3:1394078235,k4:'t',k5:'D',id:1,k6:-295096914});CREATE (n0 :L2{k17:'yEG',k16:'i',id:2,k15:'Ec',k14:-54203318});CREATE (n0 :L3{k19:'d',k18:false,k20:false,k22:1457756488,id:3,k21:32474385,k24:'P3c'});CREATE (n0 :L1:L3{k20:false,k22:-229937006,k10:1542904315,k21:183211824,k7:'b',k24:'zIT0IpIV',k8:'H',k12:-1691450154,k23:false,k9:true,k19:'6',k18:true,id:4});CREATE (n0 :L5{k38:true,k33:'V',id:5,k32:false,k34:false,k37:148687334,k36:'F78Y'});CREATE (n0 :L0{k0:-686273364,k1:-765279958,k2:-355339862,k3:1367445918,k4:'txanC',k5:'K',id:6,k6:2146045159});CREATE (n0{id:7});CREATE (n0 :L5:L2{k17:'xJ',k38:false,k16:'o',k33:'E',id:8,k32:false,k13:'n',k34:false,k37:882356271,k15:'3b',k36:'N',k14:-1156937016});CREATE (n0 :L4:L3{k31:'s8CCOH',k20:true,k30:105068813,k22:-1509021065,k21:-1659855810,k24:'o',k23:true,k26:'8Achy0kW',k25:false,k28:false,k27:false,k19:'i4',k29:'7WPij',k18:false,id:9});CREATE (n0 :L3{k18:false,k20:false,k22:-992297153,id:10,k21:32474385,k24:'K',k23:true});CREATE (n0 :L6{k39:252307250,k40:true,k42:false,k41:1332898216,id:11,k43:false});CREATE (n0 :L1{k11:75364597,id:12,k8:'LttqFl5T',k12:-17017086,k9:false});CREATE (n0 :L2{k17:'T',k16:'v0',id:13,k13:'inTBlBFN6',k14:-735787139});CREATE (n0 :L4{k28:true,k27:true,k29:'O8j',k31:'V',k30:-2093310024,id:14,k26:'CZ1Y5o',k25:true});CREATE (n0{id:15});MATCH (n0{id:6}), (n1{id:11})MERGE(n0)-[r:T4{k71:'Y',k70:'w',k73:'UIB7O9TE',k72:-1940509062,k74:1669727327,id:16}]->(n1);MATCH (n0{id:11}), (n1{id:14})MERGE(n0)-[r:T3{k64:false,k63:'G',k66:false,id:17,k65:'uWe04',k68:478343347,k67:1346242705,k69:false}]->(n1);MATCH (n0{id:3}), (n1{id:6})MERGE(n0)-[r:T2{k60:false,k62:'2',id:18,k57:730129005,k59:true,k58:1007006578}]->(n1);MATCH (n0{id:3}), (n1{id:14})MERGE(n0)-[r:T4{k71:'K',k70:'GZ',k73:'cpcLtp',k72:-939238012,k74:411070405,id:19}]->(n1);MATCH (n0{id:3}), (n1{id:1})MERGE(n0)-[r:T4{k71:'VsIgLV0Qo',k70:'mnh',k73:'t',k72:1656222538,k74:-1618611655,id:20}]->(n1);MATCH (n0{id:10}), (n1{id:6})MERGE(n0)-[r:T3{k64:false,k63:'qnkqbq',k66:false,id:21,k68:-1453296892,k67:1346242705,k69:true}]->(n1);MATCH (n0{id:9}), (n1{id:5})MERGE(n0)-[r:T2{k62:'U',k61:true,id:22,k57:1833944522,k59:true,k58:-676152620}]->(n1);MATCH (n0{id:9}), (n1{id:10})MERGE(n0)-[r:T4{k71:'g',k70:'6',k73:'d',k72:1606771957,k74:1974710001,id:23}]->(n1);MATCH (n0{id:5}), (n1{id:10})MERGE(n0)-[r:T0{k49:1236341010,k50:-508099983,k44:-627729478,id:24,k45:false,k48:'qI',k47:'1'}]->(n1);MATCH (n0{id:4}), (n1{id:2})MERGE(n0)-[r:T2{k60:false,k62:'1',k61:false,id:25,k57:-1613783457,k59:false,k58:1862587390}]->(n1);MATCH (n0{id:14}), (n1{id:0})MERGE(n0)-[r:T3{k64:true,k63:'mhpVEm',k66:false,id:26,k65:'5BcNm7',k68:-1412808577,k67:-680776162,k69:true}]->(n1);MATCH (n0{id:0}), (n1{id:15})MERGE(n0)-[r:T4{k71:'Y',k70:'w',k73:'SlU',k72:1613856877,k74:-1069030028,id:27}]->(n1);MATCH (n0{id:7}), (n1{id:3})MERGE(n0)-[r:T4{k70:'9g',k73:'sVvcQx',k72:1656222538,k74:411070405,id:28}]->(n1);MATCH (n0{id:3}), (n1{id:2})MERGE(n0)-[r:T2{k60:false,k62:'0',k61:false,id:29,k57:-299180189,k59:true,k58:-1196651826}]->(n1);MATCH (n0{id:15}), (n1{id:4})MERGE(n0)-[r:T1{k51:false,k53:225377259,k52:true,id:30,k54:'OW',k56:'dzOv'}]->(n1);MATCH (n0{id:12}), (n1{id:15})MERGE(n0)-[r:T3{k64:false,k63:'v',k66:false,id:31,k65:'Lq19t',k68:-635539246,k67:-680776162,k69:false}]->(n1);MATCH (n0{id:10}), (n1{id:1})MERGE(n0)-[r:T4{k71:'g',k70:'GZ',k73:'xAZZAfW',k72:1606771957,k74:-512858594,id:32}]->(n1);MATCH (n0{id:12}), (n1{id:6})MERGE(n0)-[r:T2{k60:true,k62:'R',k61:true,id:33,k57:-1602938937,k59:false,k58:1742931223}]->(n1);MATCH (n0{id:10}), (n1{id:6})MERGE(n0)-[r:T1{k51:true,k53:-253214238,k52:false,k55:'QumeLL5',id:34,k54:'5TD',k56:'fa'}]->(n1);MATCH (n0{id:6}), (n1{id:12})MERGE(n0)-[r:T0{k49:517676661,k50:-1187247370,k44:-2128309550,id:35,k46:'u',k45:true,k48:'qI',k47:'WAM3qms'}]->(n1);MATCH (n0{id:0}), (n1{id:14})MERGE(n0)-[r:T3{k64:false,k63:'bPJlbm',id:36,k65:'vWuEM',k68:-1698049694,k67:824525511,k69:false}]->(n1);MATCH (n0{id:3}), (n1{id:15})MERGE(n0)-[r:T2{k60:true,k62:'g',k61:true,id:37,k57:-165983676,k59:true,k58:-1277933065}]->(n1);MATCH (n0{id:2}), (n1{id:3})MERGE(n0)-[r:T1{k53:-1278972793,k52:false,k55:'n18Zm',id:38,k54:'nzZW0M9h',k56:'2Yxb'}]->(n1);MATCH (n0{id:14}), (n1{id:12})MERGE(n0)-[r:T3{k64:false,k63:'i',k66:false,id:39,k65:'rZDW8',k68:-1013282732,k67:1346242705,k69:true}]->(n1);MATCH (n0{id:0}), (n1{id:3})MERGE(n0)-[r:T2{k60:true,k62:'tc',id:40,k57:654290036,k59:true,k58:746059162}]->(n1);MATCH (n0{id:12}), (n1{id:3})MERGE(n0)-[r:T0{k49:218850170,k50:1549160672,k44:1772607245,id:41,k46:'qvd',k45:true,k48:'d9',k47:'1'}]->(n1);MATCH (n0{id:6}), (n1{id:8})MERGE(n0)-[r:T1{k51:true,k53:-606104599,k52:true,k55:'PD',id:42,k54:'g'}]->(n1);MATCH (n0{id:0}), (n1{id:11})MERGE(n0)-[r:T2{k60:true,k62:'R',k61:true,id:43,k57:-953101578,k59:true,k58:746059162}]->(n1);MATCH (n0{id:4}), (n1{id:3})MERGE(n0)-[r:T2{k60:false,k62:'7',k61:true,id:44,k57:-1861107496,k59:false,k58:1007006578}]->(n1);MATCH (n0{id:14}), (n1{id:9})MERGE(n0)-[r:T2{k60:true,k62:'RO',k61:true,id:45,k57:-299180189,k59:true,k58:-1887540123}]->(n1);MATCH (n0{id:12}), (n1{id:12})MERGE(n0)-[r:T4{k71:'3',k70:'i',k73:'sVvcQx',k72:-939238012,k74:-1657330068,id:46}]->(n1);
- Execute the following three equivalent queries:
MATCH (n0)<-[]-(n1 :L3)-[]->(n2), (n5)-[r6:T4]->(n8 :L0)<-[r7:T4]-(n9 :L3)OPTIONALMATCH (n6 :L1)-[*..2]->(n2), (n1)<-[r8:T1]-(n10 :L2)RETURNcount(*)--result:132MATCH (n0)<-[]-(n1 :L3)-[]->(n2),(n5)-[r6:T4*1..1]->(n8:L0)<-[r7:T4*1..1]-(n9:L3)WHERESIZE(r6)=1ANDSIZE(r7)=1WITHr6[0]ASr6,r7[0]ASr7,n0,n1,n2,n5,n8,n9OPTIONALMATCH (n6 :L1)-[*..2]->(n2),(n1)<-[r8:T1]-(n10 :L2)RETURNcount(*)--result:204MATCH (n0)<-[]-(n1 :L3)-[]->(n2),p= (n5)-[r:T4*2..2]-(n9:L3)WHEREALL(xin ['L0']WHERExinlabels(nodes(p)[1]))WITHr[0]ASr6,r[0]ASr7,n0,n1,n2,n5,nodes(p)[1]asn8,n9OPTIONALMATCH (n6 :L1)-[*..2]->(n2),(n1)<-[r8:T1]-(n10 :L2)RETURNcount(*)--result:132
Expected Result
The first query returns 132, the second returns 204, and the last returns 132. In Neo4j, all queries return 132.