Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
Subhajit97 opened this issue Jul 26, 2022 · 0 comments
Open
Assignees

Comments

@Subhajit97
Copy link

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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants