[CAY-2799] CHAR type support for Oracle

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 5.0-M2
• Component/s: Database integration
• Environment: Oracle
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 21/Feb/23 09:09
• Updated: 13/Jun/24 12:25

Description

Here's a test case to illustrate this problem

@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
    }

Issue Links

• relates to: CAY-1470 Oracle: Problem with bind CHAR in select