Subject Re: [firebird-support] Re: Views getting corrupt
Author Martijn Tonies

> M> I've had the same problem with InterBase 6 and Firebird 1. I haven't
> M> been able to figure out why it happens, even after close examination of
> M> the system tables ... :-/
> FWIW I have been observing similar behaviour on views based on other
> views since IB 5.6 (it looks like it is more frequent if the
> deprecable syntax "create view ... as select * from ..." is used).

I never use that syntax.

> In my case a backup/restore didn't cure the problem, while pumping the
> data into an empty database did.

In my case, backup/restore actually _caused_ it to happen.

> Never been able to reproduce it in a simple case, though. I suspect
> the problem must be in the view metadata, but I have nothing yet to
> back up my suspicion.

Re-creating the views solved the problem.

I first thought it had to do with the charset/collation, we kinda updated
a system table to modify the default collation for that particular charset.
But when examining the system tables, I couldn't find any differences :-/

Still no luck figuring this out.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions