[asterisk-bugs] [JIRA] (ASTERISK-26057) Not correct query for realtime dialplan in sqlite3 database

[Stepan (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stepan updated ASTERISK-26057:
------------------------------

    Description: 
Hello,

I try to configure realtime dialplan on sqlite3 engine (it has already perfectly work on mysql engine). But I got a problem that Asterisk can not find extensions on db file. I've see query in debug 
bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '\_%' AND "context" = 'statusprofi_107' AND "priority" = '1'. 
This query did not work directly on db file. But query like that 
bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '_%' AND "context" = 'statusprofi_107' AND "priority" = '1' 
works fine. I think Asterisk does not need to escaping '_' symbol for sqlite. 

[extconfig.conf|http://pastebin.com/yR9GMkpG]
[res_config_sqlite3.conf|http://pastebin.com/Uj8UWHuq]
[debug|http://pastebin.com/tv7NLggC]

Please feel free if you'll need any additional information.

  was:
Hello,

I try to configure realtime dialplan on sqlite3 engine (it has already perfectly work on mysql engine). but I got a problem that asterisk can not find extensions on db file. I've see query in debug 
bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '\_%' AND "context" = 'statusprofi_107' AND "priority" = '1'. 
This query did not work directly on db file. But query like that 
bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '_%' AND "context" = 'statusprofi_107' AND "priority" = '1' 
works fine. Asterisk does not need to escaping '_' symbol for sqlite. 

[extconfig.conf|http://pastebin.com/yR9GMkpG]
[res_config_sqlite3.conf|http://pastebin.com/Uj8UWHuq]
[debug|http://pastebin.com/tv7NLggC]

Please feel free if you'll need any additional information.


> Not correct query for realtime dialplan in sqlite3 database
> -----------------------------------------------------------
>
>                 Key: ASTERISK-26057
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26057
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_sqlite3
>    Affects Versions: 11.20.0, 11.22.0
>         Environment: Ubuntu 14.04.3, 3.13.0-44-generic, x86_64, 
> Linux Mint 17.1, 3.13.0-37-generic, x86_64
>            Reporter: Stepan
>              Labels: realtime, sqlite3
>
> Hello,
> I try to configure realtime dialplan on sqlite3 engine (it has already perfectly work on mysql engine). But I got a problem that Asterisk can not find extensions on db file. I've see query in debug 
> bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '\_%' AND "context" = 'statusprofi_107' AND "priority" = '1'. 
> This query did not work directly on db file. But query like that 
> bq. SELECT * FROM "sip_extensions" WHERE "exten" LIKE '_%' AND "context" = 'statusprofi_107' AND "priority" = '1' 
> works fine. I think Asterisk does not need to escaping '_' symbol for sqlite. 
> [extconfig.conf|http://pastebin.com/yR9GMkpG]
> [res_config_sqlite3.conf|http://pastebin.com/Uj8UWHuq]
> [debug|http://pastebin.com/tv7NLggC]
> Please feel free if you'll need any additional information.



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