Hi Denys,
Thanks so much for looking into this . I have filed below JIRA for this
issue
https://issues.apache.org/jira/browse/HIVE-28567
Thanks,
Ratnesh
On Wed, Oct 9, 2024 at 1:45 PM Denys Kuzmenko <dkuzme...@apache.org> wrote:
> Hi Ratnesh,
>
> Thanks for reporting the issue. Would you be able to create a JIRA ticket
> with the same?
>
> I did a quick search and found escape chars being added only in case of
> direct SQL [1]
>
> {code}
> // The following syntax is required for using LIKE clause wildcards
> '_' and '%' as literals.
> if (node.operator == Operator.LIKE) {
> nodeValue0 = nodeValue0 + " ESCAPE '\\' ";
> }
> {code}
>
> Also, the syntax in the generated query seems valid [2].
> We need to investigate further.
>
> Thanks,
> Denys
>
> [1] https://issues.apache.org/jira/browse/HIVE-22900
> [2] https://mariadb.com/docs/server/ref/mdb/operators/LIKE/
>
