[asterisk-bugs] [JIRA] (ASTERISK-25628) res_config_pgsql: Incorrect behavior when column does not exist

[Dmitry (JIRA)]

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

Dmitry commented on ASTERISK-25628:
-----------------------------------

when column does not exist and requirements=warn require_pgsql() return 0 (not -1)
so it does not work correctly logging queue = incorrectly selected column for insert and =>

 res_config_pgsql.c:168 in int _pgsql_exec(): PostgreSQL RealTime: Query Failed: INSERT INTO asterisk.queue_log (time, data5, data4, data3, data2, data1, event, agent, queuename, callid) VALUES (...)

 res_config_pgsql.c:169 in int _pgsql_exec(): PostgreSQL RealTime: Query Failed because: ERROR:  column "data5" of relation "queue_log" does not exist LINE 1: INSERT INTO asterisk.queue_log ...




> res_config_pgsql: Incorrect behavior when column does not exist
> ---------------------------------------------------------------
>
>                 Key: ASTERISK-25628
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25628
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_pgsql
>    Affects Versions: 13.6.0
>            Reporter: Dmitry
>            Assignee: Dmitry
>            Severity: Minor
>         Attachments: patch.txt
>
>
> When column not exist in database require_pgsql() return 0
> and other code does not work properly (for example in main/logger.c logger_queue_rt_start()).



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