Passing dynamic argument to gman_do

Asked by laloutre87 on 2019-08-01

Hello,

I am trying to use the udf functions (version 0.6) .

When i call it like this :

select gman_do_background("test", "_", "_");

or even

select gman_do_background(CONCAT("te","st"), "_", "_");

It works, and my worker "test" procedure is triggered.

But if i try to do :

CREATE DEFINER PROCEDURE `CallGearmanBackground`(IN `jobtocall` VARCHAR(70))
     BEGIN select gman_do_background(jobtocall, "_", "_" );
END

and then

call CallGearmanBackground("test");

I get this error :

    Can't initialize function 'gman_do_background'; First argument must be a string.

I tried several type for the procedure argument (VARBINARY, TEXT, BLOB ) ... all trigger the same error.

Any way around this ?

Question information

Language:
English Edit question
Status:
Expired
For:
Gearman MySQL UDF Edit question
Assignee:
No assignee Edit question
Last query:
2019-08-01
Last reply:
2019-08-17
Launchpad Janitor (janitor) said : #1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.