[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Lionel Elie Mamane changed: What|Removed |Added Status|NEW |ASSIGNED

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #12 from Lionel Elie Mamane --- (In reply to Drew Jensen from comment #11) > and it turns out there is an old issue about boolean comparisons and > postgresql > https://bugs.documentfoundation.org/show_bug.cgi?id=88099 > with

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #11 from Drew Jensen --- and it turns out there is an old issue about boolean comparisons and postgresql https://bugs.documentfoundation.org/show_bug.cgi?id=88099 with a patch entered to fix it, from back in 2015. -- You

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #10 from Drew Jensen --- So the other SDBC driver which would have to deal with this is Postgresql as it also has a true boolean (mysql is also an alias either for a TINYINT pre 5.7 or bit[1] post 5.7, MSSQL is also an alias

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #9 from Drew Jensen --- (In reply to Lionel Elie Mamane from comment #8) > This could be a problem more widespread... Basically all DBMS that have a > real boolean type and don't automatically convert between integers and >

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #8 from Lionel Elie Mamane --- This could be a problem more widespread... Basically all DBMS that have a real boolean type and don't automatically convert between integers and booleans (not automatically converting is the SQL

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Xisco Faulí changed: What|Removed |Added Blocks|116968 |51780 Referenced Bugs:

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #7 from Drew Jensen --- It is not a migration problem, per se. The 0 and 1 are correct when the database is HSQLdb since HSQLdb 1.8 had no native boolean field (it was an alias for a BIT field of length 1). Firebird has a

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Xisco Faulí changed: What|Removed |Added Blocks|51780 |116968 --- Comment #6 from Xisco

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #5 from Alex Thurgood --- @Xisco : because the checkbox filter setting which sets 1 or 0 worked in the original hsqldb and doesn't when the db is migrated to Firebird ? -- You are receiving this mail because: You are the

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Xisco Faulí changed: What|Removed |Added Version|6.1.2.1 release |5.4.0.0.alpha1+ -- You are

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Xisco Faulí changed: What|Removed |Added Keywords|regression | Blocks|116968

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #3 from Drew Jensen --- Created attachment 145945 --> https://bugs.documentfoundation.org/attachment.cgi?id=145945=edit Screen capture of Form-based-filter working Alright in this screen capture, I use the same form but

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 --- Comment #2 from Drew Jensen --- Created attachment 145944 --> https://bugs.documentfoundation.org/attachment.cgi?id=145944=edit Screen with erroneous behavior Ok, attached is an .ogv file from a screen capture which shows the

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Alex Thurgood changed: What|Removed |Added Blocks||116968 Referenced Bugs:

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEW Keywords|

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Drew Jensen changed: What|Removed |Added OS|Mac OS X (All) |All -- You are receiving this

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 Drew Jensen changed: What|Removed |Added CC||drewjensen.in...@gmail.com ---

[Libreoffice-bugs] [Bug 120713] Firebird Form-Based Filter search with checkbox values of "1" or "0" fails.

https://bugs.documentfoundation.org/show_bug.cgi?id=120713 sdritc...@gmail.com changed: What|Removed |Added Summary|Firebird Migration: |Firebird Form-Based Filter