[MDEV-18015] Assertion `global_status_var.global_memory_used == 0' failed when using window functions and views - Jira

XML

Word

Printable

The mtr test case is:

--source include/have_udf.inc

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 1) , b) from t1;

select * from v1;

Warnings are generated on shutdown.

relates to

MDEV-15837 Assertion `item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM' failed in compare_order_elements function