Submitted by: @sim1984

Assigned to: @aafemt

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;

Commits: 739b993 8830bfb