hibernate/hibernate-orm · error · IllegalQueryOperationException
Query has multiple items in the select list
Error message
Query has multiple items in the select list
What it means
Error "Query has multiple items in the select list" thrown in hibernate/hibernate-orm.
Source
Thrown at hibernate-core/src/main/java/org/hibernate/query/internal/KeyBasedPagination.java:52
public static <R> SqmSelectStatement<KeyedResult<R>> paginate(
List<Order<? super R>> keyDefinition, List<Comparable<?>> keyValues,
SqmSelectStatement<KeyedResult<R>> statement, NodeBuilder builder) {
final SqmQuerySpec<?> querySpec = statement.getQuerySpec();
final List<? extends JpaSelection<?>> items = querySpec.getSelectClause().getSelectionItems();
final JpaSelection<?> selected = switch ( items.size() ) {
case 0 -> {
final List<SqmRoot<?>> sqmRoots = querySpec.getRootList();
if ( sqmRoots == null || sqmRoots.isEmpty() ) {
throw new IllegalArgumentException( "Query did not define any query roots" );
}
if ( sqmRoots.size() != 1 ) {
throw new IllegalArgumentException( "Query has multiple query roots" );
}
yield sqmRoots.get( 0 );
}
case 1 -> items.get( 0 );
default -> throw new IllegalQueryOperationException("Query has multiple items in the select list");
};
if ( selected instanceof SqmFrom<?, ?> root ) {
statement.orderBy( keyDefinition.stream().map( order -> sortSpecification( statement, order ) )
.collect( toList() ) );
statement.select( keySelection( keyDefinition, root, selected, builder ) );
if ( keyValues != null ) {
final SqmPredicate restriction = keyRestriction( keyDefinition, keyValues, root, builder );
final SqmPredicate queryWhere = querySpec.getRestriction();
statement.where( queryWhere == null ? restriction : builder.and( queryWhere, restriction ) );
}
return statement;
}
else {
throw new IllegalQueryOperationException("Select item was not an entity type");
}
}
@SuppressWarnings({"rawtypes", "unchecked"})View on GitHub (pinned to fad1729dce)
Solutions
- Key-based pagination requires a single select item. Select only the paginated entity.
When it happens
Trigger: The query structure does not meet the single-root/single-select-item requirement: Query has multiple items in the select list
Common situations: Key-based pagination or Specifications applied to queries with zero/multiple roots or multi-item select lists.
AI-assisted analysis of hibernate/hibernate-orm@fad1729dce (2026-08-22).
Data as JSON: /api/errors/f527d7e974d283e7.
Report an issue: GitHub.