summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorbell@sanja.is.com.ua <>2005-07-02 16:12:32 +0300
committerbell@sanja.is.com.ua <>2005-07-02 16:12:32 +0300
commit40abfc1b6f71b2dc3150598938f8e56a9b7ac886 (patch)
tree5eb43e708b0431cf6818939cc42a1bcd5aa59a11 /mysql-test/t/view.test
parent4ab4ee9c7cf2b9b6d1a740806e49f87228d04faa (diff)
downloadmariadb-git-40abfc1b6f71b2dc3150598938f8e56a9b7ac886.tar.gz
fixed var_samp printing (BUG#10651)
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 06b523b3610..504a30bb8b7 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -1696,3 +1696,13 @@ drop view v1;
CREATE VIEW v1 AS SELECT SUBSTRING_INDEX("dkjhgd:kjhdjh", ":", 1);
SELECT * FROM v1;
drop view v1;
+
+#
+# Using var_samp with view (BUG#10651)
+#
+create table t1 (s1 int);
+create view v1 as select var_samp(s1) from t1;
+show create view v1;
+drop view v1;
+drop table t1;
+