# 486 Live Queries Returning All Records in a Data File Instead of Correct Result Set

---

If field1 is a part of multiple primary index, but not the first field from the index executing query:
select * from table1 where field1='TEST1111111' returns proper results
if request live = False and when RequestLive := True it returns all records for the file