118
118
id select_type table type possible_keys key key_len ref rows Extra
119
119
1 PRIMARY <derived2> system NULL NULL NULL NULL 0 const row not found
120
120
3 SUBQUERY t2 ALL NULL NULL NULL NULL 2
124
124
# 5) Test that subquery materialization is setup for query with