Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2799

CHAR type support for Oracle

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • 5.0-M1
    • Database integration
    • None
    • Oracle

    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
          }
      

      Attachments

        Issue Links

          Activity

            People

              ntimofeev Nikita Timofeev
              ntimofeev Nikita Timofeev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: