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 floattypes;
29 create table floattypes (
30 id int not null primary key,
32 float_null_hash float,
33 float_null_btree float,
34 float_null_both float,
35 float_null_none float,
37 float_not_null_hash float,
38 float_not_null_btree float,
39 float_not_null_both float,
40 float_not_null_none float
42 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
44 create unique index idx_float_null_hash using hash on floattypes(float_null_hash);
45 create index idx_float_null_btree on floattypes(float_null_btree);
46 create unique index idx_float_null_both on floattypes(float_null_both);
48 create unique index idx_float_not_null_hash using hash on floattypes(float_not_null_hash);
49 create index idx_float_not_null_btree on floattypes(float_not_null_btree);
50 create unique index idx_float_not_null_both on floattypes(float_not_null_both);
54 // @Index(name="idx_float_null_both", columns=@Column(name="float_null_both")),
55 // @Index(name="idx_float_not_null_both", columns=@Column(name="float_not_null_both"))
57 /** Float 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="floattypes")
62 @PrimaryKey(column="id")
63 public interface FloatTypes extends IdBase {
69 @Column(name="float_null_hash")
70 /// @Index(name="idx_float_null_hash")
71 Float getFloat_null_hash();
72 void setFloat_null_hash(Float value);
74 @Column(name="float_null_btree")
75 @Index(name="idx_float_null_btree")
76 Float getFloat_null_btree();
77 void setFloat_null_btree(Float value);
79 @Column(name="float_null_both")
80 Float getFloat_null_both();
81 void setFloat_null_both(Float value);
83 @Column(name="float_null_none")
84 Float getFloat_null_none();
85 void setFloat_null_none(Float value);
87 @Column(name="float_not_null_hash")
88 // @Index(name="idx_float_not_null_hash")
89 float getFloat_not_null_hash();
90 void setFloat_not_null_hash(float value);
92 @Column(name="float_not_null_btree")
93 @Index(name="idx_float_not_null_btree")
94 float getFloat_not_null_btree();
95 void setFloat_not_null_btree(float value);
97 @Column(name="float_not_null_both")
98 float getFloat_not_null_both();
99 void setFloat_not_null_both(float value);
101 @Column(name="float_not_null_none")
102 float getFloat_not_null_none();
103 void setFloat_not_null_none(float value);