[
https://issues.apache.org/jira/browse/ASTERIXDB-3584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3584:
---------------------------------
Labels: triaged (was: )
> '!=' and '=' returns unexpected result when comparison happens across
> incompatible types
> ----------------------------------------------------------------------------------------
>
> Key: ASTERIXDB-3584
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3584
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: FUN - Functions
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Labels: triaged
>
> The '!=' and '=' operators returns unexpected result when comparison happens
> across incompatible types. For example,
> {code:java}
> // the below returns empty result.
> SELECT * FROM [2] AS t
> WHERE t NOT IN [1,"str",3];
> SELECT * FROM ["str"] AS t
> WHERE t != 4;{code}
> This is because the comparison “str” != 4 returns NULL which is converted to
> “false”.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
