{"action":"created","issue":{"url":"https://api.github.com/repos/h2database/h2database/issues/1485","repository_url":"https://api.github.com/repos/h2database/h2database","labels_url":"https://api.github.com/repos/h2database/h2database/issues/1485/labels{/name}","comments_url":"https://api.github.com/repos/h2database/h2database/issues/1485/comments","events_url":"https://api.github.com/repos/h2database/h2database/issues/1485/events","html_url":"https://github.com/h2database/h2database/issues/1485","id":365798035,"node_id":"MDU6SXNzdWUzNjU3OTgwMzU=","number":1485,"title":"Default window frame in presence of ORDER BY is RANGE .., not ROWS","user":{"login":"lukaseder","id":734593,"node_id":"MDQ6VXNlcjczNDU5Mw==","avatar_url":"https://avatars2.githubusercontent.com/u/734593?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2018-10-02T08:47:49Z","updated_at":"2018-10-02T11:34:44Z","closed_at":"2018-10-02T11:34:44Z","author_association":"CONTRIBUTOR","body":"The following statement:\r\n\r\n```sql\r\nSELECT a, count(*) OVER (ORDER BY a) c\r\nFROM (VALUES(1),(1),(2)) t(a)\r\n```\r\n\r\nYields:\r\n\r\n```\r\nA  | C\r\n-- | --\r\n1  | 1\r\n1  | 2\r\n2  | 3\r\n```\r\n\r\nWhen it should yield\r\n\r\n```\r\na |c \r\n--|--\r\n1 |2 \r\n1 |2 \r\n2 |3 \r\n```\r\n\r\nThe default frame clause in the absence of an explicit frame clause is:\r\n\r\n- `RANGE UNBOUNDED PRECEDING` in the presence of an `ORDER BY` clause\r\n- `RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING` in the absence of an `ORDER BY` clause.\r\n\r\nIt seems the current behaviour is to default to some `ROWS UNBOUNDED PRECEDING` behaviour."},"comment":{"url":"https://api.github.com/repos/h2database/h2database/issues/comments/426240818","html_url":"https://github.com/h2database/h2database/issues/1485#issuecomment-426240818","issue_url":"https://api.github.com/repos/h2database/h2database/issues/1485","id":426240818,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNjI0MDgxOA==","user":{"login":"katzyn","id":23182944,"node_id":"MDQ6VXNlcjIzMTgyOTQ0","avatar_url":"https://avatars0.githubusercontent.com/u/23182944?v=4","gravatar_id":"","url":"https://api.github.com/users/katzyn","html_url":"https://github.com/katzyn","followers_url":"https://api.github.com/users/katzyn/followers","following_url":"https://api.github.com/users/katzyn/following{/other_user}","gists_url":"https://api.github.com/users/katzyn/gists{/gist_id}","starred_url":"https://api.github.com/users/katzyn/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/katzyn/subscriptions","organizations_url":"https://api.github.com/users/katzyn/orgs","repos_url":"https://api.github.com/users/katzyn/repos","events_url":"https://api.github.com/users/katzyn/events{/privacy}","received_events_url":"https://api.github.com/users/katzyn/received_events","type":"User","site_admin":false},"created_at":"2018-10-02T11:34:44Z","updated_at":"2018-10-02T11:34:44Z","author_association":"CONTRIBUTOR","body":"Both issues (incorrect default and incorrect `CURRENT ROW` with `RANGE` / `GROUPS`) should be fixed. Please re-open this issue or create a new one if something is still going wrong."}}
{"actor":{"display_login":"katzyn"}}