From 9f379d7f05c43b2d09de91c3af5cc35613a745e4 Mon Sep 17 00:00:00 2001
From: "konstantin@mysql.com" <>
Date: Tue, 7 Jun 2005 14:11:36 +0400
Subject: Patch two (the final one) for Bug#7306 "the server side
 preparedStatement  error for LIMIT placeholder". The patch adds grammar
 support for LIMIT ?, ? and changes the type of
 ST_SELECT_LEX::select_limit,offset_limit from ha_rows to Item*, so that it
 can point to Item_param.

---
 mysql-test/include/ps_modify.inc | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

(limited to 'mysql-test/include/ps_modify.inc')

diff --git a/mysql-test/include/ps_modify.inc b/mysql-test/include/ps_modify.inc
index 04b9734240b..633c317f4b2 100644
--- a/mysql-test/include/ps_modify.inc
+++ b/mysql-test/include/ps_modify.inc
@@ -174,11 +174,8 @@ where a=2
 limit 1';
 execute stmt1 ;
 select a,b from t1 where b = 'bla' ;
-# currently (May 2004, Version 4.1) it is impossible
--- error 1064
-prepare stmt1 from 'update t1 set b=''bla''
-where a=2
-limit ?';
+prepare stmt1 from 'update t1 set b=''bla'' where a=2 limit ?';
+execute stmt1 using @arg00;
 
 --disable_query_log
 select '------ insert tests ------' as test_sequence ;
-- 
cgit v1.2.1