Fix test failing on MariaDB

vladmihalcea · vladmihalcea · commit e2e48e4e0785 · 2017-05-18T10:19:09.000+03:00
diff --git a/documentation/src/test/java/org/hibernate/userguide/mapping/basic/SubselectTest.java b/documentation/src/test/java/org/hibernate/userguide/mapping/basic/SubselectTest.java
@@ -235,12 +235,12 @@ public void setDescription(String description) {
 	@Subselect(
 		"select " +
 		"	a.id as id, " +
-		"	c.first_name||' '||c.last_name as clientName, " +
+		"	concat(concat(c.first_name, ' '), c.last_name) as clientName, " +
 		"	sum(at.cents) as balance " +
 		"from account a " +
 		"join client c on c.id = a.client_id " +
 		"join account_transaction at on a.id = at.account_id " +
-		"group by a.id, c.first_name||' '||c.last_name"
+		"group by a.id, concat(concat(c.first_name, ' '), c.last_name)"
 	)
 	@Synchronize( {"client", "account", "account_transaction"} )
 	public static class AccountSummary {
