PostgreSQLDialect: function md5() always returns a string value

Description

The md5() function always returns a string type and not the type given as parameter.
Therefore the line

registerFunction( "md5", new StandardSQLFunction("md5") );

has to be changed to

registerFunction( "md5", new StandardSQLFunction("md5", Hibernate.STRING) );

in class org.hibernate.dialect.PostgreSQLDialect

Environment

None

Status

Assignee

Brett Meyer

Reporter

DirkD

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

3.2.4.sp1

Priority

Minor