Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 21368 invoked from network); 1 Feb 2006 19:00:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Feb 2006 19:00:23 -0000 Received: (qmail 13610 invoked by uid 500); 1 Feb 2006 19:00:22 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 13576 invoked by uid 500); 1 Feb 2006 19:00:22 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 13565 invoked by uid 99); 1 Feb 2006 19:00:22 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Feb 2006 11:00:22 -0800 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 01 Feb 2006 11:00:21 -0800 Received: (qmail 21268 invoked by uid 65534); 1 Feb 2006 19:00:01 -0000 Message-ID: <20060201190001.21266.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r374144 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ejbql.out master/j9_13/ejbql.out tests/lang/ejbql.sql Date: Wed, 01 Feb 2006 19:00:00 -0000 To: derby-commits@db.apache.org From: djd@apache.org X-Mailer: svnmailer-1.0.5 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: djd Date: Wed Feb 1 10:59:57 2006 New Revision: 374144 URL: http://svn.apache.org/viewcvs?rev=374144&view=rev Log: DERBY-680 (partial) Commit part of patch related to modifying ejbql test as it is separate from the the issue of changing ij. Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ejbql.sql Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?rev=374144&r1=374143&r2=374144&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Wed Feb 1 10:59:57 2006 @@ -1624,48 +1624,42 @@ ----------- NULL ij> autocommit off; -ij> -- Prepare Statements, should pass and return 1 -prepare p1 as 'select abs(?) from myint'; -ij> prepare p1 as 'select 1 from myint where ? <= 4'; -ij> execute p1 using 'values absval( 4 )'; +ij> values absval( 4 ); 1 ----------- -1 -ij> execute p1 using 'values absval( -4 )'; -1 ------------ -1 -ij> execute p1 using 'values absval( 4.4 )'; -1 ------------ -1 -ij> execute p1 using 'values absval( -4.4 )'; -1 ------------ -1 -ij> -- Prepare Statements, should pass and return 1 -prepare p2 as 'select {fn abs(?)} from myint'; -ij> prepare p2 as 'select 1 from myint where ? <= 4'; -ij> execute p2 using 'values {fn abs( 4 )}'; +4 +ij> values absval( -4 ); 1 ----------- -1 -ij> execute p2 using 'values {fn abs( -4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( 4.4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( -4.4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( -4.44444444444444444444444 )}'; -1 ------------ -1 +4 +ij> values absval( 4.4 ); +1 +----- +4.4 +ij> values absval( -4.4 ); +1 +----- +4.4 +ij> values {fn abs( 4 )}; +1 +----------- +4 +ij> values {fn abs( -4 )}; +1 +----------- +4 +ij> values {fn abs( 4.4 )}; +1 +----- +4.4 +ij> values {fn abs( -4.4 )}; +1 +----- +4.4 +ij> values {fn abs( -4.44444444444444444444444 )}; +1 +--------------------------- +4.44444444444444444444444 ij> autocommit on; ij> drop table myint; 0 rows inserted/updated/deleted Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out?rev=374144&r1=374143&r2=374144&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out Wed Feb 1 10:59:57 2006 @@ -1624,48 +1624,42 @@ ----------- NULL ij> autocommit off; -ij> -- Prepare Statements, should pass and return 1 -prepare p1 as 'select abs(?) from myint'; -ij> prepare p1 as 'select 1 from myint where ? <= 4'; -ij> execute p1 using 'values absval( 4 )'; +ij> values absval( 4 ); 1 ----------- -1 -ij> execute p1 using 'values absval( -4 )'; -1 ------------ -1 -ij> execute p1 using 'values absval( 4.4 )'; -1 ------------ -1 -ij> execute p1 using 'values absval( -4.4 )'; -1 ------------ -1 -ij> -- Prepare Statements, should pass and return 1 -prepare p2 as 'select {fn abs(?)} from myint'; -ij> prepare p2 as 'select 1 from myint where ? <= 4'; -ij> execute p2 using 'values {fn abs( 4 )}'; +4 +ij> values absval( -4 ); 1 ----------- -1 -ij> execute p2 using 'values {fn abs( -4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( 4.4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( -4.4 )}'; -1 ------------ -1 -ij> execute p2 using 'values {fn abs( -4.44444444444444444444444 )}'; -1 ------------ -1 +4 +ij> values absval( 4.4 ); +1 +----- +4.4 +ij> values absval( -4.4 ); +1 +----- +4.4 +ij> values {fn abs( 4 )}; +1 +----------- +4 +ij> values {fn abs( -4 )}; +1 +----------- +4 +ij> values {fn abs( 4.4 )}; +1 +----- +4.4 +ij> values {fn abs( -4.4 )}; +1 +----- +4.4 +ij> values {fn abs( -4.44444444444444444444444 )}; +1 +--------------------------- +4.44444444444444444444444 ij> autocommit on; ij> drop table myint; 0 rows inserted/updated/deleted Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ejbql.sql URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ejbql.sql?rev=374144&r1=374143&r2=374144&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ejbql.sql (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/ejbql.sql Wed Feb 1 10:59:57 2006 @@ -388,22 +388,16 @@ select abs(a) from myint; autocommit off; --- Prepare Statements, should pass and return 1 -prepare p1 as 'select abs(?) from myint'; -prepare p1 as 'select 1 from myint where ? <= 4'; -execute p1 using 'values absval( 4 )'; -execute p1 using 'values absval( -4 )'; -execute p1 using 'values absval( 4.4 )'; -execute p1 using 'values absval( -4.4 )'; +values absval( 4 ); +values absval( -4 ); +values absval( 4.4 ); +values absval( -4.4 ); --- Prepare Statements, should pass and return 1 -prepare p2 as 'select {fn abs(?)} from myint'; -prepare p2 as 'select 1 from myint where ? <= 4'; -execute p2 using 'values {fn abs( 4 )}'; -execute p2 using 'values {fn abs( -4 )}'; -execute p2 using 'values {fn abs( 4.4 )}'; -execute p2 using 'values {fn abs( -4.4 )}'; -execute p2 using 'values {fn abs( -4.44444444444444444444444 )}'; +values {fn abs( 4 )}; +values {fn abs( -4 )}; +values {fn abs( 4.4 )}; +values {fn abs( -4.4 )}; +values {fn abs( -4.44444444444444444444444 )}; autocommit on; drop table myint;