`List` call for tables with required quals fails if used with `Left Join`

[Subhajit97]

We have table net_dns_record where domain is required to perform the LIST operation. We have a use case where we have a CSV file (domains.csv) containing a list of domains, and we will use these domains to query the net_dns_record table.

domains.csv

domain
steampipe.io

Query:

select
    Q.domain,
    N.value
from
    domains Q
left join
    net_dns_record N
    on N.domain = concat('_dmarc.', Q.domain) 
    and N.type = 'TXT'

When executing the above query, getting below error

Error: rpc error: code = Internal desc = 'List' call for table 'net_dns_record' is missing 1 required qual: column:'domain' operator: =
 (SQLSTATE HV000)

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions[bot]]

This issue was closed because it has been stalled for 90 days with no activity.