Обсуждение: FEATURE: Reuse temporary tables

Поиск
Список
Период
Сортировка

FEATURE: Reuse temporary tables

От
Дата:
ACTUAL:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf a=
tc left join akh_test_suit ats on ats.id =3D atc.test_suit_id) tc1
left join (select atc.id, ats.test_suit_type_id from akh_testing_conf atc l=
eft join akh_test_suit ats on ats.id =3D atc.test_suit_id) tc2 on tc2.test_=
suit_type_id =3D tc1.test_suit_type_id
where tc1.id =3D 3879

FEATURED:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf a=
tc left join akh_test_suit ats on ats.id =3D atc.test_suit_id) tc1
left join tc1 tc2 on tc2.test_suit_type_id =3D tc1.test_suit_type_id
where tc1.id =3D 3879=