MySQL 5.6.14 Source Code Document
|
Public Member Functions | |
Class | getInstanceType () |
void | test () |
void | btreeIndexScanDouble () |
void | hashIndexScanDouble () |
void | bothIndexScanDouble () |
void | noneIndexScanDouble () |
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) |
Static Public Member Functions | |
static String | toString (IdBase idBase) |
Protected Member Functions | |
Double | getDouble (int number) |
void | printResultInstance (IdBase instance) |
Protected Member Functions inherited from testsuite.clusterj.AbstractQueryTest | |
int | getNumberOfInstances () |
void | setAutotransaction (boolean b) |
Protected Member Functions inherited from testsuite.clusterj.AbstractClusterJModelTest | |
boolean | getCleanupAfterTest () |
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) |
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 () |
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() |
Definition at line 23 of file QueryDoubleTypesTest.java.
|
inlinevirtual |
Return the type of instances used for the queries.
Implements testsuite.clusterj.AbstractQueryTest.
Definition at line 26 of file QueryDoubleTypesTest.java.
|
inlineprotected |
Print the results of a query for debugging.
instance | the instance to print |
Reimplemented from testsuite.clusterj.AbstractQueryTest.
Definition at line 189 of file QueryDoubleTypesTest.java.
|
inline |
Test all single- and double-predicate queries using DoubleTypes.
drop table if exists doubletypes; create table doubletypes ( id int not null primary key,
double_null_hash double(10,5), double_null_btree double(10,5), double_null_both double(10,5), double_null_none double(10,5)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
create unique index idx_double_null_hash using hash on doubletypes(double_null_hash); create index idx_double_null_btree on doubletypes(double_null_btree); create unique index idx_double_null_both on doubletypes(double_null_both); Double types allow hash indexes to be defined but ndb-bindings do not allow an equal lookup, so they are not used. If hash indexes are supported in future, uncomment the test case methods.
Definition at line 57 of file QueryDoubleTypesTest.java.