Thread: [Hibernate-issues] [Hibernate-JIRA] Created: (HHH-489) Custom SQLFunction not being called

An object relational-mapping (ORM) library for Java

Brought to you by: davidedalto, dreab8, epbernard, gsmet, and 5 others

hibernate-issues

[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-489) Custom SQLFunction not being called

From: <no...@at...> - 2005-05-16 16:55:49

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-489

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-489
    Summary: Custom SQLFunction not being called
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.3

   Assignee: 
   Reporter: Darren Scott

    Created: Mon, 16 May 2005 11:55 AM
    Updated: Mon, 16 May 2005 11:55 AM
Environment: Java 1.4.2_04
Hibernate 3.0.3
MySQL 3.23.45-max-nt
mysql-connector-java-3.1.6


Description:
A custom SQLFunction I have written to implement bitwise AND behaviour for MySQL dialects is not being called as expected under Hibernate 3.0.2 and 3.0.3. The resulting SQL does not show the expected function translation from HQL bitwise_and(X,Y) to SQL X & Y.

This previously worked under Hibernate 3.0.1.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Updated: (HHH-489) Custom SQLFunction not being called

From: <no...@at...> - 2005-05-16 16:59:42

The following issue has been updated:

    Updater: Darren Scott (mailto:da...@da...)
       Date: Mon, 16 May 2005 11:59 AM
    Comment:
The attached ZIP contains a trivial example recreating the issue, including Java source, Hibernate configuration and mapping files and minimal database schema and data. Also included are two log files showing successful behaviour under Hibernate 3.0.1 and failure under Hibernate 3.0.3
    Changes:
             Attachment changed to hibernate-sqlfunction-test.zip
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://opensource.atlassian.com/projects/hibernate/browse/HHH-489?page=history

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-489

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-489
    Summary: Custom SQLFunction not being called
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.3

   Assignee: 
   Reporter: Darren Scott

    Created: Mon, 16 May 2005 11:55 AM
    Updated: Mon, 16 May 2005 11:59 AM
Environment: Java 1.4.2_04
Hibernate 3.0.3
MySQL 3.23.45-max-nt
mysql-connector-java-3.1.6


Description:
A custom SQLFunction I have written to implement bitwise AND behaviour for MySQL dialects is not being called as expected under Hibernate 3.0.2 and 3.0.3. The resulting SQL does not show the expected function translation from HQL bitwise_and(X,Y) to SQL X & Y.

This previously worked under Hibernate 3.0.1.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Assigned: (HHH-489) Custom SQLFunction not being called

From: <no...@at...> - 2005-05-17 03:11:42

Message:

   The following issue has been re-assigned.

   Assignee: Gavin King (mailto:ga...@hi...)
---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-489

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-489
    Summary: Custom SQLFunction not being called
       Type: Bug

     Status: Open
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.3

   Assignee: Gavin King
   Reporter: Darren Scott

    Created: Mon, 16 May 2005 11:55 AM
    Updated: Mon, 16 May 2005 10:09 PM
Environment: Java 1.4.2_04
Hibernate 3.0.3
MySQL 3.23.45-max-nt
mysql-connector-java-3.1.6


Description:
A custom SQLFunction I have written to implement bitwise AND behaviour for MySQL dialects is not being called as expected under Hibernate 3.0.2 and 3.0.3. The resulting SQL does not show the expected function translation from HQL bitwise_and(X,Y) to SQL X & Y.

This previously worked under Hibernate 3.0.1.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Closed: (HHH-489) Custom SQLFunction not being called

From: <no...@at...> - 2005-05-20 04:03:17

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Thu, 19 May 2005 11:02 PM

The SQLFunction interface changed.
---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-489

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-489
    Summary: Custom SQLFunction not being called
       Type: Bug

     Status: Closed
   Priority: Major
 Resolution: REJECTED

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0.3

   Assignee: Gavin King
   Reporter: Darren Scott

    Created: Mon, 16 May 2005 11:55 AM
    Updated: Thu, 19 May 2005 11:02 PM
Environment: Java 1.4.2_04
Hibernate 3.0.3
MySQL 3.23.45-max-nt
mysql-connector-java-3.1.6


Description:
A custom SQLFunction I have written to implement bitwise AND behaviour for MySQL dialects is not being called as expected under Hibernate 3.0.2 and 3.0.3. The resulting SQL does not show the expected function translation from HQL bitwise_and(X,Y) to SQL X & Y.

This previously worked under Hibernate 3.0.1.


---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-489) Custom SQLFunction not being called

From: Daniele G. (JIRA) <no...@at...> - 2006-05-27 10:44:30

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-489?page=comments#action_23170 ] 

Daniele Gariboldi commented on HHH-489:
---------------------------------------

In hibernate 3.1.2 i did so for PostgresSQL, just in case someone is looking for this (I was ;-)  ).
It would be useful to standardize on function names, for HQL beeing cross-db for bitwise operations.

import org.hibernate.Hibernate;
import org.hibernate.dialect.function.SQLFunctionTemplate;

public class PostgreSQLDialect extends org.hibernate.dialect.PostgreSQLDialect {
	public PostgreSQLDialect() {
		super();
		registerFunction("bit_and", new SQLFunctionTemplate(Hibernate.INTEGER,"?1 & ?2"));
		registerFunction("bit_or", new SQLFunctionTemplate(Hibernate.INTEGER,"?1 | ?2"));
		registerFunction("bit_not", new SQLFunctionTemplate(Hibernate.INTEGER,"~?1"));
		registerFunction("gbit_or", new SQLFunctionTemplate(Hibernate.INTEGER,"bit_or(?1)"));
	}
}

> Custom SQLFunction not being called
> -----------------------------------
>
>          Key: HHH-489
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-489
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0.3
>  Environment: Java 1.4.2_04
> Hibernate 3.0.3
> MySQL 3.23.45-max-nt
> mysql-connector-java-3.1.6
>     Reporter: Darren Scott
>     Assignee: Gavin King
>  Attachments: hibernate-sqlfunction-test.zip
>
>
> A custom SQLFunction I have written to implement bitwise AND behaviour for MySQL dialects is not being called as expected under Hibernate 3.0.2 and 3.0.3. The resulting SQL does not show the expected function translation from HQL bitwise_and(X,Y) to SQL X & Y.
> This previously worked under Hibernate 3.0.1.

-- 
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