[
https://issues.apache.org/jira/browse/OPENJPA-1133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ravi P Palacherla reassigned OPENJPA-1133:
------------------------------------------
Assignee: Ravi P Palacherla
> DBDictionary.getPlaceholderValueString returns 0 for boolean which fails in
> PostgreSQL database.
> ------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-1133
> URL: https://issues.apache.org/jira/browse/OPENJPA-1133
> Project: OpenJPA
> Issue Type: Bug
> Components: query
> Affects Versions: 2.0.0
> Environment: openJPA trunk.
> PostgreSQL 8.3
> Reporter: Ravi P Palacherla
> Assignee: Ravi P Palacherla
> Attachments: OPENJPA-1133_trunk.patch
>
>
> When DBDictionary.getPlaceholderValueString is called with Types.BIT, it
> returns "0".
> PostgreSQL actually requires that a boolean be set. It cannot handle a
> numeric argument.
> Fix Description:
> Overriden DBDictionary.getPlaceholderValueString() inside PostgresDictionary
> to process Types.BIT correctly.
> Now, the method returns 'false' value when Types.BIT is passed as Column.type.
> Test case:
> I am unable to provide a test case.
> The above bug is exposed from Kodo product which internally uses openJPA.
> When a query is made on a subclass using kodo api.
> Kodo generates an SQL ( with help of openJPA) that has UNION in it.
> It generates a SQL similar to the following:
> SELECT 0 FROM public.classA t0 UNION ALL SELECT t0.guidance FROM
> public.classB t0
>
> It got 0 from the openJPA DBDictionary.getPlaceholderValueString as the
> guidance data type is boolean.
> The above SQL will throw an exception in postgreSQL db saying:
> ERROR: UNION types integer and boolean cannot be matched.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
