[asterisk-bugs] [JIRA] (ASTERISK-25030) Avoid using LIKE when using realtime engine

[Mickael Marrache (JIRA)]

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

Mickael Marrache commented on ASTERISK-25030:
---------------------------------------------

I would not call this a feature request but an improvement. The way it is designed now complicates implementation of new realtime engines that work with databases that don't support the LIKE keyword. I encountered this issue while implementing a reatime engine working with MongoDB.

Regarding the patch contribution process, I would rather attach a patch directly to this ticket.

> Avoid using LIKE when using realtime engine
> -------------------------------------------
>
>                 Key: ASTERISK-25030
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25030
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Applications/app_directory, Applications/app_followme, Applications/app_meetme, Applications/app_queue, Channels/chan_sip/DatabaseSupport, PBX/pbx_realtime
>            Reporter: Mickael Marrache
>            Assignee: Mickael Marrache
>            Severity: Minor
>
> Avoid using LIKE when performing regex lookups using realtime engine.
> I think that the value should have a special format indicating it is a regular expression. For example, starting and ending with / (forward slash). In such case, the value should be interpreted as a regular expression by the realtime engine implementation (which may not only be a relational database that supports the well known LIKE keyword).



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