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

Public Member Functions

Class<?> getInstanceType ()
void testInAndBetween ()
void testBetweenAndIn ()
void testPartialBoundsAndEqual ()
void testGapBoundsAndEqual ()
void testNegativeInParameter ()
void testPrettyBigIn ()
void testNegativeInTooBig ()
- 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)

Protected Member Functions

boolean getCleanupAfterTest ()
void createInstances (int number)
LongIntStringIndex createInstance (int index)
long getPK1 (int index)
int getPK2 (int index)
String getPK3 (int index)
String getValue (int index)
String toString (LongIntStringIndex instance)
- Protected Member Functions inherited from testsuite.clusterj.AbstractQueryTest
int getNumberOfInstances ()
void setAutotransaction (boolean b)
void printResultInstance (IdBase instance)
- Protected Member Functions inherited from testsuite.clusterj.AbstractClusterJModelTest
void setAutoCommit (Connection connection, boolean b)
void createEmployeeInstances (int count)
void consistencyCheck (Employee emp)
void createDn2idInstances (int number)
void consistencyCheck (Dn2id dn2id)
List< Object[]> getExpected ()
String getTableName ()
ColumnDescriptor[] getColumnDescriptors ()
Object getColumnValue (int i, int j)
void writeJDBCreadNDB ()
void writeJDBCreadJDBC ()
void writeNDBreadNDB ()
void writeNDBreadJDBC ()
void queryAndVerifyResults (String where, ColumnDescriptor[] columnDescriptors, String conditions, Object[] parameters, int...objectIds)
List< Object[]> queryJDBC (ColumnDescriptor[] columnDescriptors, String conditions, Object[] parameters)
void verifyQueryResults (String where, List< Object[]> results, int...objectIds)
void verify (String where, List< Object[]> expecteds, List< Object[]> actuals)
void generateInstances (ColumnDescriptor[] columnDescriptors)
IdBase getNewInstance (Class<?extends IdBase > modelClass)
void writeToJDBC (ColumnDescriptor[] columnDescriptors, List< IdBase > instances)
void writeToNDB (ColumnDescriptor[] columnDescriptors, List< IdBase > instances)
List< Object[]> readFromNDB (ColumnDescriptor[] columnDescriptors)
List< Object[]> readFromJDBC (ColumnDescriptor[] columnDescriptors)
String getA1for (int number, int index)
String getA3for (long i)
void createAllPrimitivesInstances (int number)
void createAllPrimitivesInstances (Session session, int number)
AllPrimitives createAllPrimitiveInstance (Session session, int i)
void initialize (AllPrimitives instance, int i)
- Protected Member Functions inherited from testsuite.clusterj.AbstractClusterJTest
boolean getDebug ()
void addTearDownClasses (Class<?>...classes)
void createSessionFactory ()
Properties modifyProperties ()
void dumpSystemProperties ()
void error (String message)
void error (String context, Exception ex)
void errorIfNotEqual (String message, Object expected, Object actual)
void errorIfNotEqual (String message, int[] expected, int[] actual)
void errorIfEqual (String message, Object expected, Object actual)
void failOnError ()
void closeConnection ()
void getConnection (Properties extraProperties)
Connection getConnection ()
void getConnection (String propertiesFileName)
void loadDriver ()
void initializeErrorMessages ()
void initializeJDBC ()
void initializeSchema ()
void loadProperties ()
void loadProperties (String propsFileName)
void loadSchema ()
void loadSchemaDefinition ()
void localTearDown ()
final void setUp () throws Exception
final void tearDown () throws Exception
void removeAll (Class<?> cls)
boolean testSchema ()
boolean resetSchema ()
String dump (List< String > list)

Protected Attributes

int PK_MODULUS = 3
long PRETTY_BIG_NUMBER = 1000000000000000L
- Protected Attributes inherited from testsuite.clusterj.AbstractQueryTest
QueryHolder holder
- Protected Attributes inherited from testsuite.clusterj.AbstractClusterJModelTest
List< Employee > employees
List< Dn2id > dn2ids
List< IdBase > instances = new ArrayList<IdBase>()
ClassLoader loader
- Protected Attributes inherited from testsuite.clusterj.AbstractClusterJTest
Session session
SessionFactory sessionFactory
Transaction tx
boolean debug

Additional Inherited Members

- 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 ()
- 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 columns compared via IN. Predicates using IN cannot use indexes, although indexes can be used for AND predicates where some of the predicates are IN predicates. This test is based on AbstractQueryTest.

Definition at line 32 of file QueryMultiColumnIndexInTest.java.

Member Function Documentation

LongIntStringIndex testsuite.clusterj.QueryMultiColumnIndexInTest.createInstance ( int  index)
inlineprotected

Create an instance of LongIntStringPK.

Parameters
indexthe index to use to generate data
Returns
the instance

Definition at line 155 of file QueryMultiColumnIndexInTest.java.

void testsuite.clusterj.QueryMultiColumnIndexInTest.createInstances ( int  number)
inlineprotectedvirtual

The strategy for instances is for the "instance number" to create the three keys, such that the value of the instance is: pk1 * PK_MODULUS^2 + pk2 * PK_MODULUS + pk3

Implements testsuite.clusterj.AbstractQueryTest.

Definition at line 143 of file QueryMultiColumnIndexInTest.java.

Class<?> testsuite.clusterj.QueryMultiColumnIndexInTest.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 48 of file QueryMultiColumnIndexInTest.java.

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