Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-13 Thread Gabor Boros
2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: a, is there a findable symlink from libfbclient.so.2 to the real name of libfbclient (probably libfbclient.so.3.0.5) b, is the installer creating it? I started from scratch, just in case. After the "make" step the output of "find / -name

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Vlad Khorsun
13.06.2019 17:02, Adriano dos Santos Fernandes wrote: On 13/06/2019 06:43, Vlad Khorsun wrote:   I don't offer to change internal representation (UTC + offset\region_id) as is. This is the only way to have correct comparison of timestamp with time zone. But i offer to change *external*

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Vlad Khorsun
13.06.2019 16:44, Alex Peshkoff via Firebird-devel wrote: On 13.06.2019 12:43, Vlad Khorsun wrote: First, you loose things. The adjusted (displayable) timestamp is not convertible back for duplicated timestamps (DST end).   Not sure i got you. Could you provide an example ? At 03:00:00

[Firebird-devel] [FB-Tracker] Created: (CORE-6083) USING PLUGIN clause does not work in RECREATE USER

2019-06-13 Thread Alexander Peshkov (JIRA)
USING PLUGIN clause does not work in RECREATE USER -- Key: CORE-6083 URL: http://tracker.firebirdsql.org/browse/CORE-6083 Project: Firebird Core Issue Type: Sub-task Components:

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-13 Thread Adriano dos Santos Fernandes
On 13/06/2019 12:43, Mark Rotteveel wrote: > > I propose the following solution: > > If ICU is present, use the current logic to derive the time in the > specified zone, but if ICU is absent, just display the UTC time > (+00:00). Don't throw errors for this. > I do not see a need to do an

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-13 Thread Mark Rotteveel
On 11-6-2019 16:35, Adriano dos Santos Fernandes wrote: On 11/06/2019 11:22, liviuslivius wrote: >from rdb$database - BOOM! But why is that boom? Why not show e.g. 11.06.2019 16:08 (GMT+01:00)? This does require some conversion? This is stored during save process. if user uses +01:00

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Dimitry Sibiryakov
13.06.2019 16:45, Adriano dos Santos Fernandes wrote: Considering the reality that we don't have SQL parser in the client for tools usage, and that generic tools (ISQL and like) will be the clients for the feature, no, they can't issue a server call to decode each column its going to display.

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Adriano dos Santos Fernandes
On 13/06/2019 11:23, Dimitry Sibiryakov wrote: > 13.06.2019 16:02, Adriano dos Santos Fernandes wrote: >> So one (client) could request "give-me that timestamp-tz (utc timestamp >> + region/offset) columns and additionally give-me its string >> representation or offset or whatever". > >   System

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Dimitry Sibiryakov
13.06.2019 16:02, Adriano dos Santos Fernandes wrote: So one (client) could request "give-me that timestamp-tz (utc timestamp + region/offset) columns and additionally give-me its string representation or offset or whatever". System table or package suits that. If user application needs that

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Adriano dos Santos Fernandes
On 13/06/2019 11:02, Adriano dos Santos Fernandes wrote: > Even a different external representation would need to work as input > data when sending data from client to server. > > So as I said, a data that have dummy fields when using from > client->server I'm totally against. > > A extendable

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Adriano dos Santos Fernandes
On 13/06/2019 06:43, Vlad Khorsun wrote: > > >   I don't offer to change internal representation (UTC + > offset\region_id) as is. > This is the only way to have correct comparison of timestamp with time > zone. > But i offer to change *external* representation to region_time + > offset\region_id

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 13.06.2019 12:43, Vlad Khorsun wrote: First, you loose things. The adjusted (displayable) timestamp is not convertible back for duplicated timestamps (DST end).   Not sure i got you. Could you provide an example ? At 03:00:00 due to DST change time is set to 02:00:00. To what UTC

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 12.06.2019 19:57, Adriano dos Santos Fernandes wrote: On 12/06/2019 13:33, Gabor Boros wrote: Hi All, I try to make and test "my own" build with Debian 10. First with default settings, just execute "autogen.sh", "make" and "make install" without any modification. At the last step I got the

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-13 Thread Alex Peshkoff via Firebird-devel
On 11.06.2019 17:14, Vlad Khorsun wrote: So users don't want messages => don't need .msg file. Users want message but don't want .msg file => it will not have messages.   This is not true. fbclient contains all error messages engine could produce. It have just some messages of utilities,

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Vlad Khorsun
12.06.2019 14:43, Adriano dos Santos Fernandes wrote: On 11/06/2019 16:52, Vlad Khorsun wrote: 11.06.2019 22:28, Adriano dos Santos Fernandes wrote: On 11/06/2019 13:08, Vlad Khorsun wrote: He may also do not use fbclient to format (convert from/to ts to string) or convert (with/without

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Vlad Khorsun
12.06.2019 18:27, Adriano dos Santos Fernandes wrote: On 12/06/2019 10:18, Dimitry Sibiryakov wrote: 12.06.2019 13:43, Adriano dos Santos Fernandes wrote: Then we will not have a single source of truth anymore. When user will create a client timestamp-tz value, he will need to fill that

Re: [Firebird-devel] Build, install and test 3.0 on Debian 10

2019-06-13 Thread Paul Beach
> I try to make and test "my own" build with Debian 10. First with default > settings, just execute "autogen.sh", "make" and "make install" without > any modification. At the last step I got the next problem: > > > Firebird 3.0.5.33140-0.amd64 Installation > > Press Enter to start

[Firebird-devel] [FB-Tracker] Created: (CORE-6082) From time to time handle to restore of security3.fdb backup is not released by firebird.exe (using service_mgr)

2019-06-13 Thread Karol Bieniaszewski (JIRA)
>From time to time handle to restore of security3.fdb backup is not released by >firebird.exe (using service_mgr) --- Key: CORE-6082 URL: