Duplicates in RDB$FORMATS
-------------------------
Key: CORE-4949
URL: http://tracker.firebirdsql.org/browse/CORE-4949
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Beta 2, 2.5.4
Reporter: Dmitriy Starodubov
Attachments: dup.patch
сreate.sql script creates a database table, and then in a single transaction it
alters table and creates broken procedure.
At DFW stage creation a new format in RDB$FORMATS performed in a separate
(system) transaction. So when DFW transaction is rolled back due to broken
procedure, new format in RDB$FORMAT remains.
If execute script alter.sql in new connection, it will create one more format
record and so on.
SQL> select * from rdb$formats;
RDB$RELATION_ID RDB$FORMAT RDB$DESCRIPTOR
=============== ========== =================
128 1 8:0
==============================================================================
==============================================================================
128 2 8:2
==============================================================================
==============================================================================
128 2 8:4
==============================================================================
==============================================================================
128 2 8:6
==============================================================================
Attached patch allows to create new format in a general DFW transaction and it
removed if it rolled back. If there is no objection, I can apply it.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
