I have a mysql database with a stored procedure with one of the parameters as a BIT datatype. I am using Postman to test.
I’ve tried multiple types of calls using GET with query string params, POST with json body, etc. and it always returns an empty set [] with a status of 200. After troubleshooting the proc, I realized it was the BIT param.
I’ve tried changing the parameter value to 0,1,true,false,yes,no,t,f,y,n. Exact same result everytime.
I am aware that I could send TEXT or INT instead. But I was wondering if somebody else has come across this or if I’m doing something incorrectly or if it’s a bug.
Thanks!