问SQL错误[1038] [HY001]：排序内存不足，请考虑增加服务器排序缓冲区大小

EN

create PROCEDURE art_usp_Article_Search(in SearchTerm varchar(200),in SortColumn varchar(100),in SortOrder varchar(5),in PageNumber int,in PageSize int)
BEGIN
    
    
    DECLARE StartRow INT;
    DECLARE EndRow INT;
    declare NSortColumn varchar(100);
    declare NSortOrder varchar(100);
    -- calculate the starting and ending of records
    SET NSortColumn = LOWER(IFNULL(SortColumn, ''));
    SET NSortOrder = LOWER(IfNULL(SortOrder, ''));
    SET StartRow = (PageNumber - 1) * PageSize  ;    
    SET EndRow = (PageNumber * PageSize)+1      ;   
    
    WITH CTETitleResult AS (
        SELECT ROW_NUMBER() OVER (ORDER BY 
            CASE 
                WHEN (@SortColumn = 'title' AND @SortOrder='asc') THEN title
                WHEN (@SortColumn = 'date' AND @SortOrder='asc') THEN date
            end
         ) AS RowNumber
        , COUNT(*) OVER () AS TotalCount
        ,id,code,categoryId ,title,shortDescription ,description ,tags ,content,date,time,typeId,isActive,isSpecial,visited,author,imageId,statusId,created_by,updated_by,created_at,updated_at
        FROM art_article aa 
        WHERE isActive = 1
         AND (
                 (IfNULL(SearchTerm, '') = '' OR title LIKE CONCAT('%', SearchTerm, '%'))
            )
    ),CTEDescriptionResult AS (
        SELECT ROW_NUMBER() OVER (ORDER BY 
            CASE 
                WHEN (@SortColumn = 'title' AND @SortOrder='asc') THEN title
                WHEN (@SortColumn = 'date' AND @SortOrder='asc') THEN date
            end
         ) AS RowNumber
        , COUNT(*) OVER () AS TotalCount
        ,id,code,categoryId ,title,shortDescription ,description ,tags ,content,date,time,typeId,isActive,isSpecial,visited,author,imageId,statusId,created_by,updated_by,created_at,updated_at
        FROM art_article aa 
        WHERE isActive = 1
         AND (
                 (IfNULL(SearchTerm, '') = '' OR shortDescription LIKE CONCAT('%', SearchTerm, '%'))
            )
    )
    SELECT *
        FROM CTETitleResult
        WHERE RowNumber > StartRow AND RowNumber < EndRow
        union       
        SELECT *
        FROM CTEDescriptionResult
        WHERE RowNumber > StartRow AND RowNumber < EndRow
        ORDER BY RowNumber;
    
END

call art_usp_Article_Search('','title','asc',1,10)