-
Notifications
You must be signed in to change notification settings - Fork 3.5k
/
SubQueryImplicitJoinReferenceTest.java
180 lines (151 loc) · 5.69 KB
/
SubQueryImplicitJoinReferenceTest.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
/*
* Hibernate, Relational Persistence for Idiomatic Java
*
* License: GNU Lesser General Public License (LGPL), version 2.1 or later.
* See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
*/
package org.hibernate.orm.test.query.sqm.exec;
import java.io.Serializable;
import java.util.Objects;
import javax.persistence.Embeddable;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.ManyToOne;
import org.junit.jupiter.api.Test;
import org.hibernate.testing.TestForIssue;
import org.hibernate.testing.orm.junit.DomainModel;
import org.hibernate.testing.orm.junit.SessionFactory;
import org.hibernate.testing.orm.junit.SessionFactoryScope;
/**
* Test that uses a subquery that makes an implicit join to a previously resolved implicit join in the
* outer query. This test verifies that the query succeeds when such a query is executed.
*
* @author Chris Cranford
*/
@DomainModel(annotatedClasses = {
SubQueryImplicitJoinReferenceTest.TheEntity.class,
SubQueryImplicitJoinReferenceTest.RevisionInfoEntity.class })
@SessionFactory
@TestForIssue(jiraKey = "HHH-14482")
public class SubQueryImplicitJoinReferenceTest {
@Test
public void performDataPreparation(SessionFactoryScope scope) {
// Simulate creating revision 1
final RevisionInfoEntity revEntity = new RevisionInfoEntity();
revEntity.setId( 1 );
// Simulate creating the audit record
final TheEntity entity = new TheEntity();
entity.setOriginalId( OriginalId.from( revEntity, 1 ) );
entity.setData( "Test" );
// Persist the entities
scope.inTransaction( session -> { session.save( revEntity ); session.save( entity ); } );
}
@Test
public void performHqlTest(SessionFactoryScope scope) {
// Now simulate running an audit query
scope.inSession( session -> {
session.createQuery( "select e__ FROM TheEntity e__ "
+ "WHERE e__.originalId.rev.id = (select max(e2__.originalId.rev.id) FROM "
+ "TheEntity e2__ WHERE " +
"e2__.originalId.rev.id <= 2 and e__.originalId.id = e2__.originalId.id)" ).list();
} );
}
@Test
public void performHqlIsNullTest(SessionFactoryScope scope) {
// Now simulate running an audit query
scope.inSession( session -> {
session.createQuery( "select e__ FROM TheEntity e__ "
+ "WHERE e__.originalId.rev.id = (select max(e2__.originalId.rev.id) FROM "
+ "TheEntity e2__ WHERE " +
"e2__.originalId.rev is null)" ).list();
} );
}
@Test
public void performHqlTest2(SessionFactoryScope scope) {
// Now simulate running an audit query
scope.inSession( session -> {
session.createQuery( "select e__ FROM TheEntity e__ "
+ "WHERE e__.originalId.id = (select max(e2__.originalId.id) FROM "
+ "TheEntity e2__ WHERE " +
"e__.originalId.id = e2__.originalId.id and e2__.originalId.rev.id <= 2)" ).list();
} );
}
@Test
public void performHqlTest3(SessionFactoryScope scope) {
// Now simulate running an audit query
scope.inSession( session -> {
session.createQuery( "select e2__.originalId.id, e2__.originalId.rev.id FROM "
+ "TheEntity e2__ WHERE " +
" e2__.originalId.rev.id <= 2" ).list();
} );
}
@Entity(name = "TheEntity")
public static class TheEntity {
@EmbeddedId
private OriginalId originalId;
private String data;
public OriginalId getOriginalId() {
return originalId;
}
public void setOriginalId(OriginalId originalId) {
this.originalId = originalId;
}
public String getData() {
return data;
}
public void setData(String data) {
this.data = data;
}
}
@Entity(name="RevisionInfoEntity")
public static class RevisionInfoEntity {
@Id
private Integer id;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
}
@Embeddable
public static class OriginalId implements Serializable {
@ManyToOne
private RevisionInfoEntity rev;
private Integer id;
public RevisionInfoEntity getRev() {
return rev;
}
public void setRev(RevisionInfoEntity rev) {
this.rev = rev;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public static OriginalId from(RevisionInfoEntity rev, Integer id) {
OriginalId oId = new OriginalId();
oId.rev = rev;
oId.id = id;
return oId;
}
@Override
public int hashCode() {
return Objects.hash(rev, id);
}
@Override
public boolean equals(Object obj) {
if ( obj == null ) {
return false;
}
if ( obj.getClass() != this.getClass() ) {
return false;
}
final OriginalId other = (OriginalId) obj;
return Objects.equals( rev, other.rev ) && Objects.equals( id, other.id );
}
}
}