Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2024-10-23 21:10:04 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.26871 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Package is "orafce" Wed Oct 23 21:10:04 2024 rev:23 rq:1217062 version:4.13.5+git0.ab95f82 Changes: -------- --- /work/SRC/openSUSE:Factory/orafce/orafce.changes 2024-09-25 21:56:11.255509878 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.26871/orafce.changes 2024-10-23 21:11:18.801282320 +0200 @@ -1,0 +2,43 @@ +Tue Oct 22 14:01:46 UTC 2024 - [email protected] + +- Update to version 4.13.5+git0.ab95f82: + * prepare for 4.13.5 + * export orafce_sys_extract_utc and orafce_sys_extract_utc_oracle_date for win build + * With Oracle passing en empty string to the to_date(txt, fmt) function returns NULL whereas PostgreSQL returns '0001-01-01 BC'. This true whatever is the format passed as second argument. Change the behavior of function to_date(txt, fmt) to mimic Oracle. + +------------------------------------------------------------------- +Tue Oct 15 12:13:46 UTC 2024 - [email protected] + +- Update to version 4.13.4+git0.8f3f211: + * prepare for 4.13.4 + * fix update script from 4.12 to 4.13 + * prepare for 4.13.3 + * umask is usually entered as octec number, then read it as octec number + +------------------------------------------------------------------- +Tue Oct 15 12:06:21 UTC 2024 - [email protected] + +- Update to version 4.13.4+git0.8f3f211: + * prepare for 4.13.4 + * fix update script from 4.12 to 4.13 + +------------------------------------------------------------------- +Tue Oct 15 11:55:06 UTC 2024 - [email protected] + +- Update to version 4.13.3+git0.0bf0f15: + * prepare for 4.13.3 + * umask is usually entered as octec number, then read it as octec number + +------------------------------------------------------------------- +Sat Sep 28 00:31:28 UTC 2024 - Marcus Rueckert <[email protected]> + +- enable pg17 + +------------------------------------------------------------------- +Sat Sep 28 00:31:10 UTC 2024 - [email protected] + +- Update to version 4.13.2+git0.f8f8700: + * prepare for 4.13.2 + * fix missing update of control file and regress tests + +------------------------------------------------------------------- Old: ---- orafce-4.13.0+git3.25d74aa.obscpio New: ---- orafce-4.13.5+git0.ab95f82.obscpio ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ orafce.spec ++++++ --- /var/tmp/diff_new_pack.ileNlU/_old 2024-10-23 21:11:19.581314880 +0200 +++ /var/tmp/diff_new_pack.ileNlU/_new 2024-10-23 21:11:19.581314880 +0200 @@ -20,7 +20,7 @@ %define realname orafce Name: %{pgname}-orafce -Version: 4.13.0+git3.25d74aa +Version: 4.13.5+git0.ab95f82 Release: 0 Summary: Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++++++ _multibuild ++++++ --- /var/tmp/diff_new_pack.ileNlU/_old 2024-10-23 21:11:19.609316048 +0200 +++ /var/tmp/diff_new_pack.ileNlU/_new 2024-10-23 21:11:19.613316216 +0200 @@ -4,5 +4,6 @@ <package>postgresql14</package> <package>postgresql15</package> <package>postgresql16</package> + <package>postgresql17</package> </multibuild> ++++++ _service ++++++ --- /var/tmp/diff_new_pack.ileNlU/_old 2024-10-23 21:11:19.637317218 +0200 +++ /var/tmp/diff_new_pack.ileNlU/_new 2024-10-23 21:11:19.637317218 +0200 @@ -1,15 +1,18 @@ <services> - <service name="obs_scm" mode="disabled"> + <service name="obs_scm" mode="manual"> <param name="url">https://github.com/orafce/orafce.git</param> <param name="versionformat">@PARENT_TAG@+git@TAG_OFFSET@.%h</param> <param name="versionrewrite-pattern">VERSION_(\d+).(\d+).(\d+)(.*)</param> <param name="versionrewrite-replacement">\1.\2.\3\4</param> + <param name="revision">VERSION_4_13_5</param> + <!-- <param name="revision">master</param> + --> <param name="scm">git</param> <param name="changesgenerate">enable</param> </service> <service name="tar" mode="buildtime"/> - <service mode="disabled" name="set_version"/> + <service mode="manual" name="set_version"/> <service name="recompress" mode="buildtime"> <param name="file">*.tar</param> <param name="compression">gz</param> ++++++ _servicedata ++++++ --- /var/tmp/diff_new_pack.ileNlU/_old 2024-10-23 21:11:19.657318053 +0200 +++ /var/tmp/diff_new_pack.ileNlU/_new 2024-10-23 21:11:19.661318220 +0200 @@ -1,6 +1,6 @@ <servicedata> <service name="tar_scm"> <param name="url">https://github.com/orafce/orafce.git</param> - <param name="changesrevision">25d74aad957eda018f8da14decba996cc2ce32f2</param></service></servicedata> + <param name="changesrevision">ab95f8296486801e3f90d101e43a7528674399e0</param></service></servicedata> (No newline at EOF) ++++++ orafce-4.13.0+git3.25d74aa.obscpio -> orafce-4.13.5+git0.ab95f82.obscpio ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/META.json new/orafce-4.13.5+git0.ab95f82/META.json --- old/orafce-4.13.0+git3.25d74aa/META.json 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/META.json 2024-10-22 05:08:49.000000000 +0200 @@ -2,7 +2,7 @@ "name": "orafce", "abstract": "Oracle's compatibility functions and packages", "description": "This module allows use a well known Oracle's functions and packages inside PostgreSQL", - "version": "4.13.0", + "version": "4.13.5", "maintainer": [ "Pavel Stehule <[email protected]>", "Takahiro Itagaki <[email protected]>" @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.13.0", + "version": "4.13.5", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/builtins.h new/orafce-4.13.5+git0.ab95f82/builtins.h --- old/orafce-4.13.0+git3.25d74aa/builtins.h 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/builtins.h 2024-10-22 05:08:49.000000000 +0200 @@ -97,6 +97,8 @@ extern PGDLLEXPORT Datum orafce_sysdate(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum orafce_sessiontimezone(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum orafce_dbtimezone(PG_FUNCTION_ARGS); +extern PGDLLEXPORT Datum orafce_sys_extract_utc(PG_FUNCTION_ARGS); +extern PGDLLEXPORT Datum orafce_sys_extract_utc_oracle_date(PG_FUNCTION_ARGS); /* from file.c */ extern PGDLLEXPORT Datum utl_file_fopen(PG_FUNCTION_ARGS); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/datefce.c new/orafce-4.13.5+git0.ab95f82/datefce.c --- old/orafce-4.13.0+git3.25d74aa/datefce.c 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/datefce.c 2024-10-22 05:08:49.000000000 +0200 @@ -611,6 +611,13 @@ text *fmt_txt = PG_GETARG_TEXT_PP(1); Datum newDate; + /* + * With Oracle passing en empty string to to_date(txt, fmt) returns + * NULL, PostgreSQL returns 0001-01-01 BC whatever is the format. + */ + if (strlen(text_to_cstring(date_txt)) == 0) + PG_RETURN_NULL(); + /* it will return timestamp at GMT */ newDate = DirectFunctionCall2(to_timestamp, PointerGetDatum(date_txt), diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/expected/orafce.out new/orafce-4.13.5+git0.ab95f82/expected/orafce.out --- old/orafce-4.13.0+git3.25d74aa/expected/orafce.out 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/expected/orafce.out 2024-10-22 05:08:49.000000000 +0200 @@ -2614,6 +2614,12 @@ 2009-01-02 00:00:00 (1 row) +SELECT to_date('', 'yyyy-mm-dd'); + to_date +--------------- + 0001-01-01 BC +(1 row) + SELECT to_date('112012', 'J'); to_date --------------- @@ -2626,23 +2632,21 @@ 1003-03-15 (1 row) -SELECT oracle.to_date('112012', 'J'); - to_date ---------------------- - 4406-09-03 00:00:00 +SELECT oracle.to_date('', 'yyyy-mm-dd'); + to_date +--------- + (1 row) +SELECT oracle.to_date('112012', 'J'); +ERROR: Dates before 1582-10-05 ('J2299159') cannot be verified due to a bug in Oracle. SELECT oracle.to_date('1003-03-15', 'yyyy-mm-dd'); - to_date ---------------------- - 1003-03-15 00:00:00 -(1 row) - +ERROR: Dates before 1100-03-01 cannot be verified due to a bug in Oracle. SET orafce.oracle_compatibility_date_limit TO off; SELECT oracle.to_date('112012', 'J'); - to_date ---------------------- - 4406-09-03 00:00:00 + to_date +------------------------ + 4407-07-30 00:00:00 BC (1 row) SELECT oracle.to_date('1003/03/15', 'yyyy/mm/dd'); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/file.c new/orafce-4.13.5+git0.ab95f82/file.c --- old/orafce-4.13.0+git3.25d74aa/file.c 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/file.c 2024-10-22 05:08:49.000000000 +0200 @@ -192,7 +192,7 @@ if (!myextra) return false; - *myextra = (int) strtol(*newval, NULL, 10); + *myextra = (int) strtol(*newval, NULL, 8); *extra = (void *) myextra; return true; diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/orafce--4.12--4.13.sql new/orafce-4.13.5+git0.ab95f82/orafce--4.12--4.13.sql --- old/orafce-4.13.0+git3.25d74aa/orafce--4.12--4.13.sql 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/orafce--4.12--4.13.sql 2024-10-22 05:08:49.000000000 +0200 @@ -15,7 +15,7 @@ AS 'MODULE_PATHNAME','ora_to_date' LANGUAGE C STABLE STRICT PARALLEL SAFE; -CREATE FUNCTION oracle.to_date(TEXT, TEXT) +CREATE OR REPLACE FUNCTION oracle.to_date(TEXT, TEXT) RETURNS oracle.date AS $$ SELECT oracle.orafce__obsolete_to_date($1, $2)::oracle.date; $$ LANGUAGE SQL STABLE STRICT PARALLEL SAFE; diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/orafce.control new/orafce-4.13.5+git0.ab95f82/orafce.control --- old/orafce-4.13.0+git3.25d74aa/orafce.control 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/orafce.control 2024-10-22 05:08:49.000000000 +0200 @@ -1,5 +1,5 @@ # orafce extension comment = 'Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS' -default_version = '4.12' +default_version = '4.13' module_pathname = '$libdir/orafce' relocatable = false diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.13.0+git3.25d74aa/sql/orafce.sql new/orafce-4.13.5+git0.ab95f82/sql/orafce.sql --- old/orafce-4.13.0+git3.25d74aa/sql/orafce.sql 2024-09-24 19:52:38.000000000 +0200 +++ new/orafce-4.13.5+git0.ab95f82/sql/orafce.sql 2024-10-22 05:08:49.000000000 +0200 @@ -542,8 +542,10 @@ SELECT to_number(1210.73::numeric, 9999.99::numeric); SELECT to_date('2009-01-02'); +SELECT to_date('', 'yyyy-mm-dd'); SELECT to_date('112012', 'J'); SELECT to_date('1003/03/15', 'yyyy/mm/dd'); +SELECT oracle.to_date('', 'yyyy-mm-dd'); SELECT oracle.to_date('112012', 'J'); SELECT oracle.to_date('1003-03-15', 'yyyy-mm-dd'); SET orafce.oracle_compatibility_date_limit TO off; ++++++ orafce.obsinfo ++++++ --- /var/tmp/diff_new_pack.ileNlU/_old 2024-10-23 21:11:19.853326234 +0200 +++ /var/tmp/diff_new_pack.ileNlU/_new 2024-10-23 21:11:19.857326401 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.13.0+git3.25d74aa -mtime: 1727200358 -commit: 25d74aad957eda018f8da14decba996cc2ce32f2 +version: 4.13.5+git0.ab95f82 +mtime: 1729566529 +commit: ab95f8296486801e3f90d101e43a7528674399e0
