So, let’s look at the rpm_package_files table. This table returns a list of all files in an rpm, or, in all rpms.
Let’s allow a reasonable implementation. clearly there’s an index on rpm. It would be folly to return all data for all queries and let sqlite filter.
But, a row needs more than just the rpm name to be unique. After all, an rpm has multiple files in it/ This leads to thinking the uniqness of the row is the rpm+filename.
Though the underlying implementation presumably only takes rpm name in as a constraint.