Item_subselect::used_tables_cache is unstable, it's value can vary depending on the current thread operation. The effect this might have is difficult to determine.

We need to add an assertion at the beginning of the optimize phase that this attribute is the same as at other phases and/or statement executions.