2 "from" sql clauses appear in certain hql cases

Description

Method TransformFromClause(string fromClause) in JetDriver.cs returns 2 "from" clauses in certain hql cases. The case will be supplied with unit tests patch.

Environment

None

Attachments

1

Activity

Show:

Hadi Eskandari 
April 8, 2010 at 12:59 AM

I used your patch, which generates the following SQL statement on current version:

select catalogent0_.IdCatalogEntry as col_0_0_, catalogent0_.IdCatalogCategory as col_1_0_, catalogent0_.IdProductType as col_2_0_, catalogcat1_.[Name] as col_3_0_, producttyp2_.[Name] as col_4_0_ from CatalogEntriesEntity catalogent0_, CatalogCategoriesEntity catalogcat1_, ProductTypesEntity producttyp2_ where catalogent0_.IdCatalogCategory=catalogcat1_.IdCatalogCategory and catalogent0_.IdProductType=producttyp2_.IdProductType and catalogcat1_.IdProductCatalog=5

Select statement seems right, so I have just added your passing unit test to the source code.

Cannot Reproduce

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created November 5, 2009 at 12:24 PM
Updated April 8, 2010 at 12:59 AM
Resolved April 8, 2010 at 12:59 AM
Who's Looking?