[asterisk-bugs] [JIRA] (ASTERISK-28065) res_odbc: missing SQL error diagnostic

[Asterisk Team (JIRA)]

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

Asterisk Team commented on ASTERISK-28065:
------------------------------------------

Thanks for creating a report! The issue has entered the triage process. That means the issue will wait in this status until a Bug Marshal has an opportunity to review the issue. Once the issue has been reviewed you will receive comments regarding the next steps towards resolution.

A good first step is for you to review the [Asterisk Issue Guidelines|https://wiki.asterisk.org/wiki/display/AST/Asterisk+Issue+Guidelines] if you haven't already. The guidelines detail what is expected from an Asterisk issue report.

Then, if you are submitting a patch, please review the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process].

> res_odbc: missing SQL error diagnostic
> --------------------------------------
>
>                 Key: ASTERISK-28065
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28065
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 13.23.0
>         Environment: Linux Slackware-64 14.2 
> unixODBC 2.3.7pre
> mysql-connector-odbc 5.3.11
> mysql 5.6.41
>            Reporter: Alexei Gradinari
>
> On SQL error there is not diagnostic information about this error.
> There is only
> WARNING res_odbc.c: SQL Execute error -1!
> The function ast_odbc_print_errors calls a SQLGetDiagField to get the number of available diagnostic records, but the SQLGetDiagField returns 0.
> However SQLGetDiagRec could return one diagnostic records in this case.
> Looking at many example of getting diagnostics error information I found out that the best way it's to use only SQLGetDiagRec while it returns SQL_SUCCESS.



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