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

[Rudolf Faix (JIRA)]

Rudolf Faix created ASTERISK-24568:
--------------------------------------

             Summary: 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: 13.0.1, 11.14.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)