[asterisk-bugs] [JIRA] (ASTERISK-24568) res_config_odbc fails on MS SQL Server

[Matt Jordan (JIRA)]

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

Matt Jordan commented on ASTERISK-24568:
----------------------------------------

Microsoft SQL Server receives little to no interoperability support, given its relative infrequent use with Asterisk. While this is an interoperability issue, it is unlikely to get fixed without a patch.

If you're not interested in providing a patch, this issue will most likely get closed a "Won't Fix".

Note that changing this from {{LENGTH}} to {{LEN}} is not appropriate, as that would break compatibility with other database drivers. 

> res_config_odbc fails on MS SQL Server
> --------------------------------------
>
>                 Key: ASTERISK-24568
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24568
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Resources/res_config_odbc
>    Affects Versions: 11.14.1, 13.0.1
>         Environment: OpenSuse 13.1, FreeTDS, UnixODBC, MS SQL Server
>            Reporter: Rudolf Faix
>            Severity: Minor
>
> res_config_odbc fails on SQL-Server for the following statement:
> ast_build_string(&sql, &sqlleft, "SELECT MAX(LENGTH(var_val)) FROM %s WHERE filename='%s'", table, file);
> If you exchange the word "LENGTH" to "LEN" everything is working fine:
> ast_build_string(&sql, &sqlleft, "SELECT MAX(LEN(var_val)) FROM %s WHERE filename='%s'", table, file);



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