No. It's because your view's WHERE clause is being added to your INSERT Thanks. You’re right - I should have thought to use EXPLAIN before posting here.
Repeating this, as if I should already know this, is less helpful though. It’s not as if the docs tells users to steer clear of RULEs.
If there is something I don’t understand, such as RULEs, I prefer to experiment with it and ask questions if there is something I still don’t follow. I thought
this was the correct forum for those questions. |