[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4114) ASTParserLoadingTest fails due to missing "bit_length" function

[strong liu (JIRA)]

ASTParserLoadingTest fails due to missing "bit_length" function
---------------------------------------------------------------

                 Key: HHH-4114
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4114
             Project: Hibernate Core
          Issue Type: Bug
          Components: core
    Affects Versions: 3.5.0.Beta-1, 3.3.2, 3.5
         Environment: PostgreSQL 8.3.7 
            Reporter: strong liu
            Assignee: strong liu
            Priority: Minor
             Fix For: 3.3.x, 3.5, 3.3.2


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 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira