I3 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/I3
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-ddl-review-deploy/I3 |
| rdfs:label | I3 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy I3: reserved word as a column name |
| schema:identifier | I3 |
| schema:position | 6 |
| schema:text | Reserved word as an identifier, 1 each: (a) dim_card.limit is a reserved word on Postgres and MySQL (and in ISO 9075); the generator quotes every identifier, so the DDL deploys, and the first hand-written query that does not quote it fails - the answer says this rather than claiming the CREATE TABLE fails; (b) renamed in the model (card_limit_amount or similar, following the naming convention), with the reserved-word check run against every configured dialect rather than only the development one. 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 I3: reserved word as a column name |