RowBinaryWithDefaults

import RowBinaryFormatSettings from './_snippets/common-row-binary-format-settings.md'

Description {#description}

Similar to the RowBinary format, but with an extra byte before each column that indicates if the default value should be used.

Example usage {#example-usage}

Examples:

SELECT * FROM FORMAT('RowBinaryWithDefaults', 'x UInt32 default 42, y UInt32', x'010001000000')

┌──x─┬─y─┐
│ 42 │ 1 │
└────┴───┘

• For column x there is only one byte 01 that indicates that default value should be used and no other data after this byte is provided.
• For column y data starts with byte 00 that indicates that column has actual value that should be read from the subsequent data 01000000.

Format settings {#format-settings}