MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
Public Member Functions | List of all members
testsuite.clusterj.QueryExtraConditionsTest Class Reference
Inheritance diagram for testsuite.clusterj.QueryExtraConditionsTest:
Inheritance graph
[legend]
Collaboration diagram for testsuite.clusterj.QueryExtraConditionsTest:
Collaboration graph
[legend]

Public Member Functions

Class<?> getInstanceType ()
void testExtraEqual ()
void testExtraBetween ()
- Public Member Functions inherited from testsuite.clusterj.AbstractQueryTest
void localSetUp ()
void equalQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void likeQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void deleteEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int expected)
void equalOrEqualQuery (String propertyName, Object parameterValue1, String extraPropertyName, Object parameterValue2, String expectedIndex, int...expected)
void equalOrInQuery (String propertyName, Object parameterValue1, String extraPropertyName, Object parameterValue2, String expectedIndex, int...expected)
void inQuery (String propertyName, Object parameterValue1, String expectedIndex, int...expected)
void inAndInQuery (String propertyName, Object parameterValue1, String extraPropertyName, Object parameterValue2, String expectedIndex, int...expected)
void inAndBetweenQuery (String propertyName, Object parameterValue1, String extraPropertyName, Object parameterValue2, Object parameterValue3, String expectedIndex, int...expected)
void betweenAndInQuery (String propertyName, Object parameterValue1, Object parameterValue2, String extraPropertyName, Object parameterValue3, String expectedIndex, int...expected)
void greaterThanQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void greaterEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void lessThanQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void lessEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void betweenQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterThanAndLessThanQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterThanAndLikeQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void deleteGreaterThanAndLessThanQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int expected)
void greaterEqualAndLessThanQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterThanAndLessEqualQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterEqualAndLessEqualQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterEqualAndLikeQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void equalAnd1ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue, String expectedIndex, int...expected)
void greaterThanAnd1ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue, String expectedIndex, int...expected)
void greaterEqualAnd1ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue, String expectedIndex, int...expected)
void lessThanAnd1ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue, String expectedIndex, int...expected)
void lessEqualAnd1ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue, String expectedIndex, int...expected)
void equalAnd2ExtraQuery (String propertyName, Object parameterValue, String extraPropertyName, PredicateProvider extraPredicateProvider, Object extraParameterValue1, Object extraParameterValue2, String expectedIndex, int...expected)
void notEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notNotEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notNotNotEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notGreaterThanQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notGreaterEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notLessThanQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notLessEqualQuery (String propertyName, String expectedIndex, Object parameterValue, int...expected)
void notBetweenQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterThanAndNotGreaterThanQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterEqualAndNotGreaterThanQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterThanAndNotGreaterEqualQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)
void greaterEqualAndNotGreaterEqualQuery (String propertyName, String expectedIndex, Object parameterLowerValue, Object parameterUpperValue, int...expected)

Additional Inherited Members

- Protected Member Functions inherited from testsuite.clusterj.AbstractQueryTest
int getNumberOfInstances ()
void setAutotransaction (boolean b)
void printResultInstance (IdBase instance)
- Static Protected Member Functions inherited from testsuite.clusterj.AbstractClusterJModelTest
static long getMillisFor (int year, int month, int day, int hour, int minute, int second)
static long getMillisFor (int year, int month, int day)
static long getMillisFor (int days, int hour, int minute, int second)
static void resetLocalSystemDefaultTimeZone (Connection connection)
static Object[] setupDn2idPK ()
- Protected Attributes inherited from testsuite.clusterj.AbstractQueryTest
QueryHolder holder
- Static Protected Attributes inherited from testsuite.clusterj.AbstractClusterJModelTest
static TimeZone localSystemTimeZone = TimeZone.getDefault()
static final long ONE_SECOND = 1000L
static final long ONE_MINUTE = 1000L * 60L
static final long ONE_HOUR = 1000L * 60L * 60L
static final long TEN_HOURS = 1000L * 60L * 60L * 10L
static final long ONE_DAY = 1000L * 60L * 60L * 24L
static Object[] dn2idPK = setupDn2idPK()

Detailed Description

Query for conditions beyond index values. Additional conditions are represented by multiple predicates joined via AND and OR. This test is based on QueryAllPrimitivesTest.

Definition at line 29 of file QueryExtraConditionsTest.java.

Member Function Documentation

Class<?> testsuite.clusterj.QueryExtraConditionsTest.getInstanceType ( )
inlinevirtual

Return the type of instances used for the queries.

Returns
the type of instances for the test

Implements testsuite.clusterj.AbstractQueryTest.

Definition at line 32 of file QueryExtraConditionsTest.java.

void testsuite.clusterj.QueryExtraConditionsTest.testExtraEqual ( )
inline 
    Test queries with extra conditions using AllPrimitives.

drop table if exists allprimitives; create table allprimitives ( id int not null primary key,

int_not_null_hash int not null, int_not_null_btree int not null, int_not_null_both int not null, int_not_null_none int not null, int_null_hash int, int_null_btree int, int_null_both int, int_null_none int,

byte_not_null_hash tinyint not null, byte_not_null_btree tinyint not null, byte_not_null_both tinyint not null, byte_not_null_none tinyint not null, byte_null_hash tinyint, byte_null_btree tinyint, byte_null_both tinyint, byte_null_none tinyint,

short_not_null_hash smallint not null, short_not_null_btree smallint not null, short_not_null_both smallint not null, short_not_null_none smallint not null, short_null_hash smallint, short_null_btree smallint, short_null_both smallint, short_null_none smallint,

long_not_null_hash bigint not null, long_not_null_btree bigint not null, long_not_null_both bigint not null, long_not_null_none bigint not null, long_null_hash bigint, long_null_btree bigint, long_null_both bigint, long_null_none bigint

Definition at line 82 of file QueryExtraConditionsTest.java.

The documentation for this class was generated from the following file: