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

Oracle: Problem with bind CHAR in select

    XMLWordPrintableJSON

Details

    Description

      I have Table tUser

      desc tUser
      Name Null Type
      ------------------------------ --------
      USERID NOT NULL NUMBER(15)
      BRIEF NOT NULL CHAR(30)

      And wish to find user with BRIEF 'credit' :

      INFO QueryLogger: Detected and installed adapter: org.apache.cayenne.dba.oracle.OracleAdapter
      INFO QueryLogger: SELECT * FROM tUser WHERE Brief = ? [bind: 'credit']
      INFO QueryLogger: === returned 0 rows. - took 125 ms.

      But if I try whitespaces at the end I would get:

      INFO QueryLogger: SELECT * FROM tUser WHERE Brief = ? [bind: 'credit ']
      INFO QueryLogger: === returned 1 row. - took 109 ms.

      It's absolutely not CROSS DB behavior!

      Attachments

        1. CAY-1470.patch
          6 kB
          Evgeny Ryabitskiy
        2. CAY-1470.patch
          6 kB
          Evgeny Ryabitskiy
        3. CAY-1470.patch
          4 kB
          Evgeny Ryabitskiy
        4. CAY-1470-Test.patch
          1 kB
          Evgeny Ryabitskiy

        Issue Links

          Activity

            People

              apparition Evgeny Ryabitskiy
              apparition Evgeny Ryabitskiy
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: