summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps.test
diff options
context:
space:
mode:
authordavi@buzz.(none) <>2008-02-28 20:22:50 -0300
committerdavi@buzz.(none) <>2008-02-28 20:22:50 -0300
commit2905909d8946c19141c86af12ac6017b9bde2488 (patch)
tree676edb9a4be1993cb98b1e11f9a509999832bf6d /mysql-test/t/ps.test
parent55f0fba46259d74aa178c682830f6a166846d30a (diff)
parent369c24937036a7850e61f7a77d5f9e169be3f724 (diff)
downloadmariadb-git-2905909d8946c19141c86af12ac6017b9bde2488.tar.gz
Merge buzz.(none):/home/davi/mysql-5.0-runtime
into buzz.(none):/home/davi/mysql-5.1-runtime
Diffstat (limited to 'mysql-test/t/ps.test')
-rw-r--r--mysql-test/t/ps.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test
index bc784412392..d137461ce9c 100644
--- a/mysql-test/t/ps.test
+++ b/mysql-test/t/ps.test
@@ -1961,6 +1961,25 @@ prepare stmt from "create view v1 as select * from t1";
--error ER_NO_SUCH_TABLE
prepare stmt from "create view v1 as select * from `t1` `b`";
+#
+# Bug#33851: Passing UNSIGNED param to EXECUTE returns ERROR 1210
+#
+
+prepare stmt from "select ?";
+set @arg= 123456789.987654321;
+select @arg;
+execute stmt using @arg;
+set @arg= "string";
+select @arg;
+execute stmt using @arg;
+set @arg= 123456;
+select @arg;
+execute stmt using @arg;
+set @arg= cast(-12345.54321 as decimal(20, 10));
+select @arg;
+execute stmt using @arg;
+deallocate prepare stmt;
+
--echo End of 5.0 tests.
#