- enable pg 13 and 14

- Update to version 3.17.0+git12.e9ab8a3:

OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=18
This commit is contained in:
Marcus Rückert 2021-11-30 19:42:07 +00:00 committed by Git OBS Bridge
parent 865a068974
commit 2424640ba5
6 changed files with 105 additions and 5 deletions

View File

@ -2,4 +2,6 @@
<package>postgresql10</package>
<package>postgresql11</package>
<package>postgresql12</package>
<package>postgresql13</package>
<package>postgresql14</package>
</multibuild>

View File

@ -1,4 +1,4 @@
<servicedata>
<service name="tar_scm">
<param name="url">https://github.com/orafce/orafce.git</param>
<param name="changesrevision">a65cfb87c45790d8cd016743cb1db617c63476b7</param></service></servicedata>
<param name="changesrevision">cc4e09ae3f720e1c2b225c429bd9f6335d2814f7</param></service></servicedata>

View File

@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:f94e97b4347f762aefa3756c7a0eb6de47c1441c90e694a9af6078a84026ab91
size 603200

View File

@ -1,3 +0,0 @@
version https://git-lfs.github.com/spec/v1
oid sha256:b935c006cb84cd880bd41df59aace1a6d27c3123742af5529c51521527f66d5a
size 589984

View File

@ -1,3 +1,101 @@
-------------------------------------------------------------------
Tue Nov 30 19:41:52 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>
- enable pg 13 and 14
-------------------------------------------------------------------
Tue Nov 30 19:41:08 UTC 2021 - mrueckert@suse.de
- Update to version 3.17.0+git12.e9ab8a3:
* Fix some typos in plunit.c and plvdate.c.
* Fix a non-standard function declaration.
* pg_nextpower2_32 is available for pg13+|
* fix typo in plvdate.c
* fix typo in alert.c
* Improve the place that double the size of a buffer
* Fix access privileges of utl_file.tmpdir()
* prepare for 3.17.0
* This patch reproduce the same behavior of the regexp_* function with null input.
* Fix version number in install script.
* Remove duplicate variable declarations
* Allow even longer runtimes in DBMS_UTILITY.GET_TIME test
* prepare for 3.16.2
* fix build for msvc
* prepare for 3.16.1
* sql/dbms_utility.sql: Allow longer test runtime
* fix some shared memory leaks, reduce an possibility to raise an error 'lock requested error' by cleaning locks (these locks are not Postgres's locks) in dbms_alert_removeall and by triggering cleaning shared memory from locks related to closed processes when there are not free locks - per #PR 140 reported by @rbapin
* prepare for 3.16.0
* rename pipe type to orafce_pipe due conflict with pipe function from unistd.h
* ensure public access to public schema
* add missing sql file for 3.16
* Add DBMS_UTILITY.GET_TIME function, it returns the current time in 100th's of a second from a point in time in the past. This function is used for determining elapsed time. This function is widely used in some Oracle installation for timing of functions or statements.
* fix warning on MSVC
* prepare for 3.15.1
* Remove reference to pg_enc2name_tbl variable. It is not available on MSVC, and for this functionality it is not necessary
* prepare for 3.15.0
* function regexp_match cannot be used because it is available from Postgres 10
* Add Oracle regexp_replace() function which supports start position and occurrence. It correspond to the Oracle behavior and consist in plpgsql functions based on PG regexp_matches() and regexp_replace(). All details of the implementation is explained in the documentation. Also include in this patch also include regression tests for regexp_replace() including the Oracle queries and results in comment.
* just reformatting
* just reformatting
* Remove wrong and unused code.
* Apply orafce rule for assignment on remaining call to position() and length.
* Use better style for assignment instead of pseudo query.
* - Improve performances by replacing SELECT ... INTO syntax with := - Replace call to regexp_match() by regexp_matches() to support PostgreSQL 9.5 and 9.6. - Remove obsolete orafce--3.14.sql file - Update regression test to disable CONTEXT trace.
* Add Oracle regexp_like(), regexp_count(), regexp_instr() and regexp_substr() functions. They correspond to the Oracle behavior and consist in plpgsql functions based on PG regexp_matches(). All details of the implementation is explained in the documentation. This patch also include a regression test regexp_func.sql including the Oracle queries and results in comment.
* more ilustrative description of msvc project properties
* Oracle.sysdate uses time zone stored in GUC orafce.timezone. The setting of configuration value was correct - the global variable orafce_timezone has correct content (it can be checked by SELECT oracle.dbtimezone(). But direct output of this GUC (show orafce.timezone) was broken because the handler of system timezone was used and the statement "show orafce.timezone" did same output like "show timezone", and it is surely wrong.
* pre 3.14 changes
* When nvarchar2 and varchar2 was introduced, then was not possibility to correctly set protransform column. Orafce used UPDATE of pg_proc table. Unfortunatelly, this new dependency was not coverget by entry in pg_depend. Today this issue breaks binary upgrade. Fix is simple - on new Postgres it uses ALTER FUNCTION SUPPORT, for older releases it tries to fix pg_depend table.
* implementation of unistr function
* Added ppc64le architecture
* Added some transactions behavior differences
* Catch dbms_random.string() output variation on big-endian
* Fix the wrong filter in oracle.user_tables view in orafce--3.6--3.7.sql.
* Update README.asciidoc
* Update others.c
* Use correct macros to convert between Datums and pointers.
* note in readme
* prepare for 3.13.4
* forgotten files
* prepare for 3.13.3
* enable utf_file on MSWin
* cleaning build on MSWin
* reduce stack size
* minor cleaning
* prepare for 3.12
* fix warning for postgres 13
* fix asciidoc format
* minor README fix
* travis status
* PostgreSQL 9.4 is not supported
* example to trigger func
* fix build and tests for older releases
* trigger functions - ensure so only null or only empty string is used
* fix: 'if' condition is always true
* prepare for 3.11.1
* missing test output file
* only PostgreSQL 9.4 and higher are supported
* Run the testsuite on travis-ci.org
* clean warnings detected by -Wextra
* forgot. GRANT
* The previous securing of utl_file package required SECURITY DEFINER flags on functions. Using this flag is security risk. Insted using SECURITY DEFINER we allow READ from utl_file.utl_file_dir to PUBLIC. This design has one advantage - the final user can control usage of these function with granting user rights just only on table utl_file.utl_file_dir.
* Update README.asciidoc
* Update README.asciidoc
* Update README.asciidoc
* Update README.asciidoc
* fix long standing bug - function with access to utl_file_dir should to has security definer flag
* fix compilation against Postgres 13
* small fixes and rewrite of utl_file paragraph
* the safe dictionary in utl_file package can be identified by name too
* Fix doc and comment about months_between returning numeric (not float8).
* there are some differences between Oracle and Orafce
* fix compilation on PostgreSQL 13 (by removing useless include), fix to_multi_byte('\')
* prepare for 3.9.0
* remove extra clean to allow repeateable build without bison
* Orafce is licenced under 0-clause BSD licence
* polishing licence
* use postgres routines for printing float4, float8 values in to_char function (reduce garbage and trailing zeroes)
-------------------------------------------------------------------
Tue Nov 30 19:33:24 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>

View File

@ -3,7 +3,7 @@
%define realname orafce
Name: %{pgname}-orafce
Version: 3.8.0+git4.a65cfb8
Version: 3.17.0+git12.e9ab8a3
Release: 0
Summary: Implementation of some Oracle functions into PostgreSQL
Group: Productivity/Databases/Tools