| Subject | Re: [firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation |
|---|---|
| Author | Ann Harrison |
| Post date | 2012-08-28T15:48Z |
On Tue, Aug 28, 2012 at 10:41 AM, Rick Debay <rdebay@...> wrote:
right things, pages hold the right sort of data etc. Making sure the
metadata matches the data, that non-null field aren't null, that
constraints are followed is mostly done by restoring a gbak backup. That
may not be the right place to do it. As far as I know, there is no tool to
insure that every record can be reached by every appropriate index.
Firebird has been around for nearly 30 years and nobody has felt the need
to build such a tool.
Good luck,
Ann
[Non-text portions of this message have been removed]
> I exported the original database as DDL and recreated it. It now works.The validation in gfix checks the physical structure - pointer point to the
> Scary, as the database validation tools didn't detect any errors.
>
>
right things, pages hold the right sort of data etc. Making sure the
metadata matches the data, that non-null field aren't null, that
constraints are followed is mostly done by restoring a gbak backup. That
may not be the right place to do it. As far as I know, there is no tool to
insure that every record can be reached by every appropriate index.
Firebird has been around for nearly 30 years and nobody has felt the need
to build such a tool.
Good luck,
Ann
[Non-text portions of this message have been removed]