[3.1.4 + Hibernate4] DetachedCriteria returning list of domains used as subquery causes invalid SQL with empty SELECT clause to be generated

[droggo]

Having domains:

class Parent {
    String name
    static hasMany = [children: Child]
}
class Child {
    String name
    Related related
    static belongsTo = [parent: Parent]
}

User could execute following query with detached criteria as subquery:

DetachedCriteria subquery = new DetachedCriteria(Child).build {
    isNotNull 'name'
}
Parent.createCriteria().list {
    inList 'children', subquery
} 

But this will cause Syntax error in SQL statement error with .. (SELECT FROM CHILD .. as cause of the error. SELECT is empty. Workaround is to use projection in detached criteria, for example

projections {
    groupProperty 'id'
}

Example project is here: https://github.com/droggo/GrailsSubqueries
Integration Spec to demo this problem: https://github.com/droggo/GrailsSubqueries/blob/master/src/integration-test/groovy/error/DetachedCriteriaDomainSubqueryIntegrationSpec.groovy

[jameskleeh]

Was pretty sure this was the same issue as #9931 but the test case is a little different so I'm not sure