summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2005-11-03 10:28:12 +0300
committerunknown <sergefp@mysql.com>2005-11-03 10:28:12 +0300
commit883b38a2cd31a28b87f576fe0776857873981873 (patch)
tree0ee786b29c5953b014b95552b9427e9ce4567472 /mysql-test/t/view.test
parente2220f476680d60a5f35b9dcef6920862d578f80 (diff)
parent17fcbcf77290fff34a00ce1387760f5e5c71c134 (diff)
downloadmariadb-git-883b38a2cd31a28b87f576fe0776857873981873.tar.gz
Merged
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test9
1 files changed, 8 insertions, 1 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 0bd0e572193..7918c78deb3 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -1,5 +1,5 @@
--disable_warnings
-drop table if exists t1,t2,t9,`t1a``b`,v1,v2,v3,v4,v5,v6;
+drop table if exists t1,t2,t3,t4,t9,`t1a``b`,v1,v2,v3,v4,v5,v6;
drop view if exists t1,t2,`t1a``b`,v1,v2,v3,v4,v5,v6;
drop database if exists mysqltest;
--enable_warnings
@@ -2190,6 +2190,13 @@ DROP VIEW v1,v2;
DROP TABLE t1,t2,t3;
#
+prepare stmt1 from "select count(*) from v1 where x = ?";
+set @parm1=1;
+
+execute stmt1 using @parm1;
+execute stmt1 using @parm1;
+drop view v1;
+drop table t1,t2,t3,t4;
# Bug #14466 lost sort order in GROUP_CONCAT() in a view
#
create table t1 (f1 int, f2 int);