diff options
| author | unknown <serg@serg.mylan> | 2004-07-21 19:17:07 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-07-21 19:17:07 +0200 |
| commit | cb35648ec804ff3102895611b0a04999eb93ade1 (patch) | |
| tree | aa5680b866c9ffa1e4bc05dec5fc9d26335615c7 /mysql-test/include/ps_query.inc | |
| parent | bf95f9195fe431841fe1e29e6b82c9f47ec52ad3 (diff) | |
| download | mariadb-git-cb35648ec804ff3102895611b0a04999eb93ade1.tar.gz | |
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 :)
Diffstat (limited to 'mysql-test/include/ps_query.inc')
| -rw-r--r-- | mysql-test/include/ps_query.inc | 5 |
1 files changed, 5 insertions, 0 deletions
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; |