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.

Sign up for GitHub

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

Jump to bottom

allow test defs that have CTEs (including those in dbt-core) #165

Closed
dataders opened this issue Oct 14, 2021 · 0 comments · Fixed by #167 or #168
Closed

allow test defs that have CTEs (including those in dbt-core) #165

dataders opened this issue Oct 14, 2021 · 0 comments · Fixed by #167 or #168

Comments

@dataders
Copy link
Collaborator

given the recent refactor of test in dbt-labs/dbt-core#3261 for v0.20.0, nested CTE definitions happened. For dbt-sqlserver users, this broke even ootb tests like accepted_values.

rather than having nested CTEs (unsupported in TSQL), #137 proposes a solution of using temp tables to for the error results, then select from the temp table result.
This was referenced Oct 14, 2021
Closed
Merged
@dataders dataders mentioned this issue Nov 5, 2021
Merged
@dataders dataders linked a pull request Nov 5, 2021 that will close this issue
small changes for 0.21.0 #168
Merged
@dataders dataders closed this as completed Sep 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

enable CTES in test defs dbt-msft/dbt-sqlserver
small changes for 0.21.0 dbt-msft/dbt-sqlserver
1 participant
@dataders