Skip to content

Boolean fields being extracted incorrectly #384

Description

@DaltonCalford

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions