Re: [Firebird-devel] How to build for Android 64 bit

2020-08-24 Thread Alex Peshkoff via Firebird-devel
On 2020-08-24 14:28, marius adrian popa wrote: Alex could you publish arm64 version on Firebird 3.0 download page ? I do not work with FB3 download page myself, I can just prepare binary and put into prerelease place. Firebird-Devel mailing list, web interface at https://lists.sourcefor

Re: [Firebird-devel] How to build for Android 64 bit

2020-08-25 Thread Alex Peshkoff via Firebird-devel
On 2020-08-24 23:34, marius adrian popa wrote: Tested with 3.0 branch and fails at one moment export NDK=$HOME/android-ndk-r17c ./autogen.sh --prefix=/opt/firebird --enable-binreloc --with-cross-build=android.arm64 --without-editline  --with-builtin-tommath make yvalve make[4]: Entering direc

Re: [Firebird-devel] How to install a local source build for testing purposes?

2020-08-25 Thread Alex Peshkoff via Firebird-devel
On 2020-08-25 05:07, Ian Lawrence Barwick wrote: Hi I maintain the PostgreSQL foreign data wrapper (FDW) for Firebird [1] and am planning to verify it against Firebird 4 to check for compatibility, new features which need supporting etc. [1] https://github.com/ibarwick/firebird_fdw/ To which e

Re: [Firebird-devel] How to install a local source build for testing purposes?

2020-08-27 Thread Alex Peshkoff via Firebird-devel
On 2020-08-27 17:28, Ian Lawrence Barwick wrote: That unfortunately doesn't work: $ ./isql employee Statement failed, SQLSTATE = 08006 Unable to complete network request to host "localhost". -Failed to establish a connection. Use CONNECT or CREATE DATABASE to specify a database

Re: [Firebird-devel] How to install a local source build for testing purposes?

2020-08-27 Thread Alex Peshkoff via Firebird-devel
On 2020-08-27 17:48, Ian Lawrence Barwick wrote: 2020年8月27日(木) 23:28 Ian Lawrence Barwick : 2020年8月25日(火) 18:02 Alex Peshkoff via Firebird-devel : On 2020-08-25 05:07, Ian Lawrence Barwick wrote: (...) ./configure --prefix=/opt/firebird4 \ --with-editline \ Almost for sure --with-system

Re: [Firebird-devel] How to install a local source build for testing purposes?

2020-08-28 Thread Alex Peshkoff via Firebird-devel
On 2020-08-27 19:01, Ian Lawrence Barwick wrote: Related to that: - is it problematic if more than one Firebird instance is using that directory? I will start with mentioning once again simple requirement - users, having embedded access to firebird databases, should be in firebird group. As

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 17:23, Dimitry Sibiryakov wrote: Hello, All.   In all Firebird versions up to current backup content is padded up to 512 bytes buffer size but does it have any meaning nowadays?   I'm asking because this padding causes a little problem during restore from client side using serv

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 19:18, Dimitry Sibiryakov wrote: 01.09.2020 18:15, Alex Peshkoff via Firebird-devel wrote: And what's a  problem with it? Is database restored?   Yes. Is gbak service finished?   No. Application fall to endless loop on isc_service_query() waiting for data request

Re: [Firebird-devel] Backup padding

2020-09-01 Thread Alex Peshkoff via Firebird-devel
On 2020-09-01 19:34, Dimitry Sibiryakov wrote: 01.09.2020 18:24, Alex Peshkoff via Firebird-devel wrote: Can you send me problematic backup?   No backup file exists. This application uses the service this way on both sides. A piece come from one server - the piece is sent to the other. I

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-09-02 Thread Alex Peshkoff via Firebird-devel
On 2020-09-02 14:06, Jiří Činčura wrote: Nobody? Seems like a bug to me... You've forgotten keyword OF in SET BIND statement: SQL> set sqlda_display on; SQL> select sum(cast(1 as bigint)) from rdb$database; INPUT message field count: 0 OUTPUT message field count: 1 01: sqltype: 32752 INT128

Re: [Firebird-devel] Set bind for numeric(38) for sum function

2020-09-02 Thread Alex Peshkoff via Firebird-devel
On 2020-09-02 15:51, Dimitry Sibiryakov wrote: 02.09.2020 14:49, Alex Peshkoff via Firebird-devel wrote: You've forgotten keyword OF in SET BIND statement   I wonder why parser don't throw error in this case... SQL> set bind int128 to legacy; Statement failed, SQLSTATE = 4200

Re: [Firebird-devel] BlobWrapper and sizes

2020-09-04 Thread Alex Peshkoff via Firebird-devel
On 2020-08-10 17:33, Dimitry Sibiryakov wrote: Hello All.   BlobWrapper::getSize() uses SLONG for total size parameter but getData() uses FB_SIZE_T for the same purpose. Shouldn't they match? Should better both be ULONG - like blb_length / blh_length. Firebird-Devel mailing list, web in

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-04 Thread Alex Peshkoff via Firebird-devel
On 2020-08-05 18:48, Ivan Přenosil wrote: In FB2.5 I sometimes construct exception messages with newline like this   EXCEPTION E_ERROR 'msg-á' || x'0A0D' || 'msg-é'; In FB3 and FB4 it can cause error   Statement failed, SQLSTATE = 22000   Malformed string   -At block line: 4, col: 3 Problem is

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 14:04, Dimitry Sibiryakov wrote: 04.09.2020 12:57, Alex Peshkoff via Firebird-devel wrote: Not reproduced:   You forgot "set names win1250" at the beginning of the script. The result remains almost the same: Statement failed, SQLSTATE = HY000 exception 1 -E_ERROR

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 17:49, Ivan Přenosil wrote: Dne 04.09.2020 v 12:57 Alex Peshkoff via Firebird-devel napsal(a): Not reproduced: SQL> CREATE DATABASE '~/testDB.fdb' USER 'SYSDBA' PASSWORD 'masterkey' DEFAULT CHARACTER SET WIN1250; SQL> CREATE EXCEPTION  E_ER

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-07 14:54, Jiří Činčura wrote: Hi, one of tests in .NET Provider is doing isc_action_svc_nbak. On 4.0.0.2115 (and FB 2.5 and FB 3.0) everything is fine but on 4.0.0.2117 (and later) it fails with: unrecognized service parameter block All services except for getting server log require

Re: [Firebird-devel] Problem with exception message and OCTETS.

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-04 22:35, Adriano dos Santos Fernandes wrote: On 05/08/2020 12:48, Ivan Přenosil wrote: In FB2.5 I sometimes construct exception messages with newline like this   EXCEPTION E_ERROR 'msg-á' || x'0A0D' || 'msg-é'; In FB3 and FB4 it can cause error   Statement failed, SQLSTATE = 22000

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

2020-09-07 Thread Alex Peshkoff via Firebird-devel
On 2020-09-07 14:54, Jiří Činčura wrote: Hi, one of tests in .NET Provider is doing isc_action_svc_nbak. On 4.0.0.2115 (and FB 2.5 and FB 3.0) everything is fine but on 4.0.0.2117 (and later) it fails with: unrecognized service parameter block All services except for getting server log require

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

2020-09-08 Thread Alex Peshkoff via Firebird-devel
On 2020-09-07 20:07, Jiří Činčura wrote: Can you provide exact SPB starting service? Yes. It's { 20, 106, 44, 0, 110, 101, 116, 112, 114, 111, 118, 105, 100, 101, 114, 95, 116, 101, 115, 116, 115, 95, 68, 101, 102, 97, 117, 108, 116, 95, 70, 97, 108, 115, 101, 95, 68, 105, 115, 97, 98, 108, 10

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

2020-09-08 Thread Alex Peshkoff via Firebird-devel
On 2020-09-08 11:00, Jiří Činčura wrote: Thanks, reproduced. Great. Should I also add it to tracker? Not needed - it did not get into public releases. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Logging of warnings

2020-09-11 Thread Alex Peshkoff via Firebird-devel
On 2020-09-10 17:55, Dimitry Sibiryakov wrote: Hello All.   If IStatus contains only warnings as the result of setWarnings() call then using iscLogStatus() for it produces message containing "unknown ISC error 0" because mergeStatus() put it there.   Is it expected and desired behavior? De

Re: [Firebird-devel] Firebird ppa 3.0.6 for ubuntu 20.04

2020-09-14 Thread Alex Peshkoff via Firebird-devel
On 2020-09-14 11:39, Tonal wrote: Is there information when the last server release - 3.0.6 That said but 3.0.6 has a few severe regressions. You should better wait for 3.0.7. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Cancel isc_attach_database Before Timeout?

2020-09-21 Thread Alex Peshkoff via Firebird-devel
On 2020-09-21 15:52, Dimitry Sibiryakov wrote: 21.09.2020 13:14, Scott Morgan via Firebird-devel wrote: So, to be safe, is there a way to cancel the isc_attach_database call?   fb_cancel_operation(fb_cancel_abort) in ordinary cases, fb_shutdown() before application exit. fb_cancel_operati

Re: [Firebird-devel] Cancel isc_attach_database Before Timeout?

2020-09-21 Thread Alex Peshkoff via Firebird-devel
On 2020-09-21 16:15, Scott Morgan via Firebird-devel wrote: On 21/09/2020 13:52, Dimitry Sibiryakov wrote: 21.09.2020 13:14, Scott Morgan via Firebird-devel wrote: So, to be safe, is there a way to cancel the isc_attach_database call?   fb_cancel_operation(fb_cancel_abort) in ordinary cases,

Re: [Firebird-devel] Cancel isc_attach_database Before Timeout?

2020-09-21 Thread Alex Peshkoff via Firebird-devel
On 2020-09-21 16:43, Scott Morgan via Firebird-devel wrote: Would it do anything in a normal client situation? No. And looks like nothing is needed. Do you have any problems on client when closing application? Firebird-Devel mailing list, web interface at https://lists.sourceforge.ne

Re: [Firebird-devel] Cancel isc_attach_database Before Timeout?

2020-09-21 Thread Alex Peshkoff via Firebird-devel
On 2020-09-21 18:31, Dimitry Sibiryakov wrote: 21.09.2020 17:28, Scott Morgan via Firebird-devel wrote: Not as such, but it's relying on undefined behaviour (exiting an app whilst worker threads are still active)   On Windows it is defined behavior. Call to ExitProcess() made by default RTL w

Re: [Firebird-devel] Cancel isc_attach_database Before Timeout?

2020-09-21 Thread Alex Peshkoff via Firebird-devel
On 2020-09-21 19:11, Dimitry Sibiryakov wrote: 21.09.2020 18:03, Alex Peshkoff via Firebird-devel wrote: The most intresting for us - it's closing all opened sockets (suppose for non-TCP clients something similiar is done). As the result all I/O waits on them are finished at once, therefo

Re: [Firebird-devel] Firebird PDO preprocessing sql

2020-09-22 Thread Alex Peshkoff via Firebird-devel
On 2020-09-22 16:42, Simonov Denis via Firebird-devel wrote: Hello. I wrote a patch for the PHP PDO Firebird driver. https://github.com/php/php-src/pull/4920 The essence of the patch is to correctly process the EXECUTE BLOCK statement, as well as comments and lines. For the patch, some pieces

Re: [Firebird-devel] Firebird DSQL parser and parser generator

2020-10-13 Thread Alex Peshkoff via Firebird-devel
On 2020-10-13 06:15, Arily Essen via Firebird-devel wrote: 2. (drawing on long-term experience) - I have seen some old threads (for instance "BTYACC" starting on Dec 4, 2004) where pros/cons of different types of parsers and parser generators were discussed in the context of porting/migration

Re: [Firebird-devel] Official Docker Images of Firebird

2020-10-14 Thread Alex Peshkoff via Firebird-devel
On 2020-10-11 00:16, Adriano dos Santos Fernandes wrote: On 08/10/2020 08:18, Dev HrOokami wrote: Hello! I saw a talk here about official Firebird Docker Images and I am interested in. As my PR merged, there is already automated build for Alpine in GitHub Actions, both for FB 3 & 4 (but exclude

Re: [Firebird-devel] Firebird 4 database creation speed

2020-10-19 Thread Alex Peshkoff via Firebird-devel
On 10/19/20 5:00 PM, Dimitry Sibiryakov wrote: Hello All.   With current Firebird 4 snapshot with default firebird.conf (legacy auth disabled) and no Srp SYSDBA user, the query create database "localhost:crypt_test" user "SYSDBA" password "masterke"; is much slower than create database "loc

Re: [Firebird-devel] Firebird 4 database creation speed

2020-10-20 Thread Alex Peshkoff via Firebird-devel
On 10/19/20 8:57 PM, Dimitry Sibiryakov wrote: 19.10.2020 19:09, Dimitry Sibiryakov wrote: the time between the command has been issued and the error is shown.   And if you didn't notice: firebird.conf is default which means that legacy auth is disabled on server side. I though that in this c

Re: [Firebird-devel] Conversion error from string to date in Firebird 4

2020-10-22 Thread Alex Peshkoff via Firebird-devel
On 10/22/20 2:09 PM, Adriano dos Santos Fernandes wrote: SQL> select timestamp '22 oct 20' from rdb$database; CONSTANT = 2020-10-22 00:00:00. But now you can't easily know if 20 is a time zone or a year. In this particular case that's known

Re: [Firebird-devel] gfix -icu not properly documented in Firebird 3 release notes

2020-10-26 Thread Alex Peshkoff via Firebird-devel
Can someone (Alex) writ this? Or alternatively, give me sufficient information so that I can write it? Do not know what else to write here except After changing ICU version (also copying database file from one box to another with another ICU version) run gfix -icu your_database Fireb

Re: [Firebird-devel] Non-ascii user names in SRP

2020-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/4/20 6:37 PM, Dimitry Sibiryakov wrote: 02.11.2020 16:18, Dimitry Sibiryakov wrote:    It looks like user name is converted from win1251 into utf-8 one time more than needed.   I've found the problem. It happens when SRP plugin is trying to use attachment from login info which charset i

Re: [Firebird-devel] Non-ascii user names in SRP

2020-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/20 1:22 PM, Dimitry Sibiryakov wrote: 05.11.2020 10:35, Alex Peshkoff via Firebird-devel wrote: That's how it worked before and that caused deadlocks (see http://tracker.firebirdsql.org/browse/CORE-6412). (BTW - fix for 6412 is backported to B3, i.e. it's not fb4-only issue)

Re: [Firebird-devel] Non-ascii user names in SRP

2020-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/20 2:24 PM, Dimitry Sibiryakov wrote: 05.11.2020 12:10, Alex Peshkoff via Firebird-devel wrote: They want to modify same record. When that happens in 2 different transactions, started from 2 different attachments (specially pay attention that one is started and committed in DFW of

Re: [Firebird-devel] Non-ascii user names in SRP

2020-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/20 2:37 PM, Vlad Khorsun wrote: 05.11.2020 11:35, Alex Peshkoff via Firebird-devel пишет: On 11/4/20 6:37 PM, Dimitry Sibiryakov wrote: 02.11.2020 16:18, Dimitry Sibiryakov wrote:    It looks like user name is converted from win1251 into utf-8 one time more than needed.   I've

Re: [Firebird-devel] How to drop LegacyAuth SYSDBA?

2020-11-05 Thread Alex Peshkoff via Firebird-devel
On 11/5/20 5:03 PM, Mark Rotteveel wrote: I just tried to drop the LegacyAuth SYSDBA account from the security database, but this only results in: SQL> drop user sysdba using plugin Legacy_UserManager; Statement failed, SQLSTATE = HY000 delete record error As the second best option I tried dis

Re: [Firebird-devel] External engine lifecycle

2020-11-10 Thread Alex Peshkoff via Firebird-devel
On 11/6/20 11:10 AM, Jiří Činčura wrote: It must be bound to the Database class instance. It's talked about routines instance in https://github.com/FirebirdSQL/firebird/blob/master/doc/README.external_routines.txt For the engine, it must be the same. In the document I see only: === When Fireb

Re: [Firebird-devel] Srp keys safeguards

2020-11-11 Thread Alex Peshkoff via Firebird-devel
On 11/5/20 8:06 PM, Dimitry Sibiryakov wrote: Hello All.   https://en.wikipedia.org/wiki/Secure_Remote_Password_protocol says: The two parties also employ the following safeguards:     Carol will abort if she receives B = 0 (mod N) or u = 0.     Steve will abort if he receives A (mod N) = 0.

Re: [Firebird-devel] Parameter Base of API implementation templates

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/13/20 8:20 PM, Dimitry Sibiryakov wrote: Does subj mean that I can inherit, for example, IStatus implementation from IVersioned (or IReferenceCounted) instead of IDisposable? No. (Though must say never tried.)   If not, how exactly this parameter is supposed to be used? When you need

Re: [Firebird-devel] IStatus after cloning

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/14/20 2:11 AM, Dimitry Sibiryakov wrote: 13.11.2020 21:45, peshkoff--- via Firebird-devel wrote: Copy.   Why? I see no place in sources where original object is still in use after cloning. This is public API function (BTW, first of all needed in Interface.h / FbException). Hell

Re: [Firebird-devel] SQLCODE in OO API

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/16/20 7:27 PM, Dimitry Sibiryakov wrote:   Is it completely desupported or just forgotten? It was declared deprecated when sqlstate was introduced. I suppose it's _very_ easy to add such support, removing it later will be much harder. Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] SQLCODE in OO API

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/16/20 7:33 PM, Dimitry Sibiryakov wrote: 16.11.2020 17:31, Alex Peshkoff via Firebird-devel wrote: It was declared deprecated when sqlstate was introduced.   I see no support for SQLSTATE in the API either. IMHO should go to Util. BTW, I'm afraid there may be something else mi

Re: [Firebird-devel] SQLCODE in OO API

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/16/20 7:42 PM, Dimitry Sibiryakov wrote: 16.11.2020 17:38, Alex Peshkoff via Firebird-devel wrote: I'm afraid there may be something else missing (like isc_vax_integer for example).   isc_vax_integer is hidden behind IXPBBulder which works as ClumpletReader. We still do not

Re: [Firebird-devel] SQLCODE in OO API

2020-11-16 Thread Alex Peshkoff via Firebird-devel
On 11/16/20 7:54 PM, Dimitry Sibiryakov wrote: 16.11.2020 17:46, Alex Peshkoff via Firebird-devel wrote: Anyway fill free to add pull request with sqlstate support.   On contrary, I would like to forget about it. Why wasting time in that case here? Firebird-Devel mailing list, web

Re: [Firebird-devel] Errors vector lifetime

2020-11-18 Thread Alex Peshkoff via Firebird-devel
On 11/18/20 7:49 PM, Dimitry Sibiryakov wrote: Hello All.   How long pointer returned from IStatus::getErrors() is supposed to be valid?   Until the next call of init()?   Until the next call of setErrors()?   Until the next call of getErrors()? Always supposed that until any call, changing

Re: [Firebird-devel] IStatus::setErrors2() and malformed input

2020-11-20 Thread Alex Peshkoff via Firebird-devel
On 11/20/20 6:35 PM, Dimitry Sibiryakov wrote: Hello All.   What setErrors2() is supposed to do on malformed input? For example if received length of input buffer is mistakenly small and the last isc_arg_xxx missing its value. setErrors2() is should trust passed arguments, it's added for a

Re: [Firebird-devel] use applications with new firebird server

2020-11-24 Thread Alex Peshkoff via Firebird-devel
On 11/24/20 5:13 PM, Ismael L. Donis Garcia wrote: Are those adjustments documented somewhere? Yes, mostly in FB3 release notes - there is no big difference between FB3 & 4 from this POV. But read also about backwards compatibility in FB4 release notes too. Firebird-Devel mailing list,

Re: [Firebird-devel] Builds with USE_VALGRIND fail

2020-11-26 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 11:15 AM, Paul Reeves wrote: When I build HEAD with --enable-developer and -DUSE_VALGRIND I get these errors: alloc.cpp:2182:79: error: invalid conversion from ‘size_t (*)(size_t) {aka long unsigned int (*)(long unsigned int)}’ to ‘unsigned int’ [-fpermissive] common.h:772:51: error

Re: [Firebird-devel] Builds with USE_VALGRIND fail

2020-11-26 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 12:05 PM, Alex Peshkoff via Firebird-devel wrote: Useally we do not log DEV_BUILD problems (first of all not to confuse users I think), I will take a look what's wrong. fixed Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/fir

Re: [Firebird-devel] Reserving a new error code facility

2020-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/26/20 10:46 PM, Mark Rotteveel wrote: I'm currently writing a driver for the R2DBC specification (a new Java specification for reactive database drivers). Is it OK if I reserve a new facility code for R2DBC driver errors (similar like I did in the past for Jaybird)? OK for me. Fire

Re: [Firebird-devel] Jaybird Srp authentication issue

2020-12-04 Thread Alex Peshkoff via Firebird-devel
On 12/4/20 4:38 PM, Mark Rotteveel wrote: A bug was reported today against Jaybird (http://tracker.firebirdsql.org/browse/JDBC-635), that certain Srp users cannot authenticate against Firebird 3 when using Jaybird. The issue is not reproducible with fbclient. This obviously means that there i

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-08 Thread Alex Peshkoff via Firebird-devel
On 12/8/20 6:55 PM, Dimitry Sibiryakov wrote: Hello All.   Should a custom implementation of IStatus recognize and ignore a special case when GDS error code is set to zero using parameter ( isc_arg_gds, 0, isc_arg_end } or error with zero code is also an error? From IStatus POV - also an

Re: [Firebird-devel] Errors vector lifetime

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:03 PM, Dimitry Sibiryakov wrote: 18.11.2020 17:49, Dimitry Sibiryakov wrote:    How long pointer returned from IStatus::getErrors() is supposed to be valid?   I think I found a weird case. In Y-valve there is code like this:   status.setErrors(status.getErrors());   During such

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/8/20 8:20 PM, Dimitry Sibiryakov wrote: 08.12.2020 17:36, Alex Peshkoff via Firebird-devel wrote:   Should a custom implementation of IStatus recognize and ignore a special case when GDS error code is set to zero using parameter ( isc_arg_gds, 0, isc_arg_end } or error with zero code is

Re: [Firebird-devel] Errors vector lifetime

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:28 PM, Dimitry Sibiryakov wrote: 09.12.2020 12:21, Alex Peshkoff via Firebird-devel wrote:   During such self assignment returned pointer can be invalidated by setErrors() code before using input parameter which may cause crash or wrong result. Builtin implementation works

Re: [Firebird-devel] IStatus::setErrors() to "no errors"

2020-12-09 Thread Alex Peshkoff via Firebird-devel
On 12/9/20 2:31 PM, Dimitry Sibiryakov wrote: 09.12.2020 12:23, Alex Peshkoff via Firebird-devel wrote: That depends upon getState() internals, is not it? :)   Yes. Firebird implementation recognizes zero error code in getState() so I wonder if it is a specs' requirement or such recogn

Re: [Firebird-devel] How to build for Android 64 bit

2020-12-11 Thread Alex Peshkoff via Firebird-devel
On 12/11/20 9:17 PM, marius adrian popa wrote: Hello Alex , For android i see that firebird 3.0.7 builds ok (there are arm binaries on firebirdsql) What ndk do you recommend? I've used r10d - for FB3 it's ok, not for FB4. Firebird-Devel mailing list, web interface at https://lists.sourc

Re: [Firebird-devel] fbclient.dll 4.0.0.2308 can't connect to FB2.5

2020-12-30 Thread Alex Peshkoff via Firebird-devel
On 12/30/20 5:28 PM, Ivan Přenosil wrote: I tested the latest snapshot Firebird-4.0.0.2308 (both 32 and 64) and it can't connect to FB2.5 database, the error is   Statement failed, SQLSTATE = 28000   Your user name and password are not defined. Ask your database administrator to set up a Firebi

Re: [Firebird-devel] ibase.h vs interface.h

2021-01-08 Thread Alex Peshkoff via Firebird-devel
On 1/7/21 8:25 PM, Scott Morgan via Firebird-devel wrote: Just looking for some clarification: When writing c and C++ apps, what is the recommended API? For new projects - definitely API in interface.h. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listi

Re: [Firebird-devel] RDB$CONFIG.RDB$CONFIG_NAME datatype

2021-01-20 Thread Alex Peshkoff via Firebird-devel
On 1/20/21 3:41 PM, Vlad Khorsun wrote: Hi, all   I'll speak about new table RDB$CONFIG introduced with implementation of CORE-3708.   The field RDB$CONFIG_NAME has datatype defined as VARCHAR(63) CHARACTER SET UTF8. The original reasons behind this choice was: - UTF8 as charset for most sy

Re: [Firebird-devel] ODP: Blob filters and UDF deprecation

2021-01-31 Thread Alex Peshkoff via Firebird-devel
On 1/31/21 8:23 PM, Karol Bieniaszewski wrote: As Udf’s are depricated, are somwhere all current udfs rewriten in udr form? I mean about fbudf.dll and ib_udf.dll and with source code to look at it as a sample for self written „udr_udf” ? See misc/upgrade/udf in linux distro. Sorry, do n

Re: [Firebird-devel] Blob filters and UDF deprecation

2021-01-31 Thread Alex Peshkoff via Firebird-devel
On 1/31/21 4:03 PM, Mark Rotteveel wrote: For me this is primarily academic curiosity, I don't actually use blob filters myself. That's definite reason why blob filters were not given much attention. Next: Ok, but deprecation of UDF implies the eventual removal of UDF related code. I do

Re: [Firebird-devel] Restore service with stdin parameter

2021-02-01 Thread Alex Peshkoff via Firebird-devel
On 2/1/21 8:03 PM, Dimitry Sibiryakov wrote: Hello, All.   Server used to request from client 262144 bytes. There were plans to expand limits in INFO calls (something like new DPB version, but for INFO calls). That's why bigger buffer is transfered. Does in means that data buffer for IServ

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by Microsoft also have an old laptop with Ubuntu 32bit also another old raspberry pi that is 32 bit only I doubt all that list is worth having _new_ ver

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 12:16 PM, Paul Reeves wrote: On Tue, 2 Feb 2021 11:32:42 +0300 Alex Peshkoff via Firebird-devel wrote: On 2/1/21 10:24 PM, marius adrian popa wrote: My guess old cpus or installs Example got laptop with Windows 10 32 that is still supported by > Microsoft also have an old lap

Re: [Firebird-devel] Producing isc_arg_warning

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 1:59 PM, Jiří Činčura wrote: Hi *, what action should I do to get isc_arg_warning? Revoke non-existing grant. In employee: SQL> revoke EXECUTE ON PROCEDURE ADD_EMP_PROJ from john; Warning: EXECUTE on ADD_EMP_PROJ is not granted to JOHN. Firebird-Devel mailing list, web interfac

Re: [Firebird-devel] Usage of 32b version of Firebird

2021-02-02 Thread Alex Peshkoff via Firebird-devel
On 2/2/21 3:33 PM, Jiří Činčura wrote: Yes, good point :) Onli some new feature need new client. But It is rather rare, but happen as e.g compression as i remember. Basically whenever a new protocol version is created. Not all features make sense for old apps. What sense in having statement

