aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/interval_div_scalar.sql
blob: 2c9dbb8cb9a6cbe3ad9abe9019fea3c59c8a5276 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
USE plato;

SELECT
    ni / Int8("10"),
    wi / Int8("10"),
    ni / Uint8("11"),
    wi / Uint8("11"),
    ni / Int16("12"),
    wi / Int16("12"),
    ni / Uint16("13"),
    wi / Uint16("13"),
    ni / Int32("14"),
    wi / Int32("14"),
    ni / Uint32("15"),
    wi / Uint32("15"),
    ni / Int64("16"),
    wi / Int64("16"),
    ni / Uint64("17"),
    wi / Uint64("17"),
FROM Dates;

SELECT 
   Interval("P1D") / i8,
   Interval64("P1D") / i8,
   Interval("P1D") / u8,
   Interval64("P1D") / u8,
   Interval("P1D") / i16,
   Interval64("P1D") / i16,
   Interval("P1D") / u16,
   Interval64("P1D") / u16,
   Interval("P1D") / i32,
   Interval64("P1D") / i32,
   Interval("P1D") / u32,
   Interval64("P1D") / u32,
   Interval("P1D") / i64,
   Interval64("P1D") / i64,
   Interval("P1D") / u64,
   Interval64("P1D") / u64
FROM Dates;