{"action":"opened","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4776","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4776/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4776/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/4776/events","html_url":"https://github.com/orientechnologies/orientdb/issues/4776","id":100453070,"number":4776,"title":"UPDATE with Named Parameter set to a list containing booleans results in _NOT_PARSED_","user":{"login":"mmacfadden","id":1812291,"avatar_url":"https://avatars.githubusercontent.com/u/1812291?v=3","gravatar_id":"","url":"https://api.github.com/users/mmacfadden","html_url":"https://github.com/mmacfadden","followers_url":"https://api.github.com/users/mmacfadden/followers","following_url":"https://api.github.com/users/mmacfadden/following{/other_user}","gists_url":"https://api.github.com/users/mmacfadden/gists{/gist_id}","starred_url":"https://api.github.com/users/mmacfadden/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mmacfadden/subscriptions","organizations_url":"https://api.github.com/users/mmacfadden/orgs","repos_url":"https://api.github.com/users/mmacfadden/repos","events_url":"https://api.github.com/users/mmacfadden/events{/privacy}","received_events_url":"https://api.github.com/users/mmacfadden/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-08-12T02:41:49Z","updated_at":"2015-08-12T02:41:49Z","closed_at":null,"body":"There is a an issue with SQL named parameters in 2.1, when the value of the named parameter is a list containing booleans.\r\n\r\nWe start out with a doc that looks like this:\r\n```javascript\r\n{\r\n    \"@type\":\"d\",\r\n    \"@rid\":\"#9:0\",\r\n    \"@version\":1,\r\n    \"@class\":\"test\",\r\n    \"id\":1,\r\n    \"boolean\":false,\r\n    \"integerList\":[],\r\n    \"booleanList\":[]\r\n}\r\n```\r\n\r\nWe then use this updated statement:\r\n\r\n```sql\r\nUPDATE test SET boolean = :boolean, booleanList = :booleanList, integerList = :integerList WHERE id = 1\r\n```\r\nThen execute that with the following named parameters:\r\n\r\n:boolean = true\r\n:booleanList = [true]\r\n:integerList = [1]\r\n\r\nThis results in the following document:\r\n\r\n```javascript\r\n{\r\n    \"@type\":\"d\",\r\n    \"@rid\":\"#9:0\",\r\n    \"@version\":2,\r\n    \"@class\":\"test\",\r\n    \"id\":1,\r\n    \"boolean\":true,\r\n    \"integerList\":[1],\r\n    \"booleanList\":[\"_NOT_PARSED_\"]\r\n}\r\n\r\nInterestingly, setting the named parameters to a boolean works.  Setting a named parameter to a list of integers works.  Setting the named parameter to a list of booleans results in \"_NOT_PARSED_\".\r\n\r\nI have created a gist that reproduces the issue: \r\n\r\nhttps://gist.github.com/mmacfadden/cd4f432af79a5626dd94"}}