{"action":"created","issue":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/10909","repository_url":"https://api.github.com/repos/neo4j/neo4j","labels_url":"https://api.github.com/repos/neo4j/neo4j/issues/10909/labels{/name}","comments_url":"https://api.github.com/repos/neo4j/neo4j/issues/10909/comments","events_url":"https://api.github.com/repos/neo4j/neo4j/issues/10909/events","html_url":"https://github.com/neo4j/neo4j/issues/10909","id":292190914,"number":10909,"title":"Working Cypher Query in 3.2.3 broken in 3.3.2","user":{"login":"billscheidel","id":23562672,"avatar_url":"https://avatars3.githubusercontent.com/u/23562672?v=4","gravatar_id":"","url":"https://api.github.com/users/billscheidel","html_url":"https://github.com/billscheidel","followers_url":"https://api.github.com/users/billscheidel/followers","following_url":"https://api.github.com/users/billscheidel/following{/other_user}","gists_url":"https://api.github.com/users/billscheidel/gists{/gist_id}","starred_url":"https://api.github.com/users/billscheidel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/billscheidel/subscriptions","organizations_url":"https://api.github.com/users/billscheidel/orgs","repos_url":"https://api.github.com/users/billscheidel/repos","events_url":"https://api.github.com/users/billscheidel/events{/privacy}","received_events_url":"https://api.github.com/users/billscheidel/received_events","type":"User","site_admin":false},"labels":[{"id":556879276,"url":"https://api.github.com/repos/neo4j/neo4j/labels/3.3","name":"3.3","color":"FF7256","default":false},{"id":19053963,"url":"https://api.github.com/repos/neo4j/neo4j/labels/bug","name":"bug","color":"fc2929","default":true},{"id":647067906,"url":"https://api.github.com/repos/neo4j/neo4j/labels/team-cypher","name":"team-cypher","color":"cccccc","default":false}],"state":"closed","locked":false,"assignee":{"login":"Lojjs","id":7222590,"avatar_url":"https://avatars1.githubusercontent.com/u/7222590?v=4","gravatar_id":"","url":"https://api.github.com/users/Lojjs","html_url":"https://github.com/Lojjs","followers_url":"https://api.github.com/users/Lojjs/followers","following_url":"https://api.github.com/users/Lojjs/following{/other_user}","gists_url":"https://api.github.com/users/Lojjs/gists{/gist_id}","starred_url":"https://api.github.com/users/Lojjs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Lojjs/subscriptions","organizations_url":"https://api.github.com/users/Lojjs/orgs","repos_url":"https://api.github.com/users/Lojjs/repos","events_url":"https://api.github.com/users/Lojjs/events{/privacy}","received_events_url":"https://api.github.com/users/Lojjs/received_events","type":"User","site_admin":false},"assignees":[{"login":"Lojjs","id":7222590,"avatar_url":"https://avatars1.githubusercontent.com/u/7222590?v=4","gravatar_id":"","url":"https://api.github.com/users/Lojjs","html_url":"https://github.com/Lojjs","followers_url":"https://api.github.com/users/Lojjs/followers","following_url":"https://api.github.com/users/Lojjs/following{/other_user}","gists_url":"https://api.github.com/users/Lojjs/gists{/gist_id}","starred_url":"https://api.github.com/users/Lojjs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Lojjs/subscriptions","organizations_url":"https://api.github.com/users/Lojjs/orgs","repos_url":"https://api.github.com/users/Lojjs/repos","events_url":"https://api.github.com/users/Lojjs/events{/privacy}","received_events_url":"https://api.github.com/users/Lojjs/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-01-28T09:25:19Z","updated_at":"2018-02-09T10:47:53Z","closed_at":"2018-02-09T10:47:53Z","author_association":"NONE","body":"I recently started testing against 3.3.2 and found a query that is now failing.  \r\n\r\nThe following query produces 1 result in 3.2.3 but 0 results in 3.3.2.  Basically I'm looking for a set of nodes with a particular set of labels.\r\n\r\n### Steps to reproduce\r\n\r\n- Neo4j version: 3.3.2\r\n- Operating system: Ubuntu 16.04\r\n- API/Driver: Browser using Bolt\r\n\r\n```\r\nCREATE (:Foo { id: 1 });\r\nCREATE (:Bar { id: 1 });\r\n\r\nMATCH (n { id: 1 }) WHERE LABELS(n) IN ['Foo', 'Baz'] RETURN n;\r\n```\r\n\r\n### Expected behavior\r\n\r\n1 result returned:  (:Foo)\r\n\r\n### Actual behavior\r\n\r\n0 results"},"comment":{"url":"https://api.github.com/repos/neo4j/neo4j/issues/comments/364400600","html_url":"https://github.com/neo4j/neo4j/issues/10909#issuecomment-364400600","issue_url":"https://api.github.com/repos/neo4j/neo4j/issues/10909","id":364400600,"user":{"login":"pontusmelke","id":88000,"avatar_url":"https://avatars3.githubusercontent.com/u/88000?v=4","gravatar_id":"","url":"https://api.github.com/users/pontusmelke","html_url":"https://github.com/pontusmelke","followers_url":"https://api.github.com/users/pontusmelke/followers","following_url":"https://api.github.com/users/pontusmelke/following{/other_user}","gists_url":"https://api.github.com/users/pontusmelke/gists{/gist_id}","starred_url":"https://api.github.com/users/pontusmelke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pontusmelke/subscriptions","organizations_url":"https://api.github.com/users/pontusmelke/orgs","repos_url":"https://api.github.com/users/pontusmelke/repos","events_url":"https://api.github.com/users/pontusmelke/events{/privacy}","received_events_url":"https://api.github.com/users/pontusmelke/received_events","type":"User","site_admin":false},"created_at":"2018-02-09T10:47:53Z","updated_at":"2018-02-09T10:47:53Z","author_association":"CONTRIBUTOR","body":"Hi @billscheidel \r\nYou are right that it works in 3.2.3, however it shouldn't have sorry about that 😞 \r\n\r\nIt has been fixed in later versions of 3.2.\r\n\r\n`LABELS(n)` returns a list so you are basically checking if a list is contained in another list which should evaluate to `false` in this case but unfortunately didn't work as intended in 3.2.3.\r\n\r\nThe canonical way of doing this is by using\r\n\r\n```\r\nMATCH (n { id: 1 }) WHERE n:Foo OR n:Baz RETURN n;\r\n```\r\n\r\nSorry for the inconvenience and thanks for reporting!\r\nRegards\r\nPontus\r\n "}}
{"actor":{"display_login":"pontusmelke"}}