Author: aadamchik
Date: Fri Apr 25 13:32:01 2008
New Revision: 651695
URL: http://svn.apache.org/viewvc?rev=651695&view=rev
Log:
normalizing the unit test to ensure it runs the same way on all DB's
Modified:
cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
Modified:
cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
URL:
http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java?rev=651695&r1=651694&r2=651695&view=diff
==============================================================================
---
cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
(original)
+++
cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/java/org/apache/cayenne/access/DataContextSQLTemplateTest.java
Fri Apr 25 13:32:01 2008
@@ -56,7 +56,7 @@
public void testSQLResultSetMappingMixed() throws Exception {
createTestData("prepare");
- String sql = "SELECT t0.ARTIST_ID AS X, t0.ARTIST_NAME AS Y,
t0.DATE_OF_BIRTH AS Z, count(t1.PAINTING_ID) AS C "
+ String sql = "SELECT #result('t0.ARTIST_ID' 'long' 'X'),
#result('t0.ARTIST_NAME' 'String' 'Y'), #result('t0.DATE_OF_BIRTH' 'Date' 'Z'),
#result('count(t1.PAINTING_ID)' 'int' 'C') "
+ "FROM ARTIST t0 LEFT JOIN PAINTING t1 ON (t0.ARTIST_ID =
t1.ARTIST_ID) "
+ "GROUP BY t0.ARTIST_ID, t0.ARTIST_NAME, t0.DATE_OF_BIRTH "
+ "ORDER BY t0.ARTIST_ID";
