My environement info:
License Level: OPEN SOURCE
DreamFactory Version: 2.12.0
System Database: mysql
Install Path: /opt/dreamfactory/
Log Path: /opt/dreamfactory/storage/logs/
Log Mode: single
Log Level: DEBUG
Cache Driver: file
Cache Path: /opt/dreamfactory/storage/framework/cache/data/
Demo: false
I’m trying to call a remote stored procedure this stored procedure with a single parameter
CREATE DEFINER=dba@% PROCEDURE sp_my_proc(
_ IN param varchar(11)_
)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ‘’
SELECT param
When I try to call the procedure in API_Docs with this request:
curl -X GET “http://xx.xx.xx.xx/api/v2/data_dev_us/_proc/sp_my_proc?param=1” -H “accept: application/json” -H “X-DreamFactory-API-Key:…”
the response return an error:
“Failed to call database stored procedure.\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘param’ in ‘field list’”,
My educated guess is that the framework doesn’t pass any parameter to the remote procedure.
As I get the same SQL Error message if I run this command in mysql client : call sp_my_proc();
Update: MariaDB host is a columnstore configured instance. I confirm that for standard MariaDB instance, the issue is not present.
Regards,
Dejan