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

[Rusty Newton (JIRA)]

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

Rusty Newton commented on ASTERISK-25030:
-----------------------------------------

[~Miko95] do you have a patch you would like to submit? If so I'll leave this open while you prepare it and follow the [Patch Contribution Process|https://wiki.asterisk.org/wiki/display/AST/Patch+Contribution+Process]. Thanks!

> 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
>            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)