postgresql13-orafce-4.14.1+git0.48e67e7-bp156.4.9.1<>,ҨhI%z y"(.Ce8T!%HPal.n:vڨYK3;`0G:IU`T 6A==[ǧ{vxkyJK5""!poL~!r){Cbk4tBV\STf5o) vV𯛔f׈k_R^ M^Ph *φ@'|)I'ѴēMըh3e&T8"tŃFwZ M;DkBvq['j #2+J-XSGU|<yϣ]9 >!t>d\}XPCYtD Ҵ;E kTva耎K t%H^'d;BtSxoUĻ ׼FjMAGxBk}EH]IWbj}^#7]<*IK!=LC|767Z lϾh*/FD>>?d* 6 ndhtx 11 *1 1 P1 1 1111  c (8,9D,:,FG1H1Il1XY\ 1]1^bicdeflu1vw|1x@1yz$48>Cpostgresql13-orafce4.14.1+git0.48e67e7bp156.4.9.1Implementation of some Oracle functions into PostgreSQLThe goal of this project is implementation some functions from Oracle database. Some date functions (next_day, last_day, trunc, round, ...) are implemented now. Functionality was verified on Oracle 10g and module is useful for production work.hs390zl21 *SUSE Linux Enterprise 15openSUSEMIThttp://bugs.opensuse.orgProductivity/Databases/Toolshttps://github.com/orafce/orafcelinuxs390x:j t JOUyn7 T IjO= m7yB>y4W*?u`UeAA큤AA큤hhhgegegegehhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhha109d6b5d5fe3119ce29b3eb68248a98d1445365432dff08c53d1c43e88931497915c70f3540845abaf85c480df94f8ebd9bfbecfad45250ec0dd95e10403e9b95a1c5f0e0077c4d05fb10162c712ab7f473f57b3dd40a514ce453ad298e2ddd58e987eb59cfe203e44113ce3b66e12c955caa0d352add2bc92e1dc3c3d3e66019859a6f22f07357d0515e9d8db49d3ffda8db587f902a1916fdf3980612ae119110e6dfde7e2daeb3e4e645fd17a182d38f72c386717e2c12ced461c5df86d2344f8b402312536683a10d59048787fdc46e6c7ff5b802f19c36e68e692f85d2e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855a04cd1310c5aa5df7e92de9aad07cf5a2a924ba960ac26444950a6184d3c6d7e5086299c9d7f58a55c07b862bcd864de4cf115e5e87a8401e3efe2f936bb3a8997cd077599550279d3eafb792a40e1863eefac17fdb71c9ea610053873e7d9caefb261c05fe251a8ec10f23dd10e569036110517bf6fb6091d91d66cbe11ed9f2427c118becda3f43d5e7d38d83a242993ba2d024fd7756f6668779461b066d0bbdb03fe33c2d8cc68997217d7830e5505f3bd0b9e07c4367028278f430ea62c55eb7c3d55fd475d76eb0a3bc46742dd3c070fbdacb27e2939f122b626370bc29228f53d73f680b934a1503a164d31e1471ecfa16484001ea1ecbe5fd806a9b3a7ad077d18d354039efbb175a915a9fa38ca499d208cb6d65e212764dd1ec1071e7dd232a5a5a8bf3d7fa8870308aa40cb4132e3fe7fe868650658514a13e663d30b77f0be2bce5799d7d9a327dea643abca34e5f6bf25886309d0c4043e3b7a0e053794fad143075128b688f9bd6432021bc986689cf2b5e0858be2bf0f3c9e4bc9939b3b1d67c407a4cdca2d93ed11b9fa88af2f720aa98e15a2df89a9d6adca55c6c0074497abc9e8169ee48a04f8999a79ff7e07ea4b53e8a67e17b6aa7acada5a101f47ab286bbb8ea1ddc0277ef5b62eee44db3f161c349fd17d47b6cc2939118084bc433131cbf8e0a24676362e390fa1e1d57ac75f3be6cb74a0101dfffbfba3b2fabc7109634bcd7896b4068f7bc9ae0400f0c019c9735b59012349c3a48118759713c372bac073179fa6539886d063b8aa98b3a5affec02a18ef508860c64abd6c756639f0a626677dc6682075aa622f7c61e8615e90455d3e55162d07bc37ea91b13b1560f9c5eb3866ae1c68a066884e483d36067edf44a365b9c07049c427d77d179bba7a90fe9725b0ca783be9048d7ae95682cf4928e4de1b972be909bfe90d83adde4ef8ceadc05a125b209e5160832b0eed2dc0e60fde462465048e23b579ff2e87780d57cdaa749eded2e25c28dd5c2453830f35dba3a2c37677b0b58c838d9f360db31a5fdcea434835c5a0e5e0a67c25b31d9b6e06941667757c422e8b8f9e326ea91f3e728bf8e6342eeaac532e437401383e42e9a844a0650d3e3b49e5f69e8a76192ed98ae82931f0c5dc68e7f47ad2e771945fa49b01ab139d93dc920f7c4cfecafaff9007d8dcb6ad74db6a27a33651c4f4f6b0881facf74d11f8de1c99bafb3b4e8f1924b119d7c281b01ea51be65b897830b788e3b1bd418a085388d7e0792d7228b12340292a589f1283883bb64ef7ba047480c25d4ae2bacf068abf64c04ee30455701d067ed342c0851a8b44f10958e504e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b85517a8d7ae0878bf607c91cf343685975d07cfbd8771512c79617a71d5ba84812b049fc96b94aad68a29f2bcc5f16d2ce7aa1ae4dcbce99253ca6974e8f630a4ad008df003827c15bb8b66884c9c2b3b6b14160494f6b68a493e0c2e555f65cadb97d5c0d071ef24ebe12a6cd533e012c25a24b19293c95ee34d46f20e81a5d3622b39151109b24788a47ae323ac6ecd66306bc80de94dcb042d5f83a6b83a14ae290e8e93ab974a6842d86ad248df704285d3b85f166c4e6befb9a86a6727503frootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootrootpostgresql13-orafce-4.14.1+git0.48e67e7-bp156.4.9.1.src.rpmorafcepostgresql13-orafcepostgresql13-orafce(s390-64)@@@@@@@@    libc.so.6()(64bit)libc.so.6(GLIBC_2.17)(64bit)libc.so.6(GLIBC_2.2)(64bit)libc.so.6(GLIBC_2.3)(64bit)libc.so.6(GLIBC_2.3.4)(64bit)libc.so.6(GLIBC_2.33)(64bit)libc.so.6(GLIBC_2.38)(64bit)libc.so.6(GLIBC_2.4)(64bit)postgresql13-serverrpmlib(CompressedFileNames)rpmlib(FileDigests)rpmlib(PayloadFilesHavePrefix)rpmlib(PayloadIsXz)13.203.0.4-14.6.0-14.0-15.2-14.14.3ge\@gE@ggY@gY@gY@fff@f@f@f]@fO/f/fe@e@e@ee)1@ejev@d dddx@dOd)n@dadac1ccca@a@a@]@]@[S@[Ѱ@YJYJT@emiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.commrueckert@suse.demrueckert@suse.deMarcus Rueckert mrueckert@suse.deemiliano.langella@suse.comMarcus Rueckert emiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comMarcus Rueckert emiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comemiliano.langella@suse.comMartin Pluskal Emiliano Langella Marcus Rueckert Marcus Rueckert mrueckert@suse.deMarcus Rueckert mrueckert@suse.deMarcus Rueckert mrueckert@suse.deMarcus Rueckert mrueckert@suse.deReinhard Max mrueckert@suse.demrueckert@suse.demrueckert@suse.de- Update to version 4.14.1+git0.48e67e7: * prepare for 4.14.1 * introduce new github workflows * Update README.asciidoc * fix regress tests on msvc * DiffUtils from gnuwin32 are necessary for ninja test on msvc * info about using meson * fix meson.build for msvc * support for meson- Update to version 4.14.0+git0.f0ecbd3: * 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).- Update to version 4.13.5+git0.ab95f82: * 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- Update to version 4.13.4+git0.8f3f211: * prepare for 4.13.4 * fix update script from 4.12 to 4.13- Update to version 4.13.3+git0.0bf0f15: * prepare for 4.13.3 * umask is usually entered as octec number, then read it as octec number- enable pg17- Update to version 4.13.2+git0.f8f8700: * prepare for 4.13.2 * fix missing update of control file and regress tests- Update to version 4.13.0+git3.25d74aa: * 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.- disable pg11 builds as we will remove the EOL package soon- Update to version 4.11.0+git0.72e1417: * - 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- Update to version 4.10.3+git0.e050dd6: * prepare for 4.10.3 * security check can be ignored when the value is configured by ALTER SYSTEM, and in reload the system is not in transactional state. fix #270- 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)- Update to version 4.10.0+git0.cfdcdf2: * remove whitechar * Allow to set umask for utl_file.fopen by setting orafce.umask. This setting is allowed only for user with rights of role orafce_set_umask.- Update to version 4.9.4+git0.6f3b83a: * prepare for 4.9.4 * after any fclose call, the pointer FILE should not be used ever * after any fclose call, the pointer FILE should not be used ever- Update to version 4.9.3+git0.6adbd66: * prepare for 4.9.3 * fix regress tests * fix broken handling null in dbms_sql.column_value * fix build for master (pg17+) * possibility to raise error inside trigger functions * fix regress test on fc40- 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)- Update to version 4.9.1+git0.1071eb6: * prepare for 4.9.1 * fix white spaces in regress tests * fix formatting issues from previous commit * dbms_random.string Enhancement #252- 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- Update to version 4.7.0+git1.fca4108: * changes related to msvc 2019 build * remainder function should be marked STRICT (#225)- enable pg 16- Update to version 4.6.1+git0.8785767: * prepare for 4.6.1 * return back dbms_alert_defered_signal header necessary for upgrade - #231- 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- Update to version 4.5.0+git8.b3ad258: * better comment * fix issue reported by cppcheck, all tests passed * test passed except pg 17 * fix * code cleaning * formatting * use condition variable for synchronization of dbms_alert waiting on signal * formatting * typo * prepare for 4.5.0 * detect different identity of pipe after wakeup * fix issues reported by cppcheck * decrease timeout as protection against deadlocks * using ConditionVariables for synchronization dbms_pipe writer and dbms_pipe reader * fix isses reported by cppcheck * fix issues reported by cppcheck- Update to version 4.4.0+git0.eb5513d: * update version info and year * regexp_x functions should be immutable- Update to version VERSION_4.3.0+git0.fac8b9c: * fix regress test for dbms_random.string * add chars '\' and '~' to list of printable chars for function dbms_random.string * fix dbms_random should not be immutable (Issue #222)- 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- 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- 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- Added "Name:" tag.- remove pg 10 support- enable pg 15- 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- enable pg 13 and 14- 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)- remove dead PG versions- Update to version 3.8.0+git4.a65cfb8: * return back missing files * fresh parser files * master is now unreleased 3.9 * minor enhancing user_constraints view - use conrelid::regclass instead table_name. This will be consistent with index name, and show schema for tables that are not on search_path * prepare for 3.8 * qualify decode function to be installable on greenplum * fix PostgreSQL 12 support * missing files * typo * fix compilation and regress tests for PostgreSQL 11 * Revert "Merge pull request #83 from kato-sho/fix-build-for-PG12" * Fix build for PostgreSQL 12 * remove extra #include utils/nabstime.h * update against change format of FunctionCallInfo in PostgreSQL 12 * fix compilation for pre PostgreSQL 12 * fix compile for PostgreSQL 12 * prepare for 3.7.2 * bug fix release * fix bad filter in oracle.user_tables view * update NEWS * use older syntax for create operator command * add warning about possible compatibility issue * fix docs * null safe pipe operator for (n)varchar2 should be explicitly enabled (due compatibility) * bugfix should to use OR REPLACE clause * add bugfixes to update script * fix readme * more faster (n)varchar2 null safe concat * null safe concat operator for varchar2 and nvarchar2 * fix compilation for PostgreSQL 12 * target type should be qualified * broken formula for add_month * fix broken oracle.add_months for last day in month * fix comment assigned to wrong object * minor doc nvl- adding postgresql12 to _multibuild- Update to version 3.6.1+git24.cf58d28: * remove strict flag for nvl functions * minor cleaning * remove pre 9.4 support * fixes for 12 * fix compile on PostgreSQL 12 * missing reset fsec in ora_timestamptz_round function * #74 - badly joined comment * #75 set correct type for trunc and round two params functions - float4 * allow usage of schema oracle and plunit * copy paste correction intarray -> orafce * fix broken compilation on non MSC platforms * fix output path * add postgresql 10.3 target support need ICU header by path c:\icu * fix conversion from 'size_t' to 'int' * add 9.6 build environments fix C89 compatible compliance * fix nensenses related yyllex, using older form of bison option * new function oracle.numtodsinterval * disallow functions from utl_file package on MS Windows * clean headers used by msvc * cleaning complete build on msvc * add missing files for windows compilation * fix #64 * dba_segments view, cleaning * Fix formatting of examples. * Append documentation about how to translate REGEXP_SUBSTR Oracle function to PostgreSQL. * fix the position of a half-width space added by rpad(). * enhancing emulation of Oracle views * fix some segfaults reported by Andreas Seltenreich #59 * new few Oracle system views * prepare for 3.6 * Minor bug in doc * Avoid setting unused variable value * Fix issue #54 - missing collatable flag for string types varchar2, nvarchar2. * Ensure LWLockRegisterTranche call in every session before LWLockAcquire call. * Preparation for 3.5 release. * add missing V1 signatures * Add Orafce Documentation and Oracle to PostgreSQL Migration Guide - drop patch orafce-orafce_sql_yyparse-bison26.patch- Add build for PostgreSQL 11 and drop 9.3. - BuildRequire server-devel instead of devel.- update to 3.4.0 * new aggregate function wm_concat * PostgreSQL 9.6, 10 are supported well * remove support for 8.3, 8.4, 9.0, 9.1 (only 9.2 and higher are supported) * new functions: sysdate, sessiontimezone, dbtimezone * remove support for 8.2 * add support for 9.5 * change the releasion number system * new functions: to_single_byte, to_multi_byte, nanvl, length, ltrim, btrim, rtrim, lpad, rpad * fix compilation issue in new code for Pg <= 9.1- switch to multibuild- update to 3.0.9 * PostgreSQL 9.4 compilation * new datatype and related functions: oracle.date * new varchar2, nvarchar2 types and related functions (Amit Langote) * oracle.substr emulate better Oracle substr function behave (Vinayak Pokale) * fix few internal issues that breaks a PGXN tests (Pavel Stehule)s390zl21 1744879764  !"#$%&'()*+,-./01234564.14.1+git0.48e67e7-bp156.4.9.14.14.1+git0.48e67e7-bp156.4.9.14.14.1+git0.48e67e7-bp156.4.9.1lib64orafce.sopostgresql13-orafceCOPYRIGHT.orafceINSTALL.orafceNEWSREADME.asciidocpostgresql13extensionorafce--3.10--3.11.sqlorafce--3.11--3.12.sqlorafce--3.12--3.13.sqlorafce--3.13--3.14.sqlorafce--3.14--3.15.sqlorafce--3.15--3.16.sqlorafce--3.16--3.17.sqlorafce--3.17--3.18.sqlorafce--3.18--3.19.sqlorafce--3.19--3.20.sqlorafce--3.2--3.3.sqlorafce--3.20--3.21.sqlorafce--3.21--3.22.sqlorafce--3.22--3.23.sqlorafce--3.23--3.24.sqlorafce--3.24--3.25.sqlorafce--3.25--4.0.sqlorafce--3.3--3.4.sqlorafce--3.4--3.5.sqlorafce--3.5--3.6.sqlorafce--3.6--3.7.sqlorafce--3.7--3.8.sqlorafce--3.8--3.9.sqlorafce--3.9--3.10.sqlorafce--4.0--4.1.sqlorafce--4.1--4.2.sqlorafce--4.10--4.11.sqlorafce--4.11--4.12.sqlorafce--4.12--4.13.sqlorafce--4.13--4.14.sqlorafce--4.14.sqlorafce--4.2--4.3.sqlorafce--4.3--4.4.sqlorafce--4.4--4.5.sqlorafce--4.5--4.6.sqlorafce--4.6--4.7.sqlorafce--4.7--4.8.sqlorafce--4.8--4.9.sqlorafce--4.9--4.10.sqlorafce.control/usr/lib/postgresql13//usr/lib/postgresql13/lib64//usr/share/doc/packages//usr/share/doc/packages/postgresql13-orafce//usr/share//usr/share/postgresql13//usr/share/postgresql13/extension/-fmessage-length=0 -grecord-gcc-switches -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector-strong -funwind-tables -fasynchronous-unwind-tables -fstack-clash-protectionobs://build.opensuse.org/openSUSE:Maintenance:18867/openSUSE_Backports_SLE-15-SP6_Update/ec5083cac58bbb8cdde8363333d44091-orafce.openSUSE_Backports_SLE-15-SP6_Update:postgresql13drpmxz5s390x-suse-linuxdirectoryELF 64-bit MSB shared object, IBM S/390, version 1 (SYSV), dynamically linked, BuildID[sha1]=8ad26aa86d8e33a05a166d1ee9542a2e105dd13f, not strippedASCII textUTF-8 Unicode text, with very long linesemptyRRRRRRRR>h'zoxLVSEU'_J]2*0C8$7#yJ1\dr(Bt8HL]5 髹ҿO+do,Mhvmiq?IV v {|qZtYIMlsOiᲔ j(!.M*+xk D.lq?W&M|)rh w$'Ia[b f(Y sHґ3UZF" &,K9o5rς,c#>"'Z >S%=}'b#P#f|eޑ yQnA[1y>ǃ1IEiXۨR-f/p F>:F[֧)jD<!Eg)'T 8tF3 [u Ŕho}X3+ܔbW9oDx~JɁ B@fg+%"E>A|OM!( N aW-Mw {&o2G2eR[ӥPk]NK<=HԹO0=C}!f-+L3M'4sGz,N(%H'qՌ(bgNxF[YuIhQTj1ٗ8phS8UGZ}Ȼq0Hgc==Hٛ|괹`rtE=T˵ph Ѹ{:} no/j ';2vΉpx:cM:w>f$2Gݧ|Gj4N+uy[`Hw Y&Y^X{R+/ہhvN]4QC1<{p?Ʃ [si(ZnM\z?Wctm\8yO?wWw Zdgt!`(L?N %2FEO1ZG'nmzq+]$Ev{T%)E^hpD6G9|K+pEψ#bJ:DU.+cQ8nm1)uU]?9#0* ]O+'A#ձ@ӢjdX #>TrD%.U M@rp鷍YxAc`3YƗpI'1U|s>xU85=M@"Dn#:] u\üX!3X}iď4B7Knc{M{h޺mq )B.F> nNS{1Fwܠ{Z=*ڂ1WR [KL //~ڗaL"댫`mv]6~(ct@-$Qo`V0x>='@vt5Sͱ#5*&L6b b~fĠx4/ Trzց\9z?4b#s? F=f]!7э EfwZ9H/&N ʓg"ު5Z]oTY pzܞ6·*]6" >o\;_Hn|N^.ou8n=z=wM\Xx_"}-@ߍX:3>D2$&Q?Y5(18yfTӓ z;7'qeu_1johWNrgCh*nA5+܏PXBۖ؁׏?R$WsS37YTNJp[,GSe4KST"ò43g-طZY#i@bDJ 1ݙݦ,mZ t9Ih*/osfۋ͢k,yx ~k3G;Nq$kjriLIqE:Ț;(Y/u.&C¸5t@(R4+"}+ se$&Ѓo郀>׏v8=ND+*6WT5e)Ţ- ᠃!{ s޵ѯ gg>Q9LRH=? {i+Qdm6Z*Sy*(b?@i W*;Qg"!@W=7,սp6`Kq:#}}ߍ%u:U~![ύ M5Сr_X[rNAŌq*/2%z,_Mc vj= ^J0ćN6S6}5QN `t`{ `@8'L07\b(xT5gv,\CݼxA.JnukuL(5 d)r?D Ʒ n9)%Nꫛݡ-_֛N&=sV'Aײ`Ʃ8{]5tDnd=մ`tE3屐]YtXXg牵"uRJ`_5=V|?bT\œD"Ξ8$AnK2t+" W-yaJkF>זv\& i'#PzA?R%"kZq-,Elk%Vכq] TW@[3g %(PdEeT|7!ΠGK &Ɨ0"O^bQXN|ϲ?vċ GRd}>DoJ)u:wQk'B&T3K,[uc 92[Xэ{'!waT光wƲ'vet0ByЙ٨@+?/]5nB^A;1١f`55ޡ+MtfyO:X~;͔gvRip,N-\{U'+2׻1|%{uf2X|Rn $}9,)+@xFpP;N` {3Y9B%hW&56z",nn Ϙ 1|S.Dqʡz! ܀-յ5Ak3q`?e M=&;vx9hkP|fiﭾh(q-3f:\hL@稻br;h"1HO8֑]hcﻀO,;ҫ>a:r\oqQ^_BRo^2BmtbYW?]gllj#W9Ӌtv N | ÓUCr: N*XZ1fAh<_Eܽd{ 4/!7YR"kdܷ^pc |("JSV|qu1l#yT5 y٨-H$RK9@(ӓIݪ+3Aw[D畛%3`5Y'Q<Ls6/~Iœ/K7 ꁩ)#?=t6ˮ*i`[l\ohTϛX[H/Rzg2 ާpY#Ͱ Ņ+)[SX L)rۓHA}hiݫ-EdzGwWq4wJw趬Q#FQ؜Y!`I֍%ź嬧43]Σ)a״fsPc\k&Pz0b<8JgNXG ̖6"ri?6jOj-EZ0Y%3tU 'ovZ|)bep1WVys:jF_!5myC&l9ۼ-wNCMZa*&]n^=o@{Mf&80X4}1-B莼Z~fU-x2HC˒-.yxw|"in<{/Wr [}yH-ܚXL2gt0?(0SW`\ >h-\qVU) AYK"~`NQl©2Ml)?U!I[CPD fzڷWLiDyiLޢi&PDC/5x2KSF; ;F *3ڧSGGZ՟<#=ͣqAQdt*-'c^[)bmA3^3*6Ă ki$#SDlvgbH k7GZ P\~*i &~crVm&W ?A'w&5tjGqk]|`YuVw8\3L76w.f@+ֺ6'_ XAIY,'N 2ȇ5'x!V/*VjǒkCtVI kٌ+n}tY9JIzk껭L#7cM_=e=;/TJNc].r9y9w~~|"m5X/InC싗뼀/3#|=Zx%RnӾaزTx*ͫ6! 3UUix'?Zւ1n_ov6Xob\*KAa:+IʃmPl|nX:&"h0!;䖸;w a<8Љ_t9E?rEDx W&؛?hyN"/0 Bo,WYƯ'%oƿ_F^\ʅ4m.ӜUqTBuEsa@A[($dӞ.!NI_iqxR%/^_c/3NJt-G(,;2CJ [N|@LVI\P~S}:=$'NKFVs[1S.׍-8ho3)0$k K;?WK,Ul%缙xӃGLm:Hi㟧t)Nq|+{+(rkwLǾHu Äq` q[*Ps<$lQ}Cpua÷Gs}ͭ ("%o}&a -2+V_ y9:<2{q8*#Pa|E=Z7x?1(3q+苽-ۙh7ޭhǎ)U#mhJL8({V̽?uP bԯ|";yYXh;R}-:QX@Qc?%zf;uw(Y'jakj.E2 n+ZB-api?P-v{>zh X}gqy1d~A TNHѲBs(YiHA4/hm@ѝDC.s4XH,o{OADHdlq#Τƞsl4p z;)%ƫ7c}VnQ]E1-B)ￂ[_}J˔lງrVq!0[~ Ṍl8PU3F\[FŖI@N9,JHEY-^ y:j.Y7A3D%C"U}0bDo=Z E;Ȅvi<!]a5 롕 L,&QtTQiP)s3Y42/ʃC-O< 8sz)Trȧ†YOS5 A$үp' B?ȥDOF3TĒ"$Y`DW{+_`B\=HawSGtYS.jz^u]!Yzݱm%ׂw~'ښl$w8Yf£y6C .g57rRYzq;/:{ѨC(hg }Š?~ e:mhxGNoB3r^mw#3چ-:,.SBcU2^abۏ듍!.=fYpI`;yX$^,@=Rj:l^i}>."%?s<7ՆD˯6$4sXH()irHubաLVˁeo(kTg1U-&%rے)Հ&_  ` < fQI.h$AH]v%lgQ`˯Ioc~4V9),Vf< 9Ww/K?iXg9_YfNG(pB%c8A>{3) & *Sgek?&^CS)Qn70hf_KR,6p,f{0{`[;moa R0,7mބzB I*VCPKTMMNönAZW(Oa6,Yn*z=YNsfSv&Z}(co٘<@Cf"9nci9Si[=hGƍb}EU$js¶ W>V44JEE:Ɇ&fcusPjwS$'*>Uc7aw 7s2(0sg3 [SMu9c5v4M-+`1T]qw^}5.H'=F@,ʤc{iqR{ޡ{s||';QfL;WntrU\LD`0aY =Հ]V"ȰՍ0b*Gj~ϱTs 䌫|϶cž@<* duѳ^5f{[R|3 ]K@?|$'B%BLRFœ ^ =1g$eF@RGjL{ZN sYs yȏ  [.?qڂT& 4BCŌe@cXy,P9)UNJ,^局zy߯ulm Q U \Q5[OHsAΰCBBP> (\ Oo){67ޓHq˺TJ0o]̡hֺ=2oN H(wSIO ÇvAIiNtl.ԄkW v / "hH7qc7!8GŴ4\B*oRv%dPr%f.]mA6 VmѱVѥL6 b399E|*yB l d*NMHqb-?m ?Ÿq b@dD.AEtE'o&J`BO#sD{Q?-zKeKLm Gm -tp: >u<4?i5sK&N$TUL>/h'/94/K*]l؈GN 69)e/Y(.@|5n,5<,aP? 43F que^=eb@l&/0@,(5Aat6ha% s""%JVDX8=8}'E~DZ7hWdࡶ;B>Wl,>9BXA%$pPֿ `5k5Iu(atWXM-\ck/ekIewEf_9=Xq"k=W %WG1XO L}]&-ސ_1R#eRn@q0:kB&y_ `k[o?6ަ@b Ě>@$>-- BڱBVʹ^T 69?zP t(ފ(_x):k42""ؘ[räVԉF9kF5k5:,D 2$68B@i7c@w\LdT]e**2/Gm=VQ^Qqk?dgWX^$ 9+>܆i2c@*(P0N/ 7>.y6qĮL1ɼv&Wriĉ`4 -=!2j9E-<%4I+LZfG P\5JCfRI2=hॳqH e Vą-;W갨}O۝yG_Ac.(zL3>rjg9'DDB+qyޗp4hh)&O,5ӻ4ղ5J'CEuI#2㒩(C4LIW"&fB2v 2owPЁ6+9a.=Q '炊Hˇ1LJ _c)ּVc./=ԋFk*hh*븭%Vv=_;Qc3j"fU=f$1<{Q|E9$-Ip;q &({ߣ׶#D-Sua?_A˜)}ߓQlC;Dq+Z'*~u5Б/rY=R5D_G}f䱋wf,^oV7ϪÇ(i '2̝ eGNigg  }.弐kL|b:Yi/]c1[^RdrB.`To6/I K=}{d1??FZ$Bŀ} ɘ_Yyrr '^j*|6Tߣ*LdOⷪ5-gz_ O+Dd7X!p?Kmd~ .8w5j%!uz|xb\adɚ~!sKy9tϿi A10 A`Q +|➇it[w2΃g݃uz, s Ϩ[/pj^ gIG LZT: "1يxQu==(߯"vsn٬gAx!8&3k`/u3Cv.ΝI=} Tͨ%|sI[J'X]O@ !] +oݮ;13zɨ#GvN}iQ߃(Ȃw?l|W }x|'Nbn'dk^8 5*[ Kf~:YRפT6n{]g&Jmx f'-[P ܩE~$ZPAǐQ!z --<1c tVb@|^p]CB5a,UUi,PZ9xl=LYGYG)K֘%7ɓbݵe9 Dwveo<~2=#]WDP`-6lWΙS+*z;>IS Ɏۜ D>$1 <~Ҏ]]Tl-mRioXF?:}<*qWgT8x]5"(㗆qsI Sw\,]77HJ|*% jJ#CfXwVCgwp*#WWtykRV=1>`EQ9ʬUej鈢95* -r4L8;MTyVP!`- SiQxt#TG\ ixfwpo?Ϡz8^'Xjz$Q("exSYke鞩+ _.9 m~3 KTq6}A[˚c 㺎7 tc0e$$F_djhJK8OBXK}iWBe8q,FDeZ # aiPjCJvu#ɧ7eܻfA~s;diwL ]-TfHng+#'!JIi+ yZ_f:c^[ gA"1I4#P*F\oQk|7 |_Xr0LQ.J3Gy1JAǼ8`-9 ~l8H9lo7R<]pO2ű}נՑĘ ʤ#ˑSGGkÙgAD4cMX1Z^ 7ܡr?% O.h#bNYHd?˳g*厩_[u*eX;%0u3 S"3t*~BA?>TpԮfse܃ڃHʵVVZtI1Jj,iNQr䝖0>x 1CbYd'KLQחoAinHtpc\)P3q }kƋ\̯~~eU0HAL,Ύ%J@N ?P3N:t+-M]]hN8$~$+)C HQg& >\|7tOT,s%?1%-&WiO/tC$˳m?gD$JVUTE!8GsfBm' |z*|Є|-d!A;ZdB[ף4 OU r岮P* X;W~k_!̷|UI`Uw4.l/5(9*}f&]f"!lC@wȨ/!8P p*1%<,82C.# ]Ap_ZԦ#i$*6uW>PxR@&hfK*{d^h4YƵ=eܓu@àHZjeFB?DžNtXPªtWj*$P"+ZKE =?8{CKh;c_nÉ<GNJ=6Je -"/} )4y%pC`J JswiAm:qϒOg {58B E>x`XG7bRs_lw Nb1` Eh~?|ErF1 oA1|+8iyDm&I< |5ݖu%9 -2Z.a+f.2K:M?)lbrK]yP;jL7 \JSu=:{qx-.Һ(|\&)ʝD 1(V'by!sa޷Tg3aK򱒈RN9d>iWݷϽUG"qңz14He!NƄj__H@q̩:iCm+n˗Ys&r߉$O_':Dq:rVz`+$ ҿÚ|l ML=nmd~Jb?kΰbn4)"YʍWz 3GOE3gOH̾Ͻ?1w17}r[ہj@ *%c c!6>t.E:f~ءBl`Y4zsX%o]nM+ƙԅ7Z]n0]Hǯ46/|}D_RM=^!\tD)& e͝6s.\}|b<6&è`PU h5d n0bJwS ]kG_y]z.@dM  mo2D vvFB䂆%&pD0y4HQ[Odd~>)oT!Dz|15iv%fq&'SX,ʫƵFA*A{  YZ