[asterisk-bugs] [JIRA] (ASTERISK-26010) [patch]func_odbc: single database connection should be optional

[Alexei Gradinari (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexei Gradinari updated ASTERISK-26010:
----------------------------------------

    Description: 
func_odbc was changed in Asterisk 13.9.0 to make func_odbc use a single
database connection per DSN because of reported bug with MySQL/MariaDB LAST_INSERT_ID().

This is drawback in performance when func_odbc is used very often in dialplan.

Single database connection should be optional.

Meanwhile... even with not persistent connection the stored routine (procedure or function) can be used to get correct LAST_INSERT_ID value.


  was:
func_odbc was changed in Asterisk 13.9.0 to make func_odbc use a single
database connection per DSN because of reported bug with MySQL/MariaDB LAST_INSERT_ID().

This is drawback in performance when func_odbc is used very often in dialplan.

Single database connection should be optional.

Meanwhile... even with not persistent connection the stored routine (procedure or function) should be used to get correct LAST_INSERT_ID value.



> [patch]func_odbc: single database connection should be optional
> ---------------------------------------------------------------
>
>                 Key: ASTERISK-26010
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26010
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Functions/func_odbc
>    Affects Versions: 13.9.0
>            Reporter: Alexei Gradinari
>
> func_odbc was changed in Asterisk 13.9.0 to make func_odbc use a single
> database connection per DSN because of reported bug with MySQL/MariaDB LAST_INSERT_ID().
> This is drawback in performance when func_odbc is used very often in dialplan.
> Single database connection should be optional.
> Meanwhile... even with not persistent connection the stored routine (procedure or function) can be used to get correct LAST_INSERT_ID value.



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