Issue Details (XML | Word | Printable)

Key: CORE-2532
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Sergey Nikitin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Incorrect size of volumes in multi volume database

Created: 28/Jun/09 07:52 PM   Updated: 21/Sep/10 05:26 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.5 Alpha 1, 2.1.1, 2.1.2, 2.5 Beta 1, 2.1.3
Fix Version/s: 2.5 Beta 2, 2.1.4

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
While creating multi-volume database, actual sizes of volumes are not corresponding to the number of pages set in RDB$FILES

set sql dialect 3;
create database 'c:\testmulti.fdb' user 'sysdba' password 'masterkey'
page_size 4096
length 1000
FILE 'c:\dbmv1.fd1' length 2000
FILE 'c:\dbmv1.fd2' length 3000
FILE 'c:\dbmv1.fd3' length 4000
FILE 'c:\dbmv1.fd4' length 5000;

create generator g1;
create table t1(c1 varchar(100));
insert into t1(c1) values ('test test test testtttttt test');
insert into t1 select * from t1 where gen_id(g1, 1)<1000000;
exit;

As a result, database files were created

29.06.2009 00:25 8 216 576 DBMV1.FD1 2006 pages
29.06.2009 00:25 12 357 632 DBMV1.FD2 3017 pages
29.06.2009 00:25 16 453 632 DBMV1.FD3 4017 pages
29.06.2009 00:25 38 703 104 DBMV1.FD4
29.06.2009 00:25 4 190 208 TESTMULTI.FDB -1023 pages








 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.