Re: [Firebird-devel] Replication: declarative control

On 2/21/19 12:46 PM, Pavel Cisar wrote: Second, IMHO declaring tables as "publishable" via CREATE|ALTER TABLE is too restrictive. I'd rather manage the replication set using some global commands, be it ALTER DATABASE or something different, allowing to include/exclude all tables at once, or co

Re: [Firebird-devel] Setting time zone bind through DPB?

On 2/23/19 2:39 PM, Mark Rotteveel wrote: On 18-2-2019 12:59, Alex Peshkoff via Firebird-devel wrote: On 2/18/19 2:21 PM, Adriano dos Santos Fernandes wrote: On 16/02/2019 12:57, Mark Rotteveel wrote: BTW: similar arguments could be made for the SET DECFLOAT options, but I don't have a

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

On 2/23/19 7:54 PM, Dimitry Sibiryakov wrote: 23.02.2019 17:51, Paul Reeves wrote:   It is linked to the fact that rpm installs don't allow interaction at install time, so the security database is not initialised.   IIRC, rpm install 2.5 used to initialize security database using random passw

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

On 2/24/19 10:52 AM, Mark Rotteveel wrote: On 23-2-2019 20:56, Lester Caine wrote: On 23/02/2019 19:21, Paul Reeves wrote:    It is linked to the fact that rpm installs don't allow interaction at install time, so the security database is not initialised.     IIRC, rpm install 2.5 used to initi

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

On 2/25/19 4:45 PM, Mark Rotteveel wrote: On 25-2-2019 13:51, Alex Peshkoff via Firebird-devel wrote: On 2/24/19 10:52 AM, Mark Rotteveel wrote: The security database inside the distribution is already initialized with a Legacy_Auth SYSDBA only. I'm not sure why the same can't be do

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

On 2/25/19 5:51 PM, Lester Caine wrote: On 25/02/2019 14:05, Alex Peshkoff via Firebird-devel wrote: Then lets change this question to why the security database in the distribution isn't initialized for SRP (ie having the PLG$SRP table, maybe other things needed). Would it be possib

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-6011) Enabling legacy authentication in Windows installer leads to less secur config than possible

On 2/25/19 5:51 PM, Lester Caine wrote: On 25/02/2019 14:05, Alex Peshkoff via Firebird-devel wrote: Then lets change this question to why the security database in the distribution isn't initialized for SRP (ie having the PLG$SRP table, maybe other things needed). Would it be possib

Re: [Firebird-devel] isc_database_info and current database user

On 2/27/19 12:30 PM, Kovalenko Dmitry wrote: Hello, Could anybody tell me – how I can get name of current user through isc_database_info API function? I see isc_info_user_names. But I want to get the only one name. isql is using select current_user from rdb$database Firebird-Devel mai

Re: [Firebird-devel] isc_database_info and current database user

On 2/28/19 1:46 PM, Adriano dos Santos Fernandes wrote: On 28/02/2019 05:30, Kovalenko Dmitry wrote: select current_user from rdb$database Usage of similar queries is not good idea for connection provider. It is problem to added new info-tags (current_user and, may be, current_role) for isc_da

Re: [Firebird-devel] isc_database_info and current database user

On 2/28/19 2:15 PM, Kovalenko Dmitry wrote: Can you explain - what a problem with use of SQL to get that data? Need start (and commit) implicit transaction. For me - it is not good behavior of provider. For RORC I can't say for sure that this is too bad behavior. But as a minimum getInfo() r

Re: [Firebird-devel] isc_database_info and current database user

On 3/1/19 12:40 AM, Adriano dos Santos Fernandes wrote: Grouped by user name of what connection pool already is configured for: the user name to connect. Certainly. Mapped user name has nothing to do with connection pool. Why would anyone need the mapped user name instead of the already know

Re: [Firebird-devel] isc_database_info and current database user

On 3/1/19 1:25 PM, Dimitry Sibiryakov wrote: 01.03.2019 8:59, Alex Peshkoff via Firebird-devel wrote: Mapped user name has nothing to do with connection pool.   Are you sure that there will be never a case when single client-side user name is mapped to different server-side users depending

Re: [Firebird-devel] Start transaction from base transaction

On 3/1/19 4:50 PM, Dmitry Yemanov wrote: 01.03.2019 16:40, Adriano dos Santos Fernandes wrote: BTW it would be good to known if this pull request (with fb_info_tra_snapshot_number, SET TRANSACTION SNAPSHOT [ AT NUMBER ] and isc_tpb_at_snapshot_number) will go to master/v4. No problems from m

Re: [Firebird-devel] 32-bit builds check

On 3/2/19 3:24 PM, Mark Rotteveel wrote: On 21-1-2019 18:11, Alex Peshkoff via Firebird-devel wrote: Do not know why but 25% of users continue downloading i86 firebird binaries. Therefore we plan to provide 32-bit for fb4 too. Some theories on why people download the 32 bit variants: 1. They

Re: [Firebird-devel] 32-bit builds check

On 3/2/19 8:18 PM, Mark Rotteveel wrote: On 2-3-2019 13:45, Alex Peshkoff via Firebird-devel wrote: On 3/2/19 3:24 PM, Mark Rotteveel wrote: 2. Usage of the term Linux AMD64 might be confusing for people, assuming it doesn't work on their Intel processor. We may want to consider renami

Re: [Firebird-devel] Timezone id in big endian clients?

