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

(7.4.z) HHH-14669 - CriteriaLiteralWithSingleQuoteTest: SAP ASE16.0 does not support grouping by column heading or alias

XMLWordPrintable

      This is a clone of https://hibernate.atlassian.net/browse/HHH-14669

      Running org.hibernate.jpa.test.criteria.literal.CriteriaLiteralWithSingleQuoteTest.testLiteralProjectionAndGroupBy on

      SAP ASE16.0 results in an exception:

      select
      ''' || aValue || ''' as col_0_0_ 
      from
      Students criteriali0_ 
      group by
      ''' || aValue || '''
      com.sybase.jdbc4.jdbc.SybSQLException: GROUP BY expressions must refer to column names
      

      According to documentation we can not group by column heading or alias.

      Perhaps an SkipForDialect annotation could be added.

      Environment:

      oracle-java-1.8

      jconn4.jar - jConnect (TM) for JDBC(TM)/16.0 GA (Build 27008)

      hibernate.dialect org.hibernate.dialect.SybaseASE157Dialect
      hibernate.connection.driver_class com.sybase.jdbc4.jdbc.SybDriver
      hibernate.connection.url jdbc:sybase:Tds:\${db.hostname}:5000/\${db.username}?SQLINITSTRING=set quoted_identifier on&SQLINITSTRING=set ANSINULL on
      hibernate.connection.username \${db.username}
      hibernate.connection.password \${db.password}
      hibernate.jdbc.use_streams_for_binary false
      hibernate.hbm2ddl.jdbc_metadata_extraction_strategy=individually

              lvydra Lukas Vydra
              szhantem@redhat.com Sultan Zhantemirov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: