[asterisk-bugs] [JIRA] (ASTERISK-24742) [patch] Improves ast_odbc_find_table function in res_odbc

[ibercom (JIRA)]

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

ibercom commented on ASTERISK-24742:
------------------------------------

This patch only fixes an anomalous behavior. It doesn't change anything.
SELECT or INSERT operation create a single command "SET SESSION ..." in database.
UPDATE operation creates two commands "SET SESSION ..." in database and it is incorrect.


> [patch] Improves ast_odbc_find_table function in res_odbc
> ---------------------------------------------------------
>
>                 Key: ASTERISK-24742
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24742
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 11.14.0
>            Reporter: ibercom
>            Assignee: ibercom
>         Attachments: patch.diff
>
>
> I was logging mysql usage with Asterisk-11 realtime and I have seen two "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED" commands before each UPDATE operation.
> Whereas, there was only one before each SELECT or INSERT operation.



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