{"action":"created","comment":{"url":"https://api.github.com/repos/timescale/timescaledb/pulls/comments/232455819","pull_request_review_id":173665249,"id":232455819,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDIzMjQ1NTgxOQ==","diff_hunk":"@@ -362,7 +362,7 @@ FROM unnest(ARRAY[\n \\set ON_ERROR_STOP 0\n SELECT time_bucket(10::smallint, '-32768'::smallint);\n SELECT time_bucket(10::smallint, '-32761'::smallint);\n-select time_bucket(10::smallint, '-32000'::smallint, 1000::smallint);\n+select time_bucket(10::smallint, '-32768'::smallint, 1000::smallint);","path":"test/sql/timestamp.sql","position":5,"original_position":5,"commit_id":"635823b201b83cdc87d9bfd88f667c18744dff16","original_commit_id":"19e48be203c2762c6f9a86d11e46d50d901ddbe4","user":{"login":"svenklemm","id":31455525,"node_id":"MDQ6VXNlcjMxNDU1NTI1","avatar_url":"https://avatars1.githubusercontent.com/u/31455525?v=4","gravatar_id":"","url":"https://api.github.com/users/svenklemm","html_url":"https://github.com/svenklemm","followers_url":"https://api.github.com/users/svenklemm/followers","following_url":"https://api.github.com/users/svenklemm/following{/other_user}","gists_url":"https://api.github.com/users/svenklemm/gists{/gist_id}","starred_url":"https://api.github.com/users/svenklemm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svenklemm/subscriptions","organizations_url":"https://api.github.com/users/svenklemm/orgs","repos_url":"https://api.github.com/users/svenklemm/repos","events_url":"https://api.github.com/users/svenklemm/events{/privacy}","received_events_url":"https://api.github.com/users/svenklemm/received_events","type":"User","site_admin":false},"body":"done","created_at":"2018-11-10T15:44:06Z","updated_at":"2018-11-10T15:44:06Z","html_url":"https://github.com/timescale/timescaledb/pull/838#discussion_r232455819","pull_request_url":"https://api.github.com/repos/timescale/timescaledb/pulls/838","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/comments/232455819"},"html":{"href":"https://github.com/timescale/timescaledb/pull/838#discussion_r232455819"},"pull_request":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/838"}},"in_reply_to_id":231198565},"pull_request":{"url":"https://api.github.com/repos/timescale/timescaledb/pulls/838","id":228116201,"node_id":"MDExOlB1bGxSZXF1ZXN0MjI4MTE2MjAx","html_url":"https://github.com/timescale/timescaledb/pull/838","diff_url":"https://github.com/timescale/timescaledb/pull/838.diff","patch_url":"https://github.com/timescale/timescaledb/pull/838.patch","issue_url":"https://api.github.com/repos/timescale/timescaledb/issues/838","number":838,"state":"open","locked":false,"title":"Move int time_bucket functions with offset to C","user":{"login":"svenklemm","id":31455525,"node_id":"MDQ6VXNlcjMxNDU1NTI1","avatar_url":"https://avatars1.githubusercontent.com/u/31455525?v=4","gravatar_id":"","url":"https://api.github.com/users/svenklemm","html_url":"https://github.com/svenklemm","followers_url":"https://api.github.com/users/svenklemm/followers","following_url":"https://api.github.com/users/svenklemm/following{/other_user}","gists_url":"https://api.github.com/users/svenklemm/gists{/gist_id}","starred_url":"https://api.github.com/users/svenklemm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svenklemm/subscriptions","organizations_url":"https://api.github.com/users/svenklemm/orgs","repos_url":"https://api.github.com/users/svenklemm/repos","events_url":"https://api.github.com/users/svenklemm/events{/privacy}","received_events_url":"https://api.github.com/users/svenklemm/received_events","type":"User","site_admin":false},"body":"Move the int time_bucket functions with offset to C. This makes implementing gap filling easier because inlined SQL functions can't be identified in the target list.\r\n\r\nThis also increases the accepted value range for timestamps when using int time_bucket with offset since the code uses offset modulo period.","created_at":"2018-11-03T12:34:21Z","updated_at":"2018-11-10T15:44:06Z","closed_at":null,"merged_at":null,"merge_commit_sha":"5fd34fe49e0bf956e71915c04d9b5e04e620c841","assignee":null,"assignees":[],"requested_reviewers":[{"login":"cevian","id":112245,"node_id":"MDQ6VXNlcjExMjI0NQ==","avatar_url":"https://avatars0.githubusercontent.com/u/112245?v=4","gravatar_id":"","url":"https://api.github.com/users/cevian","html_url":"https://github.com/cevian","followers_url":"https://api.github.com/users/cevian/followers","following_url":"https://api.github.com/users/cevian/following{/other_user}","gists_url":"https://api.github.com/users/cevian/gists{/gist_id}","starred_url":"https://api.github.com/users/cevian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cevian/subscriptions","organizations_url":"https://api.github.com/users/cevian/orgs","repos_url":"https://api.github.com/users/cevian/repos","events_url":"https://api.github.com/users/cevian/events{/privacy}","received_events_url":"https://api.github.com/users/cevian/received_events","type":"User","site_admin":false},{"login":"erimatnor","id":819732,"node_id":"MDQ6VXNlcjgxOTczMg==","avatar_url":"https://avatars3.githubusercontent.com/u/819732?v=4","gravatar_id":"","url":"https://api.github.com/users/erimatnor","html_url":"https://github.com/erimatnor","followers_url":"https://api.github.com/users/erimatnor/followers","following_url":"https://api.github.com/users/erimatnor/following{/other_user}","gists_url":"https://api.github.com/users/erimatnor/gists{/gist_id}","starred_url":"https://api.github.com/users/erimatnor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erimatnor/subscriptions","organizations_url":"https://api.github.com/users/erimatnor/orgs","repos_url":"https://api.github.com/users/erimatnor/repos","events_url":"https://api.github.com/users/erimatnor/events{/privacy}","received_events_url":"https://api.github.com/users/erimatnor/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/timescale/timescaledb/pulls/838/commits","review_comments_url":"https://api.github.com/repos/timescale/timescaledb/pulls/838/comments","review_comment_url":"https://api.github.com/repos/timescale/timescaledb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/timescale/timescaledb/issues/838/comments","statuses_url":"https://api.github.com/repos/timescale/timescaledb/statuses/635823b201b83cdc87d9bfd88f667c18744dff16","head":{"label":"svenklemm:time_bucket_c","ref":"time_bucket_c","sha":"635823b201b83cdc87d9bfd88f667c18744dff16","user":{"login":"svenklemm","id":31455525,"node_id":"MDQ6VXNlcjMxNDU1NTI1","avatar_url":"https://avatars1.githubusercontent.com/u/31455525?v=4","gravatar_id":"","url":"https://api.github.com/users/svenklemm","html_url":"https://github.com/svenklemm","followers_url":"https://api.github.com/users/svenklemm/followers","following_url":"https://api.github.com/users/svenklemm/following{/other_user}","gists_url":"https://api.github.com/users/svenklemm/gists{/gist_id}","starred_url":"https://api.github.com/users/svenklemm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svenklemm/subscriptions","organizations_url":"https://api.github.com/users/svenklemm/orgs","repos_url":"https://api.github.com/users/svenklemm/repos","events_url":"https://api.github.com/users/svenklemm/events{/privacy}","received_events_url":"https://api.github.com/users/svenklemm/received_events","type":"User","site_admin":false},"repo":{"id":137101956,"node_id":"MDEwOlJlcG9zaXRvcnkxMzcxMDE5NTY=","name":"timescaledb","full_name":"svenklemm/timescaledb","private":false,"owner":{"login":"svenklemm","id":31455525,"node_id":"MDQ6VXNlcjMxNDU1NTI1","avatar_url":"https://avatars1.githubusercontent.com/u/31455525?v=4","gravatar_id":"","url":"https://api.github.com/users/svenklemm","html_url":"https://github.com/svenklemm","followers_url":"https://api.github.com/users/svenklemm/followers","following_url":"https://api.github.com/users/svenklemm/following{/other_user}","gists_url":"https://api.github.com/users/svenklemm/gists{/gist_id}","starred_url":"https://api.github.com/users/svenklemm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/svenklemm/subscriptions","organizations_url":"https://api.github.com/users/svenklemm/orgs","repos_url":"https://api.github.com/users/svenklemm/repos","events_url":"https://api.github.com/users/svenklemm/events{/privacy}","received_events_url":"https://api.github.com/users/svenklemm/received_events","type":"User","site_admin":false},"html_url":"https://github.com/svenklemm/timescaledb","description":"An open-source time-series database optimized for fast ingest and complex queries.  Engineered up from PostgreSQL, packaged as an extension.","fork":true,"url":"https://api.github.com/repos/svenklemm/timescaledb","forks_url":"https://api.github.com/repos/svenklemm/timescaledb/forks","keys_url":"https://api.github.com/repos/svenklemm/timescaledb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/svenklemm/timescaledb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/svenklemm/timescaledb/teams","hooks_url":"https://api.github.com/repos/svenklemm/timescaledb/hooks","issue_events_url":"https://api.github.com/repos/svenklemm/timescaledb/issues/events{/number}","events_url":"https://api.github.com/repos/svenklemm/timescaledb/events","assignees_url":"https://api.github.com/repos/svenklemm/timescaledb/assignees{/user}","branches_url":"https://api.github.com/repos/svenklemm/timescaledb/branches{/branch}","tags_url":"https://api.github.com/repos/svenklemm/timescaledb/tags","blobs_url":"https://api.github.com/repos/svenklemm/timescaledb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/svenklemm/timescaledb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/svenklemm/timescaledb/git/refs{/sha}","trees_url":"https://api.github.com/repos/svenklemm/timescaledb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/svenklemm/timescaledb/statuses/{sha}","languages_url":"https://api.github.com/repos/svenklemm/timescaledb/languages","stargazers_url":"https://api.github.com/repos/svenklemm/timescaledb/stargazers","contributors_url":"https://api.github.com/repos/svenklemm/timescaledb/contributors","subscribers_url":"https://api.github.com/repos/svenklemm/timescaledb/subscribers","subscription_url":"https://api.github.com/repos/svenklemm/timescaledb/subscription","commits_url":"https://api.github.com/repos/svenklemm/timescaledb/commits{/sha}","git_commits_url":"https://api.github.com/repos/svenklemm/timescaledb/git/commits{/sha}","comments_url":"https://api.github.com/repos/svenklemm/timescaledb/comments{/number}","issue_comment_url":"https://api.github.com/repos/svenklemm/timescaledb/issues/comments{/number}","contents_url":"https://api.github.com/repos/svenklemm/timescaledb/contents/{+path}","compare_url":"https://api.github.com/repos/svenklemm/timescaledb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/svenklemm/timescaledb/merges","archive_url":"https://api.github.com/repos/svenklemm/timescaledb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/svenklemm/timescaledb/downloads","issues_url":"https://api.github.com/repos/svenklemm/timescaledb/issues{/number}","pulls_url":"https://api.github.com/repos/svenklemm/timescaledb/pulls{/number}","milestones_url":"https://api.github.com/repos/svenklemm/timescaledb/milestones{/number}","notifications_url":"https://api.github.com/repos/svenklemm/timescaledb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/svenklemm/timescaledb/labels{/name}","releases_url":"https://api.github.com/repos/svenklemm/timescaledb/releases{/id}","deployments_url":"https://api.github.com/repos/svenklemm/timescaledb/deployments","created_at":"2018-06-12T16:50:59Z","updated_at":"2018-11-10T15:28:25Z","pushed_at":"2018-11-10T15:43:20Z","git_url":"git://github.com/svenklemm/timescaledb.git","ssh_url":"git@github.com:svenklemm/timescaledb.git","clone_url":"https://github.com/svenklemm/timescaledb.git","svn_url":"https://github.com/svenklemm/timescaledb","homepage":"http://www.timescale.com/","size":3804,"stargazers_count":0,"watchers_count":0,"language":"C","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"timescale:master","ref":"master","sha":"92d4dbde9ce8b5374f56986416a60d2e78745de9","user":{"login":"timescale","id":8986001,"node_id":"MDEyOk9yZ2FuaXphdGlvbjg5ODYwMDE=","avatar_url":"https://avatars3.githubusercontent.com/u/8986001?v=4","gravatar_id":"","url":"https://api.github.com/users/timescale","html_url":"https://github.com/timescale","followers_url":"https://api.github.com/users/timescale/followers","following_url":"https://api.github.com/users/timescale/following{/other_user}","gists_url":"https://api.github.com/users/timescale/gists{/gist_id}","starred_url":"https://api.github.com/users/timescale/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timescale/subscriptions","organizations_url":"https://api.github.com/users/timescale/orgs","repos_url":"https://api.github.com/users/timescale/repos","events_url":"https://api.github.com/users/timescale/events{/privacy}","received_events_url":"https://api.github.com/users/timescale/received_events","type":"Organization","site_admin":false},"repo":{"id":84240850,"node_id":"MDEwOlJlcG9zaXRvcnk4NDI0MDg1MA==","name":"timescaledb","full_name":"timescale/timescaledb","private":false,"owner":{"login":"timescale","id":8986001,"node_id":"MDEyOk9yZ2FuaXphdGlvbjg5ODYwMDE=","avatar_url":"https://avatars3.githubusercontent.com/u/8986001?v=4","gravatar_id":"","url":"https://api.github.com/users/timescale","html_url":"https://github.com/timescale","followers_url":"https://api.github.com/users/timescale/followers","following_url":"https://api.github.com/users/timescale/following{/other_user}","gists_url":"https://api.github.com/users/timescale/gists{/gist_id}","starred_url":"https://api.github.com/users/timescale/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timescale/subscriptions","organizations_url":"https://api.github.com/users/timescale/orgs","repos_url":"https://api.github.com/users/timescale/repos","events_url":"https://api.github.com/users/timescale/events{/privacy}","received_events_url":"https://api.github.com/users/timescale/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/timescale/timescaledb","description":"An open-source time-series database optimized for fast ingest and complex queries.  Engineered up from PostgreSQL, packaged as an extension.","fork":false,"url":"https://api.github.com/repos/timescale/timescaledb","forks_url":"https://api.github.com/repos/timescale/timescaledb/forks","keys_url":"https://api.github.com/repos/timescale/timescaledb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/timescale/timescaledb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/timescale/timescaledb/teams","hooks_url":"https://api.github.com/repos/timescale/timescaledb/hooks","issue_events_url":"https://api.github.com/repos/timescale/timescaledb/issues/events{/number}","events_url":"https://api.github.com/repos/timescale/timescaledb/events","assignees_url":"https://api.github.com/repos/timescale/timescaledb/assignees{/user}","branches_url":"https://api.github.com/repos/timescale/timescaledb/branches{/branch}","tags_url":"https://api.github.com/repos/timescale/timescaledb/tags","blobs_url":"https://api.github.com/repos/timescale/timescaledb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/timescale/timescaledb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/timescale/timescaledb/git/refs{/sha}","trees_url":"https://api.github.com/repos/timescale/timescaledb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/timescale/timescaledb/statuses/{sha}","languages_url":"https://api.github.com/repos/timescale/timescaledb/languages","stargazers_url":"https://api.github.com/repos/timescale/timescaledb/stargazers","contributors_url":"https://api.github.com/repos/timescale/timescaledb/contributors","subscribers_url":"https://api.github.com/repos/timescale/timescaledb/subscribers","subscription_url":"https://api.github.com/repos/timescale/timescaledb/subscription","commits_url":"https://api.github.com/repos/timescale/timescaledb/commits{/sha}","git_commits_url":"https://api.github.com/repos/timescale/timescaledb/git/commits{/sha}","comments_url":"https://api.github.com/repos/timescale/timescaledb/comments{/number}","issue_comment_url":"https://api.github.com/repos/timescale/timescaledb/issues/comments{/number}","contents_url":"https://api.github.com/repos/timescale/timescaledb/contents/{+path}","compare_url":"https://api.github.com/repos/timescale/timescaledb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/timescale/timescaledb/merges","archive_url":"https://api.github.com/repos/timescale/timescaledb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/timescale/timescaledb/downloads","issues_url":"https://api.github.com/repos/timescale/timescaledb/issues{/number}","pulls_url":"https://api.github.com/repos/timescale/timescaledb/pulls{/number}","milestones_url":"https://api.github.com/repos/timescale/timescaledb/milestones{/number}","notifications_url":"https://api.github.com/repos/timescale/timescaledb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/timescale/timescaledb/labels{/name}","releases_url":"https://api.github.com/repos/timescale/timescaledb/releases{/id}","deployments_url":"https://api.github.com/repos/timescale/timescaledb/deployments","created_at":"2017-03-07T20:03:41Z","updated_at":"2018-11-10T12:13:21Z","pushed_at":"2018-11-10T15:43:22Z","git_url":"git://github.com/timescale/timescaledb.git","ssh_url":"git@github.com:timescale/timescaledb.git","clone_url":"https://github.com/timescale/timescaledb.git","svn_url":"https://github.com/timescale/timescaledb","homepage":"http://www.timescale.com/","size":3778,"stargazers_count":6076,"watchers_count":6076,"language":"C","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":288,"mirror_url":null,"archived":false,"open_issues_count":96,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":288,"open_issues":96,"watchers":6076,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/838"},"html":{"href":"https://github.com/timescale/timescaledb/pull/838"},"issue":{"href":"https://api.github.com/repos/timescale/timescaledb/issues/838"},"comments":{"href":"https://api.github.com/repos/timescale/timescaledb/issues/838/comments"},"review_comments":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/838/comments"},"review_comment":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/timescale/timescaledb/pulls/838/commits"},"statuses":{"href":"https://api.github.com/repos/timescale/timescaledb/statuses/635823b201b83cdc87d9bfd88f667c18744dff16"}},"author_association":"MEMBER"}}
{"actor":{"display_login":"svenklemm"}}