[
https://issues.apache.org/jira/browse/OPENJPA-1726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12890272#action_12890272
]
Jeremy Bauer commented on OPENJPA-1726:
---------------------------------------
I ran into some issues with uuid-string and uuid-type4-string a while back.
This problem isn't specific to PostgreSQL, but looks to be even more prevalent
on that platform since it stores data in UTF-8. UTF-8 is particularly picky
about character values. To be honest, I wouldn't ever recommend the use of
uuid-string or uuid-type4-string since they generate integral byte values and
plug them in as character data without taking into account the character
encoding of either the client or database column. Depending on the conversion,
the id may get converted to some other value or fail to convert (like we are
witnessing on PostgreSQL). A better choice would have been to convert the
values to ASCII base-10 numeric characters. This is not something we can
change now though, since there may be existing applications happily running
with the current generation strategy. The use of uuid-hex or uuid-type4-hex is
a much better choice since the key value includes only invariant ch!
aracters.
Since this could fail intermittently on any platform a better choice might be
to either discontinue testing uuid-string or uuid-type4-string (while
continuing to test uuid-hex and uuid-type4-hex) or test the -string variants
separately, excluding PostgreSQL. I'm OK with either, or simply excluding the
test from running on PostgreSQL as you suggested.
> Clean up OpenJPA test case failures for PostgreSQL
> --------------------------------------------------
>
> Key: OPENJPA-1726
> URL: https://issues.apache.org/jira/browse/OPENJPA-1726
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 2.1.0
> Reporter: Fay Wang
> Assignee: Fay Wang
> Priority: Minor
> Attachments: OPENJPA-1726-2.patch, OPENJPA-1726.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
