* prepare for 4.14.0
* prepare for 4.13.6
* remove invalid alternative results of dbms_random test
* fix dbms_random test for pg 12
* fix error when orafce's triggers was executed on table with dropped columns
* update year in info comment
* fix white chars
* Oracle does switch of low, high when low is higher than high arg of dbms_random.value. Do this in orafce too. Some cleaning in related regress tests. Attention: this change breaks alternative expected results.
* regress test for new nvl function
* fix Makefile and return type previously added nvl function
* Add support to nvl(double precision, integer) and to_date(integer, text).
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=71
* prepare for 4.13.5
* export orafce_sys_extract_utc and orafce_sys_extract_utc_oracle_date for win build
* With Oracle passing en empty string to the to_date(txt, fmt) function returns NULL whereas PostgreSQL returns '0001-01-01 BC'. This true whatever is the format passed as second argument. Change the behavior of function to_date(txt, fmt) to mimic Oracle.
- Update to version 4.13.4+git0.8f3f211:
* prepare for 4.13.4
* fix update script from 4.12 to 4.13
* prepare for 4.13.3
* umask is usually entered as octec number, then read it as octec number
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=69
- Update to version 4.13.2+git0.f8f8700:
* prepare for 4.13.2
* fix missing update of control file and regress tests
* 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.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=67
* 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.
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=65
* - refresh sql parser - fix warning: no previous declaration for ‘orafce_sql_yynerrs’ [-Wmissing-variable-declarations]
* fix format doc
* fix format doc
* fix format doc
* fix sys_extract_utc calculation for pg12
* regress tests for sys_extract_utc
* fix another warnings related to master - after drop support for pg12, the code for pipe and alert needs refactoring
* fix warnings related to master build
* fix build pg12
* support of sys_extract_utc function
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=61
- 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)
OBS-URL: https://build.opensuse.org/request/show/1176507
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=57
- 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)
OBS-URL: https://build.opensuse.org/request/show/1145077
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=49
- 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
OBS-URL: https://build.opensuse.org/request/show/1136069
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=45
- 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
- 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
OBS-URL: https://build.opensuse.org/request/show/1076777
OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/orafce?expand=0&rev=28
