{"action":"created","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4538","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4538/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4538/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4538/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4538","id":94015908,"number":4538,"title":"named parameters not working in let block","user":{"login":"mudigal","id":4555676,"avatar_url":"https://avatars.githubusercontent.com/u/4555676?v=3","gravatar_id":"","url":"https://api.github.com/users/mudigal","html_url":"https://github.com/mudigal","followers_url":"https://api.github.com/users/mudigal/followers","following_url":"https://api.github.com/users/mudigal/following{/other_user}","gists_url":"https://api.github.com/users/mudigal/gists{/gist_id}","starred_url":"https://api.github.com/users/mudigal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mudigal/subscriptions","organizations_url":"https://api.github.com/users/mudigal/orgs","repos_url":"https://api.github.com/users/mudigal/repos","events_url":"https://api.github.com/users/mudigal/events{/privacy}","received_events_url":"https://api.github.com/users/mudigal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-07-09T10:54:32Z","updated_at":"2015-07-09T13:59:33Z","closed_at":null,"body":"A Query like \r\n\r\n'SELECT FROM ABC \r\nLET $x = (SELECT FROM XYZ WHERE x = :named)\r\nWHERE y.contains($x)'\r\n\r\nhere where in pass the map of named parameters i do not get any results, where in I should be getting some.\r\n\r\nWhile debugging found out that OCommandExecutorSQLResultsetAbstract::assignLetClauses() makes a call to query method without passing the parameters.\r\n\r\nLINE details here:\r\nvarValue = ODatabaseRecordThreadLocal.INSTANCE.get().query(subQuery);\r\n\r\nwhile it should have been \r\nvarValue = ODatabaseRecordThreadLocal.INSTANCE.get().query(subQuery, getParameters());"},"comment":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/comments/119986305","html_url":"https://github.com/orientechnologies/orientdb/issues/4538#issuecomment-119986305","issue_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4538","id":119986305,"user":{"login":"nagarajasr","id":7237012,"avatar_url":"https://avatars.githubusercontent.com/u/7237012?v=3","gravatar_id":"","url":"https://api.github.com/users/nagarajasr","html_url":"https://github.com/nagarajasr","followers_url":"https://api.github.com/users/nagarajasr/followers","following_url":"https://api.github.com/users/nagarajasr/following{/other_user}","gists_url":"https://api.github.com/users/nagarajasr/gists{/gist_id}","starred_url":"https://api.github.com/users/nagarajasr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nagarajasr/subscriptions","organizations_url":"https://api.github.com/users/nagarajasr/orgs","repos_url":"https://api.github.com/users/nagarajasr/repos","events_url":"https://api.github.com/users/nagarajasr/events{/privacy}","received_events_url":"https://api.github.com/users/nagarajasr/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T13:59:33Z","updated_at":"2015-07-09T13:59:33Z","body":"Which version of OrientDB ?\r\nIf you are using any of the 2.1-rc's, try changing the \"=\" to \"in\" as follows:\r\n\r\n```sql\r\nSELECT FROM ABC \r\nLET $x in (SELECT FROM XYZ WHERE x = :named)\r\nWHERE y.contains($x)\r\n```\r\n\r\nsee this issue #4530 "}}