|
From: <leg...@at...> - 2003-08-30 05:22:27
|
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
|
|
From: <leg...@at...> - 2003-08-30 22:30:27
|
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
|
|
From: <leg...@at...> - 2003-09-01 06:15:30
|
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
|
|
From: <leg...@at...> - 2003-09-01 22:38:27
|
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
|
|
From: <leg...@at...> - 2003-09-02 04:59:28
|
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
|