MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
QueryHashIndexScanTest.java
1 /*
2  Copyright 2010 Sun Microsystems, Inc.
3  All rights reserved. Use is subject to license terms.
4 
5  This program is free software; you can redistribute it and/or modify
6  it under the terms of the GNU General Public License as published by
7  the Free Software Foundation; version 2 of the License.
8 
9  This program is distributed in the hope that it will be useful,
10  but WITHOUT ANY WARRANTY; without even the implied warranty of
11  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12  GNU General Public License for more details.
13 
14  You should have received a copy of the GNU General Public License
15  along with this program; if not, write to the Free Software
16  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
17 */
18 
19 package testsuite.clusterj;
20 
21 import testsuite.clusterj.model.Employee;
22 
24 
25  @Override
26  public Class getInstanceType() {
27  return Employee.class;
28  }
29 
30  @Override
31  void createInstances(int number) {
32  createEmployeeInstances(10);
33  instances.addAll(employees);
34  }
35 
40  public void testHashIndexScan() {
41  equalQuery("magic", "idx_unique_hash_magic", 8, 8);
42  greaterEqualQuery("magic", "none", 7, 7, 8, 9);
43  greaterThanQuery("magic", "none", 6, 7, 8, 9);
44  lessEqualQuery("magic", "none", 4, 4, 3, 2, 1, 0);
45  lessThanQuery("magic", "none", 4, 3, 2, 1, 0);
46  betweenQuery("magic", "none", 4, 6, 4, 5, 6);
47  greaterEqualAndLessEqualQuery("magic", "none", 4, 6, 4, 5, 6);
48  greaterThanAndLessEqualQuery("magic", "none", 4, 6, 5, 6);
49  greaterEqualAndLessThanQuery("magic", "none", 4, 6, 4, 5);
50  greaterThanAndLessThanQuery("magic", "none", 4, 6, 5);
51 
52  failOnError();
53  }
54 
55 }