Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-2715

Core - ASTParserLoadingTest fails due to missing "bit_length" function

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • EAP 5.0.0, 4.2.0.GA_CP08, 4.3.0.GA_CP07
    • 4.2.0.GA_CP07, 4.3.0.GA_CP06, EAP 5.0.0.CR3
    • Hibernate
    • None

    • PostgreSQL 8.3.7

    • Workaround Exists
    • Hide

      Use an explicit cast instead
      from Animal a where bit_length(str(a.bodyWeight)) = 24 or from Animal a where bit_length(cast(a.bodyWeight as string)) = 24

      Show
      Use an explicit cast instead from Animal a where bit_length(str(a.bodyWeight)) = 24 or from Animal a where bit_length(cast(a.bodyWeight as string)) = 24

    Description

      Test testEJBQLFunctions fails when executing the following query on PostgreSQL:
      from Animal a where bit_length(a.bodyWeight) = 24

      Similar to JBPAPP-1036, but our target at that time was PostgreSQL 8.2.3 (on which, the test passes with no problems).

      Log excerpt:
      12:49:28,109 WARN JDBCExceptionReporter:100 - SQL Error: 0, SQLState: 42883
      12:49:28,110 ERROR JDBCExceptionReporter:101 - ERROR: function bit_length(real) does not exist

      http://opensource.atlassian.com/projects/hibernate/browse/HHH-4114

      Attachments

        Activity

          People

            shaozliu Strong Liu(刘少壮) (Inactive)
            jpkroehling@redhat.com Juraci Paixão Kröhling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: