and { only { filter_eq { all_rows ; hpfs ; partial } } ; eq { hop { filter_eq { all_rows ; hpfs ; partial } ; ntfs } ; yes v1 .2 } } = true
select the rows whose hpfs record fuzzily matches to partial . there is only one such row in the table . the ntfs record of this unqiue row is yes v1 .2 .