The GitHub Actions job "CodeQL" on grails-core.git/feat/hibernate7-sql-projection has succeeded. Run started by GitHub user jdaugherty (triggered by jdaugherty).
Head commit for run: dcd19bc8a0962201b69f3ba2daca70df793c988b / James Daugherty <[email protected]> Match backquoted and bracketed group by aliases regardless of case A name in the group by clause of a sqlGroupProjection resolves to the SQL projection with that column alias. Every quoted name was matched case sensitively, but only double quotes make an identifier case sensitive: MySQL and MariaDB compare column aliases case insensitively even in backquotes, and SQL Server brackets follow its case-insensitive default collation. A group by clause such as `BOXWIDTH` for the alias boxWidth was therefore rendered as is and failed with "Unknown column", although the same native query succeeds. Only a double-quoted name is now matched case sensitively. Add SqlProjectionHibernate7Spec, which runs the documented projections, grouping by column aliases, {alias} with a join, the DSL type constants and declared Hibernate types on H2, PostgreSQL, MySQL, MariaDB and Oracle, as SqlRestrictionHibernate7Spec does for sqlRestriction. 8.0.0 has been released, so the new classes are @since 8.0.1. Report URL: https://github.com/apache/grails-core/actions/runs/37861326417 With regards, GitHub Actions via GitBox
