Hi.

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,
  TIME_UNIT Varchar(2),
  SVR_NAME Varchar(1000),
  ACS_COUNT Integer
);


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.

WORK_DATE
TIME_UNIT
SVR_NAME
ACS_COUNT


Step3) Right after the step2, I get an error when I execute query like following.

SELECT WORK_DATE FROM T_WORK

ErrorCode:
335544569
ErrorMessage:
Dynamic SQL Error
SQL error code = -206
Column unknown
WORK_DATE
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

ErrorCode:
335544343
ErrorMessage:
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.