Subject | Alter tabel problem |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2004-08-24T08:53:08Z |
I'm using FB 1.03 in Windows 2000
I have a table (containing about 20-30 records):
CREATE TABLE FOR_CORRESP (
NAME VARCHAR(35) CHARACTER SET WIN1252 NOT NULL,
ACCOUNT ACCOUNT NOT NULL,
BALCODE VARCHAR(3) CHARACTER SET WIN1252,
COUNTRY VARCHAR(3) CHARACTER SET WIN1252,
PRIMARY KEY (NAME,ACCOUNT)
);
When I tried to change it with:
alter table for_corresp alter name type varchar(70);
the ibserver.exe started to run with 90% CPU and it took 5 min to stop
the server.
Is it some server problem or shouldn't I use ALTER this way?
Riho Ellermaa
I have a table (containing about 20-30 records):
CREATE TABLE FOR_CORRESP (
NAME VARCHAR(35) CHARACTER SET WIN1252 NOT NULL,
ACCOUNT ACCOUNT NOT NULL,
BALCODE VARCHAR(3) CHARACTER SET WIN1252,
COUNTRY VARCHAR(3) CHARACTER SET WIN1252,
PRIMARY KEY (NAME,ACCOUNT)
);
When I tried to change it with:
alter table for_corresp alter name type varchar(70);
the ibserver.exe started to run with 90% CPU and it took 5 min to stop
the server.
Is it some server problem or shouldn't I use ALTER this way?
Riho Ellermaa