【踩坑】存储过程入参为NULL 报错

自己写了个存储过程代码如下

CREATE DEFINER=`pan`@`%` PROCEDURE `get_app_page_by_condition`(
	IN `key_word` VARCHAR ( 20 ),
	IN `category_name_id` BIGINT,
	IN `developer_id` BIGINT,
	IN `is_enable` TINYINT,
	IN `is_inverted` TINYINT,
	IN `tag` VARCHAR ( 20 ),
	IN `start_num` INT,
	IN `page_size` INT 
	)
BEGIN#Routine body goes here...
	DECLARE
		cate_lv INT;
	SELECT
		lv INTO cate_lv 
	FROM
		category_name 
	WHERE
		id = category_name_id;
	
	select developer_id;
	
		SET @keyword_condition = NULL;
		SET @category_condition = NULL;
		SET @developer_id_condition = NULL;
		SET @is_enable_condition = NULL;
		SET @is_inverted_condition = NULL;
		SET @tag_condition = NULL;
		SET @page_condition = NULL;
	
	SET @base_result_sql = '	SELECT   app.id,
            app_name,

            av.id as app_version_id,