C2 (2 points)

https://knobit.org/id/task/dm-ddl-review-deploy/C2

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dm-ddl-review-deploy/C2
rdfs:label	C2 (2 points) en
schema:hasPart	dm-ddl-review-deploy C2: SQL approved by reading, never executed
schema:identifier	C2
schema:position	2
schema:text	SQL reviewed without being run, 1 each: (a) CI executes only Postgres; the SQL Server, Oracle, MySQL and Databricks scripts were approved by reading, and the answer requires every configured dialect to be executed against an empty database (a container or a scratch schema) in CI, with the drop script run afterwards, as this stage's gate; (b) it ties that to the evidence - names at least one defect in this set that an execution on a read-approved target would have stopped (the ~ operator on the four non-Postgres targets, the TEXT index on MySQL) - and does not claim that Postgres was never run. en

Used by

has question	Card and account mart DDL on five engines, with its release evidence (DDL review skills)
schema:isPartOf	dm-ddl-review-deploy C2: SQL approved by reading, never executed