SELECT Lists

Literal Output Values

Literal select items add a constant cell to each row.

highlighted = computed this step

Literal output values

A SELECT list can put the same exact literal value beside every row.

literal output\text{literal output}

Read literal rows

The literal appears in all 4 output rows.

literal rows=4\text{literal rows}=4

SELECT-list examples are tiny finite-table transforms; DISTINCT, aggregation, type coercion, optimizer behavior, and database-product claims are out of scope.

Literal output values: base rowsitemqtybonusstatuspen31openmug20opencup21closedtagNULL1open SELECT list itemspositionkindsourceoutput0columnitemitem1literalliteral inventorykind SELECT output rowsitemkindpeninventorymuginventorycupinventorytaginventory SELECT factsfactvalueinputRowCount4outputRowCount4outputColumnCount2duplicateOutputRows0rowOrdersource_orderdistinctAppliedno

No hidden lookup

The literal value is pinned in the select item, not read from another table.

pinned literal\text{pinned literal}

Summary

Literal select items add a constant cell to each row.

constant per row\text{constant per row}