|Subject||Question about an error during Create/Drop tables.|
My name is Shingo.
I got a trouble that Firebird does not create table correctly sometime
when I create and drop so frequently.
I actually execute the following steps.
(Assume that the table is already in database.)
Step1) Execute following query.
DROP TABLE T_WORK;
CREATE TABLE T_WORK
WORK_DATE Char(10) NOT NULL,
Step2) After executing step1), execute following query in order to check
a column in the table exist or not.
select r.rdb$field_name from rdb$relation_fields r where r.rdb$relation_name='T_WORK'
The system shows following results.
Step3) Right after the step2, I get an error when I execute query like following.
SELECT WORK_DATE FROM T_WORK
Dynamic SQL Error
SQL error code = -206
At line 1, column 18
Step4) At the time when I get the error, I also get the different error like following.
(Once I get error like step3, I always get error like following.)
SELECT * FROM T_WORK
invalid request BLR at offset 24
table id 7096 is not defined
My question is that the error occurs *not* every time, it just occurs sometime so I can not see the cause of the error.
Is there any tips for the phenomenon?
I'd appreciate if anyone could give me a resolution for that.