[asterisk-bugs] [JIRA] (ASTERISK-23457) sqlite3: realtime queue fails after pragma result

[Scott Griepentrog (JIRA)]

Scott Griepentrog created ASTERISK-23457:
--------------------------------------------

             Summary: sqlite3: realtime queue fails after pragma result
                 Key: ASTERISK-23457
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23457
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
    Affects Versions: 11.2.0, SVN
            Reporter: Scott Griepentrog
            Severity: Minor


When loading queues and queue_members, the function realtime_sqlite3_execute_handle() issues sql command "PRAGMA table_info("queue_members") via sqlite3_exec(), and then fails due to a zero return value from sqlite3_changes(), which then causes it to presume the need to create the table and columns that already exist.

The error
{noformat}
res_config_sqlite3.c: Could not execute ')': near ")": syntax error
{noformat}
appears when this issue occurs.  The error is caused by attempting to create a list of columns that don't exist when they've already been passed to the add_column_name() callback issued by sqlite3_exec().




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