Regression: Can not create large index
--------------------------------------
Key: CORE-5271
URL: http://tracker.firebirdsql.org/browse/CORE-5271
Project: Firebird Core
Issue Type: Bug
Affects Versions: 4.0 Initial
Environment: Windows 10 x64, WI-T4.0.0.246 Firebird 4.0
Reporter: Simonov Denis
set names utf8;
create database 'localhost/3054:test'
user SYSDBA password 'masterkey'
page_size 8192
default character set utf8;
create table t1(
id int not null,
a int
);
commit;
set term !;
execute block
as
declare i int = 0;
begin
while (i < 4000000) do
begin
insert into t1(id) values(:i);
i = i + 1;
end
end!
set term ;!
commit;
alter table t1 add constraint pk_t1 primary key (id);
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements.
sort error.
No free space found in temporary directories.
operating system directive CreateFile failed.
Синтаксическая ошибка в имени файла, имени папки или метке тома. .
Empirically found that this error does not occur when you create any index, but
only when sorting requires more memory than TempCacheLimit. For example here is
a script runs without errors.
create table t2(
id int not null,
a int
);
commit;
set term !;
execute block
as
declare i int = 0;
begin
while (i < 40000) do -- much smaller number of keys
begin
insert into t2(id) values(:i);
i = i + 1;
end
end!
set term ;!
commit;
alter table t2 add constraint pk_t2 primary key (id);
commit;
--
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
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
