@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

<https://knobit.org/id/task/dm-ddl-review-deploy/I2> a edu:Question ;
    rdfs:label "I2 (2 points)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    schema:hasPart <https://knobit.org/id/register/data-modelling#I-822> ;
    schema:identifier "I2" ;
    schema:position 5 ;
    schema:text "Expression running on one engine only, 1 each: (a) ck_fact_payment_reference uses the Postgres regex operator ~, which the generator passes through verbatim, so the constraint deploys on Postgres and fails on SQL Server, Oracle, MySQL and Databricks; (b) the fix is in the model: a portable expression (LENGTH(payment_reference) BETWEEN 8 AND 24, or comparisons and IN) as the constraint, and the pattern kept as a validity DQ rule - not a per-dialect edit of the SQL and not dropping the rule."@en .

edu:Question rdfs:label "Question"@en,
        "Küsimus"@et .

<https://knobit.org/id/register/data-modelling#I-822> rdfs:label "dm-ddl-review-deploy I2: regex check running on one engine only"@en .