Columns of type 'N' having value 0 does not appear in get_item, scan.

[Ajaya Agrawal]

There could be a similar bug in the calls which fetches data from MagnetoDB.

table_schema:
{
    "table_name": "email_data",
    "attribute_definitions": [
        {
            "attribute_name": "a",
            "attribute_type": "S"
        },
        {
            "attribute_name": "b",
            "attribute_type": "N"
        }

    ],
    "key_schema": [
        {
            "attribute_name": "a",
            "key_type": "HASH"
        },
        {
            "attribute_name": "b",
            "key_type": "RANGE"
        }
    ]

}

put_item:
{
    "item": {
        "a": {
            "S": "a"
        },
        "b": {
            "N": 0
        }
    }
}

get_item:
{
   "consistent_read": true,
   "key":
       {

           "a": {
               "S": "a"
            },
            "b": {
            "N": 0
            }
       }
}

result of get_item:
{
    "item": {
        "a": {
            "S": "a"
        }
    }
}
expected result:
{
    "item": {
        "a": {
            "S": "a"
        }
        "b": {
            "N": 0
        }
     }
}

[Andrii Ostapenko (aostapenko)]

Could you please add more details: expected and actual behavior

[Ajaya Agrawal (ajayaa)]

This is also seen in scan request. The row is returned but the column having values 0 is not there at all. If you send a filter in scan on that column then the result is empty.