------=_Part_195477_22492492.1298531284431
Content-Type: text/plain; charset=GBK
Content-Transfer-Encoding: base64

SGmjugogICBJIGZpbmQgYSBjcmFzaCBidWcsIHZlcnNpb24gaXMgIG15c3Fs IDUuNS44CgogICBK
dXN0IHRyeToKICAgdXNlIHRlc3Q7CgogICBkcm9wIHRhYmxlIGlmIGV4aXN0 cyB0MSx0MjsKICAg
Y3JlYXRlIHRhYmxlIHQxKGEgaW50KTsKICAgY3JlYXRlIHRhYmxlIHQyKGIg aW50KTsKICBQUkVQ
QVJFc3RtdCBGUk9NICJzZWxlY3Qgc3VtKGIpIGZyb20gdDIgZ3JvdXAgYnkg YiBoYXZpbmcgYiBp
biAoc2VsZWN0IGIgZnJvbSB0MSkiOwogICBleGVjdXRlIHN0bXQ7ICAgICAg IC0tICBjcmFzaAog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAg
ICAgICAgICAgICAgIHpob25ndGFvCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgMjAxMS0wMi0y Mw==
------=_Part_195477_22492492.1298531284431--

Hi zhongtao,

thank you for reporting this bug. It has been filed as
http://bugs.mysql.com/bug.php?id=60279

Regards,
Roy

On 24.02.11 08.08, tanzhongt wrote:
> 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;


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org