Re: [Firebird-devel] blr 31 & 30

2021-02-04 Thread Alex Peshkoff via Firebird-devel
On 2/4/21 7:29 PM, Mark Rotteveel wrote: On 2021-02-04 15:55, Norbert Saint Georges wrote: Mark Rotteveel a écrit : On 2021-02-04 09:39, Norbert Saint Georges wrote: yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for? The EX

Re: [Firebird-devel] Firebird 4, new int128 problem

2021-02-08 Thread Alex Peshkoff via Firebird-devel
On 2/8/21 5:44 PM, Lucas Schatz wrote: Hi, I'm beginning my tests with Fb4 RC1, successfully converted my database, but I'm having problems with the new int128 data type, where my component access doesn't support it yet, is it possible to disable somehow INT128,DECFLOAT(16) DECFLOAT(34) # DECF

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 5:42 PM, Mark Rotteveel wrote: I'm working on the Firebird 3 Language Reference, and I'm currently writing documentation for SET TRUSTED ROLE. I have tried reading the Firebird 3 release notes, and a Google-translated version of the Russian Firebird 3 Language Reference, but the meani

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 7:01 PM, Mark Rotteveel wrote: On 09-02-2021 16:23, Mark Rotteveel wrote: In other words, does my confusion derive from the fact the Firebird 3 release notes say that CREATE MAPPING ... TO ROLE ... updates the CURRENT_ROLE, while in fact it does no such thing? Having done some furth

