interval_mul_scalar.sql 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. USE plato;
  2. SELECT
  3. ni * Int8("10"),
  4. wi * Int8("10"),
  5. ni * Uint8("11"),
  6. wi * Uint8("11"),
  7. ni * Int16("12"),
  8. wi * Int16("12"),
  9. ni * Uint16("13"),
  10. wi * Uint16("13"),
  11. ni * Int32("14"),
  12. wi * Int32("14"),
  13. ni * Uint32("15"),
  14. wi * Uint32("15"),
  15. ni * Int64("16"),
  16. wi * Int64("16"),
  17. ni * Uint64("17"),
  18. wi * Uint64("17"),
  19. FROM Dates;
  20. SELECT
  21. Int8("10") * ni,
  22. Int8("10") * wi,
  23. Uint8("11") * ni,
  24. Uint8("11") * wi,
  25. Int16("12") * ni,
  26. Int16("12") * wi,
  27. Uint16("13") * ni,
  28. Uint16("13") * wi,
  29. Int32("14") * ni,
  30. Int32("14") * wi,
  31. Uint32("15") * ni,
  32. Uint32("15") * wi,
  33. Int64("16") * ni,
  34. Int64("16") * wi,
  35. Uint64("17") * ni,
  36. Uint64("17") * wi
  37. FROM Dates;
  38. SELECT
  39. Interval("P1D") * i8,
  40. Interval64("P1D") * i8,
  41. Interval("P1D") * u8,
  42. Interval64("P1D") * u8,
  43. Interval("P1D") * i16,
  44. Interval64("P1D") * i16,
  45. Interval("P1D") * u16,
  46. Interval64("P1D") * u16,
  47. Interval("P1D") * i32,
  48. Interval64("P1D") * i32,
  49. Interval("P1D") * u32,
  50. Interval64("P1D") * u32,
  51. Interval("P1D") * i64,
  52. Interval64("P1D") * i64,
  53. Interval("P1D") * u64,
  54. Interval64("P1D") * u64
  55. FROM Dates;
  56. SELECT
  57. i8 * Interval("P1D"),
  58. i8 * Interval64("P1D"),
  59. u8 * Interval("P1D"),
  60. u8 * Interval64("P1D"),
  61. i16 * Interval("P1D"),
  62. i16 * Interval64("P1D"),
  63. u16 * Interval("P1D"),
  64. u16 * Interval64("P1D"),
  65. i32 * Interval("P1D"),
  66. i32 * Interval64("P1D"),
  67. u32 * Interval("P1D"),
  68. u32 * Interval64("P1D"),
  69. i64 * Interval("P1D"),
  70. i64 * Interval64("P1D"),
  71. u64 * Interval("P1D"),
  72. u64 * Interval64("P1D")
  73. FROM Dates;