Select on Firebird 1.5

[mariusz]

Hi there,

I have task to insert some records to some table on production database on firebird 1.5. I use IBDAC 5.4.11. I can connect to database, but when I do select database runs process which takes entire cpu core and does nothing - I can't get table contant.

Do anyone has idea what's wrong?

Firebird 1.5.6.5026. Table is empty. DDL like following:

/******************************************************************************/
/**** Generated by IBExpert 2015-05-12 14:27:13 ****/
/******************************************************************************/

/******************************************************************************/
/**** Following SET SQL DIALECT is just for the Database Comparer ****/
/******************************************************************************/
SET SQL DIALECT 3;

/******************************************************************************/
/**** Tables ****/
/******************************************************************************/

CREATE GENERATOR KOLEJKAZ_GENERATOR;

CREATE TABLE KOLEJKAZ (
ID INTEGER NOT NULL,
SV INTEGER,
PRODUKT VARCHAR(100),
ZLECENIE VARCHAR(100),
ILE_Z INTEGER,
OCC INTEGER,
OWYD INTEGER,
GNIAZDO DOUBLE PRECISION,
OC_P INTEGER,
OC_U INTEGER,
OILEG INTEGER,
GRAM DOUBLE PRECISION,
TOOLS_ID INTEGER,
TOOLS VARCHAR(100),
PAKIET DOUBLE PRECISION,
NAZWAKZ VARCHAR(200),
UWAGI VARCHAR(1000),
ZORDER INTEGER,
ZEND INTEGER,
ZHIDE INTEGER,
MARK INTEGER,
RI1 INTEGER,
RI2 INTEGER,
RIU1 INTEGER,
RIU2 INTEGER,
RDR1 DOUBLE PRECISION,
RDR2 DOUBLE PRECISION,
RDRU1 DOUBLE PRECISION,
RS1 VARCHAR(100),
RS2 VARCHAR(100),
RSU1 VARCHAR(100),
NOCC DOUBLE PRECISION,
SOPIS VARCHAR(200),
ID_OPP INTEGER
);

/******************************************************************************/
/**** Primary Keys ****/
/******************************************************************************/

ALTER TABLE KOLEJKAZ ADD CONSTRAINT PK_KOLEJKAZ PRIMARY KEY (ID);

/******************************************************************************/
/**** Triggers ****/
/******************************************************************************/

SET TERM ^ ;

/******************************************************************************/
/**** Triggers for tables ****/
/******************************************************************************/

/* Trigger: KOLEJKAZ_BI0 */
CREATE OR ALTER TRIGGER KOLEJKAZ_BI0 FOR KOLEJKAZ
ACTIVE BEFORE INSERT POSITION 0
AS
begin
if (new.id is null) then
new.id = gen_id(kolejkaz_generator, 1);
end
^
SET TERM ; ^

/******************************************************************************/
/**** Privileges ****/
/******************************************************************************/

[ViktorV]

Unfortunately, we couldn't reproduce the problem in the way you have described: the application didn't consume the whole processor core, and we got fetching results. Please send a small sample demonstrating the problem to viktorv*devart*com, including the script for filling in the database objects.