pkcinna01 opened a new issue, #14605:
URL: https://github.com/apache/grails-core/issues/14605
This is being submitted as a bug because it should either report an error or
work. Instead it silently ignores the OrderByPath suffix
### Steps to Reproduce
1. Using a normal grails domain object with postgres 5.x, include both
Inlist and OrderBy
`def allLocations = Location.findAllByIdInListOrderByPath(locationArray)`
2. Enable show_sql in application.yml
```
hibernate:
...
show_sql: true
logSql: true
```
3. Check log output for 'order by' in generated SQL
### Expected Behaviour
Hibernate SQL should have an 'order by' clause or it should generate an
exception if invalid (not sure if OrderBy is supported for InList).
### Actual Behaviour
OrderBy is ignored
### Environment Information
- **Operating System**: Linux and Windows 7
- **Grails Version:** 3.2.9
compile 'org.grails.plugins:postgresql-extensions:5.0.0'
compile "org.grails.plugins:hibernate5"
compile "org.hibernate:hibernate-core:5.1.6.Final"
compile "org.hibernate:hibernate-ehcache:5.1.6.Final"
- **JDK Version:** 1.8
- **Container Version (If Applicable):** N/A
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
