Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 75911 invoked from network); 7 May 2010 07:05:25 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 7 May 2010 07:05:25 -0000 Received: (qmail 93051 invoked by uid 500); 7 May 2010 07:05:23 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 92908 invoked by uid 500); 7 May 2010 07:05:23 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 92889 invoked by uid 99); 7 May 2010 07:05:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 May 2010 07:05:22 +0000 X-ASF-Spam-Status: No, hits=-1.0 required=10.0 tests=AWL,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 07 May 2010 07:05:16 +0000 Received: (qmail 3617 invoked from network); 7 May 2010 07:04:55 -0000 Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1) by localhost with SMTP; 7 May 2010 07:04:55 -0000 Message-Id: From: Andrus Adamchik To: user@cayenne.apache.org In-Reply-To: <1D24C2CB-85A6-48AD-8E28-8FBC6923A8AC@lindesay.co.nz> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: EJBQL and Refreshing Data Date: Fri, 7 May 2010 10:04:54 +0300 References: <2FBA0CFF-EB35-40F2-9B8F-DEE0C99AA770@lindesay.co.nz> <538077DA-B5D7-4D6A-A6C4-A20E6A1B6965@lindesay.co.nz> <15AD44B6-5626-4F58-B401-9CF476FDBE2B@lindesay.co.nz> <6FD28A45-9202-4D60-B9DE-7F429E4A3AA1@objectstyle.org> <170850E4-3698-4ACF-B225-FBBF17CC6DD3@lindesay.co.nz> <981F6EAB-CA58-472A-BCAA-54E61433097F@objectstyle.org> <1D24C2CB-85A6-48AD-8E28-8FBC6923A8AC@lindesay.co.nz> X-Mailer: Apple Mail (2.936) On May 6, 2010, at 11:53 PM, Andrew Lindesay wrote: > Congratulations to you all on getting 3.0 formally released. thanks :-) > I have lodged a new ticket "CAY-1427" for this presumed bug below. > I see that maybe I could add a unit test into; > > org.apache.cayenne.ejbql.EJBQLCompiledExpressionTest Just found the test for EJBQL fetch joins: DataContextEJBQLFetchJoinTest. It seems to be available on 3.1 and 3.0 branches and it has a LEFT OUTER join test. Maybe you can look at it and see if the test is wrong. > I can't easily see where the "artists and paintings" database SQL > lives which presumably gets populated into some database when the > tests are setup. Is that somewhere accessible? The schema for the test DB is setup via static methods. See CayenneCase class (superclass of DB-aware unit tests) for details. * To clean the DB, call CayenneCase.deleteTestData(). * There are various ways to create new data. We used Spring XML in 3.0, in 3.1 we created a special helper subproject "cayenne-test- utilities". A release independent way would be to use SQLTemplate. Andrus