The following SPL is returning multiple values for nmds_adapter_survey.iccid when the where clause is set to a value. It should only return the specified value.
| tstats
values(nmds_adapter_survey.iccid)
values(nmds_adapter_survey.hcar)
values(nmds_adapter_survey.c_id)
from datamodel=nmdm_survey
where nmds_adapter_survey.iccid="89014103255440210384"
Results:
Setting the where clause to any numbers for the last 4 characters returns what matches the first 16 characters. The where clause below returns the same values as the SPL where clause above.
where nmds_adapter_survey.iccid="89014103255440210000"
In the data model the iccid value is defined as a string.
We've just witnessed the exact same issue for us. Looks like tstats will return results if the first 16 characters are the same, ignoring any change beyond that. Unbelievable.