flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

Boolean fields being extracted incorrectly

Open DaltonCalford opened this issue 7 months ago • 0 comments

Example from firebird isql

SQL> show table "Actions"; PERK_TRANSACTION (D_TRANSACTION) BIGINT Nullable CACHE_PULLED BINARY(1) Nullable default false MAIN_PULLED BINARY(1) Nullable default false ActionID BIGINT Not Null Time_Stamp TIMESTAMP WITH TIME ZONE Not Null EventID INTEGER Nullable SessionID VARCHAR(50) Nullable SiteID INTEGER Nullable ActionType VARCHAR(50) Nullable Message VARCHAR(255) Nullable ExtraData VARCHAR(4096) Nullable PageURL VARCHAR(4096) Nullable Referrer VARCHAR(4096) Nullable PageViewID (D_UUID) BINARY(16) Nullable IP VARCHAR(50) Nullable UserAgent VARCHAR(512) Nullable ServerName VARCHAR(32) Nullable AdSourceId INTEGER Nullable Campaign VARCHAR(255) Nullable Keyword VARCHAR(256) Nullable Position SMALLINT Nullable SubId VARCHAR(255) Nullable AdGroup VARCHAR(255) Nullable AdSource VARCHAR(50) Nullable Account VARCHAR(150) Nullable Segment VARCHAR(50) Nullable

Triggers on Table Actions: ACTIONS_SYSFIELDS, Sequence: 0, Type: BEFORE INSERT, Active SQL>

while flamerobin creates this

image

DaltonCalford avatar Jul 02 '24 16:07 DaltonCalford