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.changes 2023-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 @@
%define realname 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 @@
<servicedata>
<service name="tar_scm">
<param name="url">https://github.com/orafce/orafce.git</param>
- <param
name="changesrevision">b3ad258852b6e5e15e3a516fb0f53accdc4f9d6a</param></service></servicedata>
+ <param
name="changesrevision">6020b1e1f8c519b748b6784a76537b22a6938389</param></service></servicedata>
(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.000000000 +0200
+++ new/orafce-4.6.0+git0.6020b1e/NEWS 2023-09-01 08:25:22.000000000 +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.c 2023-08-07 08:58:46.000000000
+0200
+++ new/orafce-4.6.0+git0.6020b1e/dbms_sql.c 2023-09-01 08:25:22.000000000
+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.out 2023-08-07
08:58:46.000000000 +0200
+++ new/orafce-4.6.0+git0.6020b1e/expected/dbms_random_2.out 2023-09-01
08:25:22.000000000 +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.c 2023-08-07 08:58:46.000000000
+0200
+++ new/orafce-4.6.0+git0.6020b1e/math.c 2023-09-01 08:25:22.000000000
+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=.svn'
'--exclude=.svnignore' old/orafce-4.5.0+git8.b3ad258/random.c
new/orafce-4.6.0+git0.6020b1e/random.c
--- old/orafce-4.5.0+git8.b3ad258/random.c 2023-08-07 08:58:46.000000000
+0200
+++ new/orafce-4.6.0+git0.6020b1e/random.c 2023-09-01 08:25:22.000000000
+0200
@@ -89,7 +89,7 @@
int seed = PG_GETARG_INT32(0);
srand(seed);
-
+
PG_RETURN_VOID();
}
@@ -102,7 +102,7 @@
dbms_random_normal(PG_FUNCTION_ARGS)
{
float8 result;
-
+
/* need random value from (0..1) */
result = ltqnorm(((double) rand() + 1) / ((double) RAND_MAX + 2));
@@ -137,7 +137,7 @@
dbms_random_seed_int(PG_FUNCTION_ARGS)
{
int seed = PG_GETARG_INT32(0);
-
+
srand(seed);
PG_RETURN_VOID();
@@ -154,11 +154,11 @@
{
text *key = PG_GETARG_TEXT_P(0);
Datum seed;
-
+
seed = hash_any((unsigned char *) VARDATA_ANY(key),
VARSIZE_ANY_EXHDR(key));
-
+
srand((int) seed);
-
+
PG_RETURN_VOID();
}
@@ -178,15 +178,16 @@
{
StringInfo str;
int i;
-
+
str = makeStringInfo();
for (i = 0; i < len; i++)
{
- int pos = (int) ((double) rand() / ((double) RAND_MAX + 1) *
chrset_size);
-
+ double r = (double) rand();
+ int pos = (int) floor((r / ((double) RAND_MAX + 1)) *
chrset_size);
+
appendStringInfoChar(str, charset[pos]);
}
-
+
return cstring_to_text(str->data);
}
@@ -211,7 +212,7 @@
option = text_to_cstring(PG_GETARG_TEXT_P(0));
len = PG_GETARG_INT32(1);
-
+
switch (option[0])
{
case 'a':
@@ -249,7 +250,7 @@
charset = NULL;
chrset_size = 0;
}
-
+
PG_RETURN_TEXT_P(random_string(charset, chrset_size, len));
}
@@ -274,10 +275,10 @@
dbms_random_value(PG_FUNCTION_ARGS)
{
float8 result;
-
+
/* result [0.0 - 1.0) */
result = (double) rand() / ((double) RAND_MAX + 1);
-
+
PG_RETURN_FLOAT8(result);
}
++++++ orafce.obsinfo ++++++
--- /var/tmp/diff_new_pack.5P2lzj/_old 2023-09-08 21:17:25.418508749 +0200
+++ /var/tmp/diff_new_pack.5P2lzj/_new 2023-09-08 21:17:25.422508892 +0200
@@ -1,5 +1,5 @@
name: orafce
-version: 4.5.0+git8.b3ad258
-mtime: 1691391526
-commit: b3ad258852b6e5e15e3a516fb0f53accdc4f9d6a
+version: 4.6.0+git0.6020b1e
+mtime: 1693549522
+commit: 6020b1e1f8c519b748b6784a76537b22a6938389
