Return-Path: Delivered-To: apmail-db-jdo-commits-archive@www.apache.org Received: (qmail 70629 invoked from network); 4 Apr 2005 19:50:49 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Apr 2005 19:50:49 -0000 Received: (qmail 93292 invoked by uid 500); 4 Apr 2005 19:50:47 -0000 Mailing-List: contact jdo-commits-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-commits@db.apache.org Received: (qmail 93271 invoked by uid 99); 4 Apr 2005 19:50:46 -0000 X-ASF-Spam-Status: No, hits=-9.8 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Mon, 04 Apr 2005 12:50:43 -0700 Received: (qmail 67724 invoked by uid 65534); 4 Apr 2005 19:43:57 -0000 Message-ID: <20050404194357.67720.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: svnmailer-1.0.0-dev Date: Mon, 04 Apr 2005 19:43:57 -0000 Subject: svn commit: r160090 [44/63] - in incubator/jdo/trunk: ./ tck20/ tck20/assertions/ tck20/iut_jars/ tck20/test/ tck20/test/conf/ tck20/test/java/ tck20/test/java/org/ tck20/test/java/org/apache/ tck20/test/java/org/apache/jdo/ tck20/test/java/org/apache/jdo/tck/ tck20/test/java/org/apache/jdo/tck/api/ tck20/test/java/org/apache/jdo/tck/api/instancecallbacks/ tck20/test/java/org/apache/jdo/tck/api/jdohelper/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/cache/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/close/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/extent/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/flags/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/getobject/ tck20/test/java/org/apache/jdo/tck/api/persistencemanager/lifecycle/ tck20/test/java/org/apache/jdo/tck/api/persistencemanagerfactory/ tck20/test/java/org/apache/jdo/tck/enhancement/ tck20/test/java/org/apache/jdo/tck/extents/ tck20/test/java/org/apache/jdo/tck/lifecycle/ tck20/test/java/org/apache/jdo/tck/lifecycle/nontransactional/ tck20/test/java/org/apache/jdo/tck/models/ tck20/test/java/org/apache/jdo/tck/models/embedded/ tck20/test/java/org/apache/jdo/tck/models/fieldtypes/ tck20/test/java/org/apache/jdo/tck/models/inheritance/ tck20/test/java/org/apache/jdo/tck/pc/ tck20/test/java/org/apache/jdo/tck/pc/company/ tck20/test/java/org/apache/jdo/tck/pc/fieldtypes/ tck20/test/java/org/apache/jdo/tck/pc/inheritance/ tck20/test/java/org/apache/jdo/tck/pc/instancecallbacks/ tck20/test/java/org/apache/jdo/tck/pc/lifecycle/ tck20/test/java/org/apache/jdo/tck/pc/mylib/ tck20/test/java/org/apache/jdo/tck/query/ tck20/test/java/org/apache/jdo/tck/query/operators/ tck20/test/java/org/apache/jdo/tck/transactions/ tck20/test/java/org/apache/jdo/tck/util/ tck20/test/jdo/ tck20/test/jdo/applicationidentity/ tck20/test/jdo/applicationidentity/org/ tck20/test/jdo/applicationidentity/org/apache/ tck20/test/jdo/applicationidentity/org/apache/jdo/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/company/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/inheritance/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/instancecallbacks/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/lifecycle/ tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/mylib/ tck20/test/jdo/datastoreidentity/ tck20/test/jdo/datastoreidentity/org/ tck20/test/jdo/datastoreidentity/org/apache/ tck20/test/jdo/datastoreidentity/org/apache/jdo/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/company/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/inheritance/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/instancecallbacks/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/lifecycle/ tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/mylib/ tck20/test/orm/ tck20/test/orm/applicationidentity/ tck20/test/orm/applicationidentity/org/ tck20/test/orm/applicationidentity/org/apache/ tck20/test/orm/applicationidentity/org/apache/jdo/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/company/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/inheritance/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/instancecallbacks/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/lifecycle/ tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/ tck20/test/orm/datastoreidentity/ tck20/test/orm/datastoreidentity/org/ tck20/test/orm/datastoreidentity/org/apache/ tck20/test/orm/datastoreidentity/org/apache/jdo/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/company/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/inheritance/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/instancecallbacks/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/lifecycle/ tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/ tck20/test/sql/ tck20/test/sql/derby/ To: jdo-commits@db.apache.org From: mcaisse@apache.org X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Added: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/query/operato= rs/GreaterThan.java URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/java/org/= apache/jdo/tck/query/operators/GreaterThan.java?view=3Dauto&rev=3D160090 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/query/operators/= GreaterThan.java (added) +++ incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/query/operators/= GreaterThan.java Mon Apr 4 12:41:23 2005 @@ -0,0 +1,1194 @@ +/* + * Copyright 2005 The Apache Software Foundation. + *=20 + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at=20 + *=20 + * http://www.apache.org/licenses/LICENSE-2.0 + *=20 + * Unless required by applicable law or agreed to in writing, software=20 + * distributed under the License is distributed on an "AS IS" BASIS,=20 + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied= .=20 + * See the License for the specific language governing permissions and=20 + * limitations under the License. + */ + +package org.apache.jdo.tck.query.operators; + +import java.math.BigDecimal; +import java.math.BigInteger; +import java.util.Calendar; +import java.util.Date; +import java.util.GregorianCalendar; +import java.util.Iterator; +import java.util.Locale; +import java.util.TimeZone; + +import org.apache.jdo.tck.pc.fieldtypes.AllTypes; +import org.apache.jdo.tck.util.BatchTestRunner; + + +/** + *Title: Greater Than Query Operator + *
+ *Keywords: query + *
+ *Assertion ID: A14.6.2-16. + *
+ *Assertion Description: +The greater than operator (>) is supported for all types as +they are defined in the Java language. This includes the following types: +
    +
  • byte, short, int, long, char, Byte, Short Integer, Long, Charact= er
    • +
  • float, double, Float, Double
    • +
  • BigDecimal, BigInteger
    • +
  • Date, String
    • +
+The operation on object-valued fields of wrapper types (Boolean, Byt= e, +Short, Integer, Long, Float, and Double), and numeric = types +(BigDecimal and BigInteger) use the wrapped +values as operands. + + */ + +public class GreaterThan extends ComparisonTests { + private static String boolean_filterL =3D "value > fld_b= oolean"; + private static String boolean_filterR =3D "fld_boolean >= value"; + private static String boolean_filterT =3D "fld_boolean >= true"; + private static String boolean_filterF =3D "false > fld_b= oolean"; + private static String boolean_filterObj =3D "value.fld_boo= lean > fld_boolean"; + =20 + private static String byte_filterL =3D "value > fld_b= yte"; + private static String byte_filterR =3D "fld_byte > va= lue"; + private static String byte_filterObj =3D "value.fld_byt= e > fld_byte"; + private static String byte_filterVal =3D "fld_byte > 10= 0"; + =20 + private static String char_filterL =3D "value > fld_c= har"; + private static String char_filterR =3D "fld_char > va= lue"; + private static String char_filterObj =3D "value.fld_cha= r > fld_char"; + private static String char_filterVal =3D "'M' > fld_cha= r"; + =20 + private static String double_filterL =3D "value > fld_d= ouble"; + private static String double_filterR =3D "fld_double > = value"; + private static String double_filterObj =3D "value.fld_dou= ble > fld_double"; + private static String double_filterVal =3D "fld_double > = 100.0"; + =20 + private static String float_filterL =3D "value > fld_f= loat"; + private static String float_filterR =3D "fld_float > v= alue"; + private static String float_filterObj =3D "fld_float > v= alue.fld_float"; + private static String float_filterVal =3D "fld_float > 1= 00.0"; + =20 + private static String int_filterL =3D "value > fld_i= nt"; + private static String int_filterR =3D "fld_int > val= ue"; + private static String int_filterObj =3D "value.fld_int= > fld_int"; + private static String int_filterVal =3D "fld_int > 100= 0"; + =20 + private static String long_filterL =3D "value > fld_l= ong"; + private static String long_filterR =3D "fld_long > va= lue"; + private static String long_filterObj =3D "fld_long > va= lue.fld_long"; + private static String long_filterVal =3D "fld_long > 10= 00000"; + =20 + private static String short_filterL =3D "value > fld_s= hort"; + private static String short_filterR =3D "fld_short > v= alue"; + private static String short_filterObj =3D "value.fld_sho= rt > fld_short"; + private static String short_filterVal =3D "1000 > fld_sh= ort"; + =20 + private static String Boolean_filterL =3D "value > fld_B= oolean"; + private static String Boolean_filterR =3D "fld_Boolean >= value"; + private static String Boolean_filterT =3D "fld_Boolean >= true"; + private static String Boolean_filterF =3D "false > fld_B= oolean"; + private static String Boolean_filterObj =3D "value.fld_Boo= lean > fld_Boolean"; + private static String Boolean_filterVal =3D "fld_Boolean >= false"; + =20 + private static String Byte_filterL =3D "value > fld_B= yte"; + private static String Byte_filterR =3D "fld_Byte > va= lue"; + private static String Byte_filterObj =3D "fld_Byte > va= lue.fld_Byte"; + private static String Byte_filterVal =3D "100 > fld_Byt= e"; + =20 + private static String Character_filterL =3D "value > fld_C= haracter"; + private static String Character_filterR =3D "fld_Character= > value"; + private static String Character_filterObj =3D "value.fld_Cha= racter > fld_Character"; + private static String Character_filterVal =3D "fld_Character= > 'z'"; + =20 + private static String Double_filterL =3D "value > fld_D= ouble"; + private static String Double_filterR =3D "fld_Double > = value"; + private static String Double_filterObj =3D "value.fld_Dou= ble > fld_Double"; + private static String Double_filterVal =3D "fld_Double > = 100.0"; + =20 + private static String Float_filterL =3D "value > fld_F= loat"; + private static String Float_filterR =3D "fld_Float > v= alue"; + private static String Float_filterObj =3D "fld_Float > v= alue.fld_Float"; + private static String Float_filterVal =3D "100.0f > fld_= Float"; + =20 + private static String Integer_filterL =3D "value > fld_I= nteger"; + private static String Integer_filterR =3D "fld_Integer >= value"; + private static String Integer_filterObj =3D "fld_Integer >= value.fld_Integer"; + private static String Integer_filterVal =3D "fld_Integer >= 100"; + =20 + private static String Long_filterL =3D "value > fld_L= ong"; + private static String Long_filterR =3D "fld_Long > va= lue"; + private static String Long_filterObj =3D "value.fld_Lon= g > fld_Long"; + private static String Long_filterVal =3D "-1000 > fld_L= ong"; + =20 + private static String Short_filterL =3D "value > fld_S= hort"; + private static String Short_filterR =3D "fld_Short > v= alue"; + private static String Short_filterObj =3D "fld_Short > v= alue.fld_Short"; + private static String Short_filterVal =3D "-1000 > fld_S= hort"; + =20 + private static String String_filterL =3D "value > fld_S= tring"; + private static String String_filterR =3D "fld_String > = value"; + private static String String_filterObj =3D "value.fld_Str= ing > fld_String"; + private static String String_filterVal1 =3D "fld_String > = \"Java\""; + private static String String_filterVal2 =3D "fld_String > = \"\""; + =20 + private static String Date_filterL =3D "value > fld_D= ate"; + private static String Date_filterR =3D "fld_Date > va= lue"; + private static String Date_filterObj =3D "fld_Date > va= lue.fld_Date"; + =20 + private static String BigDecimal_filterL =3D "value > fld_B= igDecimal"; + private static String BigDecimal_filterR =3D "fld_BigDecima= l > value"; + private static String BigDecimal_filterObj =3D "value.fld_Bi= gDecimal > fld_BigDecimal"; + =20 + private static String BigInteger_filterL =3D "value > fld_B= igInteger"; + private static String BigInteger_filterR =3D "fld_BigIntege= r > value"; + private static String BigInteger_filterObj =3D "fld_BigInteg= er > value.fld_BigInteger"; + + /** */ + private static final String ASSERTION_FAILED =3D=20 + "Assertion A14.6.2-16 (GreaterThan) failed: "; + + /** + * The main is called when the class + * is directly executed from the command line. + * @param args The arguments passed to the program. + */ + public static void main(String[] args) { + BatchTestRunner.run(GreaterThan.class); + } + =20 + /** */ + public void test() { + pm =3D getPM(); + + verifyDataLoaded(pm); + tx =3D pm.currentTransaction(); + runQueries(); + + pm.close(); + pm =3D null; + } + + /** */ + private void runQueries() + { + AllTypes alltypes =3D new AllTypes(); + run_byteQuery(byte_filterL, byteParameter, new Byte((byte)0), (byt= e)0, true, 3); + run_byteQuery(byte_filterR, byteParameter, new Byte(Byte.MIN_VALUE= ), Byte.MIN_VALUE, false, 9); + run_byteQuery(byte_filterL, ByteParameter, new Byte((byte)50), (by= te)50, true, 5); + run_byteQuery(byte_filterR, ByteParameter, new Byte(Byte.MAX_VALUE= ), Byte.MAX_VALUE, false, 0); =20 + run_byteQuery(byte_filterL, shortParameter, new Short((short)75), = (byte)75, true, 7); + run_byteQuery(byte_filterR, shortParameter, new Short((short)75), = (byte)75, false, 2); + run_byteQuery(byte_filterL, ShortParameter, new Short((short)10), = (byte)10, true, 4); + run_byteQuery(byte_filterR, ShortParameter, new Short((short)25), = (byte)25, false, 5); + run_byteQuery(byte_filterL, charParameter, new Character((char)101= ), (byte)101, true, 9); + run_byteQuery(byte_filterR, charParameter, new Character((char)50)= , (byte)50, false, 3); + run_byteQuery(byte_filterL, CharacterParameter, new Character((cha= r)0), (byte)0, true, 3); + run_byteQuery(byte_filterR, CharacterParameter, new Character((cha= r)0), (byte)0, false, 6); =20 + run_byteQuery(byte_filterL, intParameter, new Integer(25), (byte)2= 5, true, 5); + run_byteQuery(byte_filterR, intParameter, new Integer(50), (byte)5= 0, false, 3); + run_byteQuery(byte_filterL, IntegerParameter, new Integer(-10), (b= yte)-10, true, 2); + run_byteQuery(byte_filterR, IntegerParameter, new Integer(-100), (= byte)-100, false, 8); + run_byteQuery(byte_filterL, longParameter, new Long(50), (byte)50,= true, 5); + run_byteQuery(byte_filterR, longParameter, new Long(60), (byte)60,= false, 3); + run_byteQuery(byte_filterL, LongParameter, new Long(-100), (byte)-= 100, true, 1); + run_byteQuery(byte_filterR, LongParameter, new Long(-100), (byte)-= 100, false, 8); + run_byteQuery(byte_filterL, floatParameter, new Float(51), (byte)5= 1, true, 7); + run_byteQuery(byte_filterR, floatParameter, new Float(-20), (byte)= -20, false, 8); + run_byteQuery(byte_filterL, FloatParameter, new Float(-99), (byte)= -99, true, 2); + run_byteQuery(byte_filterR, FloatParameter, new Float(-100), (byte= )-100, false, 8); + run_byteQuery(byte_filterL, doubleParameter, new Double(50), (byte= )50, true, 5); + run_byteQuery(byte_filterR, doubleParameter, new Double(60), (byte= )60, false, 3); + run_byteQuery(byte_filterL, DoubleParameter, new Double(Byte.MAX_V= ALUE), Byte.MAX_VALUE, true, 9); + run_byteQuery(byte_filterR, DoubleParameter, new Double(25), (byte= )25, false, 5); + run_byteQuery(byte_filterL, BigIntegerParameter, new BigInteger("5= 0"), (byte)50, true, 5); + run_byteQuery(byte_filterR, BigIntegerParameter, new BigInteger("-= 100"), (byte)-100, false, 8); + run_byteQuery(byte_filterL, BigDecimalParameter, new BigDecimal("5= 0=2E000000"), (byte)50, true, 5); + run_byteQuery(byte_filterR, BigDecimalParameter, new BigDecimal("1= 0=2E00000"), (byte)10, false, 5); =20 + alltypes.setbyte((byte)50); + run_byteQuery(byte_filterObj, AllTypesParameter, alltypes, (byte)5= 0, true, 5); + alltypes.setbyte((byte)55); + run_byteQuery(byte_filterObj, AllTypesParameter, alltypes, (byte)5= 5, true, 7); + run_byteQuery(byte_filterVal, null, null, (byte)100, false, 1); + + run_shortQuery(short_filterL, shortParameter, new Short((short)100= ), (short)100, true, 5); + run_shortQuery(short_filterR, shortParameter, new Short((short)100= ), (short)100, false, 3); + run_shortQuery(short_filterL, ShortParameter, new Short(Short.MIN_= VALUE), Short.MIN_VALUE, true, 0); + run_shortQuery(short_filterR, ShortParameter, new Short((short)253= ), (short)253, false, 3); + run_shortQuery(short_filterR, shortParameter, new Short((short)100= 0), (short)1000, false, 2); + run_shortQuery(short_filterL, byteParameter, new Byte((byte)75), (= short)75, true, 5); + run_shortQuery(short_filterR, byteParameter, new Byte((byte)-75), = (short)-75, false, 6); + run_shortQuery(short_filterL, ByteParameter, new Byte((byte)100), = (short)100, true, 5); + run_shortQuery(short_filterR, ByteParameter, new Byte((byte)100), = (short)100, false, 3); + run_shortQuery(short_filterL, charParameter, new Character((char)7= 5), (short)75, true, 5); + run_shortQuery(short_filterR, charParameter, new Character((char)9= 999), (short)9999, false, 2); + run_shortQuery(short_filterL, CharacterParameter, new Character((c= har)1000), (short)1000, true, 7); + run_shortQuery(short_filterR, CharacterParameter, new Character((c= har)10000), (short)10000, false, 1); + run_shortQuery(short_filterL, intParameter, new Integer(-10000), (= short)-10000, true, 1); + run_shortQuery(short_filterR, intParameter, new Integer(-10000), (= short)-10000, false, 8); + run_shortQuery(short_filterL, IntegerParameter, new Integer(10000)= , (short)10000, true, 8); + run_shortQuery(short_filterR, IntegerParameter, new Integer(30000)= , (short)30000, false, 1); + run_shortQuery(short_filterL, longParameter, new Long(10000), (sho= rt) 10000, true, 8); + run_shortQuery(short_filterR, longParameter, new Long(Short.MAX_VA= LUE), Short.MAX_VALUE, false, 0); + run_shortQuery(short_filterL, LongParameter, new Long(Short.MAX_VA= LUE), Short.MAX_VALUE, true, 9); + run_shortQuery(short_filterR, LongParameter, new Long(100), (short= )100, false, 3); + run_shortQuery(short_filterL, floatParameter, new Float(23000), (s= hort)23000, true, 9); + run_shortQuery(short_filterR, floatParameter, new Float(23000), (s= hort)23000, false, 1); + run_shortQuery(short_filterL, FloatParameter, new Float(-1000), (s= hort)-1000, true, 2); + run_shortQuery(short_filterR, FloatParameter, new Float(100), (sho= rt)100, false, 3); + run_shortQuery(short_filterL, doubleParameter, new Double(-10000.0= ), (short)-10000, true, 1); + run_shortQuery(short_filterR, doubleParameter, new Double(9999.0),= (short)9999, false, 2); + run_shortQuery(short_filterL, DoubleParameter, new Double(23.0), (= short)23, true, 5); + run_shortQuery(short_filterR, DoubleParameter, new Double(23.0), (= short)23, false, 5); + run_shortQuery(short_filterL, BigIntegerParameter, new BigInteger(= "10000"), (short)10000, true, 8); + run_shortQuery(short_filterR, BigIntegerParameter, new BigInteger(= "30000"), (short)30000, false, 1); + run_shortQuery(short_filterL, BigDecimalParameter, new BigDecimal(= "23.0"), (short)23, true, 5); + run_shortQuery(short_filterR, BigDecimalParameter, new BigDecimal(= "23.0"), (short)23, false, 5); + alltypes.setshort((short)100); + run_shortQuery(short_filterObj, AllTypesParameter, alltypes, (shor= t)100, true, 5); + alltypes.setshort((short)23); + run_shortQuery(short_filterObj, AllTypesParameter, alltypes, (shor= t)23, true, 5); + run_shortQuery(short_filterVal, null, null, (short)1000, true, 7); + =20 + run_charQuery(char_filterL, charParameter, new Character(Character= .MIN_VALUE), Character.MIN_VALUE, true, 0); + run_charQuery(char_filterR, charParameter, new Character(Character= .MAX_VALUE), Character.MAX_VALUE, false, 0); + run_charQuery(char_filterL, charParameter, new Character('C'), 'C'= , true, 4); + run_charQuery(char_filterR, charParameter, new Character('z'), 'z'= , false, 1); + run_charQuery(char_filterL, CharacterParameter, new Character(' ')= , ' ', true, 1); + run_charQuery(char_filterR, CharacterParameter, new Character('f')= , 'f', false, 3); + run_charQuery(char_filterL, byteParameter, new Byte((byte)Characte= r=2EMIN_VALUE), (char)Character.MIN_VALUE, true, 0); + run_charQuery(char_filterR, ByteParameter, new Byte((byte)'a'), 'a= ', false, 3); + run_charQuery(char_filterL, shortParameter, new Short((short)'M'),= 'M', true, 5); + run_charQuery(char_filterR, shortParameter, new Short((short)'M'),= 'M', false, 3); + run_charQuery(char_filterL, ShortParameter, new Short((short)'A'),= 'A', true, 2); + run_charQuery(char_filterR, ShortParameter, new Short((short)'A'),= 'A', false, 7); + run_charQuery(char_filterL, intParameter, new Integer('z'), 'z', t= rue, 7); + run_charQuery(char_filterR, intParameter, new Integer('z'), 'z', f= alse, 1); + run_charQuery(char_filterL, IntegerParameter, new Integer('B'), 'B= ', true, 3); + run_charQuery(char_filterR, IntegerParameter, new Integer('B'), 'B= ', false, 6); + run_charQuery(char_filterL, floatParameter, new Float('f'), 'f', t= rue, 7); + run_charQuery(char_filterR, floatParameter, new Float(' '), ' ', f= alse, 8); + run_charQuery(char_filterL, FloatParameter, new Float('z'), 'z', t= rue, 7); + run_charQuery(char_filterR, FloatParameter, new Float('z'), 'z', f= alse, 1); + run_charQuery(char_filterL, doubleParameter, new Double('B'), 'B',= true, 3); + run_charQuery(char_filterR, doubleParameter, new Double('B'), 'B',= false, 6); + run_charQuery(char_filterL, DoubleParameter, new Double('A'), 'A',= true, 2); + run_charQuery(char_filterR, DoubleParameter, new Double('A'), 'A',= false, 7); + run_charQuery(char_filterL, BigIntegerParameter, new BigInteger("6= 5"), 'A', true, 2); // 'A' =3D=3D 65 + run_charQuery(char_filterR, BigIntegerParameter, new BigInteger("1= 22"), 'z', false, 1); // 'z' =3D=3D 122 + run_charQuery(char_filterL, BigDecimalParameter, new BigDecimal("6= 5=2E00000"), 'A', true, 2); + run_charQuery(char_filterR, BigDecimalParameter, new BigDecimal("7= 7=2E0000"), 'M', false, 3); // 'M' =3D=3D 77 + alltypes.setchar('A'); + run_charQuery(char_filterObj, AllTypesParameter, alltypes, 'A', tr= ue, 2); + alltypes.setchar('b'); + run_charQuery(char_filterObj, AllTypesParameter, alltypes, 'b', tr= ue, 7); + run_charQuery(char_filterVal, null, null, 'M', true, 5); + =20 + run_intQuery(int_filterL, intParameter, new Integer(AllTypes.veryL= argeNegativeInt), AllTypes.veryLargeNegativeInt, true, 0); + run_intQuery(int_filterR, intParameter, new Integer(AllTypes.veryL= argePositiveInt), AllTypes.veryLargePositiveInt, false, 0); + run_intQuery(int_filterR, intParameter, new Integer(23), 23, false= , 6); + run_intQuery(int_filterL, IntegerParameter, new Integer(1000000), = 1000000, true, 8); + run_intQuery(int_filterR, IntegerParameter, new Integer(1000), 100= 0, false, 3); + run_intQuery(int_filterL, byteParameter, new Byte((byte)100), 100,= true, 4); + run_intQuery(int_filterR, byteParameter, new Byte((byte)0), 0, fal= se, 6); + run_intQuery(int_filterL, ByteParameter, new Byte((byte)100), 100,= true, 4); + run_intQuery(int_filterR, ByteParameter, new Byte((byte)0), 0, fal= se, 6); + run_intQuery(int_filterL, shortParameter, new Short((short)10000),= 10000, true, 7); + run_intQuery(int_filterR, shortParameter, new Short((short)-1000),= -1000, false, 7); + run_intQuery(int_filterL, ShortParameter, new Short((short)-1000),= -1000, true, 2); + run_intQuery(int_filterR, ShortParameter, new Short((short)10000),= 10000, false, 2); + run_intQuery(int_filterL, charParameter, new Character((char)100),= 100, true, 4); + run_intQuery(int_filterR, charParameter, new Character((char)0), 0= , false, 6); + run_intQuery(int_filterL, CharacterParameter, new Character((char)= 100), 100, true, 4); + run_intQuery(int_filterR, CharacterParameter, new Character((char)= 10000), 10000, false, 2); + run_intQuery(int_filterL, longParameter, new Long(AllTypes.veryLar= gePositiveInt), AllTypes.veryLargePositiveInt, true, 9); + run_intQuery(int_filterR, longParameter, new Long(AllTypes.veryLar= geNegativeInt), AllTypes.veryLargeNegativeInt, false, 9); + run_intQuery(int_filterL, LongParameter, new Long(10000), 10000, t= rue, 7); + run_intQuery(int_filterR, LongParameter, new Long(43), 43, false, = 6); + run_intQuery(int_filterL, floatParameter, new Float(AllTypes.veryL= argePositiveInt), AllTypes.veryLargePositiveInt, true, 9); + run_intQuery(int_filterR, floatParameter, new Float(AllTypes.veryL= argeNegativeInt), AllTypes.veryLargeNegativeInt, false, 9); + run_intQuery(int_filterL, FloatParameter, new Float(10000), 10000,= true, 7); + run_intQuery(int_filterR, FloatParameter, new Float(43), 43, false= , 6); + run_intQuery(int_filterL, doubleParameter, new Double(AllTypes.ver= yLargePositiveInt), AllTypes.veryLargePositiveInt, true, 9); + run_intQuery(int_filterR, doubleParameter, new Double(AllTypes.ver= yLargeNegativeInt), AllTypes.veryLargeNegativeInt, false, 9); + run_intQuery(int_filterL, DoubleParameter, new Double(10000.0), 10= 000, true, 7); + run_intQuery(int_filterR, DoubleParameter, new Double(43.0), 43, f= alse, 6); + run_intQuery(int_filterL, BigIntegerParameter, new BigInteger("100= 0000"), 1000000, true, 8); + run_intQuery(int_filterR, BigIntegerParameter, new BigInteger("100= 0"), 1000, false, 3); + run_intQuery(int_filterL, BigDecimalParameter, new BigDecimal("100= 00.0"), 10000, true, 7); + run_intQuery(int_filterR, BigDecimalParameter, new BigDecimal("43.= 0"), 43, false, 6); + alltypes.setint(100); + run_intQuery(int_filterObj, AllTypesParameter, alltypes, 100, true= , 4); + run_intQuery(int_filterVal, null, null, 1000, false, 3); + =20 + run_longQuery(long_filterL, longParameter, new Long(Long.MIN_VALUE= ), Long.MIN_VALUE, true, 0); + run_longQuery(long_filterR, longParameter, new Long(Long.MAX_VALUE= ), Long.MAX_VALUE, false, 0); + run_longQuery(long_filterL, LongParameter, new Long(100), 100, tru= e, 5); + run_longQuery(long_filterR, LongParameter, new Long(23), 23, false= , 5); + run_longQuery(long_filterL, byteParameter, new Byte((byte)100), 10= 0, true, 5); + run_longQuery(long_filterR, byteParameter, new Byte((byte)0), 0, f= alse, 5); + run_longQuery(long_filterL, ByteParameter, new Byte((byte)100), 10= 0, true, 5); + run_longQuery(long_filterR, ByteParameter, new Byte((byte)0), 0, f= alse, 5); + run_longQuery(long_filterL, shortParameter, new Short((short)-1000= ), -1000, true, 2); + run_longQuery(long_filterR, shortParameter, new Short((short)1000)= , 1000, false, 2); + run_longQuery(long_filterL, ShortParameter, new Short((short)100),= 100, true, 5); + run_longQuery(long_filterR, ShortParameter, new Short((short)32), = 32, false, 5); + run_longQuery(long_filterL, charParameter, new Character((char)0),= 0, true, 4); + run_longQuery(long_filterR, charParameter, new Character((char)100= ), 100, false, 3); + run_longQuery(long_filterL, CharacterParameter, new Character((cha= r)23), 23, true, 5); + run_longQuery(long_filterR, CharacterParameter, new Character((cha= r)0), 0, false, 5); + run_longQuery(long_filterL, intParameter, new Integer(100), 100, t= rue, 5); + run_longQuery(long_filterR, intParameter, new Integer(0), 0, false= , 5); + run_longQuery(long_filterL, IntegerParameter, new Integer(23), 23,= true, 5); + run_longQuery(long_filterR, IntegerParameter, new Integer(1000000)= , 1000000, false, 1); + run_longQuery(long_filterL, floatParameter, new Float(-1000000.0),= -1000000, true, 1); + run_longQuery(long_filterR, floatParameter, new Float((float)Long.= MAX_VALUE), Long.MAX_VALUE, false, 0); + run_longQuery(long_filterL, FloatParameter, new Float(100.0), 100,= true, 5); + run_longQuery(long_filterR, FloatParameter, new Float(32.0), 32, f= alse, 5); + run_longQuery(long_filterL, doubleParameter, new Double(-1000000.0= ), -1000000, true, 1); + run_longQuery(long_filterR, doubleParameter, new Double((double)Lo= ng.MAX_VALUE), Long.MAX_VALUE, false, 0); + run_longQuery(long_filterL, DoubleParameter, new Double(100.0), 10= 0, true, 5); + run_longQuery(long_filterR, DoubleParameter, new Double(32.0), 32,= false, 5); + run_longQuery(long_filterL, BigIntegerParameter, new BigInteger("2= 3"), 23, true, 5); + run_longQuery(long_filterR, BigIntegerParameter, new BigInteger("1= 000000"), 1000000, false, 1); + run_longQuery(long_filterL, BigDecimalParameter, new BigDecimal("1= 00.0"), 100, true, 5); + run_longQuery(long_filterR, BigDecimalParameter, new BigDecimal("3= 2=2E0"), 32, false, 5); + alltypes.setlong(100); + run_longQuery(long_filterObj, AllTypesParameter, alltypes, 100, fa= lse, 3); + run_longQuery(long_filterVal, null, null, 1000000, false, 1); + =20 + run_floatQuery(float_filterL, floatParameter, new Float(AllTypes.F= LOAT_SMALLEST), AllTypes.FLOAT_SMALLEST, true, 0); + run_floatQuery(float_filterR, floatParameter, new Float(AllTypes.F= LOAT_LARGEST), AllTypes.FLOAT_LARGEST, false, 0); + run_floatQuery(float_filterL, FloatParameter, new Float(4.0f), 4.0= f, true, 4); + run_floatQuery(float_filterR, FloatParameter, new Float(400.0f), 4= 00.0f, false, 3); + run_floatQuery(float_filterL, byteParameter, new Byte((byte)4), 4.= 0f, true, 4); + run_floatQuery(float_filterR, byteParameter, new Byte((byte)23), 2= 3=2E0f, false, 6); + run_floatQuery(float_filterL, ByteParameter, new Byte((byte)34), 3= 4=2E0f, true, 4); + run_floatQuery(float_filterR, ByteParameter, new Byte((byte)100), = 100.0f, false, 4); + run_floatQuery(float_filterL, shortParameter, new Short((short)10)= , 10.0f, true, 4); + run_floatQuery(float_filterR, shortParameter, new Short((short)23)= , 23.0f, false, 6); + run_floatQuery(float_filterL, ShortParameter, new Short((short)34)= , 34.0f, true, 4); + run_floatQuery(float_filterR, ShortParameter, new Short((short)100= ), 100.0f, false, 4); + run_floatQuery(float_filterL, charParameter, new Character((char)2= 0), 20.0f, true, 4); + run_floatQuery(float_filterR, charParameter, new Character((char)2= 3), 23.0f, false, 6); + run_floatQuery(float_filterL, CharacterParameter, new Character((c= har)34), 34.0f, true, 4); + run_floatQuery(float_filterR, CharacterParameter, new Character((c= har)100), 100.0f, false, 4); + run_floatQuery(float_filterL, intParameter, new Integer(55000000),= 55000000.0f, true, 8); + run_floatQuery(float_filterR, intParameter, new Integer(23), 23.0f= , false, 6); + run_floatQuery(float_filterL, IntegerParameter, new Integer(34), 3= 4=2E0f, true, 4); + run_floatQuery(float_filterR, IntegerParameter, new Integer(100), = 100.0f, false, 4); + run_floatQuery(float_filterL, longParameter, new Long(55000000), 5= 5000000.0f, true, 8); + run_floatQuery(float_filterR, longParameter, new Long(23), 23.0f, = false, 6); + run_floatQuery(float_filterL, LongParameter, new Long(34), 34.0f, = true, 4); + run_floatQuery(float_filterR, LongParameter, new Long(100), 100.0f= , false, 4); + run_floatQuery(float_filterL, doubleParameter, new Double(55000000= .0), 55000000.0f, true, 8); + run_floatQuery(float_filterR, doubleParameter, new Double(-20.5), = -20.5f, false, 7); + run_floatQuery(float_filterL, DoubleParameter, new Double(2.0), 2.= 0f, true, 4); + run_floatQuery(float_filterR, DoubleParameter, new Double(100.0), = 100.0f, false, 4); + run_floatQuery(float_filterL, BigIntegerParameter, new BigInteger(= "55000000"), 55000000.0f, true, 8); + run_floatQuery(float_filterR, BigIntegerParameter, new BigInteger(= "23"), 23.0f, false, 6); + run_floatQuery(float_filterL, BigDecimalParameter, new BigDecimal(= "55000000.0"), 55000000.0f, true, 8); + run_floatQuery(float_filterR, BigDecimalParameter, new BigDecimal(= "-20.5"), -20.5f, false, 7); + alltypes.setfloat(23.23f); + run_floatQuery(float_filterObj, AllTypesParameter, alltypes, 23.23= f, false, 6); + run_floatQuery(float_filterVal, null, null, 100.0f, false, 4); + =20 + run_doubleQuery(double_filterL, doubleParameter, new Double(AllTyp= es.DOUBLE_SMALLEST), AllTypes.DOUBLE_SMALLEST, true, 0); + run_doubleQuery(double_filterR, doubleParameter, new Double(AllTyp= es.DOUBLE_LARGEST), AllTypes.DOUBLE_LARGEST, false, 0); + run_doubleQuery(double_filterL, DoubleParameter, new Double(0.0), = 0=2E0, true, 3); + run_doubleQuery(double_filterR, DoubleParameter, new Double(23.34)= , 23.34, false, 6); + run_doubleQuery(double_filterL, byteParameter, new Byte((byte)100)= , 100.0, true, 4); + run_doubleQuery(double_filterR, byteParameter, new Byte((byte)0), = 0=2E0, false, 6); + run_doubleQuery(double_filterL, ByteParameter, new Byte((byte)23),= 23.0, true, 4); + run_doubleQuery(double_filterR, ByteParameter, new Byte((byte)100)= , 100.0, false, 4); + run_doubleQuery(double_filterL, charParameter, new Character((char= )100), 100.0, true, 4); + run_doubleQuery(double_filterR, charParameter, new Character((char= )0), 0.0, false, 6); + run_doubleQuery(double_filterL, CharacterParameter, new Character(= (char)23), 23.0, true, 4); + run_doubleQuery(double_filterR, CharacterParameter, new Character(= (char)100), 100.0, false, 4); + run_doubleQuery(double_filterL, shortParameter, new Short((short)1= 00), 100.0, true, 4); + run_doubleQuery(double_filterR, shortParameter, new Short((short)0= ), 0.0, false, 6); + run_doubleQuery(double_filterL, ShortParameter, new Short((short)2= 3), 23.0, true, 4); + run_doubleQuery(double_filterR, ShortParameter, new Short((short)1= 00), 100.0, false, 4); + run_doubleQuery(double_filterL, intParameter, new Integer(100), 10= 0=2E0, true, 4); + run_doubleQuery(double_filterR, intParameter, new Integer(0), 0.0,= false, 6); + run_doubleQuery(double_filterL, IntegerParameter, new Integer(5000= ), 5000.0, true, 7); + run_doubleQuery(double_filterR, IntegerParameter, new Integer(-20)= , -20.0, false, 7); + run_doubleQuery(double_filterL, longParameter, new Long(100), 100.= 0, true, 4); + run_doubleQuery(double_filterR, longParameter, new Long(0), 0.0, f= alse, 6); + run_doubleQuery(double_filterL, LongParameter, new Long(5000), 500= 0=2E0, true, 7); + run_doubleQuery(double_filterR, LongParameter, new Long(-20), -20.= 0, false, 7); + run_doubleQuery(double_filterL, floatParameter, new Float(0.0f), 0= .0f, true, 3); + run_doubleQuery(double_filterR, floatParameter, new Float(100.0f),= 100.0f, false, 4); + run_doubleQuery(double_filterL, FloatParameter, new Float(100.0f),= 100.0, true, 4); + run_doubleQuery(double_filterR, FloatParameter, new Float(69.96f),= 69.96, false, 6); + run_doubleQuery(double_filterL, BigIntegerParameter, new BigIntege= r("5000"), 5000.0, true, 7); + run_doubleQuery(double_filterR, BigIntegerParameter, new BigIntege= r("-20"), -20.0, false, 7); + run_doubleQuery(double_filterL, BigDecimalParameter, new BigDecima= l("100.0"), 100.0, true, 4); + run_doubleQuery(double_filterR, BigDecimalParameter, new BigDecima= l("69.96"), 69.96, false, 6); + alltypes.setdouble(-25.5); + run_doubleQuery(double_filterObj, AllTypesParameter, alltypes, -25= .5, true, 2); + run_doubleQuery(double_filterVal, null, null, 100.0, false, 4); + =20 + run_ByteQuery(Byte_filterL, byteParameter, new Byte((byte)50), new= Byte((byte)50), true, 5); + run_ByteQuery(Byte_filterR, byteParameter, new Byte(Byte.MIN_VALUE= ), new Byte(Byte.MIN_VALUE), false, 9); + run_ByteQuery(Byte_filterL, ByteParameter, new Byte((byte)20), new= Byte((byte)20), true, 5); + run_ByteQuery(Byte_filterR, ByteParameter, new Byte(Byte.MAX_VALUE= ), new Byte(Byte.MAX_VALUE), false, 0); =20 + run_ByteQuery(Byte_filterL, shortParameter, new Short((short)60), = new Byte((byte)60), true, 7); + run_ByteQuery(Byte_filterR, shortParameter, new Short((short)51), = new Byte((byte)51), false, 3); + run_ByteQuery(Byte_filterL, ShortParameter, new Short((short)-100)= , new Byte((byte)-100), true, 1); + run_ByteQuery(Byte_filterR, ShortParameter, new Short((short)-100)= , new Byte((byte)-100), false, 8); + run_ByteQuery(Byte_filterL, charParameter, new Character((char)101= ), new Byte((byte)101), true, 9); + run_ByteQuery(Byte_filterR, charParameter, new Character((char)10)= , new Byte((byte)10), false, 5); + run_ByteQuery(Byte_filterL, CharacterParameter, new Character((cha= r)50), new Byte((byte)50), true, 5); + run_ByteQuery(Byte_filterR, CharacterParameter, new Character((cha= r)75), new Byte((byte)75), false, 2); =20 + run_ByteQuery(Byte_filterL, intParameter, new Integer(77), new Byt= e((byte)77), true, 8); + run_ByteQuery(Byte_filterR, intParameter, new Integer(60), new Byt= e((byte)60), false, 3); + run_ByteQuery(Byte_filterL, IntegerParameter, new Integer(40), new= Byte((byte)40), true, 5); + run_ByteQuery(Byte_filterR, IntegerParameter, new Integer(75), new= Byte((byte)75), false, 2); + run_ByteQuery(Byte_filterL, longParameter, new Long(50), new Byte(= (byte)50), true, 5); + run_ByteQuery(Byte_filterR, longParameter, new Long(50), new Byte(= (byte)50), false, 3); + run_ByteQuery(Byte_filterL, LongParameter, new Long(-100), new Byt= e((byte)-100), true, 1); + run_ByteQuery(Byte_filterR, LongParameter, new Long(-100), new Byt= e((byte)-100), false, 8); + run_ByteQuery(Byte_filterL, floatParameter, new Float(50), new Byt= e((byte)50), true, 5); + run_ByteQuery(Byte_filterR, floatParameter, new Float(50), new Byt= e((byte)50), false, 3); + run_ByteQuery(Byte_filterL, FloatParameter, new Float(-100), new B= yte((byte)-100), true, 1); + run_ByteQuery(Byte_filterR, FloatParameter, new Float(-100), new B= yte((byte)-100), false, 8); + run_ByteQuery(Byte_filterL, doubleParameter, new Double(50), new B= yte((byte)50), true, 5); + run_ByteQuery(Byte_filterR, doubleParameter, new Double(50), new B= yte((byte)50), false, 3); + run_ByteQuery(Byte_filterL, DoubleParameter, new Double(-100), new= Byte((byte)-100), true, 1); + run_ByteQuery(Byte_filterR, DoubleParameter, new Double(-100), new= Byte((byte)-100), false, 8); + run_ByteQuery(Byte_filterL, BigIntegerParameter, new BigInteger("5= 0"), new Byte((byte)50), true, 5); + run_ByteQuery(Byte_filterR, BigIntegerParameter, new BigInteger("-= 100"), new Byte((byte)-100), false, 8); + run_ByteQuery(Byte_filterL, BigDecimalParameter, new BigDecimal("5= 0=2E000000"), new Byte((byte)50), true, 5); + run_ByteQuery(Byte_filterR, BigDecimalParameter, new BigDecimal("1= 0=2E00000"), new Byte((byte)10), false, 5); =20 + Byte val =3D new Byte((byte)50); + alltypes.setByte(val); + run_ByteQuery(Byte_filterObj, AllTypesParameter, alltypes, val, fa= lse, 3); + val =3D new Byte((byte)51); + alltypes.setByte(val); + run_ByteQuery(Byte_filterObj, AllTypesParameter, alltypes, val, fa= lse, 3); + run_ByteQuery(Byte_filterVal, null, null, new Byte((byte)100), tru= e, 8); + =20 + run_ShortQuery(Short_filterL, shortParameter, new Short((short)100= ), new Short((short)100), true, 5); + run_ShortQuery(Short_filterR, shortParameter, new Short((short)100= ), new Short((short)100), false, 3); + run_ShortQuery(Short_filterL, ShortParameter, new Short(Short.MIN_= VALUE), new Short(Short.MIN_VALUE), true, 0); + run_ShortQuery(Short_filterR, ShortParameter, new Short((short)253= ), new Short((short)253), false, 3); + run_ShortQuery(Short_filterR, shortParameter, new Short((short)100= 0), new Short((short)1000), false, 2); + run_ShortQuery(Short_filterL, byteParameter, new Byte((byte)75), n= ew Short((short)75), true, 5); + run_ShortQuery(Short_filterR, byteParameter, new Byte((byte)75), n= ew Short((short)75), false, 5); + run_ShortQuery(Short_filterL, ByteParameter, new Byte((byte)100), = new Short((short)100), true, 5); + run_ShortQuery(Short_filterR, ByteParameter, new Byte((byte)100), = new Short((short)100), false, 3); + run_ShortQuery(Short_filterL, charParameter, new Character((char)7= 5), new Short((short)75), true, 5); + run_ShortQuery(Short_filterR, charParameter, new Character((char)7= 5), new Short((short)75), false, 5); + run_ShortQuery(Short_filterL, CharacterParameter, new Character((c= har)100), new Short((short)100), true, 5); + run_ShortQuery(Short_filterR, CharacterParameter, new Character((c= har)200), new Short((short)200), false, 3); + run_ShortQuery(Short_filterL, intParameter, new Integer(-10000), n= ew Short((short)-10000), true, 1); + run_ShortQuery(Short_filterR, intParameter, new Integer(-10000), n= ew Short((short)-10000), false, 8); + run_ShortQuery(Short_filterL, IntegerParameter, new Integer(10000)= , new Short((short)10000), true, 8); + run_ShortQuery(Short_filterR, IntegerParameter, new Integer(10000)= , new Short((short)10000), false, 1); + run_ShortQuery(Short_filterL, longParameter, new Long(20000), new = Short((short) 20000), true, 9); + run_ShortQuery(Short_filterR, longParameter, new Long(5000), new S= hort((short) 5000), false, 2); + run_ShortQuery(Short_filterL, LongParameter, new Long(200), new Sh= ort((short)200), true, 7); + run_ShortQuery(Short_filterR, LongParameter, new Long(500), new Sh= ort((short)500), false, 3); + run_ShortQuery(Short_filterL, floatParameter, new Float(23000.0f),= new Short((short)23000), true, 9); + run_ShortQuery(Short_filterR, floatParameter, new Float(23000.0f),= new Short((short)23000), false, 1); + run_ShortQuery(Short_filterL, FloatParameter, new Float(10.0f), ne= w Short((short)10), true, 5); + run_ShortQuery(Short_filterR, FloatParameter, new Float(101.0f), n= ew Short((short)101), false, 3); + run_ShortQuery(Short_filterL, doubleParameter, new Double(-10000.0= ), new Short((short)-10000), true, 1); + run_ShortQuery(Short_filterR, doubleParameter, new Double(-10000.0= ), new Short((short)-10000), false, 8); + run_ShortQuery(Short_filterL, DoubleParameter, new Double(101.0), = new Short((short)101), true, 7); + run_ShortQuery(Short_filterR, DoubleParameter, new Double(23.0), n= ew Short((short)23), false, 5); + run_ShortQuery(Short_filterL, BigIntegerParameter, new BigInteger(= "10000"), new Short((short)10000), true, 8); + run_ShortQuery(Short_filterR, BigIntegerParameter, new BigInteger(= "30000"), new Short((short)30000), false, 1); + run_ShortQuery(Short_filterL, BigDecimalParameter, new BigDecimal(= "23.0"), new Short((short)23), true, 5); + run_ShortQuery(Short_filterR, BigDecimalParameter, new BigDecimal(= "23.0"), new Short((short)23), false, 5); + Short sval =3D new Short((short)100); + alltypes.setShort(sval); + run_ShortQuery(Short_filterObj, AllTypesParameter, alltypes, sval,= false, 3); + sval =3D new Short((short)23); + alltypes.setShort(sval); + run_ShortQuery(Short_filterObj, AllTypesParameter, alltypes, sval,= false, 5); + run_ShortQuery(Short_filterVal, null, null, new Short((short)-1000= ), true, 2); + =20 + run_CharacterQuery(Character_filterL, charParameter, new Character= (Character.MIN_VALUE), new Character(Character.MIN_VALUE), true, 0); + run_CharacterQuery(Character_filterR, charParameter, new Character= (Character.MAX_VALUE), new Character(Character.MAX_VALUE), false, 0); + run_CharacterQuery(Character_filterL, charParameter, new Character= ('C'), new Character('C'), true, 4); + run_CharacterQuery(Character_filterR, charParameter, new Character= ('z'), new Character('z'), false, 1); + run_CharacterQuery(Character_filterL, CharacterParameter, new Char= acter(' '), new Character(' '), true, 1); + run_CharacterQuery(Character_filterR, CharacterParameter, new Char= acter('f'), new Character('f'), false, 3); + run_CharacterQuery(Character_filterL, byteParameter, new Byte((byt= e)Character.MIN_VALUE), new Character((char)Character.MIN_VALUE), true, 0); + run_CharacterQuery(Character_filterR, ByteParameter, new Byte((byt= e)'a'), new Character('a'), false, 3); + run_CharacterQuery(Character_filterL, shortParameter, new Short((s= hort)'M'), new Character('M'), true, 5); + run_CharacterQuery(Character_filterR, shortParameter, new Short((s= hort)'F'), new Character('F'), false, 5); + run_CharacterQuery(Character_filterL, ShortParameter, new Short((s= hort)'A'), new Character('A'), true, 2); + run_CharacterQuery(Character_filterR, ShortParameter, new Short((s= hort)'A'), new Character('A'), false, 7); + run_CharacterQuery(Character_filterL, intParameter, new Integer('z= '), new Character('z'), true, 7); + run_CharacterQuery(Character_filterR, intParameter, new Integer('z= '), new Character('z'), false, 1); + run_CharacterQuery(Character_filterL, IntegerParameter, new Intege= r('B'), new Character('B'), true, 3); + run_CharacterQuery(Character_filterR, IntegerParameter, new Intege= r('B'), new Character('B'), false, 6); + run_CharacterQuery(Character_filterL, longParameter, new Long('z')= , new Character('z'), true, 7); + run_CharacterQuery(Character_filterR, longParameter, new Long('z')= , new Character('z'), false, 1); + run_CharacterQuery(Character_filterL, LongParameter, new Long('B')= , new Character('B'), true, 3); + run_CharacterQuery(Character_filterR, LongParameter, new Long('B')= , new Character('B'), false, 6); + run_CharacterQuery(Character_filterL, floatParameter, new Float('z= '), new Character('z'), true, 7); + run_CharacterQuery(Character_filterR, floatParameter, new Float('z= '), new Character('z'), false, 1); + run_CharacterQuery(Character_filterL, FloatParameter, new Float('M= '), new Character('M'), true, 5); + run_CharacterQuery(Character_filterR, FloatParameter, new Float('X= '), new Character('X'), false, 3); + run_CharacterQuery(Character_filterL, doubleParameter, new Double(= 'B'), new Character('B'), true, 3); + run_CharacterQuery(Character_filterR, doubleParameter, new Double(= 'B'), new Character('B'), false, 6); + run_CharacterQuery(Character_filterL, DoubleParameter, new Double(= 'A'), new Character('A'), true, 2); + run_CharacterQuery(Character_filterR, DoubleParameter, new Double(= 'A'), new Character('A'), false, 7); + run_CharacterQuery(Character_filterL, BigIntegerParameter, new Big= Integer("65"), new Character('A'), true, 2); // 'A' =3D=3D 65 + run_CharacterQuery(Character_filterR, BigIntegerParameter, new Big= Integer("122"), new Character('z'), false, 1); // 'z' =3D=3D 122 + run_CharacterQuery(Character_filterL, BigDecimalParameter, new Big= Decimal("65.00000"), new Character('A'), true, 2); + run_CharacterQuery(Character_filterR, BigDecimalParameter, new Big= Decimal("77.0000"), new Character('M'), false, 3); // 'M' =3D=3D 77 + alltypes.setCharacter(new Character('A')); + run_CharacterQuery(Character_filterObj, AllTypesParameter, alltype= s, new Character('A'), true, 2); + alltypes.setCharacter(new Character('b')); + run_CharacterQuery(Character_filterObj, AllTypesParameter, alltype= s, new Character('b'), true, 7); + run_CharacterQuery(Character_filterVal, null, null, new Character(= 'z'), false, 1); + =20 + run_IntegerQuery(Integer_filterL, intParameter, new Integer(AllTyp= es.veryLargeNegativeInt), new Integer(AllTypes.veryLargeNegativeInt), true,= 0); + run_IntegerQuery(Integer_filterR, intParameter, new Integer(AllTyp= es.veryLargePositiveInt), new Integer(AllTypes.veryLargePositiveInt), false= , 0); + run_IntegerQuery(Integer_filterR, intParameter, new Integer(23), n= ew Integer(23), false, 6); + run_IntegerQuery(Integer_filterL, IntegerParameter, new Integer(10= 00000), new Integer(1000000), true, 8); + run_IntegerQuery(Integer_filterR, IntegerParameter, new Integer(10= 00), new Integer(1000), false, 3); + run_IntegerQuery(Integer_filterL, byteParameter, new Byte((byte)10= 0), new Integer(100), true, 4); + run_IntegerQuery(Integer_filterR, byteParameter, new Byte((byte)0)= , new Integer(0), false, 6); + run_IntegerQuery(Integer_filterL, ByteParameter, new Byte((byte)10= 0), new Integer(100), true, 4); + run_IntegerQuery(Integer_filterR, ByteParameter, new Byte((byte)0)= , new Integer(0), false, 6); + run_IntegerQuery(Integer_filterL, shortParameter, new Short((short= )10000), new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, shortParameter, new Short((short= )-1000), new Integer(-1000), false, 7); + run_IntegerQuery(Integer_filterL, ShortParameter, new Short((short= )-1000), new Integer(-1000), true, 2); + run_IntegerQuery(Integer_filterR, ShortParameter, new Short((short= )-999), new Integer(-999), false, 7); + run_IntegerQuery(Integer_filterL, charParameter, new Character((ch= ar)10000), new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, charParameter, new Character((ch= ar)10000), new Integer(10000), false, 2); + run_IntegerQuery(Integer_filterL, CharacterParameter, new Characte= r((char)100), new Integer(100), true, 4); + run_IntegerQuery(Integer_filterR, CharacterParameter, new Characte= r((char)10000), new Integer(10000), false, 2); + run_IntegerQuery(Integer_filterL, longParameter, new Long(AllTypes= .veryLargePositiveInt), new Integer(AllTypes.veryLargePositiveInt), true, 9= ); + run_IntegerQuery(Integer_filterR, longParameter, new Long(AllTypes= .veryLargeNegativeInt), new Integer(AllTypes.veryLargeNegativeInt), false, = 9); + run_IntegerQuery(Integer_filterL, LongParameter, new Long(10000), = new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, LongParameter, new Long(43), new= Integer(43), false, 6); + run_IntegerQuery(Integer_filterL, floatParameter, new Float(AllTyp= es.veryLargePositiveInt), new Integer(AllTypes.veryLargePositiveInt), true,= 9); + run_IntegerQuery(Integer_filterR, floatParameter, new Float(AllTyp= es.veryLargeNegativeInt), new Integer(AllTypes.veryLargeNegativeInt), false= , 9); + run_IntegerQuery(Integer_filterL, FloatParameter, new Float(10000)= , new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, FloatParameter, new Float(43), n= ew Integer(43), false, 6); + run_IntegerQuery(Integer_filterL, doubleParameter, new Double(AllT= ypes.veryLargePositiveInt), new Integer(AllTypes.veryLargePositiveInt), tru= e, 9); + run_IntegerQuery(Integer_filterR, doubleParameter, new Double(AllT= ypes.veryLargeNegativeInt), new Integer(AllTypes.veryLargeNegativeInt), fal= se, 9); + run_IntegerQuery(Integer_filterL, DoubleParameter, new Double(1000= 0), new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, DoubleParameter, new Double(1000= 001.0), new Integer(1000001), false, 1); + run_IntegerQuery(Integer_filterL, BigIntegerParameter, new BigInte= ger("1000000"), new Integer(1000000), true, 8); + run_IntegerQuery(Integer_filterR, BigIntegerParameter, new BigInte= ger("1000"), new Integer(1000), false, 3); + run_IntegerQuery(Integer_filterL, BigDecimalParameter, new BigDeci= mal("10000.0"), new Integer(10000), true, 7); + run_IntegerQuery(Integer_filterR, BigDecimalParameter, new BigDeci= mal("43.0"), new Integer(43), false, 6); + alltypes.setInteger(new Integer(100)); + run_IntegerQuery(Integer_filterObj, AllTypesParameter, alltypes, n= ew Integer(100), false, 4); + run_IntegerQuery(Integer_filterVal, null, null, new Integer(100), = false, 4); + =20 + run_LongQuery(Long_filterL, longParameter, new Long(Long.MIN_VALUE= ), new Long(Long.MIN_VALUE), true, 0); + run_LongQuery(Long_filterR, longParameter, new Long(Long.MAX_VALUE= ), new Long(Long.MAX_VALUE), false, 0); + run_LongQuery(Long_filterL, LongParameter, new Long(100), new Long= (100), true, 5); + run_LongQuery(Long_filterR, LongParameter, new Long(23), new Long(= 23), false, 5); + run_LongQuery(Long_filterL, byteParameter, new Byte((byte)100), ne= w Long(100), true, 5); + run_LongQuery(Long_filterR, byteParameter, new Byte((byte)0), new = Long(0), false, 5); + run_LongQuery(Long_filterL, ByteParameter, new Byte((byte)100), ne= w Long(100), true, 5); + run_LongQuery(Long_filterR, ByteParameter, new Byte((byte)0), new = Long(0), false, 5); + run_LongQuery(Long_filterL, shortParameter, new Short((short)-1000= ), new Long(-1000), true, 2); + run_LongQuery(Long_filterR, shortParameter, new Short((short)1000)= , new Long(1000), false, 2); + run_LongQuery(Long_filterL, ShortParameter, new Short((short)101),= new Long(101), true, 7); + run_LongQuery(Long_filterR, ShortParameter, new Short((short)32), = new Long(32), false, 5); + run_LongQuery(Long_filterL, charParameter, new Character((char)0),= new Long(0), true, 4); + run_LongQuery(Long_filterR, charParameter, new Character((char)100= ), new Long(100), false, 3); + run_LongQuery(Long_filterL, CharacterParameter, new Character((cha= r)23), new Long(23), true, 5); + run_LongQuery(Long_filterR, CharacterParameter, new Character((cha= r)1110), new Long(1110), false, 2); + run_LongQuery(Long_filterL, intParameter, new Integer(100), new Lo= ng(100), true, 5); + run_LongQuery(Long_filterR, intParameter, new Integer(0), new Long= (0), false, 5); + run_LongQuery(Long_filterL, IntegerParameter, new Integer(23), new= Long(23), true, 5); + run_LongQuery(Long_filterR, IntegerParameter, new Integer(1000000)= , new Long(1000000), false, 1); + run_LongQuery(Long_filterL, floatParameter, new Float(-1000000.0),= new Long(-1000000), true, 1); + run_LongQuery(Long_filterR, floatParameter, new Float((float)Long.= MAX_VALUE), new Long(Long.MAX_VALUE), false, 0); + run_LongQuery(Long_filterL, FloatParameter, new Float(100.0f), new= Long(100), true, 5); + run_LongQuery(Long_filterR, FloatParameter, new Float(32.0f), new = Long(32), false, 5); + run_LongQuery(Long_filterL, doubleParameter, new Double(-1000000.0= ), new Long(-1000000), true, 1); + run_LongQuery(Long_filterR, doubleParameter, new Double((double)Lo= ng.MAX_VALUE), new Long(Long.MAX_VALUE), false, 0); + run_LongQuery(Long_filterL, DoubleParameter, new Double(100.0), ne= w Long(100), true, 5); + run_LongQuery(Long_filterR, DoubleParameter, new Double(32.0), new= Long(32), false, 5); + run_LongQuery(Long_filterL, BigIntegerParameter, new BigInteger("2= 3"), new Long(23), true, 5); + run_LongQuery(Long_filterR, BigIntegerParameter, new BigInteger("1= 000000"), new Long(1000000), false, 1); + run_LongQuery(Long_filterL, BigDecimalParameter, new BigDecimal("1= 00.0"), new Long(100), true, 5); + run_LongQuery(Long_filterR, BigDecimalParameter, new BigDecimal("3= 2=2E0"), new Long(32), false, 5); + alltypes.setLong(new Long(100)); + run_LongQuery(Long_filterObj, AllTypesParameter, alltypes, new Lon= g(100), true, 5); + run_LongQuery(Long_filterVal, null, null, new Long(-1000), true, 2= ); + =20 + run_FloatQuery(Float_filterL, floatParameter, new Float(-100000000= 0=2E0f), new Float(-1000000000.0f), true, 1); + run_FloatQuery(Float_filterR, floatParameter, new Float(9000000000= .0f), new Float(9000000000.0f), false, 1); + run_FloatQuery(Float_filterL, FloatParameter, new Float(0.0), new = Float(0.0f), true, 2); + run_FloatQuery(Float_filterR, FloatParameter, new Float(4.0), new = Float(4.0f), false, 7); + run_FloatQuery(Float_filterL, byteParameter, new Byte((byte)0), ne= w Float(0.0f), true, 2); + run_FloatQuery(Float_filterR, byteParameter, new Byte((byte)23), n= ew Float(23.0f), false, 7); + run_FloatQuery(Float_filterL, ByteParameter, new Byte((byte)34), n= ew Float(34.0f), true, 3); + run_FloatQuery(Float_filterR, ByteParameter, new Byte((byte)100), = new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, shortParameter, new Short((short)0),= new Float(0.0f), true, 2); + run_FloatQuery(Float_filterR, shortParameter, new Short((short)23)= , new Float(23.0f), false, 7); + run_FloatQuery(Float_filterL, ShortParameter, new Short((short)34)= , new Float(34.0f), true, 3); + run_FloatQuery(Float_filterR, ShortParameter, new Short((short)100= ), new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, charParameter, new Character((char)0= ), new Float(0.0f), true, 2); + run_FloatQuery(Float_filterR, charParameter, new Character((char)2= 3), new Float(23.0f), false, 7); + run_FloatQuery(Float_filterL, CharacterParameter, new Character((c= har)34), new Float(34.0f), true, 3); + run_FloatQuery(Float_filterR, CharacterParameter, new Character((c= har)100), new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, intParameter, new Integer(50000000),= new Float(50000000.0f), true, 7); + run_FloatQuery(Float_filterR, intParameter, new Integer(23), new F= loat(23.0f), false, 7); + run_FloatQuery(Float_filterL, IntegerParameter, new Integer(34), n= ew Float(34.0f), true, 3); + run_FloatQuery(Float_filterR, IntegerParameter, new Integer(100), = new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, longParameter, new Long(50000000), n= ew Float(50000000.0f), true, 7); + run_FloatQuery(Float_filterR, longParameter, new Long(23), new Flo= at(23.0f), false, 7); + run_FloatQuery(Float_filterL, LongParameter, new Long(34), new Flo= at(34.0f), true, 3); + run_FloatQuery(Float_filterR, LongParameter, new Long(100), new Fl= oat(100.0f), false, 5); + run_FloatQuery(Float_filterL, doubleParameter, new Double(50000000= .0f), new Float(50000000.0f), true, 7); + run_FloatQuery(Float_filterR, doubleParameter, new Double(100.0f),= new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, DoubleParameter, new Double(0.0f), n= ew Float(0.0f), true, 2); + run_FloatQuery(Float_filterR, DoubleParameter, new Double(100.0f),= new Float(100.0f), false, 5); + run_FloatQuery(Float_filterL, BigIntegerParameter, new BigInteger(= "55000000"), new Float(55000000.0f), true, 8); + run_FloatQuery(Float_filterR, BigIntegerParameter, new BigInteger(= "23"), new Float(23.0f), false, 7); + run_FloatQuery(Float_filterL, BigDecimalParameter, new BigDecimal(= "55000000.0"), new Float(55000000.0f), true, 8); + run_FloatQuery(Float_filterR, BigDecimalParameter, new BigDecimal(= "-20.5"), new Float(-20.5f), false, 8); + alltypes.setFloat(new Float(23.23f)); + run_FloatQuery(Float_filterObj, AllTypesParameter, alltypes, new F= loat(23.23f), false, 7); + run_FloatQuery(Float_filterVal, null, null, new Float(100.0f), tru= e, 3); + =20 + run_DoubleQuery(Double_filterL, doubleParameter, new Double(-99999= 9999999.0), new Double(-999999999999.0), true, 1); + run_DoubleQuery(Double_filterR, doubleParameter, new Double(999999= 9999999.0), new Double(9999999999999.0), false, 1); + run_DoubleQuery(Double_filterL, DoubleParameter, new Double(0.0), = new Double(0.0), true, 3); + run_DoubleQuery(Double_filterR, DoubleParameter, new Double(23.34)= , new Double(23.34), false, 6); + run_DoubleQuery(Double_filterL, byteParameter, new Byte((byte)100)= , new Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, byteParameter, new Byte((byte)0), = new Double(0.0), false, 6); + run_DoubleQuery(Double_filterL, ByteParameter, new Byte((byte)-23)= , new Double(-23.0), true, 3); + run_DoubleQuery(Double_filterR, ByteParameter, new Byte((byte)100)= , new Double(100.0), false, 4); + run_DoubleQuery(Double_filterL, shortParameter, new Short((short)1= 00), new Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, shortParameter, new Short((short)0= ), new Double(0.0), false, 6); + run_DoubleQuery(Double_filterL, ShortParameter, new Short((short)2= 3), new Double(23.0), true, 4); + run_DoubleQuery(Double_filterR, ShortParameter, new Short((short)4= 00), new Double(400.0), false, 3); + run_DoubleQuery(Double_filterL, charParameter, new Character((char= )100), new Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, charParameter, new Character((char= )0), new Double(0.0), false, 6); + run_DoubleQuery(Double_filterL, CharacterParameter, new Character(= (char)23), new Double(23.0), true, 4); + run_DoubleQuery(Double_filterR, CharacterParameter, new Character(= (char)400), new Double(400.0), false, 3); + run_DoubleQuery(Double_filterL, intParameter, new Integer(100), ne= w Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, intParameter, new Integer(0), new = Double(0.0), false, 6); + run_DoubleQuery(Double_filterL, IntegerParameter, new Integer(23),= new Double(23.0), true, 4); + run_DoubleQuery(Double_filterR, IntegerParameter, new Integer(100)= , new Double(100.0), false, 4); + run_DoubleQuery(Double_filterL, longParameter, new Long(100), new = Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, longParameter, new Long(0), new Do= uble(0.0), false, 6); + run_DoubleQuery(Double_filterL, LongParameter, new Long(23), new D= ouble(23.0), true, 4); + run_DoubleQuery(Double_filterR, LongParameter, new Long(100), new = Double(100.0), false, 4); + run_DoubleQuery(Double_filterL, floatParameter, new Float(0.0f), n= ew Double(0.0f), true, 3); + run_DoubleQuery(Double_filterR, floatParameter, new Float(100.0f),= new Double(100.0f), false, 4); + run_DoubleQuery(Double_filterL, FloatParameter, new Float(100.0f),= new Double(100.0f), true, 4); + run_DoubleQuery(Double_filterR, FloatParameter, new Float(69.96f),= new Double(69.96), false, 6); + run_DoubleQuery(Double_filterL, BigIntegerParameter, new BigIntege= r("5000"), new Double(5000.0), true, 7); + run_DoubleQuery(Double_filterR, BigIntegerParameter, new BigIntege= r("-20"), new Double(-20.0), false, 7); + run_DoubleQuery(Double_filterL, BigDecimalParameter, new BigDecima= l("100.0"), new Double(100.0), true, 4); + run_DoubleQuery(Double_filterR, BigDecimalParameter, new BigDecima= l("69.96"), new Double(69.96), false, 6); + alltypes.setDouble(new Double(-999999999999.0)); + run_DoubleQuery(Double_filterObj, AllTypesParameter, alltypes, new= Double(-999999999999.0), true, 1); + run_DoubleQuery(Double_filterVal, null, null, new Double(100.0), f= alse, 4); + + run_StringQuery(String_filterL, StringParameter, new String("JDO")= , new String("JDO"), true, 1); + run_StringQuery(String_filterR, StringParameter, new String("JDBC"= ), new String("JDBC"), false, 9); + alltypes.setString(new String("abcde")); + run_StringQuery(String_filterObj, AllTypesParameter, alltypes, new= String("abcde"), true, 7); + run_StringQuery(String_filterVal1, null, null, new String("Java"),= false, 4); + run_StringQuery(String_filterVal2, null, null, new String(""), fal= se, 9); + + BigDecimal bd =3D new BigDecimal("100.0"); + run_BigDecimalQuery(BigDecimal_filterL, BigDecimalParameter, bd, b= d, true, 4); + bd =3D new BigDecimal("-234234.23333"); + run_BigDecimalQuery(BigDecimal_filterR, BigDecimalParameter, bd, b= d, false, 8); + bd =3D new BigDecimal("989899.33304953"); + run_BigDecimalQuery(BigDecimal_filterL, BigDecimalParameter, bd, b= d, true, 7); + bd =3D new BigDecimal("-1123123.22"); + run_BigDecimalQuery(BigDecimal_filterR, BigDecimalParameter, bd, b= d, false, 9); + alltypes.setBigDecimal(bd); + run_BigDecimalQuery(BigDecimal_filterObj, AllTypesParameter, allty= pes, bd, true, 0); + + BigInteger bi =3D new BigInteger("987034534985043985"); + run_BigIntegerQuery(BigInteger_filterL, BigIntegerParameter, bi, b= i, true, 9); + bi =3D new BigInteger("-999999999999999999"); + run_BigIntegerQuery(BigInteger_filterR, BigIntegerParameter, bi, b= i, false, 9); + bi =3D new BigInteger("-9999999999999999999"); + run_BigIntegerQuery(BigInteger_filterR, BigIntegerParameter, bi, b= i, false, 10); + bi =3D new BigInteger("1333330"); + alltypes.setBigInteger(bi); + run_BigIntegerQuery(BigInteger_filterObj, AllTypesParameter, allty= pes, bi, false, 2); + =20 + GregorianCalendar gc =3D new GregorianCalendar(TimeZone.getTimeZon= e("GMT"), Locale.UK); + gc.clear(); + gc.set(1999, Calendar.DECEMBER, 31, 9, 0, 0); + Date d =3D gc.getTime(); + run_DateQuery(Date_filterL, DateParameter, d, d, true, 7); + gc.set(1992, Calendar.NOVEMBER, 22, 9, 0, 0); + d =3D gc.getTime(); + run_DateQuery(Date_filterR, DateParameter, d, d, false, 4); + gc.set(1959, Calendar.OCTOBER, 9, 9, 0, 0); + d =3D gc.getTime(); + run_DateQuery(Date_filterR, DateParameter, d, d, false, 7); + gc.set(1995, Calendar.JUNE, 14, 9, 0, 0); + d =3D gc.getTime(); + alltypes.setDate(d); + run_DateQuery(Date_filterObj, AllTypesParameter, alltypes, d, fals= e, 3); + + } + + private void run_byteQuery(String filter, String parameter, Object par= ameterValue, byte value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + byte val =3D obj.getbyte(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_shortQuery(String filter, String parameter, Object pa= rameterValue, short value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + short val =3D obj.getshort(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_charQuery(String filter, String parameter, Object par= ameterValue, char value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + char val =3D obj.getchar(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_intQuery(String filter, String parameter, Object para= meterValue, int value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + int val =3D obj.getint(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_longQuery(String filter, String parameter, Object par= ameterValue, long value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + long val =3D obj.getlong(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_floatQuery(String filter, String parameter, Object pa= rameterValue, float value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + float val =3D obj.getfloat(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_doubleQuery(String filter, String parameter, Object p= arameterValue, double value, boolean valueOnLeft, int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + double val =3D obj.getdouble(); + boolean correct_value =3D valueOnLeft ? value > val : val > va= lue; + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_ByteQuery(String filter, String parameter, Object par= ameterValue, + Byte value, boolean valueOnLeft, int expect= ed_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Byte val =3D obj.getByte(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_ShortQuery(String filter, String parameter, Object pa= rameterValue, + Short value, boolean valueOnLeft, int expe= cted_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Short val =3D obj.getShort(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_CharacterQuery(String filter, String parameter, Objec= t parameterValue, + Character value, boolean valueOnLeft, = int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Character val =3D obj.getCharacter(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_IntegerQuery(String filter, String parameter, Object = parameterValue, + Integer value, boolean valueOnLeft, int = expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Integer val =3D obj.getInteger(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_LongQuery(String filter, String parameter, Object par= ameterValue, + Long value, boolean valueOnLeft, int expect= ed_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Long val =3D obj.getLong(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_FloatQuery(String filter, String parameter, Object pa= rameterValue, + Float value, boolean valueOnLeft, int expe= cted_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Float val =3D obj.getFloat(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_DoubleQuery(String filter, String parameter, Object p= arameterValue, + Double value, boolean valueOnLeft, int ex= pected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Double val =3D obj.getDouble(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_StringQuery(String filter, String parameter, Object p= arameterValue, + String value, boolean valueOnLeft, int ex= pected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + String val =3D obj.getString(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_BigDecimalQuery(String filter, String parameter, Obje= ct parameterValue, + BigDecimal value, boolean valueOnLeft= , int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + BigDecimal val =3D obj.getBigDecimal(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_BigIntegerQuery(String filter, String parameter, Obje= ct parameterValue, + BigInteger value, boolean valueOnLeft= , int expected_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + BigInteger val =3D obj.getBigInteger(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } + + private void run_DateQuery(String filter, String parameter, Object par= ameterValue, + Date value, boolean valueOnLeft, int expect= ed_count) + { + tx.begin(); + runQuery(pm, filter, parameter, parameterValue, ASSERTION_FAILED); + if( query_result =3D=3D null ) + return; + Iterator iter =3D query_result.iterator(); + int cnt =3D 0; + while( iter.hasNext() ){ + AllTypes obj =3D (AllTypes) iter.next(); + Date val =3D obj.getDate(); + boolean correct_value =3D valueOnLeft ? (value.compareTo(val) = > 0) : (val.compareTo(value) > 0); + if( !correct_value ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns in= correct value, retrieved value: " + val + ", with parameter value: " + valu= e, filter, parameter); + } + cnt++; + } + if( cnt !=3D expected_count ){ + fail(ASSERTION_FAILED, "JDOQL Greater Than test returns wrong = number of instances, expected " + expected_count + ", got " + cnt, filter, = parameter); + } + query.close(query_result); + tx.rollback(); + } +} Propchange: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/query/op= erators/GreaterThan.java ---------------------------------------------------------------------------= --- svn:executable =3D *