flamerobin
flamerobin copied to clipboard
Boolean fields being extracted incorrectly
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