* Georgi Kodinov <gkodinov@stripped> [07/11/02 14:41]:
> > +drop table if exists t1, t2;
>
> Please either remove this statement (imho better : makes for harder
> discovery of missing cleanup in the previous tests) or disable the
> warnings.
ok, I choose to add 'disable_warnings'.
> > +prepare stmt from "delete from t2 where (select (select max(b) from
> > t1 group
> > +by a having a < 2) x from t1) > 10000";
>
> Do we really need the separate "prepare stmt" ? How is it different
> from --ps_protocol option of mysql-test-run.pl ?
I execute the statement twice here.
Interestingly, in prepared statements mode the 'const' property of
the subquery is lost. This was suspicious enough for me to add a
separate test.
I don't know why. And since you're rewriting subqueries in 6.0, I
don't want to investigate more than I did (1 hour).
--
-- Konstantin Osipov Software Developer, Moscow, Russia
-- MySQL AB, www.mysql.com The best DATABASE COMPANY in the GALAXY
