Data.sql 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. --sanitizer ignore memory
  2. $data = AsTuple(
  3. Bool("true"),
  4. Bool("FalsE"),
  5. Int8("-128"),
  6. Int8("127"),
  7. Uint8("0"),
  8. Uint8("255"),
  9. Int16("-32768"),
  10. Int16("32767"),
  11. Uint16("0"),
  12. Uint16("65535"),
  13. Int32("-2147483648"),
  14. Int32("2147483647"),
  15. Uint32("0"),
  16. Uint32("4294967295"),
  17. Int64("-9223372036854775808"),
  18. Int64("9223372036854775807"),
  19. Uint64("0"),
  20. Uint64("18446744073709551615"),
  21. Float("0"),
  22. Float("1"),
  23. Float("-1e30"),
  24. Float("-inf"),
  25. Float("+inf"),
  26. Float("nan"),
  27. Double("0"),
  28. Double("1"),
  29. Double("-1e300"),
  30. Double("-inf"),
  31. Double("+inf"),
  32. Double("nan"),
  33. String("foo\xffbar"),
  34. Utf8("привет"),
  35. Yson("<a=1>[3;%false]"),
  36. Json(@@{"a":1,"b":null}@@),
  37. Date("2000-01-01"),
  38. Datetime("2000-01-01T01:02:03Z"),
  39. Timestamp("2000-01-01T01:02:03.4Z"),
  40. Interval("P1DT12H"),
  41. TzDate("2000-01-01,Europe/Moscow"),
  42. TzDatetime("2000-01-01T01:02:03,Europe/Moscow"),
  43. TzTimestamp("2000-01-01T01:02:03.4,Europe/Moscow"),
  44. Uuid('31323334-3536-3738-393a-3b3c3d3e3f40'),
  45. Decimal('3.1415926535897932384626433832795029', 35, 34),
  46. Decimal('-.00000000000000000000000000000000001', 35, 35),
  47. Decimal('NAN', 10, 5),
  48. Decimal('-iNf', 1, 0)
  49. );
  50. $type = CallableType(0,
  51. TypeOf($data),
  52. TypeOf($data)
  53. );
  54. $f = Python3::f($type, @@
  55. def f(x):
  56. return x
  57. @@);
  58. select $data, $f($data);