I am trying to find the name of this feature that is implemented with SQL Databases:
Given a Record $R^1$ in table having two values for two different fields, e.g. Let value of field 1 $F_1$ be $V_1$, Let value of field 2 $F_2$ be $V_2$ A any query requiring records s.t. $F_1 = V_1$ should contain $R^1$. Also any query requiring records s.t. $F_2 = V_2$ should also contain $R^1$.
If a database does not have the above property then it definitely considered broken.
My question is what is the name for this kind of consistency?