Re: [Firebird-devel] Errors vector lifetime

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,

Re: [Firebird-devel] SQLCODE in OO API

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] SQLCODE in OO API

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 have

Re: [Firebird-devel] SQLCODE in OO API

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 missing

Re: [Firebird-devel] SQLCODE in OO API

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] IStatus after cloning

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] Parameter Base of API implementation templates

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

Re: [Firebird-devel] Srp keys safeguards

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] External engine lifecycle

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

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

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

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

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 found

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

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

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

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

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

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

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

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

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

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] Firebird 4 database creation speed

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

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

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

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

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 DSQL parser and parser generator

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] Firebird PDO preprocessing sql

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

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

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

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

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

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

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

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

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?

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.

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

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] Logging of warnings

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?

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

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] isc_action_svc_nbak failing since 4.0.0.2117

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,

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

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

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

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 =

Re: [Firebird-devel] isc_action_svc_nbak failing since 4.0.0.2117

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

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

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_ERROR 'err'; SQL> SQL> set

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

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.

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] BlobWrapper and sizes

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

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

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 = 42000 Dynamic

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

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

Re: [Firebird-devel] Backup padding

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

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 from

Re: [Firebird-devel] Backup padding

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

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

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.

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

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?

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?

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

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

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

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

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

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

On 2020-08-18 22:06, Karel Rys via Firebird-devel wrote: Hello, I have an application for Android (runs on mobile phones and barcode mobile scanners). Application is written in Delphi, uses Embedded Firebird 3.0.6 and is build for 32 bit. I would like to publish the application in Google

Re: [Firebird-devel] A new Rust driver

On 2020-08-23 16:23, Luis Fernando Batels wrote: Hi! I would like to share a new lib for use the Firebird in Rust programming language, and currently the only one: https://github.com/fernandobatels/rsfbclient. We are using the official fbclient, but one of contributors is also working on a

Re: [Firebird-devel] OO API examples for Object Pascal

On 2020-08-17 18:25, Paul Reeves wrote: I thought I would port the OO API examples to Object Pascal. After all, they are quite simple, so how hard could it be? In fact it is more difficult than I thought and I am not happy with the results. I've done two examples - update and select - and I

Re: [Firebird-devel] ../examples/include/example.h

On 2020-08-17 18:07, Paul Reeves wrote: It appears that I was looking at an older version of the api examples. How I did that, I do not know, really strange - taking into an account that last change was many years ago. but the error quickly became obvious once I started to prepare commiting

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-17 14:57, Dimitry Sibiryakov wrote: 17.08.2020 13:49, Alex Peshkoff via Firebird-devel wrote: HASH(value USING alg) returning integer   smallint for crc16, integer for legacy, crc32 and crc32c, bigint for crc64 Yes, I've meant that it will be some kind of integer, depending

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-10 20:13, Dimitry Sibiryakov wrote: 10.08.2020 18:58, Vlad Khorsun wrote: To summarize - I withdraw my initial agreement to add CRC32 calculation to function HASH(). The only argument for this is same name in plain english for different purpose things.    Very good, thanks.  

Re: [Firebird-devel] ../examples/include/example.h

On 2020-08-12 19:32, Paul Reeves wrote: I'm working on re-creating the makefile for the api examples. I don't know how, but it seems to have got lost a long while ago. Almost everything still compiles in HEAD except for api16. This is because example.h has lost the declarations for 'args'.

Re: [Firebird-devel] Building 05.user_metadata.cpp

On 2020-08-12 15:41, Paul Reeves wrote: I'm working on a makefile to build the oo api examples. Everything is fine, except for 05.user_metadata.cpp Executing this: c++ -c -Wall -g3 -std=c++11 -fno-rtti -I/opt/firebird/include/ \ 05.user_metadata.cpp -o 05.user_metadata.o produces

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-11 19:01, Dimitry Sibiryakov wrote: 11.08.2020 17:50, Alex Peshkoff via Firebird-devel wrote: I believe that many of you are all too narrowly linking HASH and whether it is appropriate for cryptography. What about particular CRC32 - it produces output value with length just 4

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-10 21:43, Leyne, Sean wrote: That old form is kept for backward compatibility. If your suggestion comes true (hope not) some idiot may try to use PJW as cryptographic hash. To summarize - I withdraw my initial agreement to add CRC32 calculation to function HASH(). The only argument

Re: [Firebird-devel] Generated files in git

