summaryrefslogtreecommitdiff
path: root/mysql-test/main/udf.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2019-01-06 17:43:02 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2019-01-06 17:43:02 +0200
commit734510a44d690dfb94264e1d2775ee1cb6f3ebb9 (patch)
tree0ccc317bf9462ca95cd1277b4ce65a7fda5fe315 /mysql-test/main/udf.test
parent2465d3e00b2f18c7d4967f9bb10438883682787d (diff)
parentfaf206a848684bc0f87c93a2b47a55063bbccc6c (diff)
downloadmariadb-git-734510a44d690dfb94264e1d2775ee1cb6f3ebb9.tar.gz
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/udf.test')
-rw-r--r--mysql-test/main/udf.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/udf.test b/mysql-test/main/udf.test
index 43d66dc68e2..bb8493135aa 100644
--- a/mysql-test/main/udf.test
+++ b/mysql-test/main/udf.test
@@ -529,6 +529,19 @@ DROP FUNCTION METAPHON;
#SELECT * FROM t1;
DROP TABLE t1;
+--echo #
+--echo # MDEV-15424: Unreasonal SQL Error (1356) on select from view
+--echo #
+--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
+eval CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME "$UDF_EXAMPLE_SO";
+create table t1(a int , b int);
+insert into t1 values(100, 54), (200, 199);
+create view v1 as select myfunc_int(max(a) over (order by b) , b) from t1;
+select * from v1;
+drop view v1;
+drop function myfunc_int;
+drop table t1;
+
--echo
--echo MDEV-15073: Generic UDAF parser code in server for windows functions
--echo