Inconsistent behaviour with `LIMIT` in subquery

[binaek]

select col from child_table where child_table.foreign_field in (select field from parent_table limit 2) limit 10 works fine

but select col from child_table where child_table.foreign_field in (select field from parent_table) limit 10 fails with 'List' call for table 'aws_s3_object' is missing 1 required qual: column:'bucket' operator: =

Note: child_table.foreign_field has {Name: "foreign_field", Require: plugin.Required} set in KeyColumns

[binaek]

select col from child_table left join child_table on child_table.field=child_table. foreign_field limit 10 also fails with 'List' call for table 'aws_s3_object' is missing 1 required qual: column:'bucket' operator: =

the above query works if I put a where parent_table.field='some_known_value'