Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm calling a proceedure in MariaDB. I noticed that when the query is parameterized, it doesn't send the values I added to the parameters. So I created this sample proceedure where it returns the values it received back.
CREATE DEFINER=`root`@`localhost` PROCEDURE `reporting_db`.`proc_Hello`(
IN `P_StartDate` DATE,
IN `P_EndDate` DATE
)
DETERMINISTIC
begin
SELECT `P_StartDate`, `P_EndDate`;
END
When I hardcode the start date and the end date, I get the result back correctly. (Here, start date parameter has a default value of 2020-01-01)
When parameterized however, query sends null instead.
For parameterized start date, I get back null.
I tried changing start date and end date to varchar(50) in the proceedure but result is the same. What is wrong here?
Hi,
I have the same issue. Did you find any solution for this?
Thank you!
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
58 | |
45 | |
42 |