DDC-20: CLONE -cache problem with joined tables and external data change #24

New Issue

2026-01-22T12:24:39+01:00

admin commented

2026-01-22 12:24:39 +01:00

Originally created by @doctrinebot on GitHub (Sep 24, 2009).

Jira issue originally created by user psycon:

Doctrine doesn't invalidate cache properly. Queries like the one below has the second table taken from cache and it shouldn't.

$comp = Doctrine_Query::create()
            ->select('a.**, s.**')
            ->from('AttachedComponents a, a.SubscriptionComponents s')
            ->fetchOne();

In bug [DC-24] the advice is to select id of second table, I selected all fields in second table but doctrine doesn't seem to notice foreign key has changed.

Originally created by @doctrinebot on GitHub (Sep 24, 2009). Jira issue originally created by user psycon: Doctrine doesn't invalidate cache properly. Queries like the one below has the second table taken from cache and it shouldn't. ``` $comp = Doctrine_Query::create() ->select('a.**, s.**') ->from('AttachedComponents a, a.SubscriptionComponents s') ->fetchOne(); ``` In bug [DC-24] the advice is to select id of second table, I selected all fields in second table but doctrine doesn't seem to notice foreign key has changed.

admin added the Bug label 2026-01-22 12:24:39 +01:00

admin closed this issue

2026-01-22 12:24:40 +01:00

admin commented

2026-01-22 12:24:41 +01:00

@doctrinebot commented on GitHub (Sep 24, 2009):

relates to DC-41: cache problem with joined tables and external data change

@doctrinebot commented on GitHub (Sep 24, 2009): - relates to [DC-41: cache problem with joined tables and external data change](http://www.doctrine-project.org/jira/browse/DC-41)

admin commented

2026-01-22 12:24:41 +01:00

@doctrinebot commented on GitHub (Sep 25, 2009):

Comment created by romanb:

After some researh this is desired behavior. However, parts of a consistent implementation of this behavior are still incomplete as described in DDC-21 and DDC-22.

@doctrinebot commented on GitHub (Sep 25, 2009): Comment created by romanb: After some researh this is desired behavior. However, parts of a consistent implementation of this behavior are still incomplete as described in [DDC-21](http://www.doctrine-project.org/jira/browse/DDC-21) and [DDC-22](http://www.doctrine-project.org/jira/browse/DDC-22).

admin commented

2026-01-22 12:24:42 +01:00