Cayenne
  1. Cayenne
  2. CAY-1470

Oracle: Problem with bind CHAR in select

    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!

      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

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Evgeny Ryabitskiy
            Reporter:
            Evgeny Ryabitskiy
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development