Re: [Firebird-devel] Local temporary tables (internals)

2021-07-30 Thread Adriano dos Santos Fernandes
On 29/07/2021 19:07, Vlad Khorsun wrote:
> 
>   Hmm... LTT is good to have, but... is it necessary here ?
> Is it possible to use RecordBuffer (and some kind of BufferedStream) for
> temporary storage ?
> 

This is what I intent to use.

RecordBuffer for storage and kind of BufferedStream who walks in already
created RecordBuffer.

Complete LTT may use the same thing, but with more complete implementation.

In initial implementation for returning, it seems sufficient to only
change store and just tweak erase/modify to not crash with
blr_local_table_id.


Adriano


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] replication/Protocol.h

2021-07-30 Thread Dmitry Yemanov

27.07.2021 17:32, Dimitry Sibiryakov wrote:


isn't header defining replication protocol supposed to be public?


Yes, it is. Please add a ticket.


Dmitry




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


Re: [Firebird-devel] Inconsistent enabling of replication

2021-07-30 Thread Dmitry Yemanov

30.07.2021 14:10, Ivan Přenosil wrote:


Enabling replication of table by
ALTER TABLE tab ENABLE PUBLICATION;
is replicated, while

ALTER DATABASE INCLUDE TABLE tab TO PUBLICATION;
is not replicated.

Is it bug or by design?


ALTER DATABASE commands are not replicated, because they may include 
file-system specifics (e.g. ADD SHADOW or DIFFERENCE FILE), or cause 
database locks (BEGIN/END BACKUP), or encrypt the database.


But perhaps we should be more intelligent here and allow some ALTER 
commands to be replicated -- those which are "internal" to the database.


However, I'm wondering whether it's expected that the replica database 
may suddenly become "master" after ENABLE PUBLICATION is replicated 
(provided replica is read-write and replication.conf is set up).



Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


[Firebird-devel] Inconsistent enabling of replication

2021-07-30 Thread Ivan Přenosil

Enabling replication of table by
ALTER TABLE tab ENABLE PUBLICATION;
is replicated, while

ALTER DATABASE INCLUDE TABLE tab TO PUBLICATION;
is not replicated.

Is it bug or by design?

Also these commands are not replicated
ALTER DATABASE ENABLE PUBLICATION;
ALTER DATABASE INCLUDE ALL TO PUBLICATION;
Is it intentional? Because when the master database crashes and I want 
to use replica as new master,

I must not forget to set all these settings again.

I.



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel