On 6/2/22 14:45, Adriano dos Santos Fernandes wrote:
On 02/06/2022 08:08, Dimitry Sibiryakov wrote:
Alex Peshkoff via Firebird-devel wrote 02.06.2022 13:01:
It is "ALTER TABLE" which must be executed on replica. Otherwise
you'll have problem with ALTER TABLE ADD FIELD.
Is it impossible to analyze clauses of statement?
Theoretically - yes. On practice it would require full Firebird SQL
parser which is hard. Simpler would be to downgrade the "missing
tablespace" error to a warning if the database is in replica mode or SQL
is performed by Applier.
Commands are replicated in text and executed in replica.
The replica execution could ignore things when are running a replicated
command.
I see no difficulty there.
Yes. Moreover - if ALTER TABLE has more clauses (like ADD FIELD) in
addition to tablespaces related, only that tablespaces related clauses
to be skipped.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
