Description: I'm beginning to translate base samples on documentation to have also them with Firebird as embedded database. https://wiki.documentfoundation.org/images/5/52/Sample-databases.zip Dragging the 'filter' table from Example_Autotext_Searchmark_Spelling._FBodb.odb to a new base file with FB, I found the error. The ID field is Yes/No[BOOLEAN] type field, that's not available with embedded FB. http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-boolean Actual Results: Yes/No[BOOLEAN] type field, it's not available with embedded FB. Expected Results: Have Yes/No[BOOLEAN] type field available with embedded FB. Reproducible: Always User Profile Reset: Additional Info: User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0
Confirming on my Linux Mint 18 master build. Boolean (Yes/No) does not appear in the list of possible field types in table edit mode.
Wastack committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1d0f3649ba271a439ab38d35ce02462561cc9caa tdf#103074 Implement Boolean Type for FB driver It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Is it possible to backport to 5.3.0?
(In reply to Volga from comment #3) > Is it possible to backport to 5.3.0? Given that 5.3.0 is already in RC stage, I feel it is a bit late. For 5.3.1, not sure we should start to introduce such functional changes rather than pure bugfixes. I won't approve it, but I won't veto it either.
Hi Lionel, by now it is under experimental features on 5.3, and if I'm not wrong will follow in that situation, so maybe it's a good oportunity to introduce this kind of funcionalities, while there could be more people testing without the risk to break their work.
(In reply to m.a.riosv from comment #5) > Hi Lionel, by now it is under experimental features on 5.3, That's a fair point, yes.