db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Boss: repair a table with two 19 features

Table b has a virtual column tax and a CHECK that is NOT ENFORCED, so one row slipped past it. Make tax price / 5, enforce and validate the check, then add the row (3, 900). Order matters: the check refuses a bad row.

task

On temp table b: change tax to price / 5, make constraint cheap enforced and validated (repair the bad row to 5000 first), and insert (3, 900).

hints