USE `test`;

DROP procedure IF EXISTS `testMariaBug`;

DELIMITER $$

USE `test`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `testMariaBug`()

BEGIN

       DROP  TABLE IF EXISTS tmpValues;

    CREATE  temporary TABLE tmpValues (`value` INT NOT NULL )

	select 1 `value`;

	drop table if exists tmpOutput;

	create  table tmpOutput (

		`COL` varchar(45)

	) 

	select distinct 

		 COL

	from 

		(

			select 

				test.TestFunction() as COL

			from

				tmpValues i

		) t;

END$$

DELIMITER ;

USE `test`;

DROP function IF EXISTS `TestFunction`;

DELIMITER $$

USE `test`$$

CREATE DEFINER=`root`@`localhost` FUNCTION `TestFunction`(

) RETURNS text CHARSET latin1

BEGIN

		return 'blah';

END$$

DELIMITER ;

#Executes successfully

call test.testMariaBug();

#fails with Error Code: 1146. Table 'test.tmpValues' doesn't exist

call test.testMariaBug();