@DomainModel(
		annotatedClasses = { FetchModeSubselectTest.User.class, FetchModeSubselectTest.Role.class }
)
@SessionFactory
@TestForIssue(jiraKey = "HHH-15453")
public class FetchModeSubselectTest {

	@BeforeEach
	public void setUp(SessionFactoryScope scope) {
		scope.inTransaction(
				session -> {
					User user = new User();
					user.setUserId( 1 );
					user.setUserName( "Ann" );

					User user2 = new User();
					user2.setUserId( 2 );
					user2.setUserName( "Bob" );

					Role manager = new Role();
					manager.setRoleId( 1 );
					manager.setRoleName( "manager" );

					Role developer = new Role();
					developer.setRoleId( 2 );
					developer.setRoleName( "developer" );

					session.persist( user );
					session.persist( user2 );

					session.persist( manager );
					session.persist( developer );

					user.addRole( manager );
				}
		);
	}

	@Test
	public void testSelect(SessionFactoryScope scope) {
		scope.inSession(
				session -> {
					List<User> userList = session.createQuery( "FROM User WHERE userId = 2", User.class ).list();
					assertThat( userList.size() ).isEqualTo( 1 );
					assertThat( userList.get( 0 ).getRoles().size() ).isEqualTo( 0 );
				}
		);
	}

	@Entity(name = "User")
	@Table(name = "USER_TABLE")
	public static class User {

		private Integer userId = null;
		private String userName = null;
		private Set<Role> roles = null;

		@Id
		@Column(name = "USER_ID")
		public Integer getUserId() {
			return userId;
		}

		public void setUserId(Integer userId) {
			this.userId = userId;
		}

		@Column(name = "USER_NAME")
		public String getUserName() {
			return userName;
		}

		public void setUserName(String userName) {
			this.userName = userName;
		}

		@ManyToMany(cascade = CascadeType.PERSIST, fetch = FetchType.EAGER)
		@JoinTable(
				name = "USER_ROLE",
				joinColumns = @JoinColumn(name = "USER_ID"),
				inverseJoinColumns = @JoinColumn(name = "ROLE_ID"))
		@Fetch(FetchMode.SUBSELECT)
		public Set<Role> getRoles() {
			return roles;
		}

		public void setRoles(Set<Role> roles) {
			this.roles = roles;
		}

		public void addRole(Role role) {
			if ( roles == null ) {
				roles = new HashSet<>();
			}
			roles.add( role );
		}

		@Override
		public boolean equals(Object o) {
			if ( this == o ) {
				return true;
			}
			if ( o == null || getClass() != o.getClass() ) {
				return false;
			}
			User user = (User) o;
			return Objects.equals( userId, user.userId ) && Objects.equals(
					userName,
					user.userName
			) && Objects.equals( roles, user.roles );
		}

		@Override
		public int hashCode() {
			return Objects.hash( userId, userName, roles );
		}
	}

	@Entity(name = "Role")
	@Table(name = "ROLE_TABLE")
	public static class Role {

		private Integer roleId = null;
		private String roleName = null;

		@Id
		@Column(name = "ROLE_ID")
		public Integer getRoleId() {
			return roleId;
		}

		public void setRoleId(Integer roleId) {
			this.roleId = roleId;
		}

		@Column(name = "ROLE_NAME")
		public String getRoleName() {
			return roleName;
		}

		public void setRoleName(String roleName) {
			this.roleName = roleName;
		}

		@Override
		public boolean equals(Object o) {
			if ( this == o ) {
				return true;
			}
			if ( o == null || getClass() != o.getClass() ) {
				return false;
			}
			Role role = (Role) o;
			return Objects.equals( roleId, role.roleId ) && Objects.equals(
					roleName,
					role.roleName
			);
		}

		@Override
		public int hashCode() {
			return Objects.hash( roleId, roleName );
		}
	}
}