You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@atlas.apache.org by "Abhishek Pal (Jira)" <ji...@apache.org> on 2023/05/12 13:27:00 UTC

[jira] [Updated] (ATLAS-4750) [Relationship Search] Relationship search isNull case doesn't consider null strings

     [ https://issues.apache.org/jira/browse/ATLAS-4750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Abhishek Pal updated ATLAS-4750:
--------------------------------
    Description: 
Currently Atlas supports relationship search where we can search entities by their relationships.
We can use various filters to search for the relationship, where one such filter is a condition of "isNull".

If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.

For example if there is are two relationships with attributes:
 * relation_X
 ** "type_str": ""
 * relation_Y
 ** "type_str": null

and we search by condition:
{code:java}
{
    "attributeName": "type_str",
    "operator": "isNull",
    "attributeValue": ""
}
{code}
we get only *relation_Y*

Whereas since *relation_X* has
{panel}
"type_str":""
{panel}
it is not treated as a null value and hence not returned.

This is also the case forĀ {panel} "operator": "notNull" {panel} where we get the *relation_X*

Ideally this should also be considered a null type

  was:
Currently Atlas supports relationship search where we can search entities by their relationships.
We can use various filters to search for the relationship, where one such filter is a condition of "isNull".

If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.

For example if there is are two relationships with attributes:
* relation_X
** "type_str": ""
* relation_Y
** "type_str": null

and we search by condition:
{code}
{
    "attributeName": "type_str",
    "operator": "isNull",
    "attributeValue": ""
}
{code}
we get only *relation_Y*

Whereas since *relation_X* has
{panel} "type_str":"" {panel}
it is not treated as a null value and hence not returned.
Ideally this should also be considered a null type


> [Relationship Search] Relationship search isNull case doesn't consider null strings
> -----------------------------------------------------------------------------------
>
>                 Key: ATLAS-4750
>                 URL: https://issues.apache.org/jira/browse/ATLAS-4750
>             Project: Atlas
>          Issue Type: Bug
>          Components:  atlas-core
>            Reporter: Abhishek Pal
>            Priority: Major
>
> Currently Atlas supports relationship search where we can search entities by their relationships.
> We can use various filters to search for the relationship, where one such filter is a condition of "isNull".
> If there are relationships where a string type attribute is set to *""* (null string), it considers this as non-null.
> For example if there is are two relationships with attributes:
>  * relation_X
>  ** "type_str": ""
>  * relation_Y
>  ** "type_str": null
> and we search by condition:
> {code:java}
> {
>     "attributeName": "type_str",
>     "operator": "isNull",
>     "attributeValue": ""
> }
> {code}
> we get only *relation_Y*
> Whereas since *relation_X* has
> {panel}
> "type_str":""
> {panel}
> it is not treated as a null value and hence not returned.
> This is also the case forĀ {panel} "operator": "notNull" {panel} where we get the *relation_X*
> Ideally this should also be considered a null type



--
This message was sent by Atlassian Jira
(v8.20.10#820010)