[CAY-1470] Oracle: Problem with bind CHAR in select

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.0 branch, 3.0
• Fix Version/s: Undefined future
• Component/s: Core Library
• Labels: 3.1-review
• Assignee: Evgeny Ryabitskiy
• Reporter: Evgeny Ryabitskiy
• Created: 04/Aug/10 14:04
• Updated: 22/Feb/23 12:35

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!

Issue Links

• is related to: CAY-2799 CHAR type support for Oracle