On 2020-08-11 12:46, Dimitry Sibiryakov wrote: 11.08.2020 11:37, Alex Peshkoff via Firebird-devel wrote: Getting serious - on my mind the main reason ti have it in git is to avoid breakage of pascal generator in cloop.   How can it help? The file is generated (and to be kept

Re: [Firebird-devel] Generated files in git

On 2020-08-11 12:30, Dimitry Sibiryakov wrote: 10.08.2020 23:49, Adriano dos Santos Fernandes wrote: You'd better leave the file there, so people can go to github and see its latest version directly.   At first, the problem is that the file is NOT there. Let's discuss not current, but

Re: [Firebird-devel] Generated files in git

On 2020-08-11 00:49, Adriano dos Santos Fernandes wrote: On 10/08/2020 18:06, Dimitry Sibiryakov wrote: 10.08.2020 13:24, Alex Peshkoff via Firebird-devel wrote: if some files are generated only in some specific build (i.e. others have no rules/targets/projects/etc to generate

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-10 18:57, Mark Rotteveel wrote: On 10-08-2020 17:17, Vlad Khorsun wrote:    Same function returning different types depending on input argument - very bad idea, I think. Not always. For example - ENCRYPT/DECRYPT may return blob or string value depending upon input datatype and I

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-10 13:31, Dimitry Sibiryakov wrote: 10.08.2020 12:23, Alex Peshkoff via Firebird-devel wrote: CRC32 returns 32-bit integer. HASH(something USING method) returns varbinary of appropriate length. What should be return value of HASH(something USING CRC32)?   32 bits integer. It won't

Re: [Firebird-devel] Generated files in git

On 2020-08-03 17:08, Dimitry Sibiryakov wrote: Hello All.   Currently some generated files are not kept in git (such as preprocessed epp and y) and some are kept (such as generated headers).   What are the rules to decide if a generated file should be kept or not? First of all - if a file

Re: [Firebird-devel] Should CRC32 function be part of HASH?

On 2020-08-02 13:52, Dmitry Yemanov wrote: 02.08.2020 13:14, Mark Rotteveel wrote: Firebird 4 introduces the function CRC32 which generates a CRC32 hash, while Firebird 4 also introduces an extension to the HASH function to add (cryptographic) hashes. Would it make sense to remove CRC32 as

[Firebird-devel] Warning related with memset/memcpy

Not sure about VC - but fresh enough (at least 8.x) gcc often produces the following warning (exact reason certainly differs): /usr/home/firebird/B3_0_Release/src/jrd/trace/../../jrd/trace/../../dsql/../jrd/val.h:154:39: warning: ‘void* memset(void*, int, size_t)’ clearing an object of

Re: [Firebird-devel] int128 datatype

On 2020-06-24 21:18, Dmitry Yemanov wrote: 24.06.2020 21:14, marius adrian popa wrote: so now we have int128 with this commit https://github.com/FirebirdSQL/firebird/commit/c2692c6ceec2a434a23be920afc2d430a85e27cb? We already had it in Beta 2 as NUMERIC(38). Only the alias name was added

Re: [Firebird-devel] ibase.h

On 2020-06-23 13:39, Adriano dos Santos Fernandes wrote: Hi! Here I'm talking mainly on the distribute kits. Currently we have in firebird/Interface.h a #include "ibase.h". That is not good. It makes mandatory that user have the include directory where ibase.h is in its include path, which

Re: [Firebird-devel] ODP: Modern C++: constexpr

On 2020-06-18 12:42, Dimitry Sibiryakov wrote: 18.06.2020 09:48, Pavel Cisar wrote: If you would be raised in Europe (especially central or eastern) in last century (or another place ruled by One Truth Owners), you would not be so surprised.   90 years passed since the last book burning.

Re: [Firebird-devel] Values in auth block

On 2020-06-17 22:00, Dimitry Sibiryakov wrote: 17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote:     Auth block 2, length 80     AUTH_TYPE: USER     AUTH_NAME: SD   BTW, can I rely on fact that AUTH_TYPE is always come before AUTH_NAME in the block? Better

Re: [Firebird-devel] Values in auth block

On 2020-06-17 19:50, Dimitry Sibiryakov wrote: 17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote: Ignore and keep 'as is'. They are needed if later that block is passed once again to mapping code (after execute statement for example).   Unfortunately SQLConnect() accepts only plain

Re: [Firebird-devel] Values in auth block

On 2020-06-17 18:56, Dimitry Sibiryakov wrote: Hello All.   In my provider I'm getting following auth block: isc_dpb_auth_block     Auth block 0, length 53     AUTH_TYPE: Seen     AUTH_SECURE_DB: C:\PROGRAMS\FIREBIRD\FIREBIRD4.X86\TEST     Auth block 1, length 62   

Re: [Firebird-devel] MSVS project for examples

On 2020-06-17 17:31, Dimitry Sibiryakov wrote: 14.06.2020 13:17, Dimitry Sibiryakov wrote:    Are these project supposed to be included into distribution packages?   Nobody cares? Ok... If they are OK for VS now in use - why not? Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: ODP: Modern C++: constexpr

On 2020-06-17 15:44, Karol Bieniaszewski wrote: >> If feature belongs to both lists - is it allowed or denied? Please explain how?  By mistake. >> If it does not belong to both them? Its usege should be considered as use at own risk. That's not apropriate when working on a project as

Re: [Firebird-devel] ODP: Modern C++: constexpr

On 2020-06-16 19:53, Karol Bieniaszewski wrote: >> we may have black list instead white list like now. As always better is to have both black + white. Both lists is something non logical. If feature belongs to both lists - is it allowed or denied? If it does not belong to both them?

Re: [Firebird-devel] FB 4, iUtil and new interface in general

On 2020-06-16 13:57, Tony Whyman wrote: On 15/06/2020 15:37, Alex Peshkoff via Firebird-devel wrote: On 2020-06-11 18:30, Tony Whyman wrote: On 11/06/2020 11:18, Pavel Cisar wrote: This is not a problem for languages like Python, Java and .NET that don't use these files at all, but C

Re: [Firebird-devel] Modern C++: constexpr

On 2020-06-16 11:04, Dmitry Yemanov wrote: 16.06.2020 10:49, Alex Peshkoff via Firebird-devel wrote:    Is "constexpr" allowed for usage? IMO it should. I'm also playing with some containers I think we should allow: shared_ptr (with adaptor for our pools), unique_ptr. I plan to

Re: [Firebird-devel] FB 4, iUtil and new interface in general

On 2020-06-16 12:18, Dimitry Sibiryakov wrote: 15.06.2020 17:44, Pavel Cisar wrote: For interface consumer, presence of iStatus was clear indication that method may fail, and absence that it never fails. It was true for FB 3.0. Now it's not true anymore and I'd like understand why.   New

Re: [Firebird-devel] Modern C++: constexpr

On 2020-06-15 21:03, Adriano dos Santos Fernandes wrote: On 15/06/2020 14:56, Dimitry Sibiryakov wrote:   Hello All.   Is "constexpr" allowed for usage? IMO it should. I'm also playing with some containers I think we should allow: shared_ptr (with adaptor for our pools), unique_ptr. I

Re: [Firebird-devel] FB 4, iUtil and new interface in general

On 2020-06-15 18:44, Pavel Cisar wrote: Alex, Dne 15. 06. 20 v 16:20 Alex Peshkoff via Firebird-devel napsal(a): On 2020-06-11 19:56, Pavel Cisar wrote: Adriano, Dne 11. 06. 20 v 16:38 Adriano dos Santos Fernandes napsal(a): 2. Strange things with iUtil in FB 4. a) Why methods

Re: [Firebird-devel] FB 4, iUtil and new interface in general

On 2020-06-11 18:30, Tony Whyman wrote: On 11/06/2020 11:18, Pavel Cisar wrote: This is not a problem for languages like Python, Java and .NET that don't use these files at all, but C++ & Pascal are still important languages and we should offer some better solution. At least it should be

Re: [Firebird-devel] FB 4, iUtil and new interface in general

On 2020-06-11 19:56, Pavel Cisar wrote: Adriano, Dne 11. 06. 20 v 16:38 Adriano dos Santos Fernandes napsal(a): 2. Strange things with iUtil in FB 4. a) Why methods getDecFloat16, getDecFloat34 and getInt128 require iStatus parameter? I expected that these methods should be "safe" like

