2 Copyright 2010 Sun Microsystems, Inc.
3 All rights reserved. Use is subject to license terms.
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.
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.
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
19 package testsuite.clusterj.model;
21 import com.mysql.clusterj.annotation.Column;
22 import com.mysql.clusterj.annotation.Index;
23 import com.mysql.clusterj.annotation.PersistenceCapable;
24 import com.mysql.clusterj.annotation.PrimaryKey;
28 drop table if exists doubletypes;
29 create table doubletypes (
30 id int not null primary key,
32 double_null_hash double,
33 double_null_btree double,
34 double_null_both double,
35 double_null_none double,
37 double_not_null_hash double,
38 double_not_null_btree double,
39 double_not_null_both double,
40 double_not_null_none double
42 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
44 create unique index idx_double_null_hash using hash on doubletypes(double_null_hash);
45 create index idx_double_null_btree on doubletypes(double_null_btree);
46 create unique index idx_double_null_both on doubletypes(double_null_both);
48 create unique index idx_double_not_null_hash using hash on doubletypes(double_not_null_hash);
49 create index idx_double_not_null_btree on doubletypes(double_not_null_btree);
50 create unique index idx_double_not_null_both on doubletypes(double_not_null_both);
54 // @Index(name="idx_double_null_both", columns=@Column(name="double_null_both")),
55 // @Index(name="idx_double_not_null_both", columns=@Column(name="double_not_null_both"))
57 /** Double types allow hash indexes to be defined but ndb-bindings
58 * do not allow an equal lookup, so they are not used.
59 * If hash indexes are supported in future, uncomment the @Index annotations.
61 @PersistenceCapable(table="doubletypes")
62 @PrimaryKey(column="id")
63 public interface DoubleTypes extends IdBase {
69 @Column(name="double_null_hash")
70 // @Index(name="idx_double_null_hash")
71 Double getDouble_null_hash();
72 void setDouble_null_hash(Double value);
74 @Column(name="double_null_btree")
75 @Index(name="idx_double_null_btree")
76 Double getDouble_null_btree();
77 void setDouble_null_btree(Double value);
79 @Column(name="double_null_both")
80 Double getDouble_null_both();
81 void setDouble_null_both(Double value);
83 @Column(name="double_null_none")
84 Double getDouble_null_none();
85 void setDouble_null_none(Double value);
87 @Column(name="double_not_null_hash")
88 // @Index(name="idx_double_not_null_hash")
89 double getDouble_not_null_hash();
90 void setDouble_not_null_hash(double value);
92 @Column(name="double_not_null_btree")
93 @Index(name="idx_double_not_null_btree")
94 double getDouble_not_null_btree();
95 void setDouble_not_null_btree(double value);
97 @Column(name="double_not_null_both")
98 double getDouble_not_null_both();
99 void setDouble_not_null_both(double value);
101 @Column(name="double_not_null_none")
102 double getDouble_not_null_none();
103 void setDouble_not_null_none(double value);