[asterisk-bugs] [JIRA] (ASTERISK-25746) func_odbc: Requires an additional ARG when executing via CLI and Dialplan

[Kevin Harwell (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-25746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=229827#comment-229827 ] 

Kevin Harwell commented on ASTERISK-25746:
------------------------------------------

This does not appear to be a bug. From the usage description:
{noformat}
Usage: odbc write <name> <args> <value> [exec]
       Evaluates the SQL provided in the ODBC function <name>, and
       optionally executes the function.  This function is intended for
       testing purposes.  Remember to quote arguments containing spaces.
{noformat}
The command requires both _args_ and _value_, separated by a space. The example failure only contains one of the two. In the attached screenshot the working example is shown to contain a space followed by a single quote mark (i.e. '), thus it used that as the _value_ and executed the statement.

I ran various scenarios in both the latest 13 code and also using 13.5.0 and the above behavior was the same for both.


> func_odbc: Requires an additional ARG when executing via CLI and Dialplan
> -------------------------------------------------------------------------
>
>                 Key: ASTERISK-25746
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25746
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Functions/func_odbc
>    Affects Versions: 13.7.0, 13.7.1
>         Environment: linux Ubuntu 14.0LTS 4gb Ram Mysql 5.5 
>            Reporter: Joseph Giarratano
>            Assignee: Kevin Harwell
>            Severity: Minor
>         Attachments: func_odbc_additional_arg.PNG
>
>
> 13.7 ODBC Write <Func_ODBC> <ARG> EXEC requires an additional ARG when used via CLI and through a dialplan.
> 13.5 does not require the additional Argument.
> Example:
> Working example:
> ASTERISKSERVER*CLI> odbc write TG_RMBLACKLIST  4500,' ' exec                    Affected 1 rows.  Query executed on handle 0 [asterisk-mysql]
> Failed example:
> ASTERISKSERVER*CLI> odbc write TG_RMBLACKLIST  4500 exec
> UPDATE blacklist SET blacklist_enabled=0 WHERE blacklist_callid_num=4500



--
This message was sent by Atlassian JIRA
(v6.2#6252)