[EMPIREDB-300] Problem with prepared statements when using booleans with SelectInputControl

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: empire-db-2.4.7
• Fix Version/s: empire-db-2.5.0
• Component/s: Core
• Assignee: Jan Glaubitz
• Reporter: Jan Glaubitz
• Created: 05/Aug/19 05:32
• Updated: 13/Jan/22 15:07
• Resolved: 05/Aug/19 05:33

Description

When you use the SelectInputControl for BOOL types (to allow null, yes, no) it works as long as you dont use prepared statements.

When using prepared statements the values "true"/"false" are not converted to true/false and the statement fails (postgres: ERROR: column "col" is of type boolean but expression is of type character varying Hint: You will need to rewrite or cast the expression..