Re: [Firebird-devel] Firebird 4 Install and replication

2021-02-22 Thread Dmitry Yemanov
23.02.2021 09:31, Peter Gore wrote: As a test I have tried to get asynchronous replication working.  Is this even possible when Master and Replica is on the same Server? Sure. Even using a single FB instance for both. I have two databases; FB4Test.fdb and FB4TestReplica.fdb o the same

[Firebird-devel] Firebird 4 Install and replication

2021-02-22 Thread Peter Gore
Good morning, I'm a long standing Firebird User since FB1.5! My interest in FB4 is primarily replication, which I have been unable to get working. I have also noticed some errors in the documentation that I note below. I have manually downloaded the 32bit version and and run it as an application

Re: [Firebird-devel] README.online_validation.txt correction.

2021-02-22 Thread Ivan Přenosil
Dne 19.02.2021 v 16:05 Vlad Khorsun napsal(a): 19.02.2021 1:39, Ivan Přenosil wrote: The document says    val_idx_incl  pattern for indices names to include in validation run    val_idx_excl  pattern for indices names to exclude from validation run I think the description is wrong. It

[Firebird-devel] LibreOffice Patch : Can't use System V semaphores in a sandboxed macOS process

2021-02-22 Thread marius adrian popa
Interesting patch for LibreOffice https://git.libreoffice.org/core/+/22e89d2ccd3ad3ee1b5ee00aebadd3d5a38fd5dd%5E%21 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] COALESCE/UNION type derivation

2021-02-22 Thread Dmitry Yemanov
22.02.2021 13:40, Dimitry Sibiryakov wrote:   Currently Firebird uses rule "CHAR(X)+CHAR(Y)=>CHAR(MAX(X,Y))".   Theoretically it can be changed into "CHAR(X)+CHAR(Y)=>CHAR(X) if X==Y and CHAR(X)+CHAR(Y)=>VARCHAR(MAX(X,Y)) if X!=Y".   But what SQL standard says about it? IIRC, current

[Firebird-devel] COALESCE/UNION type derivation

2021-02-22 Thread Dimitry Sibiryakov
Hello All. Currently Firebird uses rule "CHAR(X)+CHAR(Y)=>CHAR(MAX(X,Y))". Theoretically it can be changed into "CHAR(X)+CHAR(Y)=>CHAR(X) if X==Y and CHAR(X)+CHAR(Y)=>VARCHAR(MAX(X,Y)) if X!=Y". But what SQL standard says about it? -- WBR, SD. Firebird-Devel mailing list, web