mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
211 stars 64 forks source link

Boolean fields being extracted incorrectly #384

Open DaltonCalford opened 3 days ago

DaltonCalford commented 3 days ago

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