summaryrefslogtreecommitdiff
path: root/mysql-test/r/ps.result
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2004-05-07 03:32:51 +0400
committerunknown <sergefp@mysql.com>2004-05-07 03:32:51 +0400
commitdee8f22c079addf7ed2a27ea6ed73a81f52c5cb7 (patch)
treef598ed6d83584721292ad9cd5c5c0e1efd8b7a4e /mysql-test/r/ps.result
parent6810ca1b71e049cc86adbc12bebedbce41d03a7c (diff)
downloadmariadb-git-dee8f22c079addf7ed2a27ea6ed73a81f52c5cb7.tar.gz
Added a test for a problem that was fixed by automerge and fixed a typo.
Diffstat (limited to 'mysql-test/r/ps.result')
-rw-r--r--mysql-test/r/ps.result13
1 files changed, 11 insertions, 2 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result
index d16f24b34c6..fc82645840c 100644
--- a/mysql-test/r/ps.result
+++ b/mysql-test/r/ps.result
@@ -2,7 +2,7 @@ drop table if exists t1,t2;
create table t1
(
a int primary key,
-b char(10),
+b char(10)
);
insert into t1 values (1,'one');
insert into t1 values (2,'two');
@@ -89,4 +89,13 @@ prepare stmt6 from 'insert into t1 values (5,"five"); select2';
ERROR 42000: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; select2' at line 1
explain prepare stmt6 from 'insert into t1 values (5,"five"); select2';
ERROR 42000: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from 'insert into t1 values (5,"five"); select2'' at line 1
-drop table t1;
+create table t2
+(
+a int
+);
+insert into t2 values (0);
+set @arg00=NULL ;
+prepare stmt1 from 'select 1 FROM t2 where a=?' ;
+execute stmt1 using @arg00 ;
+1
+drop table t1,t2;