Bug #3360 count(distinct) crash server in prepared statements
| Submitted: | 1 Apr 2004 10:22 | Modified: | 7 Apr 2004 13:55 |
|---|---|---|---|
| Reporter: | Oleksandr Byelkin | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1 | OS: | Any (all) |
| Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[3 Apr 2004 0:18]
Oleksandr Byelkin
ChangeSet 1.1760 04/04/03 11:13:51 bell@sanja.is.com.ua +12 -0 fixed brocken of client_test fixed aggregate functions in PS (BUG#3360)
[7 Apr 2004 13:55]
Oleksandr Byelkin
pushed
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: count(distinct) crash server in prepared statements How to repeat: static void test_selecttmp() { MYSQL_STMT *stmt; int rc, i; const char *query= "select a,(select count(distinct t1.b) as sum from t1,t2 where t1.a=t2.a and t2.b > 0 and t1.a <= t3.b group by t1.a order by sum limit 1) from t3"; myheader("test_select_tmp"); rc = mysql_query(mysql, "DROP TABLE IF EXISTS t1,t2,t3"); myquery(rc); rc= mysql_query(mysql,"CREATE TABLE t1 (a int , b int);"); myquery(rc); rc= mysql_query(mysql,"create table t2 (a int, b int);"); myquery(rc); rc= mysql_query(mysql,"create table t3 (a int, b int);"); myquery(rc); rc= mysql_query(mysql, "insert into t1 values (0,100),(1,2), (1,3), (2,2), (2,7), \ (2,-1), (3,10);"); myquery(rc); rc= mysql_query(mysql, "insert into t2 values (0,0), (1,1), (2,1), (3,1), (4,1);"); myquery(rc); rc= mysql_query(mysql, "insert into t3 values (3,3), (2,2), (1,1);"); myquery(rc); stmt= mysql_prepare(mysql, query, strlen(query)); mystmt_init(stmt); for (i= 0; i < 3; i++) { rc= mysql_execute(stmt); mystmt(stmt, rc); assert(3 == my_process_stmt_result(stmt)); } mysql_stmt_close(stmt); rc= mysql_query(mysql, "DROP TABLE t1,t2,t3"); myquery(rc); }