Subject Bug in create table?
Author maverickthunder

Days ago I was creating a table names "Clientes" using Firebird SQL Maestro to manage my database using CREATE TABLE and some ALTER TABLE to create the indexes.

The script generates an error in metadata update (i do not remember the exact error) but after some retries, i selected only the create table part and executed the script. It succeeded and I continue working.

Later I wanted to change a field named "Observaciones" from a blob text to a large varchar and ALTER TABLE command rejected to make the change (also to drop de column) showing a -607 error in metadata update.

Seeing the definition in my original script I noticed that I have put TWO columns named "Observaciones" !!!

The table was created with only one column but RDB$RELATION_FIELDS had 2 rows, one for each Observaciones field.

So I believe it must be a bug in firebird's code.

Best regards,
Mauro H. Leggieri