Join returns zero rows when a required key column is used on one table

[e-gineer]

~/src/steampipe-plugin-grafana $ STEAMPIPE_LOG=info steampipe query
Welcome to Steampipe v0.8.0-rc.0
For more information, type .help
> select * from grafana_user
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
| id | email             | name   | login  | theme  | org_id | is_admin | is_disabled | is_external | updated_at          | created_at          | last_seen_at        | last_seen_at_age 
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
| 1  | admin@localhost   | <null> | admin  | <null> | 1      | true     | false       | false       | 2021-09-03 22:38:31 | 2021-09-03 22:37:13 | 2021-09-04 01:52:31 | < 1m             
| 2  | [email protected] | Nathan | nathan | <null> | 1      | false    | false       | false       | 2021-09-03 22:39:30 | 2021-09-03 22:39:30 | 2021-09-04 00:38:21 | 1h               
+----+-------------------+--------+--------+--------+--------+----------+-------------+-------------+---------------------+---------------------+---------------------+------------------
> 
> select * from grafana_folder_permission where folder_uid = 'AvAWlQ47z'
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
| folder_uid | user_id | team_id | role   | is_folder | permission | permission_name | folder_id | dashboard_id |
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
| AvAWlQ47z  | <null>  | <null>  | Viewer | true      | 1          | View            | 2         | <null>       |
| AvAWlQ47z  | 2       | <null>  | <null> | true      | 1          | View            | 2         | <null>       |
| AvAWlQ47z  | <null>  | <null>  | Editor | true      | 2          | Edit            | 2         | <null>       |
| AvAWlQ47z  | <null>  | 1       | <null> | true      | 2          | Edit            | 2         | <null>       |
+------------+---------+---------+--------+-----------+------------+-----------------+-----------+--------------+
> select * from grafana_folder_permission as fp, grafana_user as u where fp.folder_uid = 'AvAWlQ47z' and fp.user_id = u.id
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
| folder_uid | user_id | team_id | role | is_folder | permission | permission_name | folder_id | dashboard_id | id | email | name | login | theme | org_id | is_admin | is_disabled | is_
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
+------------+---------+---------+------+-----------+------------+-----------------+-----------+--------------+----+-------+------+-------+-------+--------+----------+-------------+----
> 
> 
~/src/steampipe-plugin-grafana $ 

I'm expecting one row to be returned by the join.

Here is the INFO level logging:

2021/09/03 21:53:16 [INFO] 
******************************************************

		steampipe postgres fdw init

******************************************************
2021/09/03 21:53:16 [INFO] Log level info
2021-09-03T21:53:16.243-0400 [INFO]  hub: query cache created
2021-09-03T21:53:16.266-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_user'
2021-09-03T21:53:16.266-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:53:16.266-0400 [INFO]  hub: --------
2021-09-03T21:53:16.266-0400 [INFO]  hub: no quals
2021-09-03T21:53:16.266-0400 [INFO]  hub: --------
2021-09-03T21:53:16.266-0400 [INFO]  hub: CACHE MISS - no index
2021-09-03T21:53:16.266-0400 [INFO]  hub: StartScan
  table: grafana_user
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  Concurrency Summary
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  getUser                       : 2
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  ------------------------------------
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  Total                         : 2
2021-09-03T21:53:16.332-0400 [INFO]  plugin.steampipe-plugin-grafana.plugin: [INFO]  ------------------------------------
2021-09-03T21:53:16.333-0400 [INFO]  hub: adding 2 rows to cache
2021-09-04 01:53:16.333 GMT [57147] LOG:  statement: COMMIT
2021-09-04 01:53:43.443 GMT [57147] LOG:  statement: BEGIN READ WRITE
2021-09-04 01:53:43.443 GMT [57147] LOG:  statement: select * from grafana_folder_permission where folder_uid = 'AvAWlQ47z'
2021-09-03T21:53:43.444-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:53:43.444-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:53:43.444-0400 [INFO]  hub: connection 'grafana', table 'grafana_folder_permission', quals 
----------------------------------------------------------------
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
----------------------------------------------------------------
2021-09-03T21:53:43.444-0400 [INFO]  hub: CACHE MISS - no index
2021-09-03T21:53:43.444-0400 [INFO]  hub: StartScan
  table: grafana_folder_permission
2021-09-03T21:53:43.464-0400 [INFO]  hub: adding 4 rows to cache
2021-09-04 01:53:43.465 GMT [57147] LOG:  statement: COMMIT
2021-09-04 01:54:38.984 GMT [57147] LOG:  statement: BEGIN READ WRITE
2021-09-04 01:54:38.985 GMT [57147] LOG:  statement: select * from grafana_folder_permission as fp, grafana_user as u where fp.folder_uid = 'AvAWlQ47z' and fp.user_id = u.id
2021-09-03T21:54:38.985-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_user'
2021-09-03T21:54:38.985-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.985-0400 [INFO]  hub: --------
2021-09-03T21:54:38.985-0400 [INFO]  hub: no quals
2021-09-03T21:54:38.985-0400 [INFO]  hub: --------
2021-09-03T21:54:38.986-0400 [INFO]  hub: CACHE HIT
2021-09-03T21:54:38.986-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:38.986-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.986-0400 [INFO]  hub: connection 'grafana', table 'grafana_folder_permission', quals 
----------------------------------------------------------------
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
	Column: user_id, Operator: '=', Value: '0'
----------------------------------------------------------------
2021-09-03T21:54:38.986-0400 [INFO]  hub: CACHE MISS - no index
2021-09-03T21:54:38.986-0400 [INFO]  hub: StartScan
  table: grafana_folder_permission
2021-09-03T21:54:38.986-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:38.986-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:38.986-0400 [INFO]  hub: connection 'grafana', table 'grafana_folder_permission', quals 
----------------------------------------------------------------
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
	Column: user_id, Operator: '=', Value: '1'
----------------------------------------------------------------
2021-09-03T21:54:38.986-0400 [INFO]  hub: CACHE MISS - no index
2021-09-03T21:54:38.986-0400 [INFO]  hub: StartScan
  table: grafana_folder_permission
2021-09-03T21:54:39.022-0400 [INFO]  hub: goFdwBeginForeignScan, connection 'grafana', table 'grafana_folder_permission'
2021-09-03T21:54:39.022-0400 [INFO]  hub: executing query for connection grafana, caching ENABLED with TTL 300 seconds
2021-09-03T21:54:39.022-0400 [INFO]  hub: connection 'grafana', table 'grafana_folder_permission', quals 
----------------------------------------------------------------
	Column: user_id, Operator: '=', Value: '2'
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
	Column: folder_uid, Operator: '=', Value: 'AvAWlQ47z'
----------------------------------------------------------------
2021-09-03T21:54:39.022-0400 [INFO]  hub: CACHE HIT
2021-09-04 01:54:39.023 GMT [57147] LOG:  statement: COMMIT
2021-09-03T21:54:44.620-0400 [INFO]  hub: 2 CACHE HITS
2021-09-03T21:54:44.620-0400 [INFO]  hub: 4 CACHE MISSES
2021-09-04 01:54:44.708 GMT [57186] LOG:  statement: ;
2021-09-04 01:54:44.708 GMT [57186] LOG:  statement: select count(*) from pg_stat_activity where client_port IS NOT NULL and application_name='steampipe' and backend_type='client backend';
2021-09-04 01:54:44.750 GMT [57115] LOG:  received smart shutdown request
2021-09-04 01:54:44.752 GMT [57115] LOG:  background worker "logical replication launcher" (PID 57126) exited with exit code 1
2021-09-04 01:54:44.752 GMT [57122] LOG:  shutting down
2021-09-04 01:54:44.757 GMT [57115] LOG:  database system is shut down

[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.