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 &

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? > >

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

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

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

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

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

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] 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

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.

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

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

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,

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

[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?

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

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

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

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

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

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

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

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] 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()

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

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

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 possible

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 possible

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 done for SRP

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

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

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 need

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

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

On 2/18/19 2:57 PM, Dimitry Sibiryakov wrote: 18.02.2019 12:55, Alex Peshkoff via Firebird-devel wrote: On the other hand this should better be fixed afterwards - design where SS/CS provide different results is IMHO not good. Something like awful borland's SPB items that provide useful results

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

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 need there. The similar SET DECFLOAT wasn't it, so TIME ZONE didn't had too. That backward compatibility

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

On 2/18/19 2:47 PM, Adriano dos Santos Fernandes wrote: On 18/02/2019 08:37, Vlad Khorsun wrote:   Seriously, if you (and others) consider it is important enough to try to refresh TIP cache in such cases - fill the ticket in tracker and i'll fix it. If the change is going to appear only in

Re: [Firebird-devel] PostgreSQL vs. fsync error

On 2/17/19 10:35 AM, Omacht András wrote: Dear Developers, https://wiki.postgresql.org/wiki/Fsync_Errors Firebird can be also involved in the problem? Perodically we have corrupted databases on linux (85% wrong page type). And this cannot be reproduced for ages. Currently we are running FB

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

On 2/16/19 6:59 PM, Mark Rotteveel wrote: On 16-2-2019 16:04, Dimitry Sibiryakov wrote: 16.02.2019 15:57, Mark Rotteveel wrote: I was wondering if it was considered to also set these options through the DPB. Especially for time zone support, I'm currently considering not supporting this for

Re: [Firebird-devel] What is the cause for isc_login_changed errror?

On 2/13/19 6:11 PM, Pavel Cisar wrote: Alex, problem solved, it was a configuration issue after all. Sorry for false alarm. Sorry, can you explain better. I wonder what configuration caused an error. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] What is the cause for isc_login_changed errror?

On 2/13/19 12:10 PM, Pavel Cisar wrote: Hi all, could anyone explain me what may cause the isc_login_changed error in FB 3 for non-sysdba users? (login works ok for sysdba) It's raised in server.cpp: ServerAuth->accept() That can be a sign of attack on server or bug in FB software. What

Re: [Firebird-devel] Error on bad non-required plugins

On 2/11/19 6:37 PM, Dimitry Sibiryakov wrote: Hello, All.   Currently if plugin module has been found but is bad an error is thrown even if this plugin is not required.   Is it a desired behavior? Yes. This is designed behavior. If plugin was tried to be loaded that means that it is

Re: [Firebird-devel] Security implications of FB4 USE_GBAK_UTILITY

On 2/10/19 12:07 PM, Mark Rotteveel wrote: While answering a question on Stack Overflow about restoring with gbak, I was thinking about the implications of the new system privilege USE_GBAK_UTILITY. A user that can backup and restore a database can do a lot more to a database. They can

Re: [Firebird-devel] ICU in HEAD

On 2/8/19 3:00 PM, Vlad Khorsun wrote: 08.02.2019 13:29, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 12:15 PM, Vlad Khorsun wrote: 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil

Re: [Firebird-devel] CORE-5997

On 2/8/19 10:04 AM, liviuslivius wrote: Hi Can we discusse about CORE-5997? Why it was so fast closed as its iplementation is so important from performance POV? In mentioned tracker ticket I see: > This is e.g. slow compared to udf equivalent I.e. I assume that this problem is raised due to

Re: [Firebird-devel] ICU in HEAD

On 2/8/19 12:15 PM, Vlad Khorsun wrote: 08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU library ? Suggestions? The fastest way sooner of all will be storing

Re: [Firebird-devel] ICU in HEAD

On 2/8/19 2:24 PM, Dimitry Sibiryakov wrote: 08.02.2019 12:21, Alex Peshkoff via Firebird-devel wrote:   The error you are getting is different, so I would guess that search loop is aborted faster in this case. Is it good idea to provide full error message? (like I did - not to make other

Re: [Firebird-devel] ICU in HEAD

On 2/8/19 2:01 PM, Dimitry Sibiryakov wrote: 08.02.2019 8:31, Alex Peshkoff via Firebird-devel wrote: I can't reproduce performance problem: # time (echo 'exit;' | ./isql employee) Statement failed, SQLSTATE = XX000 Could not find acceptable ICU library -Missing entrypoint u_setDataDirectory

Re: [Firebird-devel] Changing generator's initial value without restarting

On 2/8/19 1:24 PM, Jiří Činčura wrote: Hi, is there a way to change the intial value of generator/sequence *without* restarting it? ALTER SEQUENCE? But please explain what do you mean under 'restart'. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ICU in HEAD

On 2/8/19 10:56 AM, Vlad Khorsun wrote: 08.02.2019 9:31, Alex Peshkoff via Firebird-devel wrote: On 2/7/19 6:14 PM, Dimitry Sibiryakov wrote: Hello, All.   I somehow understand why build of current HEAD is failing with message "Could not find acceptable ICU library", but I

Re: [Firebird-devel] ICU in HEAD

On 2/7/19 6:14 PM, Dimitry Sibiryakov wrote: Hello, All.   I somehow understand why build of current HEAD is failing with message "Could not find acceptable ICU library", but I wonder why it takes so much time to get this error? More than 15 second between running of isql and this failure on

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

On 1/24/19 11:50 AM, Gabor Boros wrote: 2019. 01. 24. 8:24 keltezéssel, liviuslivius írta: Hi. I have thinked about oltp comparision, and i think that comparing e.g. classic vs superserver on RAM disc is wrong. Why? Because read from "disc" is as fast as read from cache. The comparision can

Re: [Firebird-devel] Performance - 2.5 vs 3.0 vs 4.0

On 1/24/19 10:24 AM, liviuslivius wrote: Because read from "disc" is as fast as read from cache. That's worth testing for particular SSD. For example my SSD (WDS240G1G0B) works a few times slower than RAM disk. Firebird-Devel mailing list, web interface at

[Firebird-devel] 32-bit builds check

Do not know why but 25% of users continue downloading i86 firebird binaries. Therefore we plan to provide 32-bit for fb4 too. Thoughs who can and wish please test http://web.firebirdsql.org/download/prerelease/linux_x86/ This build is not expected to support Centos !!! It was decided to not

Re: [Firebird-devel] Time zone identifier to displacement convertion

On 1/21/19 1:42 AM, Jorge Gonçalves wrote: I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone database is missing for example the statement "select rdb$time_zone_util.database_version()   from rdb$database;" returns DATABASE_VERSION Statement failed, SQLSTATE

Re: [Firebird-devel] Services API validation differences

On 1/17/19 2:38 PM, Jiří Činčura wrote: I.e. isc_action_svc_repair is services frontend for gfix utility (needs exclusive DB access, can repair broken DB) but isc_action_svc_validate is used for online validation. OK, so both do validation (in case of isc_spb_rpr_validate_db), it's just

Re: [Firebird-devel] Negative value for isc_spb_val_lock_timeout

On 1/17/19 2:29 PM, Jiří Činčura wrote: Hi *, it looks server accepts negative values for isc_spb_val_lock_timeout. Is that expected? Any negative value means unlimited by timeout lock Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Services API validation differences

On 1/17/19 1:41 PM, Jiří Činčura wrote: Hi, what's the difference between isc_action_svc_repair + isc_spb_rpr_validate_db and isc_action_svc_validate? #define isc_action_svc_repair  3    /* Starts database repair process on the server */ #define isc_action_svc_validate   30   

Re: [Firebird-devel] FB4 linux package

On 1/12/19 7:15 PM, Dimitry Sibiryakov wrote: 12.01.2019 17:11, Alex Peshkoff via Firebird-devel wrote: appears -fabi-version switch is not enough.   Did you full clean rebuild with it? Certaily. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

Re: [Firebird-devel] FB4 linux package

On 1/11/19 8:31 PM, Adriano dos Santos Fernandes wrote: On 11/01/2019 15:25, Alex Peshkoff via Firebird-devel wrote: PS. Personally I would prefer not to build any public binaries (except may be docker) at all. Most of open source projects go that way. My experience is that many projects

Re: [Firebird-devel] FB4 linux package

On 1/11/19 9:54 PM, Gabor Boros wrote: 2019. 01. 11. 17:54 keltezéssel, Alex Peshkoff via Firebird-devel írta: Once again updated the build, now try with -fabi-version=7 (8 appears too big). This can affect first of all CentOS-7. Also please try on new systems with libtommath.so.1 (not .0

Re: [Firebird-devel] FB4 linux package

On 1/10/19 6:36 PM, Dimitry Sibiryakov wrote: 10.01.2019 15:35, Alex Peshkoff via Firebird-devel wrote: If we want to support Centos 7 (latest stable Centos release) we will have to use dinosaur gcc4 i.e. same version we use to build FB3. Side-note: "if" is a right word. Personal

Re: [Firebird-devel] FB4 linux package

On 1/10/19 8:39 PM, Gabor Boros wrote: 2019. 01. 10. 16:33 keltezéssel, Alex Peshkoff via Firebird-devel írta: Test it's install is once again highly welcome. Successfully installed on Debian 9, 10 and CentOS 7. (Can connect to /opt/firebird/.../employee.fdb from a different (Windows

Re: [Firebird-devel] FB4 linux package

On 1/10/19 5:48 PM, Dimitry Sibiryakov wrote: 10.01.2019 15:35, Alex Peshkoff via Firebird-devel wrote: That's the worst thing that could happen when testing. If we want to support Centos 7 (latest stable Centos release) we will have to use dinosaur gcc4 i.e. same version we use to build FB3

Re: [Firebird-devel] FB4 linux package

On 1/10/19 3:19 PM, Gabor Boros wrote: Error loading plugin Engine13 Module /opt/firebird/plugins/libEngine13.so exists but can not be loaded /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /opt/firebird/plugins/libEngine13.so) unable to open database That's the worst

[Firebird-devel] FB4 linux package

Hi all! In http://web.firebirdsql.org/download/prerelease/linux_x64/ there is 64-bit linux package of FB4 built using environment planned for 'official' builds (gcc 6.4, glibc 2.17). Please try it with your favorite linux distro (makes sense to check latest stable releases). Possible

Re: [Firebird-devel] Batch API wire protocol

On 11/10/18 12:12 PM, Mark Rotteveel wrote: I do get the feeling (although I maybe wrong, as I don't think I fully understand the protocol), that this will be hard to implement, Bot too hard. The most complex place is when we need to process segments inside segmented blobs (i.e. change

[Firebird-devel] Fwd: [FirebirdSQL/firebird] bfa58e: Cleanup - bad attempt to make events API better

After this commit it's recommended to perform full FB rebuild. Forwarded Message Subject: [FirebirdSQL/firebird] bfa58e: Cleanup - bad attempt to make events API better Date: Mon, 10 Dec 2018 03:10:58 -0800 From: AlexPeshkoff Reply-To: AlexPeshkoff To:

Re: [Firebird-devel] FB4 - Linux snapshots

On 12/3/18 12:17 PM, Gabor Boros wrote: Hi All, The current Windows snapshots of 4.0 are 4.0.0.1324 but the Linux just 4.0.0.1258. Please fix/update it. Build fails due to too old (4.8) ICU. IMO it's also time to decide what toolchain (gcc + glibc) we should use to build FB4 and prepare

Re: [Firebird-devel] CORE-5888

On 11/28/18 11:15 PM, Karol Bieniaszewski wrote: Hi Alex and others. Can you spend some time on fixing CORE-5888 about Android? This is really important to us to have suport of Android (i know, your priorities can be different). As a small incentive, I would say that it would also be very

Re: [Firebird-devel] ODS hdr_creation_date

On 11/24/18 2:34 PM, Mark Rotteveel wrote: On 23-11-2018 17:50, Dmitry Yemanov wrote: 23.11.2018 17:53, Adriano dos Santos Fernandes wrote: Does anyone see any problem in extending (in time zones branch) hdr_creation_date to include the time zone? Already existing (created in Alpha) ODS13

Re: [Firebird-devel] ODS hdr_creation_date

On 11/23/18 7:50 PM, Dmitry Yemanov wrote: 23.11.2018 17:53, Adriano dos Santos Fernandes wrote: Does anyone see any problem in extending (in time zones branch) hdr_creation_date to include the time zone? Already existing (created in Alpha) ODS13 databases will be inaccessible (or FB will

Re: [Firebird-devel] ODS hdr_creation_date

On 11/23/18 5:59 PM, Dimitry Sibiryakov wrote: 23.11.2018 15:53, Adriano dos Santos Fernandes wrote: Does anyone see any problem in extending (in time zones branch) hdr_creation_date to include the time zone?   Older gstat and third-party tools won't be able to handle it correctly. What

Re: [Firebird-devel] src/utilities/rebuild in master

On 11/23/18 5:58 PM, Adriano dos Santos Fernandes wrote: Hi! Isn't this utility obsolete? Could it be removed in master? I think yes - in a case we really need that ancient code (do not know why but if...) it can be found in old branches. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODS hdr_creation_date

On 11/23/18 5:53 PM, Adriano dos Santos Fernandes wrote: Hi! Does anyone see any problem in extending (in time zones branch) hdr_creation_date to include the time zone? Before beta release - absolutely no problem. BTW - when are you going to merge that branch? Firebird-Devel mailing

Re: [Firebird-devel] Crypto functions in firebird

On 8/27/18 1:52 PM, Adriano dos Santos Fernandes wrote: On 27/08/2018 06:15, Alex Peshkoff via Firebird-devel wrote: In firebird4 we have improved hash() function in order to make it support various kinds of hashes. But except hashes there are a lot of other crypto-related tasks that may

Re: [Firebird-devel] SIGINT/SIGTERM handling on POSIX

On 11/06/18 17:17, Adriano dos Santos Fernandes wrote: On 06/11/2018 09:57, Dimitry Sibiryakov wrote: 06.11.2018 7:34, Alex Peshkoff via Firebird-devel wrote: An idea was to have same behavior for remote and embedded connections, please read doc/README.fb_shutdown, pay attention

Re: [Firebird-devel] ODP: Firebird4 sysdba install different then in FB3?

On 10/29/18 20:21, Karol Bieniaszewski wrote: Forgot it  CREATE !!! not alter first  Or you may use CREATE or ALTER - that always works. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Batch API wire protocol

On 10/27/18 15:02, Mark Rotteveel wrote: What is the wire protocol of the batch API (that is: what operations, what message format, etc)?     op_batch_create = 99,     op_batch_msg    = 100,     op_batch_exec   = 101,     op_batch_rls    = 102,     op_batch_cs 

Re: [Firebird-devel] User-defined aggregate functions

On 10/01/18 12:44, Dimitry Sibiryakov wrote: 01.10.2018 11:24, Pavel Cisar wrote: Aggregates could produce various single-value outputs   Why to limit them to single value? Some aggregates could profit if they are able to return more values at once. For example, avg + deviation. That

Re: [Firebird-devel] Transliteration problem with table locks?

On 09/16/18 07:58, Kjell Rilbe wrote: Hi, Got no reply in firebird-support, so trying here. I've been using Firebird since a long time, successfully using quoted identifiers with Swedish characters åäö in them, but have now stumbled upon a problem. I am at version 3.0.3 (on Windows Server

Re: [Firebird-devel] Login with mixed case fails

On 09/17/18 16:31, Mark Rotteveel wrote: Lets rephrase my question. Assuming I have created a user using   create user "CaseSensitive" password 'password' using plugin Srp; Exactly which value must I pass from server to client (assuming the wire protocol, not any transformations fbclient

Re: [Firebird-devel] Login with mixed case fails

On 09/17/18 15:45, Mark Rotteveel wrote: On 16-9-2018 17:28, Mark Rotteveel wrote: I think you should probably post this to the Firebird .net provider mailing list. The problem seems to be that case-sensitive user names need to be correctly supported by the client. And in the case of

Re: [Firebird-devel] FB4 - Linux snapshots

On 10.09.2018 12:36, Gabor Boros wrote: Hi All, The available kits are one month old. Please fix the build process. Working on it... Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] op_void response after op_open_blob

On 29.08.2018 21:23, Jiří Činčura wrote: Hi, I'm debugging an issue, when _sometimes_ (so far no connection to any action), after sending op_open_blob, I get op_void as a response. How should this situation be handled? What could be reason for it? Netwrok server never sends packets with

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

On 27.08.2018 20:10, Adriano dos Santos Fernandes wrote: All, Please. If nobody else sees the magnitude of this problem, I'll shut up. What we talk here is something that is being said to fix read committed, but completely destroys it. Adriano, I agree that calling function multiple times

Re: [Firebird-devel] Crypto functions in firebird

On 27.08.2018 13:37, Sergey Mereutsa wrote: Alex, I think, you can add (using simple warping functions) most used OpenSSL functions - they cover 80%-90% of all needs in most cases. Just my 0.05 MDL :) One detail - that's supposed to be not OpenSSL but tomcrypt. With openssl we have some

Re: [Firebird-devel] Crypto functions in firebird

On 27.08.2018 13:52, Adriano dos Santos Fernandes wrote: But if a functionality is decided to be created in the engine, then it's better to write as a system package using the internal engine (created in time zones branch). Definitely yes - I've just forgotten about new functionality.

[Firebird-devel] Crypto functions in firebird

In firebird4 we have improved hash() function in order to make it support various kinds of hashes. But except hashes there are a lot of other crypto-related tasks that may be useful to execute directly from SP & triggers. Does it make sense to add functions (may be UDR?) for signing something

Re: [Firebird-devel] Sometimes appveyor build fail for no reason

On 27.08.2018 04:10, Adriano dos Santos Fernandes wrote: Hi! Sometimes the build fail with message "Object reference not set to an instance of an object." https://ci.appveyor.com/project/FirebirdSQL/firebird/build/1.0.106/job/453y3ialoydf4r4b May be some problem in their environment (.net

Re: [Firebird-devel] Error code 336920631 in header files

On 23.08.2018 08:53, Jiří Činčura wrote: Nobody? Historically this happened as follows. Initially errors registered for use in utilities could never reach user code. Later some of utilities started to be used as services - but that time errors were always returned as text strings (sooner

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 18:08, Dimitry Sibiryakov wrote: 15.08.2018 16:43, Alex Peshkoff via Firebird-devel wrote: Taking into an account that this is suggested for FB4 (not 2.5) I do not see problems with security.   Imagine server configured with DatabaseAccess = none and/or database configured

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 17:19, Leyne, Sean wrote: I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

On 15.08.2018 17:19, Dimitry Sibiryakov wrote: 15.08.2018 16:13, Alex Peshkoff via Firebird-devel wrote: In the simplest form (create database on current server) that will look like this: execute statement 'create database ''/tmp/t1''';   What about security and other settings? Will newly

[Firebird-devel] Improvement for EXECUTE STATEMENT

I want to suggest simple improvement to execute statement - make it possible to run in it CREATE DATABASE statements. It will not accept parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to the context of newly

Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

On 10.08.2018 10:26, liviuslivius wrote: Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf

Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue

On 08.08.2018 14:49, liviuslivius wrote: Hi, i have succesfully connected my Delphi application using Firedac to Firebird embeded on Android. That's great! Firebird version is LI-V3.0.3.32900. I can retrive data from tables from field types: Integer, BIGINT, CHAR, VARCHAR, DATE, TIME, 

Re: [Firebird-devel] Management statements in PSQL

On 07.08.2018 18:28, Adriano dos Santos Fernandes wrote: Hi! Current management (SET ... / ALTER SESSION) statements are valid only as top-level statements (and hence in EXECUTE STATEMENT too), i.e., cannot be in EXECUTE BLOCK or stored routine. This is a problem, as some of these statements

Re: [Firebird-devel] ⁨ Firebird 3 embedded om iOS⁩

On 27.07.2018 17:30, Svend Meyland Nicolaisen wrote: Thank you very much for the answer. Adrian Marius Popa wrote in October a blog post regarding Firebird 3 (and 2.5) on iOS: https://mapopa.blogspot.com/2017/10/firebird-3-on-apple-ios.html?m=1 The blog post contains little information

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

On 23.07.2018 18:21, Adriano dos Santos Fernandes wrote: May be has nothing to do with Mark's problem, but inet.cpp/alloc_port seems to have a race problem: -- if (!INET_initialized) {     MutexLockGuard guard(init_mutex, FB_FUNCTION);     if (!INET_initialized)     {         ...  

<    2   3   4   5   6   7   8   9   >