/*
 * 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.test.pagination;

import java.io.Serializable;
import java.util.List;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Query;

import org.hibernate.jpa.test.BaseEntityManagerFunctionalTestCase;
import org.junit.Test;

import org.hibernate.testing.TestForIssue;

import static org.hibernate.testing.transaction.TransactionUtil.doInJPA;
import static org.junit.Assert.assertEquals;

/**
 * @author Chris Cranford
 */
@TestForIssue(jiraKey = "HHH-11642")
public class SQLServerFailureTest extends BaseEntityManagerFunctionalTestCase {
	@Override
	protected Class<?>[] getAnnotatedClasses() {
		return new Class<?>[] { SimpleEntity.class };
	}

	@Test
	public void doTest() {
		doInJPA( this::entityManagerFactory, entityManager -> {
			for ( int i = 1; i <= 100; ++i ) {
				final SimpleEntity entity = new SimpleEntity( i, "Enitty" + i );
				entityManager.persist( entity );
			}
		} );

		doInJPA( this::entityManagerFactory, entityManager -> {
			Query query = entityManager.createQuery( "SELECT o FROM SimpleEntity o WHERE o.id >= :firstId" );
			query.setParameter( "firstId", 10 );
			query.setMaxResults( 50 );
			List results = query.getResultList();
			assertEquals( 50, results.size() );
		} );
	}

	@Entity(name = "SimpleEntity")
	public static class SimpleEntity implements Serializable {
		@Id
		private Integer id;
		private String name;

		SimpleEntity() {}

		SimpleEntity(Integer id, String name) {
			this.id = id;
			this.name = name;
		}

		public Integer getId() {
			return id;
		}

		public void setId(Integer id) {
			this.id = id;
		}

		public String getName() {
			return name;
		}

		public void setName(String name) {
			this.name = name;
		}
	}
}