commit orafce for openSUSE:Factory
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-09-25 21:55:21 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.29891 (New) Package is "orafce" Wed Sep 25 21:55:21 2024 rev:22 rq:1203572 version:4.13.0+git3.25d74aa Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-09-16 17:45:28.062991326 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.29891/orafce.changes 2024-09-25 21:56:11.255509878 +0200 @@ -1,0 +2,19 @@ +Wed Sep 25 12:25:11 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.13.0+git3.25d74aa: + * Fix description of GUC orafce.varchar2_null_safe_concat + * Fix description of GUC orafce.varchar2_null_safe_concat + * fix regress tests + * Update README.asciidoc + * Fix documentation formatting. + * Add description of to_date(text,text) function and the error reported due to Oracle bug. + * Update regression test result with error message change. + * Raise an error when Oracle's to_date() bugs are reached. This concern dates before 1582-10-05 ('J2299159') usinf the 'J' format and dates before 1100-03-01 that cannot be verified due to a bug in Oracle. + * remove obsolete sql signature of dbms_alert.defered_signal + * update NEWS + * Remove the BC part of the Oracle like Julian Day date + * Fix wrong number of days add to julian day in to_char(text, text) function and add pg_catalog FQDN to the to_date() builtin function called. Add regression test. + * remove obsolete file + * Fix TO_DATE(text, text) function with the 'J' (Julian day) formatting. For Oracle this is the number of days since January 1, 4712 BC whereas for PostgreSQL this is the number of days since November 24, 4714 BC. + +--- Old: orafce-4.11.0+git0.72e1417.obscpio New: orafce-4.13.0+git3.25d74aa.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.xkWycF/_old 2024-09-25 21:56:11.927537830 +0200 +++ /var/tmp/diff_new_pack.xkWycF/_new 2024-09-25 21:56:11.927537830 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.11.0+git0.72e1417 +Version:4.13.0+git3.25d74aa Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.xkWycF/_old 2024-09-25 21:56:11.979539993 +0200 +++ /var/tmp/diff_new_pack.xkWycF/_new 2024-09-25 21:56:11.983540159 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 72e141760fb2dc69aaa3db969122c4ac4f0d1651 + 25d74aad957eda018f8da14decba996cc2ce32f2 (No newline at EOF) ++ orafce-4.11.0+git0.72e1417.obscpio -> orafce-4.13.0+git3.25d74aa.obscpio ++ 9002 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.xkWycF/_old 2024-09-25 21:56:12.199549144 +0200 +++ /var/tmp/diff_new_pack.xkWycF/_new 2024-09-25 21:56:12.203549310 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.11.0+git0.72e1417 -mtime: 1724051809 -commit: 72e141760fb2dc69aaa3db969122c4ac4f0d1651 +version: 4.13.0+git3.25d74aa +mtime: 1727200358 +commit: 25d74aad957eda018f8da14decba996cc2ce32f2
commit orafce for openSUSE:Factory
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-06-04 12:51:14 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.24587 (New) Package is "orafce" Tue Jun 4 12:51:14 2024 rev:19 rq:1178357 version:4.10.3+git0.e050dd6 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-05-24 19:51:59.519377371 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.24587/orafce.changes 2024-06-04 12:51:43.553121534 +0200 @@ -1,0 +2,7 @@ +Mon Jun 03 07:22:01 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.10.3+git0.e050dd6: + * prepare for 4.10.3 + * security check can be ignored when the value is configured by ALTER SYSTEM, and in reload the system is not in transactional state. fix #270 + +--- Old: orafce-4.10.2+git0.8d10ace.obscpio New: orafce-4.10.3+git0.e050dd6.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.IXk72T/_old 2024-06-04 12:51:44.337149985 +0200 +++ /var/tmp/diff_new_pack.IXk72T/_new 2024-06-04 12:51:44.337149985 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.10.2+git0.8d10ace +Version:4.10.3+git0.e050dd6 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.IXk72T/_old 2024-06-04 12:51:44.393152017 +0200 +++ /var/tmp/diff_new_pack.IXk72T/_new 2024-06-04 12:51:44.397152162 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 8d10acec102616d9825d2f6e1b7c9f8b25dbc7cd + e050dd6ab1eb66c71450421977c0356799c36cfc (No newline at EOF) ++ orafce-4.10.2+git0.8d10ace.obscpio -> orafce-4.10.3+git0.e050dd6.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.10.2+git0.8d10ace/META.json new/orafce-4.10.3+git0.e050dd6/META.json --- old/orafce-4.10.2+git0.8d10ace/META.json2024-05-20 19:36:36.0 +0200 +++ new/orafce-4.10.3+git0.e050dd6/META.json2024-05-29 09:29:23.0 +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.10.2", + "version": "4.10.3", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.10.2", + "version": "4.10.3", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.10.2+git0.8d10ace/file.c new/orafce-4.10.3+git0.e050dd6/file.c --- old/orafce-4.10.2+git0.8d10ace/file.c 2024-05-20 19:36:36.0 +0200 +++ new/orafce-4.10.3+git0.e050dd6/file.c 2024-05-29 09:29:23.0 +0200 @@ -146,7 +146,7 @@ char *ptr = *newval; int*myextra; - if (orafce_initialized && IsNormalProcessingMode()) + if (orafce_initialized && IsNormalProcessingMode() && IsTransactionState()) { if (!superuser()) { ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.IXk72T/_old 2024-06-04 12:51:44.61316 +0200 +++ /var/tmp/diff_new_pack.IXk72T/_new 2024-06-04 12:51:44.61316 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.10.2+git0.8d10ace -mtime: 1716226596 -commit: 8d10acec102616d9825d2f6e1b7c9f8b25dbc7cd +version: 4.10.3+git0.e050dd6 +mtime: 1716967763 +commit: e050dd6ab1eb66c71450421977c0356799c36cfc
commit orafce for openSUSE:Factory
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-05-24 19:51:43 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.24587 (New) Package is "orafce" Fri May 24 19:51:43 2024 rev:18 rq:1176510 version:4.10.2+git0.8d10ace Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-04-30 17:27:48.567152091 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.24587/orafce.changes 2024-05-24 19:51:59.519377371 +0200 @@ -1,0 +2,12 @@ +Thu May 23 08:51:44 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.10.2+git0.8d10ace: + * prepare for 4.10.2 + * When load of orafce was triggered by using some orafce's function by nonprivileged user, then the check orafce_umask_check_hook fails and breaks loading of Orafce. This fix disable check in initialization time when orafce_umask is set to default value (so the check can be disabled). + * prepare for 4.10.1 + * regress tests for issues #266 and #267 + * fix obsolete (and broken) implementation of dbms_assert.qualified_sql_name + * fix not correct test of identifier validity in dbms_assert.simple_sql_name + * Add an alternative output for test dbms_random (Illumos) + +--- Old: orafce-4.10.0+git0.cfdcdf2.obscpio New: orafce-4.10.2+git0.8d10ace.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.eEHfcH/_old 2024-05-24 19:52:00.631418050 +0200 +++ /var/tmp/diff_new_pack.eEHfcH/_new 2024-05-24 19:52:00.635418197 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.10.0+git0.cfdcdf2 +Version:4.10.2+git0.8d10ace Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.eEHfcH/_old 2024-05-24 19:52:00.683419952 +0200 +++ /var/tmp/diff_new_pack.eEHfcH/_new 2024-05-24 19:52:00.687420099 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - cfdcdf258f7dc3ca5586bdbe7e6f472b672cdbc5 + 8d10acec102616d9825d2f6e1b7c9f8b25dbc7cd (No newline at EOF) ++ orafce-4.10.0+git0.cfdcdf2.obscpio -> orafce-4.10.2+git0.8d10ace.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.10.0+git0.cfdcdf2/META.json new/orafce-4.10.2+git0.8d10ace/META.json --- old/orafce-4.10.0+git0.cfdcdf2/META.json2024-04-25 12:49:24.0 +0200 +++ new/orafce-4.10.2+git0.8d10ace/META.json2024-05-20 19:36:36.0 +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.10.0", + "version": "4.10.2", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.10.0", + "version": "4.10.2", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.10.0+git0.cfdcdf2/assert.c new/orafce-4.10.2+git0.8d10ace/assert.c --- old/orafce-4.10.0+git0.cfdcdf2/assert.c 2024-04-25 12:49:24.0 +0200 +++ new/orafce-4.10.2+git0.8d10ace/assert.c 2024-05-20 19:36:36.0 +0200 @@ -50,6 +50,38 @@ static bool ParseIdentifierString(char *rawstring); /* + * Is character a valid identifier start? + * Must match scan.l's {ident_start} character class. + */ +static bool +orafce_is_ident_start(unsigned char c) +{ + /* Underscores and ASCII letters are OK */ + if (c == '_') + return true; + if ((c >= 'a' && c <= 'z') || (c >= 'A' && c <= 'Z')) + return true; + /* Any high-bit-set character is OK (might be part of a multibyte char) */ + if (IS_HIGHBIT_SET(c)) + return true; + return false; +} + +/* + * Is character a valid identifier continuation? + * Must match scan.l's {ident_cont} character class. + */ +static bool +orafce_is_ident_cont(unsigned char c) +{ + /* Can be digit or dollar sign ... */ + if ((c >= '0' && c <= '9') || c == '$') + return true; + /* ... or an identifier start character */ + return orafce_is_ident_start(c); +} + +/* * Procedure ParseIdentifierString is based on
commit orafce for openSUSE:Factory
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-04-30 17:26:47 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1880 (New) Package is "orafce" Tue Apr 30 17:26:47 2024 rev:17 rq:1170706 version:4.10.0+git0.cfdcdf2 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-04-11 19:42:13.432137236 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.1880/orafce.changes 2024-04-30 17:27:48.567152091 +0200 @@ -1,0 +2,7 @@ +Mon Apr 29 08:24:22 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.10.0+git0.cfdcdf2: + * remove whitechar + * Allow to set umask for utl_file.fopen by setting orafce.umask. This setting is allowed only for user with rights of role orafce_set_umask. + +--- Old: orafce-4.9.4+git0.6f3b83a.obscpio New: orafce-4.10.0+git0.cfdcdf2.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.8gslyW/_old 2024-04-30 17:27:49.715193840 +0200 +++ /var/tmp/diff_new_pack.8gslyW/_new 2024-04-30 17:27:49.719193985 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.9.4+git0.6f3b83a +Version:4.10.0+git0.cfdcdf2 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.8gslyW/_old 2024-04-30 17:27:49.775196022 +0200 +++ /var/tmp/diff_new_pack.8gslyW/_new 2024-04-30 17:27:49.783196313 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 6f3b83ada8fc2c0da3719ff615f318d34daa8ea6 + cfdcdf258f7dc3ca5586bdbe7e6f472b672cdbc5 (No newline at EOF) ++ orafce-4.9.4+git0.6f3b83a.obscpio -> orafce-4.10.0+git0.cfdcdf2.obscpio ++ 8876 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.8gslyW/_old 2024-04-30 17:27:50.011204605 +0200 +++ /var/tmp/diff_new_pack.8gslyW/_new 2024-04-30 17:27:50.015204750 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.9.4+git0.6f3b83a -mtime: 1712718664 -commit: 6f3b83ada8fc2c0da3719ff615f318d34daa8ea6 +version: 4.10.0+git0.cfdcdf2 +mtime: 1714042164 +commit: cfdcdf258f7dc3ca5586bdbe7e6f472b672cdbc5
commit orafce for openSUSE:Factory
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-03-07 18:30:56 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1770 (New) Package is "orafce" Thu Mar 7 18:30:56 2024 rev:15 rq:1155895 version:4.9.3+git0.6adbd66 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-02-08 19:03:09.373247497 +0100 +++ /work/SRC/openSUSE:Factory/.orafce.new.1770/orafce.changes 2024-03-07 18:32:25.66768 +0100 @@ -1,0 +2,11 @@ +Thu Mar 07 12:13:12 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.9.3+git0.6adbd66: + * prepare for 4.9.3 + * fix regress tests + * fix broken handling null in dbms_sql.column_value + * fix build for master (pg17+) + * possibility to raise error inside trigger functions + * fix regress test on fc40 + +--- Old: orafce-4.9.2+git0.17c9ce4.obscpio New: orafce-4.9.3+git0.6adbd66.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.fh64Nk/_old 2024-03-07 18:32:26.167699562 +0100 +++ /var/tmp/diff_new_pack.fh64Nk/_new 2024-03-07 18:32:26.167699562 +0100 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.9.2+git0.17c9ce4 +Version:4.9.3+git0.6adbd66 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.fh64Nk/_old 2024-03-07 18:32:26.219701480 +0100 +++ /var/tmp/diff_new_pack.fh64Nk/_new 2024-03-07 18:32:26.223701628 +0100 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 17c9ce474b254ff2ee868aa02ff23cfdf0726a85 + 6adbd66c429dabb828f10d764d356824efeb8396 (No newline at EOF) ++ orafce-4.9.2+git0.17c9ce4.obscpio -> orafce-4.9.3+git0.6adbd66.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.9.2+git0.17c9ce4/META.json new/orafce-4.9.3+git0.6adbd66/META.json --- old/orafce-4.9.2+git0.17c9ce4/META.json 2024-02-08 05:20:56.0 +0100 +++ new/orafce-4.9.3+git0.6adbd66/META.json 2024-03-06 16:43:44.0 +0100 @@ -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.9.2", + "version": "4.9.3", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.9.2", + "version": "4.9.3", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.9.2+git0.17c9ce4/README.asciidoc new/orafce-4.9.3+git0.6adbd66/README.asciidoc --- old/orafce-4.9.2+git0.17c9ce4/README.asciidoc 2024-02-08 05:20:56.0 +0100 +++ new/orafce-4.9.3+git0.6adbd66/README.asciidoc 2024-03-06 16:43:44.0 +0100 @@ -883,12 +883,12 @@ This can be enusured with trigger functions: -oracle.replace_empty_strings([raise_warnings boolean]) -oracle.replace_null_strings([raise_warnings boolean]) +oracle.replace_empty_strings([ 'on' | 'true' | 'warning' | 'error' ]) +oracle.replace_null_strings([ 'on' | 'true' | 'warning' | 'error' ]) -Optional boolean argument is used as indicator so these functions should to -raise warning when row was changed inside these functions. +Optional string argument is used as indicator so these functions should to +raise warning (possibly error) when row was changed inside these functions. CREATE TABLE test(id serial, name varchar, surname varchar); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.9.2+git0.17c9ce4/alert.c new/orafce-4.9.3+git0.6adbd66/alert.c --- old/orafce-4.9.2+git0.17c9ce4/alert.c 2024-02-08 05:20:56.0 +0100 +++ new/orafce-4.9.3+git0.6adbd66/alert.c 2024-03-06 16:43:44.0 +0100 @@ -74,6 +74,16 @@ /* in sec 1000 days */ #define MAXWAIT8640 +#if PG_VERSION_NUM >= 17 + +#define CURRENT_LXID (MyProc->vxid.lxid) + +#else + +#define CURRENT_LXID (MyProc->lxid) + +#endif + static void unregister_event(int event_id, int sid); static char* find_and_remove_message_item(int message_id, int sid, @@ -1087,7 +1097,7 @@
commit orafce for openSUSE:Factory
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-02-08 19:02:58 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1815 (New) Package is "orafce" Thu Feb 8 19:02:58 2024 rev:14 rq:1145078 version:4.9.2+git0.17c9ce4 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2024-01-29 22:32:28.120943896 +0100 +++ /work/SRC/openSUSE:Factory/.orafce.new.1815/orafce.changes 2024-02-08 19:03:09.373247497 +0100 @@ -1,0 +2,15 @@ +Thu Feb 08 08:43:18 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.9.2+git0.17c9ce4: + * prepare for 4.9.2 + * Update the usage example for DBMS_OUTPUT package. + * fix memory issues in plvlex.token function + * fix sqlscanner typecast has not assigned yylval.val.str field + * should not to crash, when we try to read column without data + * fix regress tests + * dont't try to free byref null variable + * result_cxt schema can be used only after successfull execution #254 (second part) + * fix crash of dbms_sql.execute when bound array variable is NULL #254 + * added an alternative output for test dbms_random (Windows) + +--- Old: orafce-4.9.1+git0.1071eb6.obscpio New: orafce-4.9.2+git0.17c9ce4.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.dGRIZb/_old 2024-02-08 19:03:10.153275694 +0100 +++ /var/tmp/diff_new_pack.dGRIZb/_new 2024-02-08 19:03:10.157275838 +0100 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.9.1+git0.1071eb6 +Version:4.9.2+git0.17c9ce4 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.dGRIZb/_old 2024-02-08 19:03:10.213277863 +0100 +++ /var/tmp/diff_new_pack.dGRIZb/_new 2024-02-08 19:03:10.213277863 +0100 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 1071eb658945973396144a8a6b7b8fb74cfa6047 + 17c9ce474b254ff2ee868aa02ff23cfdf0726a85 (No newline at EOF) ++ orafce-4.9.1+git0.1071eb6.obscpio -> orafce-4.9.2+git0.17c9ce4.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.9.1+git0.1071eb6/META.json new/orafce-4.9.2+git0.17c9ce4/META.json --- old/orafce-4.9.1+git0.1071eb6/META.json 2024-01-28 08:49:25.0 +0100 +++ new/orafce-4.9.2+git0.17c9ce4/META.json 2024-02-08 05:20:56.0 +0100 @@ -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.9.1", + "version": "4.9.2", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.9.1", + "version": "4.9.2", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.9.1+git0.1071eb6/dbms_sql.c new/orafce-4.9.2+git0.17c9ce4/dbms_sql.c --- old/orafce-4.9.1+git0.1071eb6/dbms_sql.c2024-01-28 08:49:25.0 +0100 +++ new/orafce-4.9.2+git0.17c9ce4/dbms_sql.c2024-02-08 05:20:56.0 +0100 @@ -535,8 +535,11 @@ if (var->typoid != InvalidOid) { - if (!var->typbyval) + if (!var->typbyval && !var->isnull) + { pfree(DatumGetPointer(var->value)); + var->value = (Datum) 0; + } var->isnull = true; } @@ -621,6 +624,17 @@ (errcode(ERRCODE_DATATYPE_MISMATCH), errmsg("value is not a array"))); + if (var->typoid != InvalidOid) + { + if (!var->typbyval && !var->isnull) + { + pfree(DatumGetPointer(var->value)); + var->value = (Datum) 0; + } + + var->isnull = true; + } + var->is_array = true; var->typoid = valtype; var->typelemid = elementtype; @@ -887,6 +901,7 @@ CursorData *cur = (CursorData *) arg; cur->cursor_xact_cxt = NULL; + cur->result_cxt = NULL; cur->tuples_cxt = NULL; cur->processed = 0; @@ -1278,7 +
commit orafce for openSUSE:Factory
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-01-03 12:29:24 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.28375 (New) Package is "orafce" Wed Jan 3 12:29:24 2024 rev:12 rq:1136070 version:4.9.0+git0.18d82db Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-10-13 23:16:21.474686255 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.28375/orafce.changes 2024-01-03 12:30:10.478843605 +0100 @@ -1,0 +2,19 @@ +Tue Jan 02 08:18:51 UTC 2024 - emiliano.lange...@suse.com + +- Update to version 4.9.0+git0.18d82db: + * prepare for 4.9.0 + * Fix REGEXP_COUNT and REGEXP_SUBSTR function to have the same behavior than Oracle with newline characters and the use of dot in the pattern. + * Added a test case about dbms_sql.debug_cursor + * don't try to show content of variable when it is null. fix issue #247 + * mark some func parallel safe + * When third argument of substr function is zero, then oracle returns null, but orafce returns empty string. This commit forces oracle's behaviour by default, but allows (by compatibility option orafce.using_substring_zero_width_in_substr set original orafce's behaviour. fix issue #240 + * copy to_char(text) from orafce--4.7--4.8.sql to orafce--4.8.sql + * mark some func parallel safe; fix makefile + * add orafce--4.8.sql (rename orafce--4.7.sql) + * add func: to_char(text) + * mark lpad, rpad, to_char, to_number parallel safe + * mark btrim,ltrim,rtrim parallel(because not support postgres version < 9.6, so directly change it) + * doesn't support postgresql extensions + * Create c-cpp.yml + +--- Old: orafce-4.7.0+git1.fca4108.obscpio New: orafce-4.9.0+git0.18d82db.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.iLY4f6/_old 2024-01-03 12:30:11.734889483 +0100 +++ /var/tmp/diff_new_pack.iLY4f6/_new 2024-01-03 12:30:11.738889628 +0100 @@ -1,7 +1,7 @@ # # spec file # -# Copyright (c) 2023 SUSE LLC +# Copyright (c) 2024 SUSE LLC # # All modifications and additions to the file contributed by third parties # remain the property of their copyright owners, unless otherwise agreed @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.7.0+git1.fca4108 +Version:4.9.0+git0.18d82db Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.iLY4f6/_old 2024-01-03 12:30:11.814892405 +0100 +++ /var/tmp/diff_new_pack.iLY4f6/_new 2024-01-03 12:30:11.818892550 +0100 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - fca41081278248956a28ea0fbaea72b1fa1bccda + 18d82dbf6a2a71474ef0ad2f68b0974b2f8381d8 (No newline at EOF) ++ orafce-4.7.0+git1.fca4108.obscpio -> orafce-4.9.0+git0.18d82db.obscpio ++ 9721 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.iLY4f6/_old 2024-01-03 12:30:12.106903070 +0100 +++ /var/tmp/diff_new_pack.iLY4f6/_new 2024-01-03 12:30:12.110903216 +0100 @@ -1,5 +1,5 @@ name: orafce -version: 4.7.0+git1.fca4108 -mtime: 1697183261 -commit: fca41081278248956a28ea0fbaea72b1fa1bccda +version: 4.9.0+git0.18d82db +mtime: 1703953812 +commit: 18d82dbf6a2a71474ef0ad2f68b0974b2f8381d8
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-10-13 23:15:20 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.20540 (New) Package is "orafce" Fri Oct 13 23:15:20 2023 rev:11 rq:1117596 version:4.7.0+git1.fca4108 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-09-25 20:53:31.051210568 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.20540/orafce.changes 2023-10-13 23:16:21.474686255 +0200 @@ -1,0 +2,12 @@ +Fri Oct 13 07:52:00 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.7.0+git1.fca4108: + * changes related to msvc 2019 build + * remainder function should be marked STRICT (#225) + +--- +Thu Sep 28 21:00:25 UTC 2023 - Marcus Rueckert + +- enable pg 16 + +--- Old: orafce-4.6.1+git0.8785767.obscpio New: orafce-4.7.0+git1.fca4108.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.RKcHvo/_old 2023-10-13 23:16:22.022706133 +0200 +++ /var/tmp/diff_new_pack.RKcHvo/_new 2023-10-13 23:16:22.022706133 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.6.1+git0.8785767 +Version:4.7.0+git1.fca4108 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _multibuild ++ --- /var/tmp/diff_new_pack.RKcHvo/_old 2023-10-13 23:16:22.054707294 +0200 +++ /var/tmp/diff_new_pack.RKcHvo/_new 2023-10-13 23:16:22.054707294 +0200 @@ -4,5 +4,6 @@ postgresql13 postgresql14 postgresql15 + postgresql16 ++ _servicedata ++ --- /var/tmp/diff_new_pack.RKcHvo/_old 2023-10-13 23:16:22.086708454 +0200 +++ /var/tmp/diff_new_pack.RKcHvo/_new 2023-10-13 23:16:22.090708599 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 8785767a0755b6982d6022d3adf4f99135306dd0 + fca41081278248956a28ea0fbaea72b1fa1bccda (No newline at EOF) ++ orafce-4.6.1+git0.8785767.obscpio -> orafce-4.7.0+git1.fca4108.obscpio ++ 8639 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.RKcHvo/_old 2023-10-13 23:16:22.302716289 +0200 +++ /var/tmp/diff_new_pack.RKcHvo/_new 2023-10-13 23:16:22.306716434 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.6.1+git0.8785767 -mtime: 1695620225 -commit: 8785767a0755b6982d6022d3adf4f99135306dd0 +version: 4.7.0+git1.fca4108 +mtime: 1697183261 +commit: fca41081278248956a28ea0fbaea72b1fa1bccda
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-09-25 20:03:48 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1770 (New) Package is "orafce" Mon Sep 25 20:03:48 2023 rev:10 rq:1113379 version:4.6.1+git0.8785767 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-09-08 21:17:23.842452309 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.1770/orafce.changes 2023-09-25 20:53:31.051210568 +0200 @@ -1,0 +2,7 @@ +Mon Sep 25 07:51:11 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.6.1+git0.8785767: + * prepare for 4.6.1 + * return back dbms_alert_defered_signal header necessary for upgrade - #231 + +--- Old: orafce-4.6.0+git0.6020b1e.obscpio New: orafce-4.6.1+git0.8785767.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.IEBm5y/_old 2023-09-25 20:53:32.895277186 +0200 +++ /var/tmp/diff_new_pack.IEBm5y/_new 2023-09-25 20:53:32.895277186 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.6.0+git0.6020b1e +Version:4.6.1+git0.8785767 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.IEBm5y/_old 2023-09-25 20:53:32.939278776 +0200 +++ /var/tmp/diff_new_pack.IEBm5y/_new 2023-09-25 20:53:32.943278920 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 6020b1e1f8c519b748b6784a76537b22a6938389 + 8785767a0755b6982d6022d3adf4f99135306dd0 (No newline at EOF) ++ orafce-4.6.0+git0.6020b1e.obscpio -> orafce-4.6.1+git0.8785767.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.6.0+git0.6020b1e/META.json new/orafce-4.6.1+git0.8785767/META.json --- old/orafce-4.6.0+git0.6020b1e/META.json 2023-09-01 08:25:22.0 +0200 +++ new/orafce-4.6.1+git0.8785767/META.json 2023-09-25 07:37:05.0 +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.6.0", + "version": "4.6.1", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.6.0", + "version": "4.6.1", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.6.0+git0.6020b1e/alert.c new/orafce-4.6.1+git0.8785767/alert.c --- old/orafce-4.6.0+git0.6020b1e/alert.c 2023-09-01 08:25:22.0 +0200 +++ new/orafce-4.6.1+git0.8785767/alert.c 2023-09-25 07:37:05.0 +0200 @@ -1211,3 +1211,13 @@ PG_RETURN_VOID(); } + +/* + * removed by Orafce 9.6, header is necessary to allow upgrade + * + */ +Datum +dbms_alert_defered_signal(PG_FUNCTION_ARGS) +{ + PG_RETURN_NULL(); +} diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.6.0+git0.6020b1e/assert.c new/orafce-4.6.1+git0.8785767/assert.c --- old/orafce-4.6.0+git0.6020b1e/assert.c 2023-09-01 08:25:22.0 +0200 +++ new/orafce-4.6.1+git0.8785767/assert.c 2023-09-25 07:37:05.0 +0200 @@ -24,6 +24,7 @@ PG_FUNCTION_INFO_V1(dbms_assert_schema_name); PG_FUNCTION_INFO_V1(dbms_assert_simple_sql_name); PG_FUNCTION_INFO_V1(dbms_assert_object_name); +PG_FUNCTION_INFO_V1(dbms_alert_defered_signal); #define CUSTOM_EXCEPTION(code, msg) \ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.6.0+git0.6020b1e/builtins.h new/orafce-4.6.1+git0.8785767/builtins.h --- old/orafce-4.6.0+git0.6020b1e/builtins.h2023-09-01 08:25:22.0 +0200 +++ new/orafce-4.6.1+git0.8785767/builtins.h2023-09-25 07:37:05.0 +0200 @@ -58,6 +58,7 @@ extern PGDLLEXPORT Datum dbms_alert_waitone(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum dbms_alert_waitany_maxwait(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum dbms_alert_waitone_maxwait(PG_FUNCTION_ARGS); +extern PGDLLEXPORT Datum dbms_alert_defered_signal(PG_FUNCTION_ARGS); /* from assert.c */ extern PGDLLEXPORT Datum dbms_assert_enquote_literal(PG_FUNCTION_ARGS); ++ orafce.obs
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-09-08 21:16:19 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1766 (New) Package is "orafce" Fri Sep 8 21:16:19 2023 rev:9 rq:1109734 version:4.6.0+git0.6020b1e Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-08-07 15:29:48.276576849 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.1766/orafce.changes 2023-09-08 21:17:23.842452309 +0200 @@ -1,0 +2,10 @@ +Fri Sep 08 13:49:42 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.6.0+git0.6020b1e: + * fix the comment error + * Fix a condition to make code reachable + * fix regress tests on mswin + * remove white chars + * describe changes in dbms_alert + +--- Old: orafce-4.5.0+git8.b3ad258.obscpio New: orafce-4.6.0+git0.6020b1e.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.5P2lzj/_old 2023-09-08 21:17:25.114497862 +0200 +++ /var/tmp/diff_new_pack.5P2lzj/_new 2023-09-08 21:17:25.118498006 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.5.0+git8.b3ad258 +Version:4.6.0+git0.6020b1e Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.5P2lzj/_old 2023-09-08 21:17:25.178500154 +0200 +++ /var/tmp/diff_new_pack.5P2lzj/_new 2023-09-08 21:17:25.182500297 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - b3ad258852b6e5e15e3a516fb0f53accdc4f9d6a + 6020b1e1f8c519b748b6784a76537b22a6938389 (No newline at EOF) ++ orafce-4.5.0+git8.b3ad258.obscpio -> orafce-4.6.0+git0.6020b1e.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.5.0+git8.b3ad258/NEWS new/orafce-4.6.0+git0.6020b1e/NEWS --- old/orafce-4.5.0+git8.b3ad258/NEWS 2023-08-07 08:58:46.0 +0200 +++ new/orafce-4.6.0+git0.6020b1e/NEWS 2023-09-01 08:25:22.0 +0200 @@ -1,5 +1,10 @@ Orafce News - History of user-visible changes -Copyright (C) 2008-2022 Orafce Global Development Group +Copyright (C) 2008-2023 Orafce Global Development Group + +Version 4.6.0 - +* emit signal by XactCallback instead deferred trigger, store not yet emmited events in + transaction scope memory instead in temporary table. New solution strongly reduces delay + (and CPU usage), but ensures visible changes to outside of transaction that emmited signal. Version 4.5.0 - 5 Aug 2023 * partial rewriting of dbms_pipe. Now, the synchronization is based on signals instead short sleeping. diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.5.0+git8.b3ad258/dbms_sql.c new/orafce-4.6.0+git0.6020b1e/dbms_sql.c --- old/orafce-4.5.0+git8.b3ad258/dbms_sql.c2023-08-07 08:58:46.0 +0200 +++ new/orafce-4.6.0+git0.6020b1e/dbms_sql.c2023-09-01 08:25:22.0 +0200 @@ -234,7 +234,7 @@ errmsg("cursor id is NULL"))); cid = PG_GETARG_INT32(0); - if (cid < 0 && cid >= MAX_CURSORS) + if (cid < 0 || cid >= MAX_CURSORS) ereport(ERROR, (errcode(ERRCODE_INVALID_PARAMETER_VALUE), errmsg("value of cursor id is out of range"))); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.5.0+git8.b3ad258/expected/dbms_random_2.out new/orafce-4.6.0+git0.6020b1e/expected/dbms_random_2.out --- old/orafce-4.5.0+git8.b3ad258/expected/dbms_random_2.out2023-08-07 08:58:46.0 +0200 +++ new/orafce-4.6.0+git0.6020b1e/expected/dbms_random_2.out2023-09-01 08:25:22.0 +0200 @@ -44,7 +44,7 @@ SELECT dbms_random.string('P',2); string - fo + go (1 row) SELECT dbms_random.string('x',4); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.5.0+git8.b3ad258/math.c new/orafce-4.6.0+git0.6020b1e/math.c --- old/orafce-4.5.0+git8.b3ad258/math.c2023-08-07 08:58:46.0 +0200 +++ new/orafce-4.6.0+git0.6020b1e/math.c2023-09-01 08:25:22.0 +0200 @@ -43,7 +43,7 @@ /* * CREATE OR REPLACE FUNCTION oracle.remainder(int, int) - * RETURNS smallint + * RETURNS int */ Datum orafce_reminder_int(PG_FUNCTION_ARGS) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-08-07 15:29:23 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.22712 (New) Package is "orafce" Mon Aug 7 15:29:23 2023 rev:8 rq:1102645 version:4.5.0+git8.b3ad258 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-07-10 16:40:14.862666950 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.22712/orafce.changes 2023-08-07 15:29:48.276576849 +0200 @@ -1,0 +2,21 @@ +Mon Aug 07 07:39:21 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.5.0+git8.b3ad258: + * better comment + * fix issue reported by cppcheck, all tests passed + * test passed except pg 17 + * fix + * code cleaning + * formatting + * use condition variable for synchronization of dbms_alert waiting on signal + * formatting + * typo + * prepare for 4.5.0 + * detect different identity of pipe after wakeup + * fix issues reported by cppcheck + * decrease timeout as protection against deadlocks + * using ConditionVariables for synchronization dbms_pipe writer and dbms_pipe reader + * fix isses reported by cppcheck + * fix issues reported by cppcheck + +--- Old: orafce-4.4.0+git0.eb5513d.obscpio New: orafce-4.5.0+git8.b3ad258.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.Go2Z39/_old 2023-08-07 15:29:48.900580680 +0200 +++ /var/tmp/diff_new_pack.Go2Z39/_new 2023-08-07 15:29:48.904580704 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.4.0+git0.eb5513d +Version:4.5.0+git8.b3ad258 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.Go2Z39/_old 2023-08-07 15:29:48.952580999 +0200 +++ /var/tmp/diff_new_pack.Go2Z39/_new 2023-08-07 15:29:48.956581024 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - eb5513d25cbf78798b91405040d76c33f4d61cb7 + b3ad258852b6e5e15e3a516fb0f53accdc4f9d6a (No newline at EOF) ++ orafce-4.4.0+git0.eb5513d.obscpio -> orafce-4.5.0+git8.b3ad258.obscpio ++ 11958 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.Go2Z39/_old 2023-08-07 15:29:49.244582792 +0200 +++ /var/tmp/diff_new_pack.Go2Z39/_new 2023-08-07 15:29:49.244582792 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.4.0+git0.eb5513d -mtime: 1688452996 -commit: eb5513d25cbf78798b91405040d76c33f4d61cb7 +version: 4.5.0+git8.b3ad258 +mtime: 1691391526 +commit: b3ad258852b6e5e15e3a516fb0f53accdc4f9d6a
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-07-10 16:40:08 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.23466 (New) Package is "orafce" Mon Jul 10 16:40:08 2023 rev:7 rq:1097879 version:4.4.0+git0.eb5513d Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-06-05 18:06:58.467263613 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.23466/orafce.changes 2023-07-10 16:40:14.862666950 +0200 @@ -1,0 +2,7 @@ +Mon Jul 10 07:03:35 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.4.0+git0.eb5513d: + * update version info and year + * regexp_x functions should be immutable + +--- Old: orafce-4.3.0+git0.fac8b9c.obscpio New: orafce-4.4.0+git0.eb5513d.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.eaTd2D/_old 2023-07-10 16:40:16.634677511 +0200 +++ /var/tmp/diff_new_pack.eaTd2D/_new 2023-07-10 16:40:16.638677535 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.3.0+git0.fac8b9c +Version:4.4.0+git0.eb5513d Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.eaTd2D/_old 2023-07-10 16:40:16.694677869 +0200 +++ /var/tmp/diff_new_pack.eaTd2D/_new 2023-07-10 16:40:16.698677892 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - fac8b9cd8fd9b2b9fd0298734c37e91cca00bbbc + eb5513d25cbf78798b91405040d76c33f4d61cb7 (No newline at EOF) ++ orafce-4.3.0+git0.fac8b9c.obscpio -> orafce-4.4.0+git0.eb5513d.obscpio ++ 8627 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.eaTd2D/_old 2023-07-10 16:40:16.934679299 +0200 +++ /var/tmp/diff_new_pack.eaTd2D/_new 2023-07-10 16:40:16.938679323 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.3.0+git0.fac8b9c -mtime: 1685592265 -commit: fac8b9cd8fd9b2b9fd0298734c37e91cca00bbbc +version: 4.4.0+git0.eb5513d +mtime: 1688452996 +commit: eb5513d25cbf78798b91405040d76c33f4d61cb7
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-06-05 18:06:56 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.15902 (New) Package is "orafce" Mon Jun 5 18:06:56 2023 rev:6 rq:1090776 version:4.3.0+git0.fac8b9c Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-05-01 18:51:39.605525776 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.15902/orafce.changes 2023-06-05 18:06:58.467263613 +0200 @@ -1,0 +2,8 @@ +Thu Jun 01 13:02:42 UTC 2023 - emiliano.lange...@suse.com + +- Update to version VERSION_4.3.0+git0.fac8b9c: + * fix regress test for dbms_random.string + * add chars '\' and '~' to list of printable chars for function dbms_random.string + * fix dbms_random should not be immutable (Issue #222) + +--- Old: orafce-4.2.6+git0.86d7f4c.obscpio New: orafce-4.3.0+git0.fac8b9c.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.7sbHNK/_old 2023-06-05 18:06:59.779271361 +0200 +++ /var/tmp/diff_new_pack.7sbHNK/_new 2023-06-05 18:06:59.783271385 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.2.6+git0.86d7f4c +Version:4.3.0+git0.fac8b9c Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _service ++ --- /var/tmp/diff_new_pack.7sbHNK/_old 2023-06-05 18:06:59.827271645 +0200 +++ /var/tmp/diff_new_pack.7sbHNK/_new 2023-06-05 18:06:59.831271668 +0200 @@ -2,7 +2,7 @@ https://github.com/orafce/orafce.git @PARENT_TAG@+git@TAG_OFFSET@.%h -VERSION_(\d+)_(\d+)_(\d+)(.*) +VERSION_(\d+).(\d+).(\d+)(.*) \1.\2.\3\4 master git ++ _servicedata ++ --- /var/tmp/diff_new_pack.7sbHNK/_old 2023-06-05 18:06:59.851271786 +0200 +++ /var/tmp/diff_new_pack.7sbHNK/_new 2023-06-05 18:06:59.855271810 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 86d7f4c925483c62e400b675770d6497856439ab + fac8b9cd8fd9b2b9fd0298734c37e91cca00bbbc (No newline at EOF) ++ orafce-4.2.6+git0.86d7f4c.obscpio -> orafce-4.3.0+git0.fac8b9c.obscpio ++ 8611 lines of diff (skipped) ++ orafce.obsinfo ++ --- /var/tmp/diff_new_pack.7sbHNK/_old 2023-06-05 18:07:00.063273039 +0200 +++ /var/tmp/diff_new_pack.7sbHNK/_new 2023-06-05 18:07:00.063273039 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.2.6+git0.86d7f4c -mtime: 1682918261 -commit: 86d7f4c925483c62e400b675770d6497856439ab +version: 4.3.0+git0.fac8b9c +mtime: 1685592265 +commit: fac8b9cd8fd9b2b9fd0298734c37e91cca00bbbc
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-05-01 18:51:38 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1533 (New) Package is "orafce" Mon May 1 18:51:38 2023 rev:5 rq:1083867 version:4.2.6+git0.86d7f4c Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-04-03 17:45:46.582754194 +0200 +++ /work/SRC/openSUSE:Factory/.orafce.new.1533/orafce.changes 2023-05-01 18:51:39.605525776 +0200 @@ -1,0 +2,10 @@ +Mon May 01 13:53:04 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.2.6+git0.86d7f4c: + * prepare for 4.2.6 + * fix corner case of instr function (be fully compatible with Oracle) see #221 + * prepare for 4.2.5 + * fix copy/paste bug + * use MoveFileEx function instead replace function on win32 + +--- Old: orafce-4.2.4+git0.2499240.obscpio New: orafce-4.2.6+git0.86d7f4c.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.71BLnY/_old 2023-05-01 18:51:41.777538670 +0200 +++ /var/tmp/diff_new_pack.71BLnY/_new 2023-05-01 18:51:41.817538907 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.2.4+git0.2499240 +Version:4.2.6+git0.86d7f4c Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.71BLnY/_old 2023-05-01 18:51:42.281541661 +0200 +++ /var/tmp/diff_new_pack.71BLnY/_new 2023-05-01 18:51:42.305541804 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 24992406c27786f007d3eb2afe9dc64475fd3a68 + 86d7f4c925483c62e400b675770d6497856439ab (No newline at EOF) ++ orafce-4.2.4+git0.2499240.obscpio -> orafce-4.2.6+git0.86d7f4c.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.4+git0.2499240/META.json new/orafce-4.2.6+git0.86d7f4c/META.json --- old/orafce-4.2.4+git0.2499240/META.json 2023-04-02 09:21:09.0 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/META.json 2023-05-01 07:17:41.0 +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.2.4", + "version": "4.2.6", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.2.4", + "version": "4.2.6", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.4+git0.2499240/expected/orafce.out new/orafce-4.2.6+git0.86d7f4c/expected/orafce.out --- old/orafce-4.2.4+git0.2499240/expected/orafce.out 2023-04-02 09:21:09.0 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/expected/orafce.out 2023-05-01 07:17:41.0 +0200 @@ -1155,6 +1155,12 @@ t (1 row) +select 0 = instr('ab;cdx', ';', 0); + ?column? +-- + t +(1 row) + select oracle.substr('This is a test', 6, 2) = 'is'; ?column? -- diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.4+git0.2499240/file.c new/orafce-4.2.6+git0.86d7f4c/file.c --- old/orafce-4.2.4+git0.2499240/file.c2023-04-02 09:21:09.0 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/file.c2023-05-01 07:17:41.0 +0200 @@ -1092,8 +1092,11 @@ IO_EXCEPTION(); } - /* rename() overwrites existing files. */ - if (_wrename(_srcpath, _dstpath) != 0) + /* +* Originaly there was rename() function, but this cannot +* to replace other existing file. +*/ + if (!MoveFileExW(_srcpath, _dstpath, MOVEFILE_REPLACE_EXISTING)) IO_EXCEPTION(); pfree(_dstpath); @@ -1110,8 +1113,7 @@ IO_EXCEPTION(); } - /* rename() overwrites existing files. */ - if (rename(srcpath, dstpath) != 0) + if (!MoveFileEx(srcpath, dstpath, MOVEFILE_REPLACE_EXISTING)) IO_EXCEPTION(); } diff -urN '--exclude=CVS' '--e
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-04-03 17:45:45 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.9019 (New) Package is "orafce" Mon Apr 3 17:45:45 2023 rev:4 rq:1076778 version:4.2.4+git0.2499240 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-03-14 18:17:28.747999426 +0100 +++ /work/SRC/openSUSE:Factory/.orafce.new.9019/orafce.changes 2023-04-03 17:45:46.582754194 +0200 @@ -1,0 +2,30 @@ +Sun Apr 02 20:30:20 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.2.4+git0.2499240: + * prepare for 4.2.4 + * fix issue #218 + * prepare for 4.2.3 + * completation of support unicode API for IO operation on WIN32 + * use wide char file API for win + * prepare for 4.2.2 + * win win32 build + +--- +Tue Mar 14 08:59:26 UTC 2023 - emiliano.lange...@suse.com + +- Update to version 4.2.1+git0.82ab40c: + * prepare for 4.2.1 + * fix build Postgres 15 + * update copyright year + * formmatting, removing white spaces + * typo + * update copyright year + * Use function _wfopen on WIN32 platform instead fopen. It should to work with file names where are used not ANSI chars. + * fix PostgreSQL 15 build + * fix build for PostgreSQL 16 + * Update README.asciidoc + * possibility to use gen_random_uuid for making result in sys_guid function + * fix build for all supported pg releases + * implementation of oracle.sys_guid() based on uuid-ossp + +--- Old: orafce-4.2.1+git0.82ab40c.obscpio New: orafce-4.2.4+git0.2499240.obscpio Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.aIkkgf/_old 2023-04-03 17:45:47.251271796 +0200 +++ /var/tmp/diff_new_pack.aIkkgf/_new 2023-04-03 17:45:47.255274896 +0200 @@ -20,7 +20,7 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.2.1+git0.82ab40c +Version:4.2.4+git0.2499240 Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools ++ _servicedata ++ --- /var/tmp/diff_new_pack.aIkkgf/_old 2023-04-03 17:45:47.323327586 +0200 +++ /var/tmp/diff_new_pack.aIkkgf/_new 2023-04-03 17:45:47.327330685 +0200 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 82ab40cfd1649588c92ef1b9d94d89a1316f01fb + 24992406c27786f007d3eb2afe9dc64475fd3a68 (No newline at EOF) ++ orafce-4.2.1+git0.82ab40c.obscpio -> orafce-4.2.4+git0.2499240.obscpio ++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.1+git0.82ab40c/META.json new/orafce-4.2.4+git0.2499240/META.json --- old/orafce-4.2.1+git0.82ab40c/META.json 2023-03-13 18:07:21.0 +0100 +++ new/orafce-4.2.4+git0.2499240/META.json 2023-04-02 09:21:09.0 +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.2.1", + "version": "4.2.4", "maintainer": [ "Pavel Stehule ", "Takahiro Itagaki " @@ -25,7 +25,7 @@ "orafce": { "file": "sql/orafce.sql", "docfile": "README.orafce", - "version": "4.2.1", + "version": "4.2.4", "abstract": "Oracle's compatibility functions and packages" } }, diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.1+git0.82ab40c/builtins.h new/orafce-4.2.4+git0.2499240/builtins.h --- old/orafce-4.2.1+git0.82ab40c/builtins.h2023-03-13 18:07:21.0 +0100 +++ new/orafce-4.2.4+git0.2499240/builtins.h2023-04-02 09:21:09.0 +0200 @@ -130,6 +130,7 @@ extern PGDLLEXPORT Datum ora_get_status(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum ora_greatest(PG_FUNCTION_ARGS); extern PGDLLEXPORT Datum ora_least(PG_FUNCTION_ARGS); +extern PGDLLEXPORT Datum orafce_sys_guid(PG_FUNCTION_ARGS); /* from pipe.c */ extern PGDLLEXPORT Datum dbms_pipe_pack_message_text(PG_FUNCTION_ARGS); diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.1+git0.82ab40c/file.c new/orafce-4.2.4+git0.2499240/file.c --- old/orafce-4.2.1+git0.82ab40c/file.c2023-03-13 18:07:21.0 +0100 +++ new/orafce-4.2.4+git0.2499240/file.c2023-04-02 09:21:09.0 +0200 @@ -1010,9 +1010,30 @@ fullna
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-03-14 18:17:25 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.31432 (New) Package is "orafce" Tue Mar 14 18:17:25 2023 rev:3 rq:1071441 version:4.2.1+git0.82ab40c Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-02-12 11:06:12.446181979 +0100 +++ /work/SRC/openSUSE:Factory/.orafce.new.31432/orafce.changes 2023-03-14 18:17:28.747999426 +0100 @@ -1,0 +2,18 @@ +Tue Mar 14 08:59:11 UTC 2023 - Martin Pluskal + +- Update to version 4.2.1+git0.82ab40c: + * prepare for 4.2.1 + * fix build Postgres 15 + * update copyright year + * formmatting, removing white spaces + * typo + * update copyright year + * Use function _wfopen on WIN32 platform instead fopen. It should to work with file names where are used not ANSI chars. + * fix PostgreSQL 15 build + * fix build for PostgreSQL 16 + * Update README.asciidoc + * possibility to use gen_random_uuid for making result in sys_guid function + * fix build for all supported pg releases + * implementation of oracle.sys_guid() based on uuid-ossp + +--- Old: orafce-4.1.1+git0.519b5b5.tar.xz New: orafce-4.2.1+git0.82ab40c.obscpio orafce.obsinfo Other differences: -- ++ orafce.spec ++ --- /var/tmp/diff_new_pack.iVyMF9/_old 2023-03-14 18:17:29.452003189 +0100 +++ /var/tmp/diff_new_pack.iVyMF9/_new 2023-03-14 18:17:29.456003211 +0100 @@ -20,13 +20,13 @@ %definerealname orafce Name: %{pgname}-orafce -Version:4.1.1+git0.519b5b5 +Version:4.2.1+git0.82ab40c Release:0 Summary:Implementation of some Oracle functions into PostgreSQL Group: Productivity/Databases/Tools License:MIT URL:https://github.com/orafce/orafce -Source0:%{realname}-%{version}.tar.xz +Source0:%{realname}-%{version}.tar.gz BuildRequires: %{pgname}-server-devel BuildRequires: bison BuildRequires: flex ++ _service ++ --- /var/tmp/diff_new_pack.iVyMF9/_old 2023-03-14 18:17:29.496003424 +0100 +++ /var/tmp/diff_new_pack.iVyMF9/_new 2023-03-14 18:17:29.53446 +0100 @@ -8,11 +8,11 @@ git enable - - + + + *.tar -xz +gz - ++ _servicedata ++ --- /var/tmp/diff_new_pack.iVyMF9/_old 2023-03-14 18:17:29.516003531 +0100 +++ /var/tmp/diff_new_pack.iVyMF9/_new 2023-03-14 18:17:29.520003553 +0100 @@ -1,6 +1,6 @@ https://github.com/orafce/orafce.git - 519b5b5d9adc7d339c0689578f5c927dcf4841ac + 82ab40cfd1649588c92ef1b9d94d89a1316f01fb (No newline at EOF) ++ orafce.obsinfo ++ name: orafce version: 4.2.1+git0.82ab40c mtime: 1678727241 commit: 82ab40cfd1649588c92ef1b9d94d89a1316f01fb
commit orafce for openSUSE:Factory
Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package orafce for openSUSE:Factory checked in at 2023-02-12 11:06:11 Comparing /work/SRC/openSUSE:Factory/orafce (Old) and /work/SRC/openSUSE:Factory/.orafce.new.1848 (New) Package is "orafce" Sun Feb 12 11:06:11 2023 rev:2 rq: version:4.1.1+git0.519b5b5 Changes: --- /work/SRC/openSUSE:Factory/orafce/orafce.changes2023-02-11 21:57:46.107788791 +0100 +++ /work/SRC/openSUSE:Factory/.orafce.new.1848/orafce.changes 2023-02-12 11:06:12.446181979 +0100 @@ -27 +27 @@ - * the table [200~utl_file.utl_file_dir is dumpable + * the table [200~utl_file.utl_file_dir is dumpable Other differences: --