https://bugs.freedesktop.org/show_bug.cgi?id=71251
--- Comment #8 from Andrzej J.R. Hunt <andr...@ahunt.org> --- (In reply to comment #6) > (In reply to comment #5) > > Could be it is a problem with the Bool-field inside of this table. There is > > no special Bool-field in Firebird. > > Hmm... Could we fake BOOLEAN in the driver, if necessary? (Meaning, if > that's the problem). Maybe we could just do it like MySQL and at table > *creation* time, just map BOOLEAN to TINYINT(1) or something like that. (And > then, the table has a TINYINT(1) field, not a BOOLEAN field.) > > (note: firebird 3 has/will have BOOLEAN datatype) It shouldn't be that hard to fake it at creation time, and reading the field as a boolean would also work fine, however there is still the issue that when reading it won't present itself as a boolean, i.e. we wouldn't have the checkboxes etc. in the UI when editing table data directly (because Base thinks it's just an integer). However we could simply read whether there is a CHECK constraint in place every time we read a SMALLINT (that's the smallest datatype in firebird -- there's no tinyint). (CHECK constraints (and not-nulls) are in RDB$CHECK_CONSTRAINTS, mapping to RDB$TRIGGERS, still need to figure out how to detect this specific check once there though.) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs