You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Evgeny Ryabitskiy (JIRA)" <ji...@apache.org> on 2010/09/17 12:43:32 UTC
[jira] Updated: (CAY-1470) Oracle: Problem with bind CHAR in select
[ https://issues.apache.org/jira/browse/CAY-1470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Evgeny Ryabitskiy updated CAY-1470:
-----------------------------------
Attachment: CAY-1470-Test.patch
I have add fix for this problem + some test case.
But test will fail on Oracle since fixedString property not set.
In CAY-1470-Test.patch some change to DriverDataSource which will help to fix tests, if you don't mind I will commit it.
> Oracle: Problem with bind CHAR in select
> ----------------------------------------
>
> Key: CAY-1470
> URL: https://issues.apache.org/jira/browse/CAY-1470
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 2.0 branch, 3.0
> Reporter: Evgeny Ryabitskiy
> Assignee: Evgeny Ryabitskiy
> Priority: Critical
> Fix For: 2.0.5, 3.1M1
>
> Attachments: CAY-1470-Test.patch, CAY-1470.patch, CAY-1470.patch, CAY-1470.patch
>
>
> 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!
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.