From 382a8c00486b258d31ea58d27ade86780e750241 Mon Sep 17 00:00:00 2001 From: "msvensson@neptunus.(none)" <> Date: Wed, 30 Mar 2005 12:14:37 +0200 Subject: BUG#8807 Select crash server - Add function Item_param::fix_fields which will update any subselect they are part of and indicate that the subsleect is not const during prepare phase, and thus should not be executed during prepare. --- mysql-test/r/ps_3innodb.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/ps_3innodb.result') diff --git a/mysql-test/r/ps_3innodb.result b/mysql-test/r/ps_3innodb.result index eb17d25e80c..61ec956035d 100644 --- a/mysql-test/r/ps_3innodb.result +++ b/mysql-test/r/ps_3innodb.result @@ -768,6 +768,10 @@ prepare stmt1 from ' select a, ?, b FROM t1 outer_table where execute stmt1 using @arg00, @arg01, @arg02, @arg03 ; a ? b 2 1 two +prepare stmt1 from 'select c4 FROM t9 where + c13 = (select MAX(b) from t1 where a = ?) and c22 = ? ' ; +execute stmt1 using @arg01, @arg02; +c4 prepare stmt1 from ' select a, b FROM t1 outer_table where a = (select a from t1 where b = outer_table.b ) order by a '; execute stmt1 ; -- cgit v1.2.1