From cb35648ec804ff3102895611b0a04999eb93ade1 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 21 Jul 2004 19:17:07 +0200 Subject: fixed ORDER BY ? new tests to ensure that prepared statement *really* work (and that MySQL not picks up some number from arbitrary location that happens to match the parameter's value) mysql-test/include/ps_query.inc: new tests to ensure that prepared statement *really* work (and that MySQL not picks up some number from arbitrary location that happens to match the parameter's value) mysql-test/r/ps_2myisam.result: results updated mysql-test/r/ps_3innodb.result: results updated mysql-test/r/ps_4heap.result: results updated mysql-test/r/ps_5merge.result: results updated mysql-test/r/ps_6bdb.result: results updated sql/sql_select.cc: don't shortcut - it backfires! (in particular - when itemptr is Item_param :) --- mysql-test/include/ps_query.inc | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'mysql-test/include/ps_query.inc') diff --git a/mysql-test/include/ps_query.inc b/mysql-test/include/ps_query.inc index e22f168dcd7..bc5d3eb6ed1 100644 --- a/mysql-test/include/ps_query.inc +++ b/mysql-test/include/ps_query.inc @@ -246,6 +246,11 @@ select a,b from t1 order by 2 ; prepare stmt1 from ' select a,b from t1 order by ? '; execute stmt1 using @arg00; +set @arg00=1 ; +execute stmt1 using @arg00; +set @arg00=0 ; +--error 1054 +execute stmt1 using @arg00; ##### parameter used in limit clause set @arg00=1; -- cgit v1.2.1