summaryrefslogtreecommitdiff
path: root/mysql-test/t/ps.test
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-05-18 18:16:51 +0500
committerunknown <ramil/ram@mysql.com/ramil.myoffice.izhnet.ru>2007-05-18 18:16:51 +0500
commit6249d57d4bc56a0213a152bae1a930fe45412111 (patch)
tree1167b254c651fb8a191c94785817429e6cbba7f9 /mysql-test/t/ps.test
parent8ab53d5f4e9225d3d3d3509f8cd47c610406ed8e (diff)
downloadmariadb-git-6249d57d4bc56a0213a152bae1a930fe45412111.tar.gz
Fox for bug #28509: strange behaviour: passing a decimal value to PS
Set parameter's type to Item::DECIMAL_ITEM assigning a decimal value. mysql-test/r/ps.result: Fox for bug #28509: strange behaviour: passing a decimal value to PS - test result. mysql-test/t/ps.test: Fox for bug #28509: strange behaviour: passing a decimal value to PS - test case. sql/item.cc: Fox for bug #28509: strange behaviour: passing a decimal value to PS - set Item_param::item_type to Item::DECIMAL_ITEM in case of DECIMAL_RESULT variable. - removed redundant item_result_type assignments as it's set before.
Diffstat (limited to 'mysql-test/t/ps.test')
-rw-r--r--mysql-test/t/ps.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test
index 3fbcf84a1f9..08949bd8cff 100644
--- a/mysql-test/t/ps.test
+++ b/mysql-test/t/ps.test
@@ -1773,5 +1773,13 @@ execute stmt;
deallocate prepare stmt;
drop tables t1;
+#
+# Bug #28509: strange behaviour: passing a decimal value to PS
+#
+prepare stmt from "create table t1 select ?";
+set @a=1.0;
+execute stmt using @a;
+show create table t1;
+drop table t1;
--echo End of 5.0 tests.