Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-22061

(7.4.z) MSSQL2019 does not support literals in Group By statement

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • None
    • Hibernate
    • None
    • False
    • False
    • Undefined

    Description

      The org.hibernate.jpa.test.criteria.literal.CriteriaLiteralWithSingleQuoteTest.testLiteralProjectionAndGroupBy test case fails on Microsoft SQL 2019 with a SQLServerException:

      select
      ''' || aValue || ''' as col_0_0_ 
       from Students criteriali0_ 
      group by
      ''' || aValue || '''
      
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Each GROUP BY expression must contain at least one column that is not an outer reference.
      

      The test is skipped in a newer version of Hibernate ORM test suite, so I'm filing this JIRA as a known issue for current (5.3.20.Final) ORM test suite we are using.

      Attachments

        Activity

          People

            rhn-cservice-bbaranow Bartosz Baranowski
            szhantem@redhat.com Sultan Zhantemirov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: