Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Records left in RDB$PAGES after rollback of CREATE TABLE statement [CORE2284] #2710

Closed
firebird-issue-importer opened this issue Jan 19, 2009 · 5 comments

Comments

@firebird-issue-importer

Submitted by: @hvlad

SQL> set autoddl off;
SQL> create table test_cs__master
CON> (
CON> str_pk varchar(32) character set UNICODE_FSS not null,
CON>
CON> primary key (str_pk)
CON> );
CON>
SQL> create table test_cs__detail
CON> (
CON> str_pk varchar(32) character set WIN1251 not null,
CON>
CON> foreign key (str_pk) references test_cs__master (str_pk)
CON> );
SQL>
SQL> commit;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-cannot create index RDB$PRIMARY12
SQL>
SQL> rollback;
SQL>
SQL> select count(*) from rdb$pages where rdb$relation_id >=
CON> (select rdb$relation_id from rdb$database);

   COUNT

============
4

Commits: 9afef19 bfb008f

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 19, 2009

Commented by: @hvlad

The reason is that records in RDB$PAGES stored by system transaction and not rolled back with user transaction.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2017

Commented by: @romansimakov

It duplicates CORE5677 but this test case is more simple and can be used for automated test for QA.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2017

Modified by: @romansimakov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

Fix Version: 3.0.3 [ 10810 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

assignee: Roman Simakov [ roman-simakov ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 11, 2017

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Dec 14, 2017

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment