BlockStreamFormat.sql 755 B

1234567891011121314151617181920
  1. /* XXX: Enable UseBlocks pragma and provide input to trigger block execution. */
  2. PRAGMA UseBlocks;
  3. SELECT
  4. value,
  5. String::RightPad(value, 20) AS right_pad,
  6. String::LeftPad(value, 20) AS left_pad,
  7. String::RightPad(value, 20, "0") AS right_pad_zero,
  8. String::LeftPad(value, 20, "0") AS left_pad_zero,
  9. String::Hex(biguint) AS hex,
  10. String::SHex(negint) AS shex,
  11. String::Bin(biguint) AS bin,
  12. String::SBin(negint) AS sbin,
  13. String::HexText(value) AS hex_text,
  14. String::BinText(value) AS bin_text,
  15. String::HumanReadableDuration(biguint) AS duration,
  16. String::HumanReadableQuantity(biguint) AS quantity,
  17. String::HumanReadableBytes(biguint) AS bytes,
  18. String::Prec(negint / 12345.6789, 4) AS prec
  19. FROM Input;