Projecting related child table causes double reference in FROM clause

Hi.

More troubles with Class Table inheritance,

The following query

        using ( var uow = _context.CreateUnitOfWork() )
        {
            var query = new Query(typeof (Derived));
            query.QueryExpression =
                Entity.Attribute("Relateds.Name") == "Name" 
                && Entity.Attribute("HasField") == true;

            query.Projection.Add("Relateds.Name");

            uow.Project(query);
        }

creates the following invalid SQL

SELECT
  Related.Name AS [Related.Name]
FROM
  E
INNER JOIN
  Related
ON
  E.Id = Related.DerivedId
LEFT OUTER JOIN
  Related
ON
  E.Id = Related.Id
LEFT OUTER JOIN
  Derived
ON
  E.Id = Derived.Id
WHERE
  ((EXISTS (
    SELECT
      Related.*
    FROM
      Related
    WHERE
      Related.DerivedId = E.Id AND
      Related.Name = 'Name'
  ) AND Derived.HasField = True) AND E.IsDerived = True)

I've tried a couple of different ways, but can't seem to get it to alias the tables different (or to the same table)

Thanks - I will need to have a look into a fix for this as the aliasing is not being picked up correctly for the field specified in the projection, but in the meantime this looks to be working:

using ( var uow = _context.CreateUnitOfWork() )
{
    var query = new Query(typeof (Derived));
    query.Mappings.Add(typeof(Related), "t0");
    query.QueryExpression =
      Entity.Attribute("Relateds.Name") == "Name"
      && Entity.Attribute("HasField") == true;

    query.Projection.Add("t0", "Name");             
    uow.Project(query);
}

Jeremy

Thanks. Any chance the fix will be in tonight's nightly?

Hi Andy,

A fix will be in the next (tonight's) nightly build - didn't make it in time for last night unfortunately :)

Jeremy