Bug #49850 Entity Framework - Table per Type inheritance List error

Description:
There is a problem using table per type inheritance when listing the contents of the parent table.
For some reason the result of the query is a list of child objects, even if there is no related child record with the same parent Id.

How to repeat:
Create a simple application with 2 tables (parent and child) and replace the one-to-one foreign key relationship to a inheritance relationshiop. Then use the code above.
The first query returns correctly a list of all child objects, but the second query returns a list of all parent, but with the "is child" incorrectly set to true for all items in the list

using (testdbEntities ctx = new testdbEntities())
{
    IList<child> childs = ctx.parent.OfType<child>().ToList();
    foreach (child c in childs)
    {
        Console.WriteLine("name: " + c.nameParent + " desc: " + c.DescChild);
    }

    IList<parent> parents = ctx.parent.ToList();
    foreach (parent p in parents)
    {
        Console.WriteLine("name: " + p.nameParent + " is child: " + (p is child));
    }
}

Suggested fix:
I could fix this problem changing the MySql provider to a comercial product - called Devart dotConnect for MySQL.

Test Case Project and Database creation script

Attachment: InheritanceTest.zip (application/x-zip-compressed, text), 33.73 KiB.

Eduardo, your report is being discussed internally, we did not forget about it.

Eduardo.

Your test case crashes in 
        public string DescChild
        {
            get
            {
                return this._DescChild;
            }
            set
            {
                this.OnDescChildChanging(value);
                this.ReportPropertyChanging("DescChild");
                this._DescChild = global::System.Data.Objects.DataClasses.StructuralObject.SetValidValue(value, false);
                this.ReportPropertyChanged("DescChild");
                this.OnDescChildChanged();
            }
        }

after executing IList<parent> parents = ctx.parent.ToList();

which makes it rather useless. Can you please rework your code so that it works against latest released version of c.NET (6.2.2)?

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/102619

799 Reggie Burnett	2010-03-08
      - fixed bug in sql generation when using a negated binary fragment in EF (bug #49850)

fixed in 6.0.6, 6.1.4, 6.2.3, 6.3.2+

Thanks Reggie.

An entry has been added to changelogs: 6.0.6, 6.1.4, 6.2.3, 6.3.2:

When using table per type inheritance and listing the contents of the parent table, the result of the query was a list of child objects, even though there was no related child record with the same parent Id.

Looks like this bug is reproducable again in 6.3.6

Looks like this bug is reproducable again in 6.3.6