{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/3994","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/3994/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/3994/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/3994/events","html_url":"https://github.com/neo4j/neo4j/issues/3994","id":57375580,"number":3994,"title":"Regression in WITH collection AS x, neo4j community 2.2.0-M03","user":{"login":"redsk","id":4172433,"avatar_url":"https://avatars.githubusercontent.com/u/4172433?v=3","gravatar_id":"","url":"https://api.github.com/users/redsk","html_url":"https://github.com/redsk","followers_url":"https://api.github.com/users/redsk/followers","following_url":"https://api.github.com/users/redsk/following{/other_user}","gists_url":"https://api.github.com/users/redsk/gists{/gist_id}","starred_url":"https://api.github.com/users/redsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/redsk/subscriptions","organizations_url":"https://api.github.com/users/redsk/orgs","repos_url":"https://api.github.com/users/redsk/repos","events_url":"https://api.github.com/users/redsk/events{/privacy}","received_events_url":"https://api.github.com/users/redsk/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-11T20:53:36Z","updated_at":"2015-12-06T19:04:31Z","closed_at":"2015-12-06T19:04:31Z","body":"Hi, there seems to be a regression in neo4j community 2.2.0-M03 from 2.2.0-M02.\r\nAfter loading the standard Movies Graph in version 2.2.0-M03 and issuing the following query from the browser:\r\n\r\nWITH [0, 154] AS x\r\nMATCH (n) WHERE ID(n) IN x\r\nMATCH (m) WHERE ID(m) IN x\r\nMATCH paths = allShortestPaths((n)-[*..3]-(m))\r\nRETURN paths\r\n\r\nI get the following error:\r\nNeo.DatabaseError.Statement.ExecutionFailure\r\n\r\nFailed to create a plan for the given QueryGraph QueryGraph(Set(),Set(IdName(n), IdName(m)),Set(IdName(x)),Selections(Set(Predicate(Set(IdName(m), IdName(x)),In(FunctionInvocation(FunctionName(ID),false,Vector(Identifier(m))),Identifier(x))), Predicate(Set(IdName(n), IdName(x)),In(FunctionInvocation(FunctionName(ID),false,Vector(Identifier(n))),Identifier(x))))),List(),Set(),Set(ShortestPathPattern(Some(IdName(paths)),PatternRelationship(IdName(  UNNAMED108),(IdName(n),IdName(m)),BOTH,List(),VarPatternLength(1,Some(3))),false)))\r\n\r\nConversely, if I issue:\r\n\r\nMATCH (n) WHERE ID(n) IN [0, 154]\r\nMATCH (m) WHERE ID(m) IN [0, 154]\r\nMATCH paths = allShortestPaths((n)-[*..3]-(m))\r\nRETURN paths\r\n\r\nit works correctly. Moreover, both queries work as expected with version 2.2.0-M02.\r\n"},"comment":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/comments/162337273","html_url":"https://github.com/neo4j/neo4j/issues/3994#issuecomment-162337273","issue_url":"https://api.github.com/repos/neo4j/neo4j/issues/3994","id":162337273,"user":{"login":"jakewins","id":182752,"avatar_url":"https://avatars.githubusercontent.com/u/182752?v=3","gravatar_id":"","url":"https://api.github.com/users/jakewins","html_url":"https://github.com/jakewins","followers_url":"https://api.github.com/users/jakewins/followers","following_url":"https://api.github.com/users/jakewins/following{/other_user}","gists_url":"https://api.github.com/users/jakewins/gists{/gist_id}","starred_url":"https://api.github.com/users/jakewins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jakewins/subscriptions","organizations_url":"https://api.github.com/users/jakewins/orgs","repos_url":"https://api.github.com/users/jakewins/repos","events_url":"https://api.github.com/users/jakewins/events{/privacy}","received_events_url":"https://api.github.com/users/jakewins/received_events","type":"User","site_admin":false},"created_at":"2015-12-06T19:04:31Z","updated_at":"2015-12-06T19:04:31Z","body":"Verified that this has been resolved: http://console.neo4j.org/r/ur7j3u"}}