Re: [Firebird-devel] What does SET TRUSTED ROLE do?

2021-02-09 Thread Alex Peshkoff via Firebird-devel
On 2/9/21 6:23 PM, Mark Rotteveel wrote: CREATE MAPPING WIN_ADMINS   USING PLUGIN WIN_SSPI   FROM Predefined_Group DOMAIN_ANY_RID_ADMINS   TO ROLE RDB$ADMIN ``` While SET AUTO ADMIN MAPPING will apply RDB$ADMIN automatically if no explicit role is specified on connect. In other words, does m

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using ABSOLUTE, and the remembering of the actual position for subsequent fetches. Or if this is just an artifa

Re: [Firebird-devel] Effect of positioning the cursor beyond the result set with ABSOLUTE

2021-02-15 Thread Alex Peshkoff via Firebird-devel
On 2/15/21 7:39 PM, Mark Rotteveel wrote: On 15-02-2021 16:21, Alex Peshkoff via Firebird-devel wrote: On 2/14/21 4:01 PM, Mark Rotteveel wrote: For documentation purposes, I was wondering if this was intended behaviour, both the ability to position beyond the bounds of the result set using

Re: [Firebird-devel] Interface versions

2021-02-17 Thread Alex Peshkoff via Firebird-devel
On 2/17/21 6:33 PM, Adriano dos Santos Fernandes wrote: Hi! We previously decided that we does not need to maintain API compatibility within mistakes done in alpha/beta versions. So interfaces does not need to be versioned between unstable releases. So it does not make sense to me to have more

Re: [Firebird-devel] Interface versions

2021-02-17 Thread Alex Peshkoff via Firebird-devel
On 2/17/21 8:15 PM, Dimitry Sibiryakov wrote: 17.02.2021 18:06, Tony Whyman wrote: For Firebird 4 RC1, the version number gets reset to 4   Only as a bugfix for wrong Pascal files generation. Just to be explicit - later you may rely on a fact that next version will be >4. Firebird-Deve

Re: [Firebird-devel] fb_cancel_raise for prepare

2021-03-04 Thread Alex Peshkoff via Firebird-devel
On 3/4/21 11:47 AM, Jiří Činčura wrote: Hi *, does fb_cancel_raise cancel also currently running prepare (op_prepare_statement)? Yes, it should. It's able to cancel any operation except attach/detach. But must say never used to test it explicitly. Firebird-Devel mailing list, web inter

Re: [Firebird-devel] RDB$USER_PRIVILEGES of 4.0

2021-03-04 Thread Alex Peshkoff via Firebird-devel
On 3/4/21 1:00 PM, Gabor Boros wrote: Hi All, In ISQL with a brand new 4.0 database: SQL> select distinct rdb$user, rdb$user_type from rdb$user_privileges where rdb$user not in ('SYSDBA','PUBLIC') order by rdb$user; RDB$USER    RDB$USER_TYPE = 22    20 3  

Re: [Firebird-devel] Reason for isc_nothing_to_cancel

2021-03-23 Thread Alex Peshkoff via Firebird-devel
On 3/23/21 5:37 PM, Jiří Činčura wrote: Hi, I found small difference in behavior regarding cancellation (fb_cancel_raise). When working over the wire I can send cancellation whenever I want it is "just fine". But doing the same when using Embedded results in isc_nothing_to_cancel being return

Re: [Firebird-devel] Fix mingw build

2021-04-02 Thread Alex Peshkoff via Firebird-devel
On 4/2/21 6:09 PM, Dimitry Sibiryakov wrote: 02.04.2021 15:19, Biswapriyo Nath wrote: How can I fix the build?   In short - you cannot. It is my experience as a mingw build maintaner before 15 years. Not sure long term, may Dimitry is right. I did not support that build. What about this p

Re: [Firebird-devel] Help appreciated about BlobId

2021-04-06 Thread Alex Peshkoff via Firebird-devel
On 4/6/21 4:25 PM, Bert Herngreen via Firebird-devel wrote: Hi, I do understand that this is not a NOT a user support forum, however I hope to find some support by being pointed out in a direction by you devs about the IB and FB file format. I have an Interbase XE3 database with 'Blob not fo

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/14/21 8:25 PM, Adriano dos Santos Fernandes wrote: Hi! C++ guarantees the execution order of constructors only inside the same translation unit (say, a .cpp file) for global objects. It also guarantees inverse order of destructors in relation to constructors order. But constructor order a

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 2:33 PM, Adriano dos Santos Fernandes wrote: I have tested with common/classes/init.cpp and this solved the specific problem I had with Boost.Test: Cleanup global __attribute__ ((init_priority (2000))); As far as I can see from documentation init_priority works only inside simgle fi

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 6:49 PM, Dimitry Sibiryakov wrote:  Hello All.  Is there a way to know the charset of a string returned by IConfigEntry::getValue()? It transfers data from config file 'as is', I suppose that matches charset none. Firebird-Devel mailing list, web interface at https://lists

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:27 PM, Dimitry Sibiryakov wrote: 15.04.2021 19:21, Adriano dos Santos Fernandes wrote: CtorDtorDebug::CtorDtorDebug - utl.cpp 6000 CtorDtorDebug::CtorDtorDebug - init.cpp 6000 CtorDtorDebug::CtorDtorDebug - init.cpp 5000 CtorDtorDebug::CtorDtorDebug - init.cpp 5400  This piece doe

Re: [Firebird-devel] Memory manager cleanup / external libraries

2021-04-15 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:21 PM, Adriano dos Santos Fernandes wrote: Can you send me full test (or patch)? I want ot test on Android. Attached test. Here is results (init.cpp is showed many times because it's included in many libraries): Same result on android: eneric_arm64:/data/firebird # bin/

Re: [Firebird-devel] travis-ci.org => travis-ci.com

2021-04-16 Thread Alex Peshkoff via Firebird-devel
On 16.04.2021 17:23, Mark Rotteveel wrote: https://github.com/FirebirdSQL/firebird currently uses travis-ci.org for the build, but this must be migrated to travis-ci.com, as travis-ci.org will shutdown soon. See also https://docs.travis-ci.com/user/migrate/open-source-repository-migration an

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/15/21 8:30 PM, Dimitry Sibiryakov wrote: 15.04.2021 18:28, Alex Peshkoff via Firebird-devel wrote: It transfers data from config file 'as is', I suppose that matches charset none.  If parameter's value is a connection string or an user name it would cause troubles

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/19/21 6:43 PM, Dimitry Sibiryakov wrote:  In my own recent config parsers I separate ANSI files from UTF-8 files by BOM and handle them accordingly but I use Unicode for internal processing which Firebird doesn't. Telling true I doubt that separating ANSI from UTF8 is actual - noone (

Re: [Firebird-devel] Charset of plugin configuration parameters

2021-04-19 Thread Alex Peshkoff via Firebird-devel
On 4/19/21 6:59 PM, Dimitry Sibiryakov wrote: 19.04.2021 17:52, Alex Peshkoff via Firebird-devel wrote: Telling true I doubt that separating ANSI from UTF8 is actual - noone (well, almost noone) will use utf8 on windows or ANSI on linux. What may be interesting (and does cause troubles) is

Re: [Firebird-devel] Dispatcher release point

2021-04-22 Thread Alex Peshkoff via Firebird-devel
On 4/22/21 6:22 PM, Dimitry Sibiryakov wrote:  Hello All.  In all examples interface got from getDispatcher() is kept until end of program. I wonder if it is correct to release it right after attachDatabase() call or something may crash? Never tried but see no problems with releasing it wh

Re: [Firebird-devel] Plugin used by trace session

2021-05-03 Thread Alex Peshkoff via Firebird-devel
On 5/3/21 7:08 PM, Dimitry Sibiryakov wrote:  Hello All.  In description of isc_action_svc_trace_start I see no way to set trace plugin used for this session. Does it mean that "there can be only one"? On my mind that means that services API should be expanded here. Firebird-Devel mail

Re: [Firebird-devel] Plugin release delay

2021-05-04 Thread Alex Peshkoff via Firebird-devel
On 5/4/21 6:25 PM, Dimitry Sibiryakov wrote:  Hello All.  Is it safe to set subj to infinity or server may misbehave? Never tried - but at the first glance do not see any problems. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] DefaultTimeZone config

2021-05-07 Thread Alex Peshkoff via Firebird-devel
On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly pass isc_dpb_session_time_zone in the attachment. For me such behavior looks suspicious (i.e. a bug to be precise). DefaultTimeZone set a

Re: [Firebird-devel] Linux installer and system library directory

2021-05-08 Thread Alex Peshkoff via Firebird-devel
Does all that mean that we have problems finding a directory where to create soft link to fbclient? If yes - do you have suggestion how to find that (primary lib) directory better? If yes - why not just fix installer? Firebird-Devel mailing list, web interface at https://lists.sourceforge.n

Re: [Firebird-devel] Values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES

2021-05-08 Thread Alex Peshkoff via Firebird-devel
On 5/8/21 3:10 PM, Mark Rotteveel wrote: On 08-05-2021 13:55, Mark Rotteveel wrote: Where can I find the values of RDB$ROLES.RDB$SYSTEM_PRIVILEGES. I assume it's a bitset, so which bits map to which privilege? After some experimentation, it looks like the bit positions map to the RDB$TYPE fo

Re: [Firebird-devel] DefaultTimeZone config

2021-05-11 Thread Alex Peshkoff via Firebird-devel
On 5/9/21 8:20 PM, Adriano dos Santos Fernandes wrote: On 07/05/2021 12:23, Alex Peshkoff via Firebird-devel wrote: On 5/6/21 9:23 PM, Adriano dos Santos Fernandes wrote: What I want to ask about if it's clear/good is that DefaultTimeZone set in client does not implicitly

<    1   2   3   4   5   6   7   8   9   >