You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by aa...@apache.org on 2014/02/08 13:55:28 UTC

svn commit: r1566011 - /cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java

Author: aadamchik
Date: Sat Feb  8 12:55:28 2014
New Revision: 1566011

URL: http://svn.apache.org/r1566011
Log:
CAY-1470 Oracle: Problem with bind CHAR in select

removing CAY-1470 test - after all the issue is not fixed, and we can't get a clean build

Modified:
    cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java

Modified: cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java?rev=1566011&r1=1566010&r2=1566011&view=diff
==============================================================================
--- cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java (original)
+++ cayenne/main/trunk/cayenne-server/src/test/java/org/apache/cayenne/query/SQLTemplateTest.java Sat Feb  8 12:55:28 2014
@@ -53,25 +53,6 @@ public class SQLTemplateTest extends Ser
         dbHelper.deleteAll("ARTIST");
     }
 
-    public void testBindCHARInWHERE() {
-        // add 2 Artists
-        DataMap testDataMap = context.getEntityResolver().getDataMap("testmap");
-        SQLTemplate q1 = new SQLTemplate(testDataMap, "INSERT INTO ARTIST VALUES (1, 'Surikov', null)", true);
-        SQLTemplate q2 = new SQLTemplate(testDataMap, "INSERT INTO ARTIST VALUES (2, 'Shishkin', null)", true);
-        QueryChain chain = new QueryChain();
-        chain.addQuery(q1);
-        chain.addQuery(q2);
-        context.performNonSelectingQuery(chain);
-        // now select one Artist by Name, It's matter that ARTIST_NAME is CHAR
-        // not VARCHAR
-        SQLTemplate s1 = new SQLTemplate(testDataMap, "SELECT * FROM ARTIST WHERE ARTIST_NAME = #bind($ARTIST_NAME)",
-                true);
-        // whitespace after name is for reason
-        s1.setParameters(Collections.singletonMap("ARTIST_NAME", "Surikov "));
-        List<DataRow> result = context.performQuery(s1);
-        assertEquals(1, result.size());
-    }
-
     public void testSQLTemplateForDataMap() {
         DataMap testDataMap = context.getEntityResolver().getDataMap("testmap");
         SQLTemplate q1 = new SQLTemplate(testDataMap, "SELECT * FROM ARTIST", true);