[asterisk-bugs] [JIRA] (ASTERISK-23458) SQlite3: Realtime queue loading fails after PRAGMA query result

[Rusty Newton (JIRA)]

Rusty Newton created ASTERISK-23458:
---------------------------------------

             Summary: SQlite3: Realtime queue loading fails after PRAGMA query result
                 Key: ASTERISK-23458
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23458
             Project: Asterisk
          Issue Type: Bug
      Security Level: None
          Components: Applications/app_queue, Resources/res_config_sqlite3
    Affects Versions: SVN, 11.2.0
            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)