Test breaking with new dbt_constraints 1.0.5 release

[Jesse-Hyperfinity]

In the latest release of dbt_constraints (1.0.5) we have noticed that our tests are failing.

Upon invesitgation, we have found that it is caused by the test compiling with two alias for the subquery:

  select
    child.product_id
  from (select * from warehouse.dev.items where product_id not like 'S%' and product_id not in (list)) dbt_subquery child

We are running this dbt build locally.

We would appreaciate help to resolve this issue.

[mjahammel]

We have experienced this as well. We have dropped back to the previous release as a result.

[Jesse-Hyperfinity]

We have experienced this as well. We have dropped back to the previous release as a result.

Yes, we have done the same for now.

[sfc-gh-dflippo]

I will investigate this today and publish a fix as soon as possible.

[sfc-gh-dflippo]

I believe I made the necessary changes but please test 1.0.6 and reopen the issue if you still are having errors.

[Jesse-Hyperfinity]

Thank you making changes!
I have tested version 1.0.6 and the same issue is occurring where the subquery is aliased as 'dbt_subquery fk_child_inner' causing the test to fail.
I am unable to reopen this issue (it states I do not have permissions).

[bjorhn]

I'm having the same problem. Seems to only happen if the test has a where filter.

[Jesse-Hyperfinity]

@sfc-gh-dflippo Just tagging to flag the previous comments so we can get this issue reopened.