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.changes 2023-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 @@ %define realname 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 @@ <servicedata> <service name="tar_scm"> <param name="url">https://github.com/orafce/orafce.git</param> - <param name="changesrevision">24992406c27786f007d3eb2afe9dc64475fd3a68</param></service></servicedata> + <param name="changesrevision">86d7f4c925483c62e400b675770d6497856439ab</param></service></servicedata> (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.000000000 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/META.json 2023-05-01 07:17:41.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.2.4", + "version": "4.2.6", "maintainer": [ "Pavel Stehule <pavel.steh...@gmail.com>", "Takahiro Itagaki <itagaki.takah...@gmail.com>" @@ -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.000000000 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/expected/orafce.out 2023-05-01 07:17:41.000000000 +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.c 2023-04-02 09:21:09.000000000 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/file.c 2023-05-01 07:17:41.000000000 +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' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.4+git0.2499240/plvstr.c new/orafce-4.2.6+git0.86d7f4c/plvstr.c --- old/orafce-4.2.4+git0.2499240/plvstr.c 2023-04-02 09:21:09.000000000 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/plvstr.c 2023-05-01 07:17:41.000000000 +0200 @@ -214,7 +214,7 @@ if (beg >= end) return 0; /* out of range */ } - else + else if (start < 0) { dx = -1; beg = Min(c_len_txt + start, c_len_txt - c_len_pat); @@ -222,6 +222,8 @@ if (beg <= end) return 0; /* out of range */ } + else + return 0; for (i = beg; i != end; i += dx) { @@ -263,7 +265,7 @@ if (beg >= end) return 0; /* out of range */ } - else + else if (start < 0) { dx = -1; beg = Min(len_txt + start, len_txt - len_pat); @@ -271,6 +273,8 @@ if (beg <= end) return 0; /* out of range */ } + else + return 0; for (i = beg; i != end; i += dx) { diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/orafce-4.2.4+git0.2499240/sql/orafce.sql new/orafce-4.2.6+git0.86d7f4c/sql/orafce.sql --- old/orafce-4.2.4+git0.2499240/sql/orafce.sql 2023-04-02 09:21:09.000000000 +0200 +++ new/orafce-4.2.6+git0.86d7f4c/sql/orafce.sql 2023-05-01 07:17:41.000000000 +0200 @@ -229,6 +229,7 @@ select 1 = instr('abcabcabc', 'abca', 1, 1); select 4 = instr('abcabcabc', 'abca', 1, 2); select 0 = instr('abcabcabc', 'abca', 1, 3); +select 0 = instr('ab;cdx', ';', 0); select oracle.substr('This is a test', 6, 2) = 'is'; select oracle.substr('This is a test', 6) = 'is a test'; select oracle.substr('TechOnTheNet', 1, 4) = 'Tech'; ++++++ orafce.obsinfo ++++++ --- /var/tmp/diff_new_pack.71BLnY/_old 2023-05-01 18:51:43.025546078 +0200 +++ /var/tmp/diff_new_pack.71BLnY/_new 2023-05-01 18:51:43.053546244 +0200 @@ -1,5 +1,5 @@ name: orafce -version: 4.2.4+git0.2499240 -mtime: 1680420069 -commit: 24992406c27786f007d3eb2afe9dc64475fd3a68 +version: 4.2.6+git0.86d7f4c +mtime: 1682918261 +commit: 86d7f4c925483c62e400b675770d6497856439ab