HHH-13619 - Support for JPA's size function as a select expression

gbadner · gbadner · commit 8c6f8025e32f · 2020-03-12T14:42:11.000-07:00
- Fix to work on Oracle by removing "as" between table name and alias
diff --git a/hibernate-core/src/main/java/org/hibernate/hql/internal/ast/tree/CollectionSizeNode.java b/hibernate-core/src/main/java/org/hibernate/hql/internal/ast/tree/CollectionSizeNode.java
@@ -74,7 +74,7 @@ public String toSqlExpression() {
 		final String sizeColumn = sizeColumns[0];
 
 		final StringBuilder buffer = new StringBuilder( "(select " ).append( sizeColumn );
-		buffer.append( " from " ).append( collectionDescriptor.getTableName() ).append( " as " ).append( collectionTableAlias );
+		buffer.append( " from " ).append( collectionDescriptor.getTableName() ).append( " " ).append( collectionTableAlias );
 		buffer.append( " where " );
 
 		boolean firstPass = true;
