Filter is not pushed down in some case

[jievince]

Introduction

Contents

Related work

query 1

profile match (v:player)-[e:follow]-(mh:player) where id(v)=="player100" with mh as mh match (mh:player)-[e:follow]-() with e as e,mh as mh where none_direct_dst(e) in ["player102","player103"] return none_direct_dst(e), mh.player.name

query2

profile match (v:player)-[e:follow]-(mh:player) where id(v)=="player100" with mh as mh match (mh:player)-[e:follow]-(c) with e as e,mh as mh where none_direct_dst(e) in ["player102","player103"] return none_direct_dst(e), mh.player.name

Query2 add a variable c to the node pattern, compared to query1. In this case, filter is not pushed down.

[jievince]

The reason is the ruleEliminateAppendVerticesRule is applied first, and then the rule PushFilterDownTraverseRule could not be matched.