{"action":"closed","issue":{"url":"https://api.github.com/repos/src-d/go-mysql-server/issues/40","repository_url":"https://api.github.com/repos/src-d/go-mysql-server","labels_url":"https://api.github.com/repos/src-d/go-mysql-server/issues/40/labels{/name}","comments_url":"https://api.github.com/repos/src-d/go-mysql-server/issues/40/comments","events_url":"https://api.github.com/repos/src-d/go-mysql-server/issues/40/events","html_url":"https://github.com/src-d/go-mysql-server/issues/40","id":300182073,"number":40,"title":"Unsupported syntax: &sqlparser.AndExpr{Left:(*sqlparser.AndExpr)(0xc42899c480), Right:(*sqlparser.ComparisonExpr)(0xc4289c4340)}","user":{"login":"ajnavarro","id":1196465,"avatar_url":"https://avatars3.githubusercontent.com/u/1196465?v=4","gravatar_id":"","url":"https://api.github.com/users/ajnavarro","html_url":"https://github.com/ajnavarro","followers_url":"https://api.github.com/users/ajnavarro/followers","following_url":"https://api.github.com/users/ajnavarro/following{/other_user}","gists_url":"https://api.github.com/users/ajnavarro/gists{/gist_id}","starred_url":"https://api.github.com/users/ajnavarro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajnavarro/subscriptions","organizations_url":"https://api.github.com/users/ajnavarro/orgs","repos_url":"https://api.github.com/users/ajnavarro/repos","events_url":"https://api.github.com/users/ajnavarro/events{/privacy}","received_events_url":"https://api.github.com/users/ajnavarro/received_events","type":"User","site_admin":false},"labels":[{"id":835651612,"url":"https://api.github.com/repos/src-d/go-mysql-server/labels/bug","name":"bug","color":"d73a4a","default":true}],"state":"closed","locked":false,"assignee":{"login":"erizocosmico","id":1312023,"avatar_url":"https://avatars1.githubusercontent.com/u/1312023?v=4","gravatar_id":"","url":"https://api.github.com/users/erizocosmico","html_url":"https://github.com/erizocosmico","followers_url":"https://api.github.com/users/erizocosmico/followers","following_url":"https://api.github.com/users/erizocosmico/following{/other_user}","gists_url":"https://api.github.com/users/erizocosmico/gists{/gist_id}","starred_url":"https://api.github.com/users/erizocosmico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erizocosmico/subscriptions","organizations_url":"https://api.github.com/users/erizocosmico/orgs","repos_url":"https://api.github.com/users/erizocosmico/repos","events_url":"https://api.github.com/users/erizocosmico/events{/privacy}","received_events_url":"https://api.github.com/users/erizocosmico/received_events","type":"User","site_admin":false},"assignees":[{"login":"erizocosmico","id":1312023,"avatar_url":"https://avatars1.githubusercontent.com/u/1312023?v=4","gravatar_id":"","url":"https://api.github.com/users/erizocosmico","html_url":"https://github.com/erizocosmico","followers_url":"https://api.github.com/users/erizocosmico/followers","following_url":"https://api.github.com/users/erizocosmico/following{/other_user}","gists_url":"https://api.github.com/users/erizocosmico/gists{/gist_id}","starred_url":"https://api.github.com/users/erizocosmico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erizocosmico/subscriptions","organizations_url":"https://api.github.com/users/erizocosmico/orgs","repos_url":"https://api.github.com/users/erizocosmico/repos","events_url":"https://api.github.com/users/erizocosmico/events{/privacy}","received_events_url":"https://api.github.com/users/erizocosmico/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-02-26T10:23:09Z","updated_at":"2018-02-26T15:06:03Z","closed_at":"2018-02-26T15:06:03Z","author_association":"MEMBER","body":"That unsupported syntax should be supported. Failing query:\r\n```\r\nselect \r\n\tsum(l_extendedprice) / 7.0 as avg_yearly \r\nfrom \r\n\tLINEITEM, \r\n\tPART \r\nwhere \r\n\tp_partkey = l_partkey and \r\n\tp_brand = 'Brand#44' and \r\n\tp_container = 'WRAP PKG' and \r\n\tl_quantity < (\r\n\t\t\t\t\tselect \r\n\t\t\t\t\t\t0.2 * avg(l_quantity) \r\n\t\t\t\t\tfrom \r\n\t\t\t\t\t\tLINEITEM \r\n\t\t\t\t\twhere \r\n\t\t\t\t\t\tl_partkey = p_partkey\r\n\t\t\t\t);\r\n```"}}
{"actor":{"display_login":"erizocosmico"}}