Grzegorz Jaśkiewicz <gryzman@gmail.com> [2009-08-13 14:23]:
> On Thu, Aug 13, 2009 at 12:36 PM, Radoslaw Zielinski<radek@pld-linux.org> wrote:
[...]
>> "kandydaci_fk_id_rekordu" FOREIGN KEY (id_rekordu) REFERENCES rekordy(id) ON DELETE CASCADE
[...]
> since you do LEFT JOIN, indeed you can get r.id to be null.
There is a foreign key on this field, and it's the only one used in the
JOIN condition. LEFT was only used to demonstrate the issue in a single
query.
--
Radosław Zieliński <radek@pld-linux.org>
