BYTES

Dynamic-length raw byte array used for calldata, return data, revert data, and packed ABI payloads. 0x-prefixed VARCHAR casts parse exact hex bytes; VARCHAR/hex output is for inspection, not numeric math.

Family
Blob-backed
Physical
BLOB
Used by
25 functions
Examples
0 samples

Used by functions

Derived from generated function parameters and return types.

Input and output

  • bytes_concat_agg

    Concatenates BYTES chunks in aggregate input order, preserving an aggregate ORDER BY clause when supplied.

    scalar function Offline 1 overload
  • create_access_list

    Builds an EIP-2930 access list for a transaction request. Each result row identifies an accessed account or storage slot and includes request status.

    table function Live RPC RPC 3 overloads
  • raw_call

    Executes an isolated EVM call and returns the raw response bytes. Without a CLIENT, it builds a reusable READ and does not execute the call.

    scalar function Live RPC RPC 4 overloads

Accepted as input

  • assume_code

    Declares exact EVM runtime bytecode used to evaluate a PROGRAM offline.

    scalar function Offline 1 overload
  • call_decode

    Decodes selector-free function return data into typed SQL columns defined by the function's ABI outputs.

    table function Offline 1 overload
  • decode_function_data

    Validates and decodes selector-prefixed function calldata into typed SQL columns defined by the function's ABI inputs.

    table function Offline 1 overload
  • error_decode_json

    Returns a status-rich JSON description of EVM revert bytes; supply an ABI to decode matching custom errors.

    scalar function Offline 3 overloads
  • event_decode

    Returns one EVM log as ABI-derived typed columns; use it when a constant event ABI can define the SQL schema at bind time.

    table function Offline 2 overloads
  • evm_decode_log_for

    Returns a log diagnostic using the ABI registered locally for a chain, emitter, and block; use it when ABI selection depends on contract context.

    scalar function Offline 1 overload
  • evm_decode_revert_for

    Returns a revert diagnostic using the ABI registered locally for a chain, contract, and block; use it when ABI selection depends on contract context.

    scalar function Offline 1 overload
  • evm_disassemble

    Decodes bytecode with evmone advanced static analysis fixed to the Osaka revision. It exposes 27 instruction, PUSH, block, stack, gas, storage, and call-hint columns without executing the code.

    table function Offline 1 overload
  • execute_call

    Builds one raw EVM call step for sequential, non-atomic PROGRAM execution.

    scalar function Offline 2 overloads
  • length

    Returns the number of bytes in a BLOB or BLOB-backed EVM value such as ADDRESS, BYTES32, UINT256, or INT256.

    scalar function Offline 1 overload
  • log_decode_json

    Returns a status-rich JSON description of one EVM log; use it when unknown, ambiguous, and malformed logs must remain distinguishable.

    scalar function Offline 2 overloads

Returned as output

  • abi_encode_packed

    Encodes scalar values with Solidity's packed ABI rules. The result has no selector, offsets, lengths, or 32-byte padding.

    scalar function Offline 1 overload
  • code_at

    Returns deployed bytecode for an address in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.

    scalar function Live RPC RPC 2 overloads
  • compile

    Compiles Solidity or Vyper source through the configured external service and normalizes one row per returned contract artifact. It performs network I/O and sends the supplied source to that service.

    table function External Service 4 overloads
  • encode_function_args

    Encodes function arguments with standard ABI encoding and omits the 4-byte function selector.

    scalar function Offline 1 overload
  • encode_function_data

    Encodes function arguments as contract calldata: the function's 4-byte selector followed by standard ABI argument bytes.

    scalar function Offline 1 overload
  • evm_pack_uint_be

    Packs a UINT256 value into an exact-width big-endian BYTES value for ABI-adjacent byte construction.

    scalar function Offline 1 overload
  • get_block

    Returns block metadata for a block number, tag, or hash. Set include_transactions to request expanded transaction objects in transactions_full; otherwise transactions contains hashes.

    table function Live RPC RPC 5 overloads
  • get_logs

    Returns EVM event logs matching the supplied emitter, block, and topic filters. Supply a human-readable event signature or JSON ABI to append typed decoded fields.

    table function Live RPC RPC 12 overloads
  • get_transaction

    Returns transaction fields and available receipt metadata for a transaction hash. The client must point to the chain where the transaction exists.

    table function Live RPC RPC 2 overloads
  • get_transaction_logs

    Returns logs from a transaction receipt, optionally filtered by emitter or indexed topics. Supply an event signature or JSON ABI to append typed decoded fields.

    table function Live RPC RPC 6 overloads
  • read_contract_multicall

    Executes a table of encoded contract reads through Multicall3 and returns one diagnostic row per input call. Results separately report batch execution and target-call success.

    table function Live RPC RPC 1 overload