{"action":"created","issue":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/49","repository_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc","labels_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/49/labels{/name}","comments_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/49/comments","events_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/49/events","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/pull/49","id":136776754,"number":49,"title":"refactor offset data for timestamp-incrementing mode","user":{"login":"lepfhty","id":1322856,"avatar_url":"https://avatars.githubusercontent.com/u/1322856?v=3","gravatar_id":"","url":"https://api.github.com/users/lepfhty","html_url":"https://github.com/lepfhty","followers_url":"https://api.github.com/users/lepfhty/followers","following_url":"https://api.github.com/users/lepfhty/following{/other_user}","gists_url":"https://api.github.com/users/lepfhty/gists{/gist_id}","starred_url":"https://api.github.com/users/lepfhty/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lepfhty/subscriptions","organizations_url":"https://api.github.com/users/lepfhty/orgs","repos_url":"https://api.github.com/users/lepfhty/repos","events_url":"https://api.github.com/users/lepfhty/events{/privacy}","received_events_url":"https://api.github.com/users/lepfhty/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-26T18:32:25Z","updated_at":"2016-06-22T03:38:11Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/pulls/49","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/pull/49","diff_url":"https://github.com/confluentinc/kafka-connect-jdbc/pull/49.diff","patch_url":"https://github.com/confluentinc/kafka-connect-jdbc/pull/49.patch"},"body":"Originally, I ran into an issue where PostgreSQL timestamps have microsecond precision, but the offsets were stored with millisecond precision. Consequently, several records would _always_ be extracted on every poll because the extra microseconds of precision caused those records to _always_ be \"newer\" than the stored offset.\r\n\r\nThe logic to save and restore nanosecond precision on a `java.sql.Timestamp` was non-trivial, so I thought it would be good to abstract the offsets into its own class `TimestampIncrementingOffset`. Wrote some tests for it too.\r\n\r\nOpen to comments and suggestions.\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/comments/227634634","html_url":"https://github.com/confluentinc/kafka-connect-jdbc/pull/49#issuecomment-227634634","issue_url":"https://api.github.com/repos/confluentinc/kafka-connect-jdbc/issues/49","id":227634634,"user":{"login":"ewencp","id":47366,"avatar_url":"https://avatars.githubusercontent.com/u/47366?v=3","gravatar_id":"","url":"https://api.github.com/users/ewencp","html_url":"https://github.com/ewencp","followers_url":"https://api.github.com/users/ewencp/followers","following_url":"https://api.github.com/users/ewencp/following{/other_user}","gists_url":"https://api.github.com/users/ewencp/gists{/gist_id}","starred_url":"https://api.github.com/users/ewencp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ewencp/subscriptions","organizations_url":"https://api.github.com/users/ewencp/orgs","repos_url":"https://api.github.com/users/ewencp/repos","events_url":"https://api.github.com/users/ewencp/events{/privacy}","received_events_url":"https://api.github.com/users/ewencp/received_events","type":"User","site_admin":false},"created_at":"2016-06-22T03:38:11Z","updated_at":"2016-06-22T03:38:11Z","body":"ok to test"}}
{"actor":{"display_login":"ewencp"}}