Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Boolean fields being extracted incorrectly #384

Open
DaltonCalford opened this issue Jul 2, 2024 · 0 comments
Open

Boolean fields being extracted incorrectly #384

DaltonCalford opened this issue Jul 2, 2024 · 0 comments

Comments

@DaltonCalford
Copy link

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

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant