Errors on Firebird SQL 2.5.1 connection

Note: please leave bug reports and feature requests on

Errors on Firebird SQL 2.5.1 connection

Postby esapien » Thu Sep 25, 2014 1:59 pm

Hi,

I am connecting to a Firebird SQL 2.5.1 db from DBeaver 3.0.1 on Linux 64-bit. There seems to be some issue when retrieving tables metadata which results in the following:

- A new column is added to a table but when querying the new column does not appear (sometimes it does later, sometimes never). When querying through FlameRobin, the column is correctly displayed.

- When retrieving a table DDL, fields are repeated as if there where multiple fields with the same name in the table. Example:

CREATE TABLE OFICIO (
ID INTEGER NOT NULL,
AP_CAMPO_GERENCIA INTEGER NOT NULL,
OF_TIPO_OFICIO INTEGER NOT NULL,
NUMERO_OFICIO VARCHAR(35) NOT NULL,
FECHA_OFICIO DATE NOT NULL,
OBSERVACIONES VARCHAR(200),
GENERO VARCHAR(20),
FECHA_GENERO DATE,
HORA_GENERO TIME,
MODIFICO VARCHAR(20),
FECHA_MODIFICO DATE,
HORA_MODIFICO TIME,
ELIMINADO VARCHAR(5) DEFAULT 'False',
ESTATUS INTEGER NOT NULL,
OF_OFICIO INTEGER,
FECHA_NOTIFICO_ALTA DATE,
HORA_NOTIFICO_ALTA TIME,
ASUNTO VARCHAR(150) NOT NULL,
URGENTE VARCHAR(5) DEFAULT 'False',
ID INTEGER NOT NULL,
OF_OFICIO INTEGER NOT NULL,
SI_MOVIMIENTO INTEGER NOT NULL,
(...)


Also, when building a diagram, non-existent (or deleted) relationships are displayed between tables.

It seems to me that as changes are performed on tables, Firebird keeps some sort of log/registry of the changes but DBeaver is showing all of them, instead of only showing the latest state.

Thank you in advance.
esapien
 
Posts: 19
Joined: Fri May 09, 2014 4:51 pm

Return to Support



Who is online

Users browsing this forum: No registered users and 14 guests