Criteria Spec

CriteriaIntegrationSpec.groovy

class CriteriaIntegrationSpec extends IntegrationSpec {
    void "Nested criteria property ordering should ignoreCase properly"() {
        given: 'A parent class and its child classes'
            Parent parent = new Parent().save()
            Child child1 = new Child(age: 100, name: 'Apollo', parent: parent).save()
            Child child2 = new Child(age: 200, name: 'Zeus', parent: parent).save()
            Child child3 = new Child(age: 300, name: 'athena', parent: parent).save()

        when: 'a criteria call is ordered by a String property'
            List names = Parent.createCriteria().list() {
                children {
                    eq('parent', parent)
                    gt('age', 50)

                    projections {
                        property('name')
                    }

                    order('name')
                }
            }

        then: 'it does not sort case-insensitively by default'
            assert names == [ 'Apollo', 'Zeus', 'athena' ]
    }
}