Skip to content

Local temporary tables can not be created on REPLICA database #8934

@pavel-zotov

Description

@pavel-zotov

Local temporary tables can not be created on REPLICA database (but should):

Database: /:db_repl_alias, User: SYSDBA
SQL> set list on;
SQL> select mon$database_name, mon$read_only, mon$replica_mode from mon$database;

MON$DATABASE_NAME               C:\FB\60SS\examples\empbuild\qa_replication\db_repl.fdb
MON$READ_ONLY                   0
MON$REPLICA_MODE                1

SQL> create local temporary table ltt_test_trn(id int) on commit delete rows;
Statement failed, SQLSTATE = 25006
Dynamic SQL Error
-attempted update during read-only transaction

SQL> create local temporary table ltt_test_att(id int) on commit preserve rows;
Statement failed, SQLSTATE = 25006
Dynamic SQL Error
-attempted update during read-only transaction

SQL> commit;
SQL> set transaction read write;
SQL> create local temporary table ltt_test_att(id int) on commit preserve rows;
Statement failed, SQLSTATE = 25006
Dynamic SQL Error
-attempted update during read-only transaction

Checked on 6.0.0.1811-89ef46f

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions