Criteria subquery = new Criteria();
subquery.addSelectColumn(new ColumnImpl("count(*)"));
subquery.where(BookPeer.AUTHOR_ID, AuthorPeer.AUTHOR_ID);
subquery.and(BookPeer.TITLE, book3.getTitle());
subquery.addFrom(BookPeer.TABLE_NAME);
Criteria criteria = new Criteria();
criteria.where(subquery, 1);
List<?> result = AuthorPeer.doSelect(criteria);
assertEquals("Expected result of size 1 but got " + result.size(),