[rpms/orafce] rawhide: Rebase to 4.16.7

[rpms/orafce] rawhide: Rebase to 4.16.7

[Michal Schorm]

            A new commit has been pushed.

            Repo   : rpms/orafce
            Branch : rawhide
            Commit : 5721a5631490ab6d0edbd5905f347ce6b5275f8a
            Author : Michal Schorm <mschorm@redhat.com>
            Date   : 2026-07-02T11:55:22+02:00
            Stats  : +7/-4 in 2 file(s)
            URL    : https://src.fedoraproject.org/rpms/orafce/c/5721a5631490ab6d0edbd5905f347ce6b5275f8a?branch=rawhide

            Log:
            Rebase to 4.16.7

'orafce' provides Oracle-compatible functions and packages for PostgreSQL.

Upstream changes (4.9.0 -> 4.16.7, ~30 releases):
- New functions: 'sys_extract_utc', 'nvl(double precision, int)',
  'to_date(int, text)'
- 'utl_file.fopen' gained umask configuration via 'orafce.umask' GUC
- New GUC: 'orafce.oracle_compatibility_date_limit'
- Meson build system support added (4.14.1)
- 'months_between' behavior changed for 'timestamp' inputs -- now
  calculated correctly instead of truncating to date first (4.16.0)
- 'regexp_instr' accepts 'return_opt' values > 1, matching Oracle (4.16.3)
- 'oracle.to_date' returns NULL for empty string input (4.13.5)
- 'dbms_random(low, high)' silently swaps args when low > high (4.14.0)
- Multiple crash fixes: 'plvstr.rvrs' out-of-bounds, 'dbms_sql' memory
  context, 'utl_file' double-fclose, orafce reload, integer overflow
- 'dbms_alert.defered_signal()' removed (was deprecated since 4.6)
- 'oracle.to_date(TEXT, TEXT)' volatility changed: IMMUTABLE -> STABLE
  (may break functional indexes using this function) (4.13.0)
- 'dbms_alert.signal' changed: SECURITY DEFINER -> SECURITY INVOKER
  (security hardening) (4.15.0)
- 'utl_file.umask' decoding fixed -- upstream warns this may break
  applications that relied on the old (incorrect) behavior (4.13.3)

Extension version: 4.9 -> 4.16. Complete upgrade script chain ships:
  4.9 -> 4.10 -> 4.11 -> 4.12 -> 4.13 -> 4.14 -> 4.15 -> 4.16
Users can run 'ALTER EXTENSION orafce UPDATE' for in-place upgrade.
Shared library name unchanged: 'orafce.so'.

PostgreSQL compatibility:
- Minimum: PG 9.5. CI tests PG 13 through 17
- PG 18 not yet in upstream CI matrix, but code has version guards
  up to PG 19 (190000). Debian sid ships 'postgresql-18-orafce' 4.16.7-1
- Builds and tests fine against PG 18.3 in Rawhide (confirmed via mockbuild)
- The FTBFS was caused by 'PGPROC.lxid' removal in PG 18; upstream fixed
  this with the 'CURRENT_LXID' compat macro

ABI/API: PostgreSQL extension (shared library loaded by PG server).
No stable ABI contract -- extension is tightly coupled to PG major version
and only loaded by PostgreSQL itself.

Reverse dependencies: none.

Upgrade safety: mostly safe.
- Extension 'ALTER EXTENSION UPDATE' path from 4.9 to 4.16 exists
- Items to note for existing users:
  1. 'dbms_alert.defered_signal()' removed (deprecated since 4.6)
  2. 'oracle.to_date(TEXT,TEXT)' volatility IMMUTABLE -> STABLE
     (check for functional indexes using this function)
  3. 'dbms_alert.signal' SECURITY DEFINER -> SECURITY INVOKER
  4. 'utl_file.umask' decoding fixed (behavior change)
- No RPM-level dependency changes

Co-Authored-By: Claude AI <noreply@anthropic.com>

---
diff --git a/orafce.spec b/orafce.spec
index 4db3e21..70f9adf 100644
--- a/orafce.spec
+++ b/orafce.spec
@@ -1,8 +1,8 @@
-%global githubversion 4_9_0
+%global githubversion 4_16_7
 
 Name:		orafce
-Version:	4.9.0
-Release:	7%{?dist}
+Version:	4.16.7
+Release:	1%{?dist}
 Summary:	Implementation of some Oracle functions into PostgreSQL
 # Automatically converted from old format: BSD - review is highly recommended.
 License:	LicenseRef-Callaway-BSD
@@ -45,6 +45,9 @@ for production work.
 
 
 %changelog
+* Thu Jul 02 2026 Michal Schorm <mschorm@redhat.com> - 4.16.7-1
+- Rebase to 4.16.7
+
 * Fri Jun 12 2026 Yaakov Selkowitz <yselkowi@redhat.com> - 4.9.0-7
 - Rebuilt for openssl 4.0
 

diff --git a/sources b/sources
index fbd2a96..fd63a5e 100644
--- a/sources
+++ b/sources
@@ -1 +1 @@
-SHA512 (VERSION_4_9_0.tar.gz) = f420a3ff26e85da167add4de6e80e3cf285d898f8209cac0439953d3bda8acea904110560a5cd5f2a679296e4bb8ac8cd9d4b4cd26412488573d403ea005c206
+SHA512 (VERSION_4_16_7.tar.gz) = 72c8d9c4f5f1500b654d8c7aeb33e56b51c972308bc9b1cabab39638e03be7fa9922eac4c928e0e31075692e3d30876e75b4f5e246c5329b08bbbf5a953f7dd7