Re: [Firebird-devel] CLOOP on Windows

On 2020-06-11 16:53, Dimitry Sibiryakov wrote: Hello All.   Why compilation of CLOOP and generation of headers is not included in Windows build routine? Sometimes ago it was explained by need of gpre & awk for it (at least pascal file). I've replaced that 2 utilities with trivial C

Re: [Firebird-devel] NMAKE usage

On 2020-06-11 18:59, Dimitry Sibiryakov wrote: Hello All.   Is there a reason why we cannot use NMAKE during Windows build to do such things as "preprocess GPRE files only if source was changed"? More than 10 years ago Jim suggested better (on my side view) way - add GPRE command as

Re: [Firebird-devel] Appveyor build

On 2020-06-05 18:14, Dimitry Sibiryakov wrote: Hello, All.   Do we have a problem with environment there? https://ci.appveyor.com/project/FirebirdSQL/firebird/builds/33322788/job/kx62jby3qgkjx9bn Unavailable host: 504  Gateway Time-out [IP: 52.38.12.101 443] I can't reach it from my

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

On 2020-06-03 10:56, Lester Caine wrote: On 03/06/2020 08:23, Lester Caine wrote: On 02/06/2020 22:17, Dimitry Sibiryakov wrote: 02.06.2020 21:45, Mark Rotteveel wrote: I think that is extremely confusing, and not acceptable.    That's why everyone was given several years to replace

Re: [Firebird-devel] Value of CURRENT_TIME is not current time

On 2020-06-03 00:17, Dimitry Sibiryakov wrote: 02.06.2020 21:45, Mark Rotteveel wrote: I think that is extremely confusing, and not acceptable.   That's why everyone was given several years to replace CURRENT_TIME with LOCALTIME and don't use TIME WITH TIMEZONE at all. Yes. What we

Re: [Firebird-devel] Compatibility issue

On 2020-06-02 13:19, Dimitry Sibiryakov wrote: 02.06.2020 12:14, Alex Peshkoff via Firebird-devel wrote: This commit breaks compatibility between versions before and after it. Two functions were removed from Util interface. I.e. old modules (if any) using Util interface should be rebuilt

[Firebird-devel] Compatibility issue

Please pay attention on commit: https://github.com/FirebirdSQL/firebird/commit/a9cef6d9aeaabc08d8f104230a38345340edf7a2 This commit breaks compatibility between versions before and after it. Two functions were removed from Util interface. I.e. old modules (if any) using Util interface should

Re: [Firebird-devel] Firebird 4.0 Beta 2 : 1) fbclient install on Linux 2) gsec

On 2020-06-01 18:07, Pro Turm wrote: Hello, could anyone answer to the question (1) ? Am Sa., 30. Mai 2020 um 11:12 Uhr schrieb Pro Turm >: Probably, the symbolic link to the fbclient is a trivial question. But if anyone know the answer, I would really

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-06-01 17:29, Mark Rotteveel wrote: On 01-06-2020 16:07, Alex Peshkoff via Firebird-devel wrote: On 2020-06-01 16:54, Mark Rotteveel wrote: On 01-06-2020 11:57, Alex Peshkoff via Firebird-devel wrote: Legacy approach of pre-initializing with well known to the world password is very bad

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-06-01 16:54, Mark Rotteveel wrote: On 01-06-2020 11:57, Alex Peshkoff via Firebird-devel wrote: Legacy approach of pre-initializing with well known to the world password is very bad idea. Not to tell much words about security - have you ever seen unix distro with pre-initialized root

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-05-29 23:12, Mark Rotteveel wrote: On 29-05-2020 22:07, Leyne, Sean wrote: The default list should only contain options which are available without additional configuration or initialization. I disagree. The default should represent best practice, most sensible and reasonable

Re: [Firebird-devel] Does Firebird 4 Beta 2 really need libncurses6?

On 2020-05-30 00:51, Tony Whyman wrote: On 29/05/2020 14:33, Alex Peshkoff via Firebird-devel wrote: On 29.05.2020 16:22, Tony Whyman wrote: Just tried to check out Beta 2 on Linux Mint 19.3 (= ubuntu bionic 18.04) and found that the binaries have been compiled to use libncurses6. Ubuntu

Re: [Firebird-devel] Does Firebird 4 Beta 2 really need libncurses6?

On 29.05.2020 16:22, Tony Whyman wrote: Just tried to check out Beta 2 on Linux Mint 19.3 (= ubuntu bionic 18.04) and found that the binaries have been compiled to use libncurses6. Ubuntu 18.04 uses libncurses5. You need ubuntu 19.10 if you don't want to go through the bother of backporting

Re: [Firebird-devel] Firebird 4.0 Beta 2 : 1) fbclient install on Linux 2) gsec

On 29.05.2020 15:02, Pro Turm wrote: error messages from my application like : "Dynamic linking error: fbclient.so not found" Looks like installer creates symbolic link to client lib in wrong dir. That's certainly a bug to  be fixed. Right now you may create symlink in right dir yourself.

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-05-28 12:37, Mark Rotteveel wrote: On 2020-05-28 11:22, Alex Peshkoff via Firebird-devel wrote: On 2020-05-28 12:06, Dimitry Sibiryakov wrote: 28.05.2020 00:35, Adriano dos Santos Fernandes wrote: It's more confusing to have a "functional" security database without users

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-05-28 12:06, Dimitry Sibiryakov wrote: 28.05.2020 00:35, Adriano dos Santos Fernandes wrote: It's more confusing to have a "functional" security database without users   No SRP users doesn't also mean no legacy or SSPI users. Certainly, but in this case the best solution is to

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-05-27 19:18, Vlad Khorsun wrote: 27.05.2020 15:14, Adriano dos Santos Fernandes wrote: On 27/05/2020 08:56, Vlad Khorsun wrote: isc_missing_data_structures is former Install incomplete, please read the Compatibility chapter in the release notes for this version It could be changed

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

On 2020-05-27 14:47, Dimitry Sibiryakov wrote: 27.05.2020 13:42, Alex Peshkoff via Firebird-devel wrote: But that will do things even more obscure - every user will get regular message about illegal login/password.   And that's right: 1. It try to login as SYSDBA and get "user not de

<    1   2   3   4   5   6   7   8   9   >