hibernate-issues

[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-300) select new Foo(...) does not work (was ok in 2.0.1)

[<leg...@at...>]

The following comment has been added to this issue:

     Author: David Channon
    Created: Sat, 30 Aug 2003 12:21 AM
       Body:
It is possible it is a side affect. I will check it out.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-300


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-300
    Summary: select new Foo(...) does not work (was ok in 2.0.1)
       Type: Bug

     Status: Assigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3
             2.1 beta 1
             2.1 beta 2

   Assignee: David Channon
   Reporter: Thilo Jahke

    Created: Fri, 29 Aug 2003 8:28 AM
    Updated: Fri, 29 Aug 2003 2:01 PM

Description:
The simple HQL Query

select new Foo(i.name, a.street, ...) 
from person i left outer join address a ...

did work fine in Hibernate 2.0.1 but not in the newer versions.
I get the error 

net.sf.hibernate.QueryException: undefined alias: i

Thilo


---------------------------------------------------------------------
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: (HB-300) select new Foo(...) does not work (was ok in 2.0.1)

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Sat, 30 Aug 2003 5:29 PM
       Body:
Thanks! :)
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-300


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-300
    Summary: select new Foo(...) does not work (was ok in 2.0.1)
       Type: Bug

     Status: Assigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3
             2.1 beta 1
             2.1 beta 2

   Assignee: David Channon
   Reporter: Thilo Jahke

    Created: Fri, 29 Aug 2003 8:28 AM
    Updated: Fri, 29 Aug 2003 2:01 PM

Description:
The simple HQL Query

select new Foo(i.name, a.street, ...) 
from person i left outer join address a ...

did work fine in Hibernate 2.0.1 but not in the newer versions.
I get the error 

net.sf.hibernate.QueryException: undefined alias: i

Thilo


---------------------------------------------------------------------
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: (HB-300) select new Foo(...) does not work (was ok in 2.0.1)

[<leg...@at...>]

The following comment has been added to this issue:

     Author: David Channon
    Created: Mon, 1 Sep 2003 1:14 AM
       Body:
I cannot replicate this issue. I have added my tests for the dialect function enhancements back into the downloaded latest CVS src from v21branch. A simple new works fine and new using a join as described works fine. All other select parser tests pass fine as well. I have sent an email to Thilo to get extra information. In a few days, unless further info from Thilo demonstrates a defect, I would consider closing this JIRA report as 'unable to replicate' or whatever is appropriate.

Questions:
   1) Should I test against other versions of the software.
   2) Noticed CVS src not have my tests for the new Dialect functions included. Do you want me to submit the patch once again. I do think it should be included as a part of the basic SQL function test suite.

I will change the hsqldb dilect to include additional functions. This will allow the stock release system test runs to include testing the extended dialect functionality. This assumes the additional tests will be commited CVS.

--David.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-300


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-300
    Summary: select new Foo(...) does not work (was ok in 2.0.1)
       Type: Bug

     Status: Assigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3
             2.1 beta 1
             2.1 beta 2

   Assignee: David Channon
   Reporter: Thilo Jahke

    Created: Fri, 29 Aug 2003 8:28 AM
    Updated: Fri, 29 Aug 2003 2:01 PM

Description:
The simple HQL Query

select new Foo(i.name, a.street, ...) 
from person i left outer join address a ...

did work fine in Hibernate 2.0.1 but not in the newer versions.
I get the error 

net.sf.hibernate.QueryException: undefined alias: i

Thilo


---------------------------------------------------------------------
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: (HB-300) select new Foo(...) does not work (was ok in 2.0.1)

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Mon, 1 Sep 2003 5:38 PM
       Body:
Yeah, just add a test to the test suite. If the user doesn't get back to you, just close the issue.

Thanks David.
---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-300


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-300
    Summary: select new Foo(...) does not work (was ok in 2.0.1)
       Type: Bug

     Status: In Progress
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3
             2.1 beta 1
             2.1 beta 2

   Assignee: David Channon
   Reporter: Thilo Jahke

    Created: Fri, 29 Aug 2003 8:28 AM
    Updated: Mon, 1 Sep 2003 1:20 AM

Description:
The simple HQL Query

select new Foo(i.name, a.street, ...) 
from person i left outer join address a ...

did work fine in Hibernate 2.0.1 but not in the newer versions.
I get the error 

net.sf.hibernate.QueryException: undefined alias: i

Thilo


---------------------------------------------------------------------
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: (HB-300) select new Foo(...) does not work (was ok in 2.0.1)

[<leg...@at...>]

The following comment has been added to this issue:

     Author: David Channon
    Created: Mon, 1 Sep 2003 11:59 PM
       Body:
 
This is a user issue not a hibernate bug. Following is the supplied query. It is missing the closing parenthesis to close the new in the select clause. It did involve a joined subclass so I loaded the mappings and created the classes anyway and the query worked fine.

 String select = new String("select distinct new SuchErgebnisInteressenten(interessent.oid, "+
     "interessent.name1, interessent.name2, interessent.geburtsdatum, adresse.strasse, adresse.plz, "+
     "adresse.ort, adresse.telefonp ");
 String alias = new String("from Interessent interessent "+
            "left outer join interessent.adresseSet adresse ");

 Query query = sess.createQuery(select + alias);
 List ergebnis = query.list();


---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-300


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-300
    Summary: select new Foo(...) does not work (was ok in 2.0.1)
       Type: Bug

     Status: In Progress
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.2
             2.0.3
             2.1 beta 1
             2.1 beta 2

   Assignee: David Channon
   Reporter: Thilo Jahke

    Created: Fri, 29 Aug 2003 8:28 AM
    Updated: Mon, 1 Sep 2003 1:20 AM

Description:
The simple HQL Query

select new Foo(i.name, a.street, ...) 
from person i left outer join address a ...

did work fine in Hibernate 2.0.1 but not in the newer versions.
I get the error 

net.sf.hibernate.QueryException: undefined alias: i

Thilo


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