{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":14332609,"defaultBranch":"master","name":"oracle_fdw","ownerLogin":"laurenz","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2013-11-12T13:17:00.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/220612?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1725807918.0","currentOid":""},"activityList":{"items":[{"before":"77553b5b21945e54d3b1650cc34a892a37beb866","after":"ccdf17abf61c0195ad5a70ac6642217e6e10d5f4","ref":"refs/heads/master","pushedAt":"2024-09-11T20:49:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Adapt to PostgreSQL commit e222534679\n\nThat commit changed the way disabled planner nodes are counted\nand modified some API functions,","shortMessageHtmlLink":"Adapt to PostgreSQL commit e222534679"}},{"before":"e60c027e76f9560d25b11e0b45438c664007d110","after":null,"ref":"refs/heads/error-on-ctid","pushedAt":"2024-09-08T15:05:18.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"}},{"before":"13ac9fb4e5ca5a515062b2c441d53079b0ec814d","after":"77553b5b21945e54d3b1650cc34a892a37beb866","ref":"refs/heads/master","pushedAt":"2024-09-08T15:00:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Throw an error on system columns used in the WHERE clause\n\nSince these columns have no meaning in Oracle, they are assigned\nmeaningless values, and using them in WHERE conditions would lead to\nmeaningless results.  As an exception, allow \"tableoid\", even though\nit is hard to imagine a use case for that.\n\nWe only test expressions that can potentially can be pushed down,\nso we won't catch uses of system columns buried in expressions that\noracle_fdw won't push down.  But this should cover accidental use,\nwhich is probably limited to simple cases like \"WHERE ctid = ...\".\n\nReported in https://stackoverflow.com/q/78823195/6464308\nThere, somebody used postgres_fdw to update a remote oracle_fdw\nforeign table.  Since postgres_fdw identifies rows by \"ctid\", all\nrows of the Oracle table were modified.","shortMessageHtmlLink":"Throw an error on system columns used in the WHERE clause"}},{"before":"c489aaec5c76e79f3d4c08474c98558c78114568","after":"e60c027e76f9560d25b11e0b45438c664007d110","ref":"refs/heads/error-on-ctid","pushedAt":"2024-08-29T14:11:28.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"do some more","shortMessageHtmlLink":"do some more"}},{"before":"cd51add7627b3d6e859a4a23a03552d041cb9f4b","after":"13ac9fb4e5ca5a515062b2c441d53079b0ec814d","ref":"refs/heads/master","pushedAt":"2024-08-26T20:51:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Increase \"prefetch\" maximum to 10240\n\nThis was the limit before commit b4e21374b5.\nBut both #671 and #674 request raising the limit because they\nobserve better performance with values over 1000, so let's\ngive in and raise the limit to 10240 again.\n\nSince such large values are likely to offer no performance\nbenefit in most cases, and there is a high risk of\nout-of-memory errors as seen in #582, add a dire warning to\nthe README.","shortMessageHtmlLink":"Increase \"prefetch\" maximum to 10240"}},{"before":"cd51add7627b3d6e859a4a23a03552d041cb9f4b","after":"c489aaec5c76e79f3d4c08474c98558c78114568","ref":"refs/heads/error-on-ctid","pushedAt":"2024-08-26T20:28:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Throw error if \"ctid\" is used\n\nThis is only a partial implementation and does not run yet.","shortMessageHtmlLink":"Throw error if \"ctid\" is used"}},{"before":null,"after":"cd51add7627b3d6e859a4a23a03552d041cb9f4b","ref":"refs/heads/error-on-ctid","pushedAt":"2024-08-07T04:50:06.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Release 2.7.0","shortMessageHtmlLink":"Release 2.7.0"}},{"before":"60005fe08e6d07f8f6d6ee7b91107bd932da530b","after":"29e0454e04edd0540fb0f56b1a3193b6d10fe1ef","ref":"refs/heads/gh-pages","pushedAt":"2024-08-01T13:40:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Update for release 2.7.0","shortMessageHtmlLink":"Update for release 2.7.0"}},{"before":"0fe00108215dc3c954b0106fff499756e0035747","after":"cd51add7627b3d6e859a4a23a03552d041cb9f4b","ref":"refs/heads/master","pushedAt":"2024-08-01T13:17:14.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Release 2.7.0","shortMessageHtmlLink":"Release 2.7.0"}},{"before":"a25048669017da109d09023bd5f99b0eb60883a1","after":"0fe00108215dc3c954b0106fff499756e0035747","ref":"refs/heads/master","pushedAt":"2024-07-24T09:19:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"fix spelling mistake","shortMessageHtmlLink":"fix spelling mistake"}},{"before":"8d73c2cd94a29dce7876c282d98737a71cad4477","after":"a25048669017da109d09023bd5f99b0eb60883a1","ref":"refs/heads/master","pushedAt":"2024-06-28T08:59:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Improve the documentation of \"nchar\"\n\nIssue #684 (reported by figoliu239) shows that the problem does not\nonly manifest with single-byte character sets.","shortMessageHtmlLink":"Improve the documentation of \"nchar\""}},{"before":"b64695e7226bf78ccda4209dc631c3998258105b","after":"8d73c2cd94a29dce7876c282d98737a71cad4477","ref":"refs/heads/master","pushedAt":"2024-06-18T11:07:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Bind empty string parameters as NULL values\n\nThe attempt to bind a parameter as an empty string SQLT_LVB\nleads to the error\n\n  ORA-01459: invalid length for variable character string\n\nThis is particularly easy to trigger with an INSERT; inserting\nan empty string is enough.\n\nWork around the problem by binding a NULL value instead.\nThis usually does the right thing, because Oracle treats empty\nstrings as NULL values anyway.  The only case where this is not\ntrue is with LOBs: they can be empty, but NOT NULL.\nBut getting that special case right would be a challenge, and\nthe fact that nobody has reported that problem until now is a\nstrong indication that few people will care.\n\nPer report from Adrian Boangiu.\nThis fixes #679.","shortMessageHtmlLink":"Bind empty string parameters as NULL values"}},{"before":"f593e07327f0151c3c4b6e8033730cd7e98770e7","after":"b64695e7226bf78ccda4209dc631c3998258105b","ref":"refs/heads/master","pushedAt":"2024-05-21T08:02:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Update the check for unsupported minor versions\n\nThat check was added in d137d15edc.  Later, there were more ABI and API\nbreaks documented (commits 07e0b4562f and 33c4086ac3), but the check was\nnever updated.\n\nIn the case of an ABI break, execution will probably never reach that\ncheck, because loading the oracle_fdw shared library fails.  Still, it\nis better to be consistent.","shortMessageHtmlLink":"Update the check for unsupported minor versions"}},{"before":"a0e33e7707b4bc8c6047d087e824fdf07e16701d","after":"f593e07327f0151c3c4b6e8033730cd7e98770e7","ref":"refs/heads/master","pushedAt":"2024-05-14T15:12:07.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix IMPORT FOREIGN SCHEMA for materialized views\n\nMaterialized views show up as TABLE *and* as MATERIALIZED VIEW\nin the Oracle catalog view ALL_OBJECTS.  Fix the query by ignoring\nthe former if both are present.\n\nAdd a materialized view to the regression tests and improve the\ncoverage for IMPORT FOREIGN SCHEMA.\n\nPer diligent testing by \"JamesInform\" in #673.","shortMessageHtmlLink":"Fix IMPORT FOREIGN SCHEMA for materialized views"}},{"before":"6d29407fd61c1e619397fc3a2d6a05990e444786","after":"a0e33e7707b4bc8c6047d087e824fdf07e16701d","ref":"refs/heads/master","pushedAt":"2024-05-13T09:22:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix query for IMPORT FOREIGN SCHEMA\n\nCommits 4a012436be and 6b1e9663a8 didn't consider that there\nmicht be different objects with the same name in the same schema.\nFor example, there may be a table and an index with the same\nname in the same schema.\n\nThat can lead to repeated results, which in turn leads to error\nmessages like\n\n    ERROR:  column \"id\" specified more than once\n\nTo fix, change NOT IN to IN and explicitly enumerate the object\ntypes that we care about.  This is safe, because tables, views\nand materialized views in the same schema must have different names.\n\nPer report from \"JamesInform\".\n\nThis closes #673.","shortMessageHtmlLink":"Fix query for IMPORT FOREIGN SCHEMA"}},{"before":"a8867e5d7333175850b3737080db1888548e6fb0","after":"6d29407fd61c1e619397fc3a2d6a05990e444786","ref":"refs/heads/master","pushedAt":"2024-05-12T15:39:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Adapt to PostgreSQL commit fd0398fcb0\n\nThis changed the way EXPLAIN displays InitPlans.","shortMessageHtmlLink":"Adapt to PostgreSQL commit fd0398fcb0"}},{"before":"33c4086ac346f2afc6153a4ce59a4cf8c63c505a","after":"a8867e5d7333175850b3737080db1888548e6fb0","ref":"refs/heads/master","pushedAt":"2024-05-08T14:24:59.000Z","pushType":"push","commitsCount":3,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Improve a comment","shortMessageHtmlLink":"Improve a comment"}},{"before":"6b1e9663a88abdf5182fc00c03c13c3e3c6e69ed","after":"33c4086ac346f2afc6153a4ce59a4cf8c63c505a","ref":"refs/heads/master","pushedAt":"2024-04-04T17:33:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Document more unsupported minor releases\n\nThe fixes for CVE-2021-3393 in 11.11, 12.6 and 13.2 modified the\nResultRelInfo struct by replacing the ri_PartitionRoot field\nwith ri_RootResultRelInfo.\n\nSo 11.0 to 11.10 and 12.0 to 12.5 cannot be used with oracle_fdw\n(we already required 13.9 for v13).","shortMessageHtmlLink":"Document more unsupported minor releases"}},{"before":"4a012436bea3b312975e5f9e1e01fa3525d598c8","after":"6b1e9663a88abdf5182fc00c03c13c3e3c6e69ed","ref":"refs/heads/master","pushedAt":"2024-03-23T17:36:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Turn import_* options into skip_*\n\nAs evidenced by my mistake in the regression tests in the previous\ncommit, having import_* options for IMPORT FOREIGN SCHEMA that default\nto \"true\" is not intuitive, so let's negate them to skip_* options.\nUsers don't expect options to default to \"true\", and that way we cannot\nforget any odd object types.","shortMessageHtmlLink":"Turn import_* options into skip_*"}},{"before":"07e0b4562fbcb54374a74d0694e9f53dd0e93fb9","after":"4a012436bea3b312975e5f9e1e01fa3525d598c8","ref":"refs/heads/master","pushedAt":"2024-03-23T13:22:55.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Complete a937b579aa and assorted cleanup\n\n- Add a change log entry.\n- Use \"matview\" instead of \"materialized view\" for option and variable names.\n- Revert rewriting the query in standard SQL.  Oracle will never remove the\n  old proprietary syntax, and older Oracle versions had lots of bugs in the\n  implementation of the standard syntax.\n- Add regression tests.\n- Document the new requirement for the regression tests.  In passing, make\n  some small documentation improvements.\n- Invent macros for all IMPORT FOREIGN SCHEMA options.\n- Rename \"boolVal\" to \"getBoolVal\" to avoid collision with a PostgreSQL macro.\n  Use \"getBoolVal\" for all boolean options.  This removes a lot of redundant\n  code and obsoletes \"optionIsTrue\", which gets removed from the code.\n\nThis closes #656.","shortMessageHtmlLink":"Complete <a class=\"commit-link\" data-hovercard-type=\"commit\" data-hovercard-url=\"https://github.com/laurenz/oracle_fdw/commit/a937b579aad708e37974f2a8fafca0984f970ce8/hovercard\" href=\"https://github.com/laurenz/oracle_fdw/commit/a937b579aad708e37974f2a8fafca0984f970ce8\"><tt>a937b57</tt></a> and assorted cleanup"}},{"before":"158c03b6eca465f352f20e3e0516d95adc6cb163","after":"07e0b4562fbcb54374a74d0694e9f53dd0e93fb9","ref":"refs/heads/master","pushedAt":"2024-03-22T04:32:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Improve the installation documentation\n\nUpdate the list of minor releases that don't work with oracle_fdw\nfrom commit 57279082a8.\n\nMention the package redhat-rpm-config as possible requirement on\nRedhat-based systems.\n\nInspired by #657.","shortMessageHtmlLink":"Improve the installation documentation"}},{"before":"d62b87614935fdef22ae79661b9b39b7491471dd","after":"158c03b6eca465f352f20e3e0516d95adc6cb163","ref":"refs/heads/master","pushedAt":"2024-02-10T09:02:48.000Z","pushType":"push","commitsCount":2,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Improve the TODO list\n\nAdd some comments that give some hints concerning the\ndifficulties involved.  This is not to discourage contributors,\nbut to avoid frustration caused by rejection of their work.","shortMessageHtmlLink":"Improve the TODO list"}},{"before":"35a7d41e94e651390751bfa813a50970090afc87","after":null,"ref":"refs/heads/debug-643","pushedAt":"2024-02-09T19:20:14.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"}},{"before":"d62b87614935fdef22ae79661b9b39b7491471dd","after":null,"ref":"refs/heads/fix-643","pushedAt":"2024-02-09T19:20:11.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"}},{"before":"d2478d8707890683e41b70f9f1571a93ff7d31b1","after":"d62b87614935fdef22ae79661b9b39b7491471dd","ref":"refs/heads/master","pushedAt":"2024-02-09T19:19:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix crash or empty result when reading larger CLOBs\n\nFound by trial and error; the Oracle documentation\nfor OCILobRead2() is less than clear.\n\nReport by Rainer Hartwig and Erik van der Vlist.\nThis fixes #614 and fixes #643.","shortMessageHtmlLink":"Fix crash or empty result when reading larger CLOBs"}},{"before":"d2478d8707890683e41b70f9f1571a93ff7d31b1","after":"d62b87614935fdef22ae79661b9b39b7491471dd","ref":"refs/heads/fix-643","pushedAt":"2024-02-07T22:48:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix crash or empty result when reading larger CLOBs\n\nFound by trial and error; the Oracle documentation\nfor OCILobRead2() is less than clear.\n\nReport by Rainer Hartwig and Erik van der Vlist.\nThis fixes #614 and fixes #643.","shortMessageHtmlLink":"Fix crash or empty result when reading larger CLOBs"}},{"before":null,"after":"d2478d8707890683e41b70f9f1571a93ff7d31b1","ref":"refs/heads/fix-643","pushedAt":"2024-02-07T22:13:36.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix copy&paste error in error message","shortMessageHtmlLink":"Fix copy&amp;paste error in error message"}},{"before":"d2478d8707890683e41b70f9f1571a93ff7d31b1","after":"35a7d41e94e651390751bfa813a50970090afc87","ref":"refs/heads/debug-643","pushedAt":"2024-02-07T05:07:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Add some debug output","shortMessageHtmlLink":"Add some debug output"}},{"before":null,"after":"d2478d8707890683e41b70f9f1571a93ff7d31b1","ref":"refs/heads/debug-643","pushedAt":"2024-02-07T04:50:58.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix copy&paste error in error message","shortMessageHtmlLink":"Fix copy&amp;paste error in error message"}},{"before":"aca08e231ae55647dffef43a50108d77ec2f01cc","after":"d2478d8707890683e41b70f9f1571a93ff7d31b1","ref":"refs/heads/master","pushedAt":"2024-02-06T20:43:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"laurenz","name":"Laurenz Albe","path":"/laurenz","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/220612?s=80&v=4"},"commit":{"message":"Fix copy&paste error in error message","shortMessageHtmlLink":"Fix copy&amp;paste error in error message"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOS0xMVQyMDo0OTo1My4wMDAwMDBazwAAAASzqGCE","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wOS0xMVQyMDo0OTo1My4wMDAwMDBazwAAAASzqGCE","endCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wMi0wNlQyMDo0MzozNS4wMDAwMDBazwAAAAPzxiEQ"}},"title":"Activity · laurenz/oracle_fdw"}