thjanssen · January 17, 2017 15:29
diff --git a/ComparisonExpression.java b/ComparisonExpression.java
 SELECT a FROM Author a WHERE a.firstName like ‘%and%’ and a.id >= 20 and size(author.books) >= 5
diff --git a/ConstructorProjection.java b/ConstructorProjection.java
 SELECT new org.thoughts.on.java.model.AuthorValue(a.id, a.firstName, a.lastName) FROM Author a
diff --git a/Distinct.java b/Distinct.java
 SELECT DISTINCT a.lastName FROM Author a
diff --git a/Downcasting.java b/Downcasting.java
 SELECT a, p FROM Author a JOIN treat (a.publications AS Book) p
diff --git a/EntityProjection.java b/EntityProjection.java
 SELECT a FROM Author a
diff --git a/From.java b/From.java
 SELECT a FROM Author a
diff --git a/GroupBy.java b/GroupBy.java
 SELECT a.lastName, COUNT(a) FROM Author a GROUP BY a.lastName
diff --git a/Having.java b/Having.java
 SELECT a.lastName, COUNT(a) AS cnt FROM Author a GROUP BY a.lastName HAVING a.lastName LIKE ‘B%’
diff --git a/InnerJoin.java b/InnerJoin.java
 SELECT a, b FROM Author a JOIN a.books b
diff --git a/JoinCondition.java b/JoinCondition.java
 SELECT a, p FROM Author a JOIN a.publications p ON p.publishingDate > ?1
diff --git a/LeftOuterJoins.java b/LeftOuterJoins.java
 SELECT a, b FROM Author a LEFT JOIN a.books b
diff --git a/OrderBy.java b/OrderBy.java
 SELECT a FROM Author a ORDER BY a.lastName ASC, a.firstName DESC
diff --git a/PathExpressions.java b/PathExpressions.java
 SELECT b FROM Book b WHERE b.publisher.name LIKE ‘%es%
diff --git a/Polymorphism.java b/Polymorphism.java
 SELECT p FROM Publication p
diff --git a/PolymorphismSubtype.java b/PolymorphismSubtype.java
 SELECT b FROM BlogPost b
diff --git a/ScalarValueProjection.java b/ScalarValueProjection.java
 SELECT a.firstName, a.lastName FROM Author a
diff --git a/Subselect.java b/Subselect.java
 SELECT a FROM Author a WHERE (SELECT count(b) FROM Book b WHERE a MEMBER OF b.authors ) > 1
diff --git a/ThetaJoin.java b/ThetaJoin.java
 SELECT b, p FROM Book b, Publisher p WHERE b.fk_publisher = p.id