You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@empire-db.apache.org by "jan (JIRA)" <ji...@apache.org> on 2019/08/05 05:33:00 UTC

[jira] [Created] (EMPIREDB-300) Problem with prepared statements when using booleans with SelectInputControl

jan created EMPIREDB-300:
----------------------------

             Summary: Problem with prepared statements when using booleans with SelectInputControl
                 Key: EMPIREDB-300
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-300
             Project: Empire-DB
          Issue Type: Improvement
          Components: Core
    Affects Versions: empire-db-2.4.7
            Reporter: jan
            Assignee: jan
             Fix For: empire-db-2.5.0


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..



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)