Greetings,
Version 3.19.3 is yielding different results than previous releases for a
query in the Entity Framework Core test suite.
The query looks like this:
SELECT [e].[Id], [e].[Discriminator], [e].[Name], [e].[BaseId], [t].[Id],
[t].[BaseParentId], [t].[Discriminator], [t].[Name], [t0].[Id],
[t0].[Discriminator], [t0].[Name], [t0].[ParentCollectionId],
[t0].[ParentReferenceId]
FROM [BaseInheritanceRelationshipEntity] AS [e]
LEFT JOIN (
SELECT [e.BaseReferenceOnBase].*
FROM [BaseReferenceOnBase] AS [e.BaseReferenceOnBase]
WHERE [e.BaseReferenceOnBase].[Discriminator] IN
('DerivedReferenceOnBase', 'BaseReferenceOnBase')
) AS [t] ON [e].[Id] = [t].[BaseParentId]
LEFT JOIN (
SELECT [e.BaseReferenceOnBase.NestedReference].*
FROM [NestedReferenceBase] AS [e.BaseReferenceOnBase.NestedReference]
WHERE [e.BaseReferenceOnBase.NestedReference].[Discriminator] IN
('NestedReferenceDerived', 'NestedReferenceBase')
) AS [t0] ON [t].[Id] = [t0].[ParentReferenceId]
WHERE [e].[Discriminator] = 'DerivedInheritanceRelationshipEntity';
I have a 143 KB input database that demonstrates the problem. On 3.16.0
and 3.18.0, this query results in 3 rows. On 3.19.3, it results in 6 rows.
Would it be appropriate for me to send the database file to someone for
further investigation?
--
E
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
