[
https://issues.apache.org/jira/browse/CAY-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17692172#comment-17692172
]
Nikita Timofeev commented on CAY-2799:
--------------------------------------
This seems really old problem, and most probably it is already documented here:
CAY-1470
> CHAR type support for Oracle
> ----------------------------
>
> Key: CAY-2799
> URL: https://issues.apache.org/jira/browse/CAY-2799
> Project: Cayenne
> Issue Type: Bug
> Components: Database integration
> Environment: Oracle
> Reporter: Nikita Timofeev
> Assignee: Nikita Timofeev
> Priority: Major
> Fix For: 4.2, 5.0.M1
>
>
> Here's a test case to illustrate this problem
> {code}
> @Test
> public void testASTLowerInWhere() throws Exception {
> // ARTIST_NAME is of char(254) type
> Artist a1 = createArtist("NAME");
> // a2 is null
> Artist a2 = ObjectSelect.query(Artist.class)
>
> .where(Artist.ARTIST_NAME.lower().eq("name")).selectOne(context);
> // a3 is a1
> Artist a3 = ObjectSelect.query(Artist.class)
> .where(Artist.ARTIST_NAME.lower().eq("name" + "
> ".repeat(250))).selectOne(context);
> assertEquals(a1, a3); // passed
> assertEquals(a1, a2); // failed
> }
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
