summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps_3innodb.result
diff options
context:
space:
mode:
authormsvensson@neptunus.(none) <>2005-03-30 12:14:37 +0200
committermsvensson@neptunus.(none) <>2005-03-30 12:14:37 +0200
commit382a8c00486b258d31ea58d27ade86780e750241 (patch)
tree26b93e9c58fdf59cd458bd87abc33b197e9f1e4c /mysql-test/r/ps_3innodb.result
parentc4a698ea3e1eb1955844489a3bde126cd512fbda (diff)
downloadmariadb-git-382a8c00486b258d31ea58d27ade86780e750241.tar.gz
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.
Diffstat (limited to 'mysql-test/r/ps_3innodb.result')
-rw-r--r--mysql-test/r/ps_3innodb.result4
1 files changed, 4 insertions, 0 deletions
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 ;