On 3/4/19 12:53 PM, Mark Rotteveel wrote: I noticed when using native connections when experimenting with time zone support in Jaybird, that the buffer returned by the client for a TIMESTAMP WITH TIME ZONE will be 12 bytes, even though it is a TIMESTAMP (8 bytes) + short (2 bytes) for the id (p

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

On 3/4/19 2:57 PM, Vlad Khorsun wrote: 04.03.2019 11:16, Simonov Denis via Firebird-devel wrote: Faced the following problem when working with Firebird 4.0 via IBExpert. Trying to execute the following SQL query. SELECT current_time FROM $RDB$DATABASE SQLCODE: -902 GDSCODE: 335545167 Unsucce

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

On 3/4/19 3:15 PM, Vlad Khorsun wrote: 04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 2:57 PM, Vlad Khorsun wrote:   I have additional question: is it true that fbclient now depends on ICU ? As fas as I know - not. At least IntlManager.cpp is placed in src/jrd, which

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

On 3/4/19 5:08 PM, Adriano dos Santos Fernandes wrote: I suppose that any "real" dependency here is to transform TZ-id to string and vice-versa. As that is present in IUtil, changing that to require the server (or transform IDs to string in data structures and wire protocol) would be a signific

Re: [Firebird-devel] CORE-6011 legacy authentication in Windows installer

On 3/6/19 6:18 PM, Paul Reeves wrote: On Wed, 6 Mar 2019 14:33:49 +0100 Mark Rotteveel wrote: Srp is not a legacy authentication, it is just slightly less secure than Srp256 I'm wondering then if I understand the difference between AuthServer and AuthClient. My understanding is that AuthServ

Re: [Firebird-devel] 32-bit vs 64-bit alignment problem (was Re: Timezone id in big endian clients?)

On 3/10/19 1:56 AM, Adriano dos Santos Fernandes wrote: Here is a patch that changes FB_MESSAGE alignment to match Firebird definitions. I have purposely didn't tested for C++11 to use alignas. I think it's better to have an error when problematic types are used and this keyword is not available

[Firebird-devel] Upgrading from 2.5 database with trigger on system table

Pre-FB3 versions made it possible to modify system tables directly including creation of new triggers on them. Currently such triggers are restored from 2.5 backup and can't be removed afterwards. I suggest to skip such triggers during restore with appropriate warning. Opinions? Firebird-De

Re: [Firebird-devel] Upgrading from 2.5 database with trigger on system table

On 3/13/19 6:26 PM, liviuslivius wrote: I do not have this to test but can such trigger be altered and then droped? In 2.5 yes. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Snapshots of 4.0

On 3/31/19 7:42 AM, Gabor Boros wrote: Hi All, The Windows kits are outdated: http://web.firebirdsql.org/download/snapshot_builds/win/4.0 In the Linux directory I see kits of 3.0: http://web.firebirdsql.org/download/snapshot_builds/linux/fbtrunk Fixed now Firebird-Devel mailing list, we

Re: [Firebird-devel] Where is udf_replace.sql in Firebird 4.0 Beta 1 ​?

On 4/15/19 10:50 AM, nilsboede...@t-online.de wrote: Hi I looking for the file misc/upgrade/v4.0/udf_replace.sql in the Firebird 4.0 Distribution ? In linux it's misc/upgrade/udf/udf_replace.sql. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/fir

Re: [Firebird-devel] Snapshots of 4.0

On 4/4/19 11:22 PM, Gabor Boros wrote: 2019. 04. 03. 13:12 keltezéssel, Alex Peshkoff via Firebird-devel írta: Fixed now If try to install on Debian 9.8 got an error message about libtommath.so.0. The installer created a symlink which point to /usr/lib/x86_64-linux-gnu/libtommath.so.1 but

Re: [Firebird-devel] Recovery from fb_shutdown possible?

On 4/19/19 10:45 AM, Mark Rotteveel wrote: Is it possible to recover from calling fb_shutdown? I'm trying to make use of embedded in Jaybird a little more crashproof by calling fb_shutdown on Java application stop. This works fine if this application stop coincides with the process exit. But

Re: [Firebird-devel] Recovery from fb_shutdown possible?

On 4/19/19 2:32 PM, Mark Rotteveel wrote: Jaybird itself is intentionally calling fb_shutdown on stop of the web application. Such a stop may be followed by a redeploy and start of the web application **in the same process**. Given how the library is loaded, this can result in the existing lib

Re: [Firebird-devel] Invalid and ambiguous timestamps with time zones

On 4/23/19 6:45 PM, Adriano dos Santos Fernandes wrote: Hi! With time zones, there is some timestamps that does not exist or are "ambiguous". For example, timestamp '2017-10-15 00:00 America/Sao_Paulo' does not exist as it's in the gap where DST starts and had one hour advanced. And timestamp

Re: [Firebird-devel] Decfloat bind and extended precision numerics

On 4/28/19 5:46 PM, Mark Rotteveel wrote: On 28-4-2019 16:42, Dimitry Sibiryakov wrote: 28.04.2019 16:31, Mark Rotteveel wrote: The problem is exactly that they cannot use those types because these drivers (clients) do not know about the existence of those types...    In this case it is enou

Re: [Firebird-devel] Public headers

On 5/20/19 7:00 PM, Adriano dos Santos Fernandes wrote: Hi! We have ugly things related to API functions and public headers: - Different ibase.h files - why_proto.h API duplication The main problem here is this - duplication of API in why_proto. As soon as it will be gone most of mentioned is

Re: [Firebird-devel] Firebird 4 and ODS 12

On 30.05.2019 18:09, Emil Totev wrote: I wonder would it be possible to make Firebird 4 work with ODS 12 (Firebird 3) databases? Before Firebird 3 it was relatively easy to upgrade your Firebird server - your databases could stay in the old ODS and be upgraded one by one, and it was easier to

Re: [Firebird-devel] Firebird 4 and ODS 12

On 30.05.2019 18:47, Dimitry Sibiryakov wrote: 30.05.2019 17:09, Emil Totev wrote:       SecurityDatabase = $(dir_secDb)/security4.fdb   You must use security3.fdb with ODS 12 in this case. Not necessary. Provider is changed in databases.conf for particular database. Security database sho

Re: [Firebird-devel] Firebird 4 and ODS 12

On 30.05.2019 20:38, Dimitry Sibiryakov wrote: 30.05.2019 18:01, Alex Peshkoff via Firebird-devel wrote: Not necessary. Provider is changed in databases.conf for particular database.   Yes, but auth module has usage of current version of provider hardcoded. In a case of FB4 server it

Re: [Firebird-devel] Firebird 4 and ODS 12

On 31.05.2019 12:09, Emil Totev wrote: On Fri, 31 May 2019 at 11:49, > wrote: On 30.05.2019 18:09, Emil Totev wrote: > I wonder would it be possible to make Firebird 4 work with ODS 12 > (Firebird 3) databases? > > Befor

Re: [Firebird-devel] "Building the code" on site out of date

On 01.06.2019 10:50, Mark Rotteveel wrote: The "Building the code" documentation at https://firebirdsql.org/en/building-the-code/ is out of date. Can someone review and update it? What I see in posix part of documentation is mostly OK - except may be required minimum software versions & con

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

On 11.06.2019 2:15, Adriano dos Santos Fernandes wrote: On 10/06/2019 19:41, Vlad Khorsun wrote: ... Vlad, first of all, please say me what's the difference with Linux fbclient that has libtommath as dependency since v3. I suppose main difference is that linux pure-client installation is som

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

On 11.06.2019 1:41, Vlad Khorsun wrote: Do this 2 facts - client have some ICU library, but it can't convert region ID obtained from   server (because of different ICU version), or even - wrong conversion of region ID at client side because of mismatched ICU   version (sounds impossible, but n

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

On 11.06.2019 14:23, Adriano dos Santos Fernandes wrote: On 11/06/2019 07:57, Vlad Khorsun wrote: 11.06.2019 13:34, Adriano dos Santos Fernandes wrote: On 11/06/2019 03:56, Vlad Khorsun wrote: 11.06.2019 2:15, Adriano dos Santos Fernandes wrote: On 10/06/2019 19:41, Vlad Khorsun wrote: ...

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

On 11.06.2019 14:47, Adriano dos Santos Fernandes wrote: On 11/06/2019 08:33, Alex Peshkoff via Firebird-devel wrote: What you mean by install? Copy one .dll + .msg file is not install. Copy more than one .dll + .msg file is install? Adriano, users prefer to copy just one .dll (in many cases

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

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, y

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

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 n

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

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 corres

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

On 14.06.2019 12:37, Gabor Boros wrote: 2019. 06. 13. 10:51 keltezéssel, Paul Beach írta: b, is the installer creating it? I see some difference between the two install.sh files. The trivial /opt/firebird vs /usr/local/firebird and two times "if [ "yes" = "yes" ]" vs "if [ "no" = "yes" ]".

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

On 14.06.2019 9:00, Gabor Boros wrote: 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? Output of "find / -name "libfbclient*" -type l -ls" w

Re: [Firebird-devel] UDR vs PSQL

On 17.06.2019 11:23, Jiří Činčura wrote: Hi, what performance could one accept between UDR and PSQL? I see that UDR is about 30%-40% slower on my machine (just plain execution - empty UDR vs empty PSQL). Does that align with team's measurements? I'm not saying it's bad or slow. I'm just looki

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

On 14.06.2019 19:41, Gabor Boros wrote: 2019. 06. 14. 15:16 keltezéssel, Alex Peshkoff via Firebird-devel írta: What do ldd isql (in appropriate bin dirs)    and ldd /usr/lib64/libfbclient.so show in both cases? Gabor, please also send me output (rather long - redir to file) of   ldconfig

Re: [Firebird-devel] UDR vs PSQL

On 19.06.2019 19:49, Paul Reeves wrote: I have never compared load and call times for UDFs and SPs, but I have always assumed that a UDF will load and execute more quickly than a SP. Calling UDF is hard process. We must emulate C call stack therefore parameters are multiple times copied here

Re: [Firebird-devel] UDR vs PSQL

On 20.06.2019 16:07, Leyne, Sean wrote: Calling UDF is hard process. We must emulate C call stack therefore parameters are multiple times copied here and there, making CSTRING from CHAR / VARCHAR is also headache - there is no place for terminating zero in the end of that string, therefore memo

[Firebird-devel] Underlying format of high precision numerics

I've compared various possible implementations of high precision numeric. Except existing in fb4 (decfloat based) were checked native gcc's __int128 and ttmath (fixed high precision library with pure .h implementation). Test performed a mix of sum/mult/div operations in a loop. Native code was

Re: [Firebird-devel] Underlying format of high precision numerics

On 21.06.2019 18:15, Mark Rotteveel wrote: Is this about the format used in Firebird internally, or are you also proposing to change the format used in the protocol? Both. Mark On 21-6-2019 15:53, Alex Peshkoff via Firebird-devel wrote: I've compared various possible implementatio

Re: [Firebird-devel] Underlying format of high precision numerics

On 22.06.2019 13:10, Dimitry Sibiryakov wrote: 21.06.2019 15:53, Alex Peshkoff via Firebird-devel wrote: internal binary layout of 128-bit integer is the same for __int128 on x64 (on x86 unsupported), ttmath's 128-bit class on x64 and ttmath on x86.   128 bits integers are supported o

Re: [Firebird-devel] Underlying format of high precision numerics

On 26.06.2019 11:48, Dimitry Sibiryakov wrote: 26.06.2019 8:46, Simonov Denis via Firebird-devel wrote: the DECFLOAT type is defined in the SQL:2016 standard as a separate type, so you don’t need to remove anything. We are talking only about the implementation of NUMERIC (19+, x) and DECIMAL (1

Re: [Firebird-devel] System package for blob manipulation in PSQL

On 27.06.2019 19:48, Mark Rotteveel wrote: P.S. These are use cases where UDF-like functionality is required -- how else would someone provide this functionality?  (I don't see UDRs supporting this) If you think a UDF can do it, why do you think a UDR wouldn't be able to do it? UDRs can do m

Re: [Firebird-devel] Underlying format of high precision numerics

On 06.07.2019 12:03, Mark Rotteveel wrote: This discussion seems to have halted without a conclusion. What is going to happen? Will extended precision numerics change to use an int128 Yes. (and maybe extend maximum precision to 38)? May be. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Compression and encryption

On 15.07.2019 13:27, Jiří Činčura wrote: Hi *, is the compression done before the encryption or after (over the wire data)? Certainly compression is done before encryption. Encrypted data can not be compressed. At least with more or less serious encryption :) Firebird-Devel mailing list

Re: [Firebird-devel] Win_Sspi and wire encryption

On 16.07.2019 9:51, Jiří Činčura wrote: Hi, can the Win_Sspi auth be somehow used with wire encryption (CNCT_client_crypt)? Since 3.0.5 - yes. There is one detail - we use MS API function to obtain session key. And it's documented that it provides high quality key only if kerberos is used.

Re: [Firebird-devel] Win_Sspi and wire encryption

On 16.07.2019 10:06, Jiří Činčura wrote: Since 3.0.5 - yes. There is one detail - we use MS API function to obtain session key. And it's documented that it provides high quality key only if kerberos is used. Is there a related item in the tracker? CORE-5948 Any chance you know the function f

Re: [Firebird-devel] Changing FLOAT to a SQL standard compliant FLOAT datatype

On 20.07.2019 10:54, Mark Rotteveel wrote: Anyone? Single question - does it add more conflicts to grammar? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] И in isc_spb_dbname

On 05.08.2019 14:26, Jiří Činčura wrote: Hi *, I'm trying to send SPB with И (U+0418) in isc_spb_dbname, but Firebird is comply to do so with "PATH NOT FOUND". With isc_spb_utf8_filename I see firebird process to accessing access img1.png, without it img2.png. Checking the byte array I'm sendi

Re: [Firebird-devel] И in isc_spb_dbname

On 06.08.2019 11:12, Jiří Činčura wrote: And one more question - what happens if you try to access that database using isql? isql freezes (after sending the "connect" statement). But looks like it's a parsing error, because first Ctrl-C gives "CON>" and second "Expected end of statement, encou

Re: [Firebird-devel] И in isc_spb_dbname

On 06.08.2019 12:26, Jiří Činčura wrote: Sooner of all that means that there is UTF8 character which can not be represebted by ANSI codepage on the server. Why it would be converted to ANSI on server? I live(d) years under the impression that the isc_dpb_utf8_filename (and SPB) tells server to

Re: [Firebird-devel] И in isc_spb_dbname

On 06.08.2019 12:41, Dimitry Sibiryakov wrote: 06.08.2019 11:36, Alex Peshkoff via Firebird-devel wrote: Why are filenames on windows converted to ANSI, not Unicode? Do not know...   Because Unicode patch was rejected and someone said "we will do it some day in our own way". Can re

Re: [Firebird-devel] И in isc_spb_dbname

On 06.08.2019 12:48, Jiří Činčura wrote: I see 2 reasons for your last words - you do not catch difference between UTF8 and Unicode, or I completely misunderstand what do you want to say here... Yeah, sorry about that. I was writing the question with assumption that the server will take the UTF

Re: [Firebird-devel] Linking re2 and libstdc++ in Linux

On 22.08.2019 19:22, Adriano dos Santos Fernandes wrote: On 22/08/2019 06:20, peshkoff--- via Firebird-devel wrote: Before making a choice i want to know why only optimized build is affected. Pay attention - delete is redefined in it too. Why that behavior difference? Alex, my understand is t

Re: [Firebird-devel] Linking re2 and libstdc++ in Linux

On 26.08.2019 18:25, Adriano dos Santos Fernandes wrote: You noted situation above and I could give more reasons: - re2 has it interface in C++, i.e., there is not C wrapper function receiving C objects like ICU, so when we use shared re2, we'll using libstdc++ in our code, and it could be inlin

[Firebird-devel] TIME WITH TZ

Hi all! From discussion in a thread "Could not find acceptable ICUlibrary​" it's getting clear that we can not satisfy all requirements to time with timezone fields (when exchanging client/server messages) in single format because they (requirements) are too contradictory. Suggested solution

Re: [Firebird-devel] TIME WITH TZ

On 30.08.2019 15:46, Dimitry Sibiryakov wrote: 30.08.2019 14:29, Dmitry Yemanov wrote:    Which sqltype value is provided by isc_dsql_prepare/describe_bind is irrelevant as long as application can override it. But 99.9% existing (at the moment) applications cannot override unknown for them da

Re: [Firebird-devel] TIME WITH TZ

On 30.08.2019 16:12, Dimitry Sibiryakov wrote: 30.08.2019 15:10, Alex Peshkoff via Firebird-devel wrote: why use new datatype at all?   That's a very good question. You took my words out of context... For some applications that makes sense. Firebird-Devel mailing list, web interfa

Re: [Firebird-devel] TIME WITH TZ

On 31.08.2019 12:41, liviuslivius wrote: >>About tools: isql supports all newer features Who use isql, really? I do. :) I suppose only to confirm some bug. I cannot imagine that someone use it by typing directly commands inside or looking at textual output if gui tools have grids, filterin

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 11:17, Vlad Khorsun wrote: 30.08.2019 19:15, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:48, Alex Peshkoff via Firebird-devel wrote: 1. Let's use SQL subtype in order to represent in the message UTC or regional time, i.e. for time with time zone 2 subtypes will

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe the problem you think this solves, and how your proposal solves it?   Hmm... the first paragraph at or

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

On 30.08.2019 19:20, Adriano dos Santos Fernandes wrote: On 30/08/2019 08:56, Dmitry Yemanov wrote: 27.08.2019 3:59, Adriano dos Santos Fernandes wrote: Sometimes a object managed by memory-pool may embed non-pooled memory or other resources. If the main object is not explicitly destroyed, i.e

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

On 02.09.2019 13:10, Dimitry Sibiryakov wrote: 02.09.2019 12:06, Alex Peshkoff via Firebird-devel wrote: Certainly it's much, much better to define rules of object deletion at construction time than to delete something explicitly (here and there) when object is going to be dest

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

On 02.09.2019 13:21, Dimitry Sibiryakov wrote: 02.09.2019 12:15, Alex Peshkoff via Firebird-devel wrote: Don't gorget - 'classic' smart pointers, containers, etc. do NOT work when object is deleted by pool.   That's why object in pool must never use non-pooled child objec

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 13:53, Mark Rotteveel wrote: On 2-9-2019 11:35, Alex Peshkoff via Firebird-devel wrote: On 02.09.2019 11:25, Vlad Khorsun wrote: 30.08.2019 20:41, Mark Rotteveel wrote:   Hope Alex will answer this, below is my own understanding of propositions. Could you explicitly describe

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 14:12, Dimitry Sibiryakov wrote: 02.09.2019 13:06, Alex Peshkoff via Firebird-devel wrote: Suggested approach makes it possible to tune server to return data in a form required by partcular client.   And (just in case) I repeat: suggested approach duplicate data coercion

Re: [Firebird-devel] Attaching non-pooled memory or other resources to memory pool lifecycle

On 02.09.2019 13:42, Dimitry Sibiryakov wrote: 02.09.2019 12:26, Alex Peshkoff via Firebird-devel wrote: When first pool-enabled classes were added to firebird ~15 years ago allocators were absolutely unable to peresent firebird pools.   Pools were implemented that time because standard

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 14:22, Dimitry Sibiryakov wrote: 02.09.2019 13:16, Alex Peshkoff via Firebird-devel wrote: How to make server always use offset (not timezone code) in selected TS with TZ using coersion?   Usual way for data coercion: application just set desired data type in metadata during

Re: [Firebird-devel] TIME WITH TZ

On 02.09.2019 14:30, Dimitry Sibiryakov wrote: 02.09.2019 13:27, Alex Peshkoff via Firebird-devel wrote: May be OK for future versions.   ..."but now we are going to make a quick hack". Ok, ok.   Don't forget to make this hack for boolean datatype as well: those applications

Re: [Firebird-devel] TIME WITH TZ

On 03.09.2019 9:29, Vlad Khorsun wrote: 03.09.2019 4:20, Adriano dos Santos Fernandes wrote: On 02/09/2019 08:06, Alex Peshkoff via Firebird-devel wrote: ICU library often missing on windows client. No, it's not, the C/C++ runtime causes much more problem in Windows than ICU.   It is

Re: [Firebird-devel] TIME WITH TZ

On 05.09.2019 5:28, Adriano dos Santos Fernandes wrote: On 04/09/2019 06:39, Vlad Khorsun wrote:   Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc cases ? Looks like f

Re: [Firebird-devel] TIME WITH TZ

On 05.09.2019 12:04, Lester Caine wrote: On 05/09/2019 08:52, Alex Peshkoff via Firebird-devel wrote:    Error is error, doesn't matter where it happens. Or you could offer "fallback" for wrong database handle\wrong server name in isc_attach_database\not working client DNS\etc

Re: [Firebird-devel] op_crypt case sensitivity on Linux

On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows builds are not. Is this expected behavior? Yes for Arc4 (plugins' names are derived from filenames), no for Symmetric (may be side

Re: [Firebird-devel] TIME WITH TZ

On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine could not drop the asked one, and no workaround should be inserted replacing region codes by wrong offsets. Why are you so

Re: [Firebird-devel] TIME WITH TZ

On 05.09.2019 17:25, Adriano dos Santos Fernandes wrote: On 05/09/2019 10:59, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 16:52, Adriano dos Santos Fernandes wrote: Looks like finally you agreed that return a different tz value is like dropping a different database because engine

Re: [Firebird-devel] op_crypt case sensitivity on Linux

On 05.09.2019 18:11, Mark Rotteveel wrote: On 5-9-2019 13:53, Alex Peshkoff via Firebird-devel wrote: On 05.09.2019 14:33, Jiří Činčura wrote: Hi, it turns out when sending "Arc4" and/or "Symmetric" in op_crypt the Linux builds are case sensitive, while Windows buil

Re: [Firebird-devel] Inserts and FKs

On 06.09.2019 14:14, Carlos H. Cantu wrote: Re: [Firebird-devel] Inserts and FKs Hi "tx2 inserts a detail record in TableB     Trigger on TableB tries to update master record,     since the record is still not visible for this snapshot,     update has null effect" I do not understand t

Re: [Firebird-devel] Inserts and FKs

On 06.09.2019 15:09, Carlos H. Cantu wrote: APvFd> Certainly you can repeat search for master record in trigger but IMHO APvFd> that's not beautiful solution. Not sure if I understand what you mean with "repeat search for master record". if (exists (select * from master where )) i.e. repea

Re: [Firebird-devel] "set decfloat bind double precision" and others

On 10.09.2019 14:35, liviuslivius wrote: The SQL standard defines a number of session management statements that all start with SET: That's funny but a number of session management statements begin not with SET but with ALTER SESSION. SQL standard is not too careful in this aspect. Fi

Re: [Firebird-devel] Handling FbException

On 10.09.2019 18:32, Jiří Činčura wrote: Hi *, every example I've found uses this structure: catch (const FbException& error) { char buf[256]; utl->formatStatus(buf, sizeof(buf), error.getStatus()); // ... } Is is guaranteed that the 256 buffer is enough? Not - though given buffer ap

Re: [Firebird-devel] Plan formatting

On 11.09.2019 10:56, liviuslivius wrote: 2. This interface change is allowed or not. Not Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Handling FbException

On 11.09.2019 11:32, Jiří Činčura wrote: No other method - but if you have reasonable suggestion we will be happy to implement it. Just an idea - language details are not needed. Is the size of the message known? No - at least in advance. What can be done is request to calculate it. That wou

Re: [Firebird-devel] Handling FbException

On 11.09.2019 16:07, Jiří Činčura wrote: No - at least in advance. What can be done is request to calculate it. Is that in API today? No. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Handling FbException

On 11.09.2019 12:59, Dimitry Sibiryakov wrote: 11.09.2019 9:13, Alex Peshkoff via Firebird-devel wrote: No other method - but if you have reasonable suggestion we will be happy to implement it. Just an idea - language details are not needed.   How about an iterator on error lines? It could

Re: [Firebird-devel] Handling FbException

On 11.09.2019 16:19, Dimitry Sibiryakov wrote: 11.09.2019 15:05, Alex Peshkoff via Firebird-devel wrote: One more related idea - return text in firebird-allocated buffer which is later released by explicit cliens call. The main visible disadvantage is possible deadlock when error is OOM

Re: [Firebird-devel] IDE or code editor on Linux

What would you recommend for editing Firebird sources on Linux? I use midnight commander but not to say I recommend it to others - it's just a matter of old habit. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Describing server types on client side

In FB4 there was added a number of new datatypes (and will be added 128-bit integers). For all of them separate SET statement is added to make it possible to bind them with some old, well known to old clients datatype. Also DPB item is added to control initial state of this feature. It was ver

Re: [Firebird-devel] TIME WITH TZ

With ALTER SESSION DESCRIBE STATEMENT a number of problems with extended timestamp format will be gone automatically. But one of key problems remains - what can client do with timezone code when it does not know conversion rule for it. A nice solutipn was already suggested by Vlad - extend tim

Re: [Firebird-devel] Describing server types on client side

On 16.09.2019 13:50, Alex Peshkoff via Firebird-devel wrote:     Example -  after ALTER SESSION DESCRIBE DECFLOAT AS CHAR char() wll be used for decfloat(16) and char() for decfloat(34). Sorry for missed numbers: ALTER SESSION DESCRIBE DECFLOAT AS CHAR char(23) wll be used for decfloat(16

<    1   2   3   4   5   6   7   8   9   >