[jira] [Commented] (IGNITE-14593) Calcite. Support not equal expression.

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-14593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17360764#comment-17360764 ] 

Aleksey Plekhanov commented on IGNITE-14593:
--------------------------------------------

Also, the current H2-based SQL engine supports the "!=" operator, and by supporting it in the calcite-based SQL engine we can minimize compatibility issues.

To support "!=" we should override {{SqlConformance.isBangEqualAllowed}} method.

> Calcite. Support not equal expression.
> --------------------------------------
>
>                 Key: IGNITE-14593
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14593
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Stanilovsky Evgeny
>            Priority: Major
>              Labels: calcite
>
> Looks like it would be helpful to support "!=" syntax, i.e. :
> {code:java}
> UPDATE test SET a=7 WHERE id != 3
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)