{"action":"created","issue":{"url":"https://api.github.com/repos/prestodb/presto/issues/11900","repository_url":"https://api.github.com/repos/prestodb/presto","labels_url":"https://api.github.com/repos/prestodb/presto/issues/11900/labels{/name}","comments_url":"https://api.github.com/repos/prestodb/presto/issues/11900/comments","events_url":"https://api.github.com/repos/prestodb/presto/issues/11900/events","html_url":"https://github.com/prestodb/presto/issues/11900","id":379899740,"node_id":"MDU6SXNzdWUzNzk4OTk3NDA=","number":11900,"title":"Unsupported RowExpression type LambdaDefinitionExpression","user":{"login":"ggreg","id":190738,"node_id":"MDQ6VXNlcjE5MDczOA==","avatar_url":"https://avatars3.githubusercontent.com/u/190738?v=4","gravatar_id":"","url":"https://api.github.com/users/ggreg","html_url":"https://github.com/ggreg","followers_url":"https://api.github.com/users/ggreg/followers","following_url":"https://api.github.com/users/ggreg/following{/other_user}","gists_url":"https://api.github.com/users/ggreg/gists{/gist_id}","starred_url":"https://api.github.com/users/ggreg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ggreg/subscriptions","organizations_url":"https://api.github.com/users/ggreg/orgs","repos_url":"https://api.github.com/users/ggreg/repos","events_url":"https://api.github.com/users/ggreg/events{/privacy}","received_events_url":"https://api.github.com/users/ggreg/received_events","type":"User","site_admin":false},"labels":[{"id":11191945,"node_id":"MDU6TGFiZWwxMTE5MTk0NQ==","url":"https://api.github.com/repos/prestodb/presto/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-12T18:26:52Z","updated_at":"2018-11-12T20:11:24Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Reproducible query:\r\n\r\n```\r\nWITH t AS (\r\n  SELECT * FROM (VALUES (1, 2, 'c', 'd', '2018-11-01')) AS t (a, b, c, d, ds)\r\n)\r\nSELECT label\r\nFROM (\r\n  SELECT IF (p <= q, '1', '0') AS label\r\n  FROM (\r\n      SELECT\r\n        reduce(               \r\n          array_agg(a),\r\n          CAST(Row(0.0, 0.0) AS ROW(field0 DOUBLE, field1 DOUBLE)),\r\n          (s, x) -> CAST(ROW(s.field0, s.field1) AS ROW(field0 DOUBLE, field1 DOUBLE)),\r\n          s -> s.field0 + s.field1\r\n        ) as p,\r\n        reduce(               \r\n          array_agg(a),             \r\n          CAST(Row(0.0, 0.0) AS ROW(field0 DOUBLE, field1 DOUBLE)),\r\n          (s, x) -> CAST(ROW(s.field0, s.field1) AS ROW(field0 DOUBLE, field1 DOUBLE)),\r\n          s -> s.field0 + s.field1\r\n        ) as q\r\n      FROM t\r\n      WHERE ds = '2018-11-01' AND d = 'test' GROUP BY c\r\n   )\r\nWHERE p >= 0.75 AND q >= 0.75)\r\n```\r\n\r\nThe query above works if i remove `WHERE p >= 0.75 AND q >= 0.75`.\r\n\r\nI found commit ??? by bisecting from 0.213."},"comment":{"url":"https://api.github.com/repos/prestodb/presto/issues/comments/438013042","html_url":"https://github.com/prestodb/presto/issues/11900#issuecomment-438013042","issue_url":"https://api.github.com/repos/prestodb/presto/issues/11900","id":438013042,"node_id":"MDEyOklzc3VlQ29tbWVudDQzODAxMzA0Mg==","user":{"login":"sopel39","id":5989165,"node_id":"MDQ6VXNlcjU5ODkxNjU=","avatar_url":"https://avatars1.githubusercontent.com/u/5989165?v=4","gravatar_id":"","url":"https://api.github.com/users/sopel39","html_url":"https://github.com/sopel39","followers_url":"https://api.github.com/users/sopel39/followers","following_url":"https://api.github.com/users/sopel39/following{/other_user}","gists_url":"https://api.github.com/users/sopel39/gists{/gist_id}","starred_url":"https://api.github.com/users/sopel39/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sopel39/subscriptions","organizations_url":"https://api.github.com/users/sopel39/orgs","repos_url":"https://api.github.com/users/sopel39/repos","events_url":"https://api.github.com/users/sopel39/events{/privacy}","received_events_url":"https://api.github.com/users/sopel39/received_events","type":"User","site_admin":false},"created_at":"2018-11-12T20:11:24Z","updated_at":"2018-11-12T20:11:24Z","author_association":"MEMBER","body":"which commit is it?"}}
{"actor":{"display_login":"sopel39"}}