On Tue, 16 Jul 2024 at 13:28, David G. Johnston
wrote:
> Add another note to caveats in the docs and call it a feature. We produce a
> valid answer for the data model encountered. The non-determinism isn’t
> wrong, it’s just a poorly written query/model with non-deterministic results.
> Since
On Monday, July 15, 2024, David Rowley wrote:
> On Tue, 16 Jul 2024 at 12:45, Richard Guo wrote:
> > As a workaround for this issue, I'm considering whether we can skip
> > checking functional dependency on primary keys for inheritance
> > parents, given that we cannot guarantee uniqueness on th
On Tue, 16 Jul 2024 at 12:45, Richard Guo wrote:
> As a workaround for this issue, I'm considering whether we can skip
> checking functional dependency on primary keys for inheritance
> parents, given that we cannot guarantee uniqueness on the keys in this
> case. Maybe something like below.
>
>
ed limitation of the
inheritance feature that we would have duplicate unique key values in
inheritance tables. Even adding a unique constraint to the children
does not prevent duplication compared to the parent.
As a workaround for this issue, I'm considering whether we can skip
checking functiona
