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
### SUBSTRAIT_AGGREGATE_TEST: v1.0
### SUBSTRAIT_INCLUDE: extension:io.substrait:functions_arithmetic_decimal

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

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