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:34:00 UTC

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

     [ https://issues.apache.org/jira/browse/EMPIREDB-300?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

jan resolved EMPIREDB-300.
--------------------------
    Resolution: Fixed

fixed in commit e2edc91fd8970e5019f8fc228f642a6aeb9fa380

> 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
>            Priority: Major
>             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)