4254ef72ec
* 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
68 lines
2.0 KiB
RPMSpec
68 lines
2.0 KiB
RPMSpec
#
|
|
# spec file for package orafce
|
|
#
|
|
# Copyright (c) 2024 SUSE LLC
|
|
#
|
|
# All modifications and additions to the file contributed by third parties
|
|
# remain the property of their copyright owners, unless otherwise agreed
|
|
# upon. The license for this file, and modifications and additions to the
|
|
# file, is the same license as for the pristine package itself (unless the
|
|
# license for the pristine package is not an Open Source License, in which
|
|
# case the license is the MIT License). An "Open Source License" is a
|
|
# license that conforms to the Open Source Definition (Version 1.9)
|
|
# published by the Open Source Initiative.
|
|
|
|
# Please submit bugfixes or comments via https://bugs.opensuse.org/
|
|
#
|
|
|
|
|
|
%define pgname @BUILD_FLAVOR@
|
|
%define realname orafce
|
|
|
|
Name: %{pgname}-orafce
|
|
Version: 4.13.0+git3.25d74aa
|
|
Release: 0
|
|
Summary: Implementation of some Oracle functions into PostgreSQL
|
|
Group: Productivity/Databases/Tools
|
|
License: MIT
|
|
URL: https://github.com/orafce/orafce
|
|
Source0: %{realname}-%{version}.tar.gz
|
|
BuildRequires: %{pgname}-server-devel
|
|
BuildRequires: bison
|
|
BuildRequires: flex
|
|
BuildRequires: krb5-devel
|
|
BuildRequires: libicu-devel
|
|
BuildRequires: openssl-devel
|
|
%requires_eq %{pgname}-server
|
|
Provides: orafce = %{version}-%{release}
|
|
%if "%{pgname}" == ""
|
|
ExclusiveArch: do_not_build
|
|
Name: %{realname}
|
|
%endif
|
|
|
|
%description
|
|
The 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.
|
|
|
|
%prep
|
|
%setup -q -n %{realname}-%{version}
|
|
|
|
%build
|
|
export PATH="$PATH:/usr/lib/%{pgname}/bin"
|
|
make USE_PGXS=1 %{?_smp_mflags} FLEX=/usr/bin/flex
|
|
|
|
%install
|
|
export PATH="$PATH:/usr/lib/%{pgname}/bin"
|
|
make USE_PGXS=1 install DESTDIR=$RPM_BUILD_ROOT
|
|
|
|
%files
|
|
%defattr(-,root,root,-)
|
|
%doc COPYRIGHT.orafce INSTALL.orafce README.asciidoc NEWS
|
|
%{_prefix}/lib/%{pgname}/%{_lib}
|
|
%{_datadir}/%{pgname}/
|
|
%exclude %{_docdir}/%{pgname}/
|
|
|
|
%changelog
|