MariaDb ColumnStore stored procedure returns Expected to read 4 header bytes but only received 0

70 Views Asked by At

I m calling a stored procedure using the following code:

dbContext.Database.ExecuteSqlRaw(sqlCommand.ToString());

I have the following Stored Procedure:

CREATE DEFINER=`user11`@`%` PROCEDURE `UpdateDimDateEntity`(IN DimDateKey INT,
     IN FullDate DATE,
     IN DayName NVARCHAR(50),
     IN DayOfWeek SMALLINT)
BEGIN
 UPDATE DimDate
    SET
        FullDate = FullDate,
        DayName = DayName,
        DayOfWeek = DayOfWeek       
    WHERE DimDate.DimDateKey = DimDateKey;
END

The return type of ExecuteSqlRaw is int (4 bytes) and I read at this article that MariaDb ColumnStore accepts definition of stored procedures with only input arguments and a single SELECT query does not return anything and that I suspect that it does not return anything the method expects a 4 byte message it does not receive it and it fails.

How can I call a SP from C# without waiting for number of affected rows?

0

There are 0 best solutions below