summaryrefslogtreecommitdiff
path: root/mysql-test/main/udf.test
diff options
context:
space:
mode:
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