Hi: I find a crash bug, version is mysql 5.5.8 Just try: use test;
drop table if exists t1,t2; create table t1(a int); create table t2(b int); PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b from t1)"; execute stmt; -- crash zhongtao 2011-02-23