Comment 2 for bug 934342

Revision history for this message
Igor Babaev (igorb-seattle) wrote :

The first plan shows that the key is copied from table t, rather then from the materialized table. The last record in table t is ('t','t'). So the key to access table t1 always is built over this record. This explains why we have a wrong result for the first plan.