diff options
| author | unknown <konstantin@mysql.com> | 2005-07-15 00:31:09 +0400 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2005-07-15 00:31:09 +0400 |
| commit | b0641a3bdd518439a2bf8d5f66dda663942e40b6 (patch) | |
| tree | 67dc52609b50b369c1fe7c45c4b20109d1c9bff2 /mysql-test/t/ps.test | |
| parent | 7750905037e9c1e64d5172819b746815ed268152 (diff) | |
| parent | 73386c15a6698234d287525c2271b64756eb3354 (diff) | |
| download | mariadb-git-b0641a3bdd518439a2bf8d5f66dda663942e40b6.tar.gz | |
Merge mysql.com:/opt/local/work/mysql-4.1-root
into mysql.com:/opt/local/work/mysql-5.0-root
regex/regerror.c:
Auto merged
sql/sql_lex.cc:
Auto merged
mysql-test/r/ps.result:
Manual merge
mysql-test/t/ps.test:
Manual merge
sql/sql_yacc.yy:
Manual merge
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 2ee6950d210..c86a69ab45f 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -801,3 +801,25 @@ execute stmt using @param1; select utext from t1 where utext like '%%'; drop table t1; deallocate prepare stmt; +# +# Bug#11299 "prepared statement makes wrong SQL syntax in binlog which stops +# replication": check that errouneous queries with placeholders are not +# allowed +# +create table t1 (a int); +--error 1064 +prepare stmt from "select ??"; +--error 1064 +prepare stmt from "select ?FROM t1"; +--error 1064 +prepare stmt from "select FROM t1 WHERE?=1"; +--error 1064 +prepare stmt from "update t1 set a=a+?WHERE 1"; +--error 1064 +select ?; +--error 1064 +select ??; +--error 1064 +select ? from t1; +drop table t1; +deallocate prepare stmt; |