{"action":"created","issue":{"url":"https://api.github.com/repos/crate/crate/issues/5610","repository_url":"https://api.github.com/repos/crate/crate","labels_url":"https://api.github.com/repos/crate/crate/issues/5610/labels{/name}","comments_url":"https://api.github.com/repos/crate/crate/issues/5610/comments","events_url":"https://api.github.com/repos/crate/crate/issues/5610/events","html_url":"https://github.com/crate/crate/pull/5610","id":230405608,"number":5610,"title":"fixed CrateDB-to-PG type mapping for field type `object_array`","user":{"login":"mikethebeer","id":6863216,"avatar_url":"https://avatars1.githubusercontent.com/u/6863216?v=4","gravatar_id":"","url":"https://api.github.com/users/mikethebeer","html_url":"https://github.com/mikethebeer","followers_url":"https://api.github.com/users/mikethebeer/followers","following_url":"https://api.github.com/users/mikethebeer/following{/other_user}","gists_url":"https://api.github.com/users/mikethebeer/gists{/gist_id}","starred_url":"https://api.github.com/users/mikethebeer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mikethebeer/subscriptions","organizations_url":"https://api.github.com/users/mikethebeer/orgs","repos_url":"https://api.github.com/users/mikethebeer/repos","events_url":"https://api.github.com/users/mikethebeer/events{/privacy}","received_events_url":"https://api.github.com/users/mikethebeer/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-05-22T14:01:32Z","updated_at":"2017-10-03T14:38:14Z","closed_at":"2017-10-03T14:38:14Z","author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/crate/crate/pulls/5610","html_url":"https://github.com/crate/crate/pull/5610","diff_url":"https://github.com/crate/crate/pull/5610.diff","patch_url":"https://github.com/crate/crate/pull/5610.patch"},"body":"Fields of type `object_array` have been returned with the `OID = 144` (same as `object`) which should be `OID = 199` (same as for `geo_shape` field type). I'm a bit unsure if this fix will affect a certain edge case for our JDBC driver. This [commit](https://github.com/crate/crate/commit/ab7c278b6a527cbafdc98116c7155fe6c400ac74) added the mapping previously. @mfussenegger what do you mean?\r\n\r\n```sql\r\ncr> select * from pg_catalog.pg_type where oid in (199, 114);\r\n+-----+----------+---------+---------+\r\n| oid | typdelim | typelem | typname |\r\n+-----+----------+---------+---------+\r\n| 199 | ,        |     114 | _json   |\r\n| 114 | ,        |       0 | json    |\r\n+-----+----------+---------+---------+\r\n```"},"comment":{"url":"https://api.github.com/repos/crate/crate/issues/comments/333862844","html_url":"https://github.com/crate/crate/pull/5610#issuecomment-333862844","issue_url":"https://api.github.com/repos/crate/crate/issues/5610","id":333862844,"user":{"login":"mfussenegger","id":38700,"avatar_url":"https://avatars0.githubusercontent.com/u/38700?v=4","gravatar_id":"","url":"https://api.github.com/users/mfussenegger","html_url":"https://github.com/mfussenegger","followers_url":"https://api.github.com/users/mfussenegger/followers","following_url":"https://api.github.com/users/mfussenegger/following{/other_user}","gists_url":"https://api.github.com/users/mfussenegger/gists{/gist_id}","starred_url":"https://api.github.com/users/mfussenegger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfussenegger/subscriptions","organizations_url":"https://api.github.com/users/mfussenegger/orgs","repos_url":"https://api.github.com/users/mfussenegger/repos","events_url":"https://api.github.com/users/mfussenegger/events{/privacy}","received_events_url":"https://api.github.com/users/mfussenegger/received_events","type":"User","site_admin":false},"created_at":"2017-10-03T14:38:14Z","updated_at":"2017-10-03T14:38:14Z","author_association":"MEMBER","body":"Closing this as it seems that this change isn't necessary."}}
{"actor":{"display_login":"mfussenegger"}}