diff options
Diffstat (limited to 'mysql-test/main/udf.test')
-rw-r--r-- | mysql-test/main/udf.test | 13 |
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 |