pool/orafce
SHA256
4
0
Fork 1
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

- enable pg 15

Browse Source 
- Update to version 4.1.1+git0.519b5b5:

OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=19
This commit is contained in:
Marcus Rückert 2023-01-31 15:03:57 +00:00 committed by Git OBS Bridge
parent 2424640ba5
commit e77d7634f5
6 changed files with 120 additions and 5 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

1
_multibuild
View File

@ -4,4 +4,5 @@
<package>postgresql12</package>
<package>postgresql13</package>
<package>postgresql14</package>
<package>postgresql15</package>
</multibuild>

2
_servicedata
View File

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

3
orafce-3.17.0+git12.e9ab8a3.tar.xz
View File

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

3
orafce-4.1.1+git0.519b5b5.tar.xz Normal file
View File

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

114
orafce.changes
View File

@ -1,3 +1,117 @@
-------------------------------------------------------------------
Tue Jan 31 15:03:15 UTC 2023 - Marcus Rueckert <mrueckert@suse.de>
- enable pg 15
-------------------------------------------------------------------
Tue Jan 31 15:02:55 UTC 2023 - mrueckert@suse.de
- Update to version 4.1.1+git0.519b5b5:
* prepare for 4.1.1
* build on master (16) branch
* use adv lock to synchronize start of pipe and alert tests
* add connect by level < num in migration docs
* Hierarchical Query identifys the leaves
* Update the connect_by_root example, for better semantics
* fix: CONNECT_BY_ROOT in hierarchical query is converted to WITH RECURSIVE syntax
* the table [200~utl_file.utl_file_dir is dumpable
* fix compilation against pg master
* prepare for 4.0.2
* fix -wextra warnings
* fix shadowed variable varning
* fix msvc build for PostgreSQL 14
* fix build for pg16
* fix META file and prepare for 4.0.1
* to_multi_byte and to_single_byte support euc_cn(gb2312)
* add oracle sql migration : CONNECT_BY_ROOT
* fix oracle connect by
* prepare for 4.0.0 release
* remove obsolete ref on orafce_sql
* rename shadow variable
* initial merge of dbms_sql from orafce_sql
* other cleaning after removing support for unsupported pg releases
* increase version
* remove support for PostgreSQL 10 and older
* Fix database creation during installchecks for ICU cluster
* fix dbms_output.serveroutput(true) clear the buffer.It conforms to the features of oracle.
* prepare for 3.25.1
* fix calculation of plvstr.is_prefix for negative numeric values - see issue #198
* fix for pre 14 releases
* doc and regress tests
* remove useless func decl
* support for older releases
* initial implementation
* initial
* fix build against master (16) branch
* wrap possible unsupported DDL to dynamic SQL
* specify schema inside definition function tanh
* only set editorconfig
* prepare for 3.24.4
* remove redundant ALTER FUNCTION #191
* prepare for 3.24.3
* PostgreSQL older than 12 doesn't allow ALTER FUNCTION pg_catalog.x SET SCHEMA oracle. Only dirty way by direct modification of system catalogue is possible. see issue #190
* prepare for 3.24.2
* fix missing oracle.mod functions in update scripts
* prepare for 3.24.1
* fix regress nlssort test for PostgreSQL 9.5 without \if command
* Fix race condition during initialization in ora_lock_shmem.
* nlssort: Add a missing call to PG_RE_THROW.
* Limit nlssort test to Linux/glibc systems with en_US.utf8 installed.
* NEWS
* set storage for varchar2 and nvarchar2 to extended strategy
* prepare for 3.23
* fix broken calculation in plvdate_isleapyear function #184
* fix support for pg9.5, fix regress tests for older releases
* prepare for 3.22.1
* Fix read past the end of string in to_sigle_byte().
* Fix dbms_utility.get_time() to use the full range of int32.
* fix readme
* prepare for 3.22.0
* move dbobjects from public and pg_catalog schemas to oracle schema
* moving objects from public and pg_catalog to oracle schema
* move RequestAddinShmemSpace to shmem_request_hook for PostgreSQL 15
* Update sql_migration06.md
* Restore sqlparse.c and sqlparse.h
* Undo comment
* Add comment
* Add Parallel safe to mod function
* Bug fix
* Add mod function for Oracle compatibility
* Fix typos and spelling in docs and error messages
* prepare for 3.21.1
* fix mswin build - regexp functions was not really marked as dllexport due missing include of builtins.h
* remove empty line
* fix of some compatibility issues
* REG_NOSUB is working only on PostgreSQL 15
* workable release for PostgreSQL 15
* modification for compotibility with orafce.regexp_instr
* backport regexp_instr from PostgreSQL 15, use C version instead PLpgSQL for better possibilities of usage regexp API
* prepare for 3.20.0
* Fix regexp_instr() function with occurrence when the same value matching a pattern is found at several place in the string.
* signature of nvl2 function is enhanced to "any", anyelement, anyelement. After this change, the behavior is more close to Oracle. Unfortunatelly - this change can break extension update for some customers that uses nvl2 in views.
* support negative start argument for function substrb. Originally orafce used buildin bytea substr function. Now it recalculate start argument. see issue #172
* prepare for 3.19
* Allow empty string on input of functions to_number and to_date. In this case returns NULL.
* remove white spaces
* replace obsolete CSTRING macro by text_to_csring function
* prepare for 3.18.1
* fix - badly handled fn_extra in oracle.greatest(least) function
* prepare for 3.18.0
* Update README.asciidoc
* Update README.asciidoc
* use older API for iteration over an array. Now, oracle.greatest and oracle.least are working on all supported releases
* remove negative tests related to orafce.greatest because: a) error message is different on supported pg versions, b) the coverage and benefit of these tests is low
* remove two lines from regress tests of greatest due dependency on used collate
* Add documentation for greatest and least functions.
* Update upgrade extension file with the smallint addition.
* Add greatest/least SQL redefinition for smallint Add regression tests fot the two functions.
* Oracle functions LEAST and GREATEST return NULL if at least one of the parameters is NULL. This is not the case for the PostgreSQL equivalent functions which only return NULL when all the parameters are NULL. This patch creates the two functions in the oracle schema to have the same behavior than in Oracle.
* Minor grammatical fix to README.asciidoc
* fix typo in charpad.c
* fix typo in orafce--3.17.sql
* Update Orafce_Documentation_05.md
* Catch dbms_random.string() output variation on Windows
-------------------------------------------------------------------
Tue Nov 30 19:41:52 UTC 2021 - Marcus Rueckert <mrueckert@suse.de>

2
orafce.spec
View File

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