[
https://issues.apache.org/jira/browse/CAY-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev updated CAY-2799:
---------------------------------
Fix Version/s: (was: 4.2)
> 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: 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)
