谓词函数all使用提问

问答 问题
,
1

版本：nebula 3.2.1

执行如下语句报错：
match (HZP_NEO4J_OLD_1:xjTest), path_1=(HZP_NEO4J_OLD_1:xjTest)-[:xjTestRelation*0…3]->(HZP_NEO4J_OLD_101:xjTest) where 1==1 and all(idx in range(0,length(nodes(path_1))-1,1) where “xjTest” in labels(nodes(path_1)[idx])) return HZP_NEO4J_OLD_1 SKIP 0 LIMIT 10

报错信息：[ERROR (-1005)]: Wrong type result, the type should be NULL, EMPTY, BOOL

image
image1475×108 8.28 KB

2

试下能否执行explain, 如果可以的执行的话， 把explain结果也贴一下

4

digraph exec_plan {
rankdir=BT;
“Project_18”[label=“{Project_18|outputVar: {"colNames":["HZP_NEO4J_OLD_1"],"type":"DATASET","name":"__Limit_13"}|inputVar: __Limit_17}”, shape=Mrecord];
“Limit_17”->“Project_18”;
“Limit_17”[label=“{Limit_17|outputVar: {"colNames":["HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_101","path_1"],"type":"DATASET","name":"__Limit_17"}|inputVar: __Filter_11}”, shape=Mrecord];
“Filter_11”->“Limit_17”;
“Filter_11”[label=“{Filter_11|outputVar: {"colNames":["HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_101","path_1"],"type":"DATASET","name":"__Filter_11"}|inputVar: __BiInnerJoin_10}”, shape=Mrecord];
“BiInnerJoin_10”->“Filter_11”;
“BiInnerJoin_10”[label=“{BiInnerJoin_10|outputVar: {"colNames":["HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_101","path_1"],"type":"DATASET","name":"__BiInnerJoin_10"}|inputVar: {"rightVar":"__Project_9","leftVar":"__Project_4"}}”, shape=Mrecord];
“Project_4”->“BiInnerJoin_10”;
“Project_9”->“BiInnerJoin_10”;
“Project_4”[label=“{Project_4|outputVar: {"colNames":["HZP_NEO4J_OLD_1"],"type":"DATASET","name":"__Project_4"}|inputVar: __AppendVertices_3}”, shape=Mrecord];
“AppendVertices_14”->“Project_4”;
“AppendVertices_14”[label=“{AppendVertices_14|outputVar: {"colNames":["HZP_NEO4J_OLD_1"],"type":"DATASET","name":"__AppendVertices_3"}|inputVar: __IndexScan_1}”, shape=Mrecord];
“IndexScan_1”->“AppendVertices_14”;
“IndexScan_1”[label=“{IndexScan_1|outputVar: {"colNames":["_vid"],"type":"DATASET","name":"__IndexScan_1"}|inputVar: }”, shape=Mrecord];
“Start_2”->“IndexScan_1”;
“Start_2”[label=“{Start_2|outputVar: {"colNames":[],"type":"DATASET","name":"__Start_2"}|inputVar: }”, shape=Mrecord];
“Project_9”[label=“{Project_9|outputVar: {"colNames":["HZP_NEO4J_OLD_1","HZP_NEO4J_OLD_101","path_1"],"type":"DATASET","name":"__Project_9"}|inputVar: __AppendVertices_8}”, shape=Mrecord];
“AppendVertices_16”->“Project_9”;
“AppendVertices_16”[label=“{AppendVertices_16|outputVar: {"colNames":["HZP_NEO4J_OLD_1","__VAR_1","HZP_NEO4J_OLD_101"],"type":"DATASET","name":"__AppendVertices_8"}|inputVar: __Traverse_7}”, shape=Mrecord];
“Traverse_15”->“AppendVertices_16”;
“Traverse_15”[label=“{Traverse_15|outputVar: {"colNames":["HZP_NEO4J_OLD_1","__VAR_1"],"type":"DATASET","name":"__Traverse_7"}|inputVar: __Argument_5}”, shape=Mrecord];
“Argument_5”->“Traverse_15”;
“Argument_5”[label=“{Argument_5|outputVar: {"colNames":["HZP_NEO4J_OLD_1"],"type":"DATASET","name":"__Argument_5"}|inputVar: __AppendVertices_3}”, shape=Mrecord];
“Start_6”[label=“{Start_6|outputVar: {"colNames":[],"type":"DATASET","name":"__Start_6"}|inputVar: }”, shape=Mrecord];
}

5

row格式太长了，不太好传，dot格式麻烦看一下是否有问题

6

可以放在单独文件里拖进来传附件

7

哦哦，找到问题了，原来list的长度是用size，而不是length :smiling_face_with_tear:

2 个赞
8

此话题已在最后回复的 7 天后被自动关闭。不再允许新回复。