Table Writes

Start With the Table

A write starts from visible keyed rows.

highlighted = computed this step

Start with the table

A write starts from a visible keyed table.

base table first\text{base table first}

Show the base rows

The base table has 3 rows and 0 writes.

rows=3\text{rows}=3

Write examples are tiny finite row modifications; SQL dialects, transactions, constraints beyond the visible key, triggers, indexes, concurrency, performance, and product behavior are out of scope.

Start with the table: base tableidnamepoints1Ada102Ben203Cy15 writes in orderstepkindkeydetailnonenonenonenone write resultsstepkindkeystatusreasonbeforeafternonenonenonenonenonenonenone final tableidnamepoints1Ada102Ben203Cy15 write factsfactvaluebaseRowCount3writeCount0appliedCount0rejectedCount0finalRowCount3keyColumnidrowOrderkey

Read the key

The id column is the key used by later updates and deletes.

key column is id\text{key column is id}

Summary

Rows render in deterministic key order.

row order by key\text{row order by key}