substrait-extensions 0.99.0

Packaged Substrait Extension Files
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
### SUBSTRAIT_AGGREGATE_TEST: v1.0
### SUBSTRAIT_INCLUDE: extension:io.substrait:functions_arithmetic_decimal

# basic: Basic examples without any special cases
max((20, -3, 1, -10, 0, 5)::dec<2, 0>) = 20::dec?<2, 0>
max((-32768, 32767, 20000, -30000)::dec<5, 0>) = 32767::dec?<5, 0>
max((-214748648, 214748647, 21470048, 4000000)::dec<9, 0>) = 214748647::dec?<9, 0>
max((2000000000, -3217908979, 629000000, -100000000, 0, 987654321)::dec<10, 0>) = 2000000000::dec?<10, 0>
max((2.5, 0, 5.0, -2.5, -7.5)::dec<2, 1>) = 5.0::dec?<2, 1>
max((99999999999999999999999999999999999999, 0, -99999999999999999999999999999999999998, 111111111, -76)::dec<38, 0>) = 99999999999999999999999999999999999999::dec?<38, 0>

# null_handling: Examples with null as input or output
max((Null, Null, Null)::dec<1, 0>) = null::dec?<1, 0>
max(()::dec<1, 0>) = null::dec?<1, 0>
max((2000000000, Null, 629000000, -100000000, Null, 987654321)::dec<10, 0>) = 2000000000::dec?<10, 0>
max((Null, Null)::dec<1, 0>) = null::dec?<1, 0>
max(()::dec<1, 0>) = null::dec?<1, 0>
max((99999999999999999999999999999999999999, -99999999999999999999999999999999999998, Null, 11111111111111111111111111111111111111, Null)::dec<38, 0>) = 99999999999999999999999999999999999999::dec?<38, 0>