root@logs:~$ mariadb -s

MariaDB [(none)]> use ez1_schema;

MariaDB [ez1_schema]> create table tabCS(col1 integer) engine=columnstore;

MariaDB [ez1_schema]> create table tabIN(col1 integer) engine=innoDB;

MariaDB [ez1_schema]> insert into tabCS values ('1');

MariaDB [ez1_schema]> insert into tabIN values ('1');

MariaDB [ez1_schema]> drop function if exists F1;

MariaDB [ez1_schema]> delimiter //

MariaDB [ez1_schema]> CREATE FUNCTION F1(pDescriprion varchar(100)) RETURNS INT begin

    -> declare g INT;

    -> select col1 into g from tabCS limit 1;

    -> return g;

    -> END;

    -> //

delimiter ;

drop function if exists F2;

delimiter //

MariaDB [ez1_schema]> delimiter ;

MariaDB [ez1_schema]>

MariaDB [ez1_schema]> drop function if exists F2;

MariaDB [ez1_schema]> delimiter //

MariaDB [ez1_schema]> CREATE FUNCTION F2(pDescriprion varchar(100)) RETURNS INT begin

    -> declare g INT;

    -> select col1 into g from tabIN limit 1;

    -> return g;

    -> END;

    -> //

delimiter ;MariaDB [ez1_schema]> delimiter ;

MariaDB [ez1_schema]> create table tabY (col1 varchar(100),col2 int) engine=columnstore;

MariaDB [ez1_schema]> insert into tabY values ('hello',1);

MariaDB [ez1_schema]> select F1('x');

F1('x')

1

MariaDB [ez1_schema]> select F2('x');

F2('x')

1

MariaDB [ez1_schema]> select col1 from tabY where col2=F1('x');

ERROR 2013 (HY000): Lost connection to server during query

MariaDB [ez1_schema]> select F1('x');

ERROR 2006 (HY000): Server has gone away

F1('x')

1

MariaDB [ez1_schema]> select F1('x');

F1('x')

1

MariaDB [ez1_schema]> select col1 from tabY where col2=F2('x');

ERROR 2013 (HY000): Lost connection to server during query

MariaDB [ez1_schema]> exit