Bug when using CAST or CONVERT in stored procedure

[kanoop]

I am writing a stored procedure that needs to select columns and cast them using a reasonably complicated cast.

dbForge complains that the type specifier is unexpected and refuses to compile the procedure.

If I then copy the body of the procedure into HeidiSQL (I am running against MariaDB 10.0.2) it accepts the code and the procedure functions as expected. But in dbForge I cannot save the procedure.

Simplified extract of procedure:

PROCEDURE proc_prf()
BEGIN
SELECT
ltim,
CONVERT(((ltim-186857010)/4188), INT) as sample_bin
where <...>

END

dbForge complains about the ", INT" part of the CONVERT function parameters and refuses to update the procedure.

[alexa]

Could you please provide us a screenshot of the error?

You can reply straight to our support system at supportATdevartDOTcom

[kanoop]

I've just emailed it to you.

[alexa]

Thank you for the reply.

Could you please also resend it to alexaATdevartDOTcom?

[kanoop]

Done

[alexa]

Thank you for the reply.

We have received your e-mail and are currently investigating this issue. We will answer you as soon as possible.