Subject RE: [firebird-support] Update statement seems to stall
Author Bob Murdoch

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Wednesday, September 28, 2005 9:22 PM
> If the server is allowing you to have a DATE type that is really a
> timestamp, then this is not just a dialect 1 database, but an old
> (on-disk structure), i.e. an IB 5.6 or lower database structure.
> Your current database structure would be ODS 10 if you are
> using a version of it that has been restored under Firebird. In that
> all of those old ODS 9 DATE columns would appear as TIMESTAMP now.

The database was originally created in IB5.6 many years ago. The
current ODS is 10.1.

> All that past, is it possible that END_DATE is null in a lot of
> cases?

No, it's a NOT NULL column.

I let the script run overnight and it completed successfully. It took
somewhere between five and twelve hours to run. It's the strangest
darn thing...

Bob M..