DataFusion 55.0.0
Substrait consumer: datafusion.substrait 55.0.0
Run in this repository's CI, 2026-10-24 17:22 UTC · the CI run
53.8%Overall
71.2%Functions
36.4%TPC-H
Findings
What fails and why, grouped by cause. Each finding lists every case it affects. Upstream issue links are maintained in docs/engine-findings.yaml.
Substrait consumer gaps (536) Failing queries (14) Engine results that differ from the Substrait definition (118) Not tested yet: this repository's tooling (238) Option modes the engine does not claim (135)
Substrait consumer gaps
These cases fail when run as Substrait plans but pass as the engine's own SQL (or were not run as SQL), so the gap is in the engine's Substrait consumer.
The consumer does not map these functions
Not yet reported upstream
The same cases pass as DataFusion SQL where DataFusion has the function; the consumer has no mapping from the Substrait name.
Functions: regexp_match_substring (46), regexp_count_substring (45), sign (41), shift_right (34), regexp_string_split (34), bitwise_not (33), shift_right_unsigned (31), add_intervals (25), is_finite (24), string_split (20), shift_left (16), is_infinite (16)
Exception: DataFusion error: This feature is not implemented: Unsupported function name: "bitwise_not"
All 365 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/bitwise_not.test:5 | bitwise_not(0::i8) | -1::i8 | |
| arithmetic/bitwise_not.test:6 | bitwise_not(1::i8) | -2::i8 | |
| arithmetic/bitwise_not.test:7 | bitwise_not(-127::i8) | 126::i8 | |
| arithmetic/bitwise_not.test:8 | bitwise_not(31766::i16) | -31767::i16 | |
| arithmetic/bitwise_not.test:9 | bitwise_not(-31766::i16) | 31765::i16 | |
| arithmetic/bitwise_not.test:10 | bitwise_not(2147483647::i32) | -2147483648::i32 | |
| arithmetic/bitwise_not.test:11 | bitwise_not(9223372036854775807::i64) | -9223372036854775808::i64 | |
| arithmetic/bitwise_not.test:12 | bitwise_not(-9223372036854775807::i64) | 9223372036854775806::i64 | |
| arithmetic/bitwise_not.test:13 | bitwise_not(null::i64?) | null::i64? | |
| arithmetic/shift_left.test:5 | shift_left(2::i32, 1::i32) | 4::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:6 | shift_left(511::i32, 8::i32) | 130816::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:7 | shift_left(301989888::i64, 3::i32) | 2415919104::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:8 | shift_left(301989888::i64, 8::i32) | 77309411328::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:9 | shift_left(-3::i32, 1::i32) | -6::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:10 | shift_left(-3::i32, 2::i32) | -12::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:11 | shift_left(-3::i64, 1::i32) | -6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:12 | shift_left(-3::i64, 2::i32) | -12::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:13 | shift_left(null::i64?, 2::i32) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:14 | shift_left(127::i64, null::i32?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_right.test:5 | shift_right(2::i32, 1::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:6 | shift_right(1024::i32, 8::i32) | 4::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:7 | shift_right(301989888::i64, 3::i32) | 37748736::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:8 | shift_right(301989888::i64, 16::i32) | 4608::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:9 | shift_right(-3::i32, 1::i32) | -2::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:10 | shift_right(-3::i32, 2::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:11 | shift_right(-3::i64, 1::i32) | -2::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:12 | shift_right(-3::i64, 2::i32) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:13 | shift_right(null::i64?, 2::i32) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:14 | shift_right(127::i64, null::i32?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right_unsigned.test:5 | shift_right_unsigned(2::i32, 1::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:6 | shift_right_unsigned(1024::i32, 8::i32) | 4::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:7 | shift_right_unsigned(301989888::i64, 3::i32) | 37748736::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:8 | shift_right_unsigned(301989888::i64, 16::i32) | 4608::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:9 | shift_right_unsigned(-3::i32, 1::i32) | 2147483646::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:10 | shift_right_unsigned(-3::i32, 2::i32) | 1073741823::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:11 | shift_right_unsigned(-3::i64, 1::i32) | 9223372036854775806::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:12 | shift_right_unsigned(-3::i64, 2::i32) | 4611686018427387903::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:13 | shift_right_unsigned(null::i64?, 2::i32) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:14 | shift_right_unsigned(127::i64, null::i32?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| comparison/is_finite.test:5 | is_finite(0.0::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:6 | is_finite(0.55::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:7 | is_finite(1000.000000000001::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:8 | is_finite(-inf::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:9 | is_finite(inf::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:10 | is_finite(null::fp64?) | null::bool? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_infinite.test:5 | is_infinite(0.0::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:6 | is_infinite(0.55::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:7 | is_infinite(1000.000000000001::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:8 | is_infinite(-inf::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:9 | is_infinite(inf::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:10 | is_infinite(null::fp64?) | null::bool? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| datetime/add_intervals.test:5 | add_intervals(PT10H::iday, PT5H::iday) | P0DT15H0M0S::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:6 | add_intervals(P10D::iday, P5D::iday) | P15D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:7 | add_intervals(P1D::iday, PT10H::iday) | P1DT10H0M0S::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:10 | add_intervals(null::iyear?, P1Y::iyear) | null::iyear? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:11 | add_intervals(null::iday?, P1D::iday) | null::iday? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| string/regexp_count_substring.test:5 | regexp_count_substring('foobarboopzoo'::str, 'o{1,}'::str, 1::i64) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:6 | regexp_count_substring('foobarboopzoo'::str, 'o{1}'::str, 1::i64) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:7 | regexp_count_substring('abcabcacb'::str, '[bc]'::str, 1::i64) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:8 | regexp_count_substring('abcdefc'::str, '(.*)c'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:11 | regexp_count_substring('foobarboopzoo'::fchar<13>, 'o{1,}'::fchar<5>, 1::i64) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:12 | regexp_count_substring('foobarboopzoo'::str, 'o{1,}'::str) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:13 | regexp_count_substring('foobarboopzoo'::str, 'o{1}'::str) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:14 | regexp_count_substring('abcabcacb'::str, '[bc]'::str) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:15 | regexp_count_substring('abcdefc'::str, '(.*)c'::str) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:18 | regexp_count_substring('foobarboopzoo'::fchar<13>, 'o{1,}'::fchar<5>) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:21 | regexp_count_substring('Hello'::str, null::str?, 1::i64) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:22 | regexp_count_substring(null::str?, ' '::str, 1::i64) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:23 | regexp_count_substring('Hello'::str, null::str?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:24 | regexp_count_substring(null::str?, ' '::str) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:27 | regexp_count_substring('abc1abc'::str, '\d'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:28 | regexp_count_substring('abc1abc'::str, '\D'::str, 1::i64) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:29 | regexp_count_substring('abc def ghi'::str, '\s'::str, 1::i64) | 2::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:30 | regexp_count_substring('abc def ghi'::str, '\S'::str, 1::i64) | 9::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:31 | regexp_count_substring('abc def ghi'::str, '\w'::str, 1::i64) | 9::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:32 | regexp_count_substring('abc def ghi,'::str, '\W'::str, 1::i64) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:33 | regexp_count_substring('abc1abc'::str, '\d'::str) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:34 | regexp_count_substring('abc1abc'::str, '\D'::str) | 6::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:35 | regexp_count_substring('abc def ghi'::str, '\s'::str) | 2::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:36 | regexp_count_substring('abc def ghi'::str, '\S'::str) | 9::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:37 | regexp_count_substring('abc def ghi'::str, '\w'::str) | 9::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:38 | regexp_count_substring('abc def ghi,'::str, '\W'::str) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_match_substring.test:5 | regexp_match_substring('foobarboopzoo'::str, 'o{1,}'::str, 1::i64, 1::i64, 0::i64) | 'oo'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:6 | regexp_match_substring('foobarboopzoo'::str, 'o{1}'::str, 1::i64, 1::i64, 0::i64) | 'o'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:7 | regexp_match_substring('abcabcacb'::str, '[bc]'::str, 1::i64, 1::i64, 0::i64) | 'b'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:8 | regexp_match_substring('abcdefghi'::str, '(.*)c'::str, 1::i64, 1::i64, 0::i64) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:9 | regexp_match_substring('abcdefghi'::str, '(.*)c?'::str, 1::i64, 1::i64, 0::i64) | 'abcdefghi'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:11 | regexp_match_substring('foobarboopzoo'::str, 'o{1,}'::str) | 'oo'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:12 | regexp_match_substring('foobarboopzoo'::str, 'o{1}'::str) | 'o'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:13 | regexp_match_substring('abcabcacb'::str, '[bc]'::str) | 'b'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:14 | regexp_match_substring('abcdefghi'::str, '(.*)c'::str) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:15 | regexp_match_substring('abcdefghi'::str, '(.*)c?'::str) | 'abcdefghi'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:19 | regexp_match_substring('Hello'::str, null::str?, 1::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:20 | regexp_match_substring(null::str?, ' '::str, 1::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:21 | regexp_match_substring('Hello'::str, null::str?) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:22 | regexp_match_substring(null::str?, ' '::str) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:25 | regexp_match_substring('abc1abc'::str, '\d'::str, 1::i64, 1::i64, 0::i64) | '1'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:26 | regexp_match_substring('abc1abc'::str, '\D'::str, 1::i64, 1::i64, 0::i64) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:27 | regexp_match_substring('abc def ghi'::str, '\s'::str, 1::i64, 1::i64, 0::i64) | ' '::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:28 | regexp_match_substring('abc def ghi'::str, '\S'::str, 1::i64, 1::i64, 0::i64) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:29 | regexp_match_substring('abc def ghi'::str, '\S+'::str, 1::i64, 1::i64, 0::i64) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:30 | regexp_match_substring('abc def ghi'::str, '\w'::str, 1::i64, 1::i64, 0::i64) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:31 | regexp_match_substring('abc def ghi'::str, '\w+'::str, 1::i64, 1::i64, 0::i64) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:32 | regexp_match_substring('abc def ghi,'::str, '\W'::str, 1::i64, 1::i64, 0::i64) | ' '::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:33 | regexp_match_substring('abc1abc'::str, '\d'::str) | '1'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:34 | regexp_match_substring('abc1abc'::str, '\D'::str) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:35 | regexp_match_substring('abc def ghi'::str, '\s'::str) | ' '::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:36 | regexp_match_substring('abc def ghi'::str, '\S'::str) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:37 | regexp_match_substring('abc def ghi'::str, '\S+'::str) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:38 | regexp_match_substring('abc def ghi'::str, '\w'::str) | 'a'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:39 | regexp_match_substring('abc def ghi'::str, '\w+'::str) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:40 | regexp_match_substring('abc def ghi,'::str, '\W'::str) | ' '::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_string_split.test:5 | regexp_string_split('Hello'::str, 'Hel+?'::str) | ['', 'lo']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:6 | regexp_string_split('Hello'::str, 'Hel+'::str) | ['', 'o']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:9 | regexp_string_split('HHHelloooo'::str, 'Hel+'::str) | ['HH', 'oooo']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:12 | regexp_string_split('abcdefg'::str, '\Aabc'::str) | ['', 'defg']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:13 | regexp_string_split('abcdefg'::str, 'efg$'::str) | ['abcd', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:16 | regexp_string_split('abc1abc'::str, '\d'::str) | ['abc', 'abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:17 | regexp_string_split('111a111'::str, '\D'::str) | ['111', '111']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:18 | regexp_string_split('abc def'::str, '\s'::str) | ['abc', 'def']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:19 | regexp_string_split('a bcdef'::str, '\S'::str) | ['', ' ', '', '', '', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:20 | regexp_string_split(' abcdef'::str, '\w'::str) | [' ', '', '', '', '', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:21 | regexp_string_split('a bcdef'::str, '\W'::str) | ['a', 'bcdef']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:24 | regexp_string_split('abc123abc'::str, '[0-9]+'::str) | ['abc', 'abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:25 | regexp_string_split('abc123abc'::str, '[bc]'::str) | ['a', '', '123a', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:26 | regexp_string_split('abcde'::str, '(.*)c'::str) | ['', 'de']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:27 | regexp_string_split('abbbbc'::str, '[b]{2,3}'::str) | ['a', 'bc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:30 | regexp_string_split('100 dollars'::str, '\d+(?= dollars)'::str) | ['', ' dollars']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:33 | regexp_string_split('100 pesos'::str, '\d+(?!\d| dollars)'::str) | ['', ' pesos']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:36 | regexp_string_split('USD100'::str, '(?<=USD)\d{3}'::str) | ['USD', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:39 | regexp_string_split('JPY100'::str, '\d{3}(?<!USD\d{3})'::str) | ['JPY', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/string_split.test:5 | string_split('abc'::str, ' '::str) | ['abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:6 | string_split('abc abc'::str, ' '::str) | ['abc', 'abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:7 | string_split('bacad'::str, 'a'::str) | ['b', 'c', 'd']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:8 | string_split('a b c d'::str, ' '::str) | ['a', 'b', 'c', 'd']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| arithmetic/bitwise_not.test:5 | bitwise_not(-128::i8) | 127::i8 | |
| arithmetic/bitwise_not.test:6 | bitwise_not(127::i8) | -128::i8 | |
| arithmetic/bitwise_not.test:7 | bitwise_not(-32768::i16) | 32767::i16 | |
| arithmetic/bitwise_not.test:8 | bitwise_not(32767::i16) | -32768::i16 | |
| arithmetic/bitwise_not.test:9 | bitwise_not(-2147483648::i32) | 2147483647::i32 | |
| arithmetic/bitwise_not.test:10 | bitwise_not(-9223372036854775808::i64) | 9223372036854775807::i64 | |
| arithmetic/bitwise_not.test:13 | bitwise_not(null::i8?) | null::i8? | |
| arithmetic/bitwise_not.test:14 | bitwise_not(null::i16?) | null::i16? | |
| arithmetic/bitwise_not.test:15 | bitwise_not(null::i32?) | null::i32? | |
| arithmetic/bitwise_not.test:18 | bitwise_not(0::i16) | -1::i16 | |
| arithmetic/bitwise_not.test:19 | bitwise_not(0::i32) | -1::i32 | |
| arithmetic/bitwise_not.test:20 | bitwise_not(0::i64) | -1::i64 | |
| arithmetic/bitwise_not.test:21 | bitwise_not(-1::i8) | 0::i8 | |
| arithmetic/bitwise_not.test:22 | bitwise_not(-1::i16) | 0::i16 | |
| arithmetic/bitwise_not.test:23 | bitwise_not(-1::i32) | 0::i32 | |
| arithmetic/bitwise_not.test:24 | bitwise_not(-1::i64) | 0::i64 | |
| arithmetic/bitwise_not.test:27 | bitwise_not(42::i8) | -43::i8 | |
| arithmetic/bitwise_not.test:28 | bitwise_not(-42::i8) | 41::i8 | |
| arithmetic/bitwise_not.test:29 | bitwise_not(1000::i16) | -1001::i16 | |
| arithmetic/bitwise_not.test:30 | bitwise_not(-1000::i16) | 999::i16 | |
| arithmetic/bitwise_not.test:31 | bitwise_not(100000::i32) | -100001::i32 | |
| arithmetic/bitwise_not.test:32 | bitwise_not(-100000::i32) | 99999::i32 | |
| arithmetic/bitwise_not.test:35 | bitwise_not(1000000000000::i64) | -1000000000001::i64 | |
| arithmetic/bitwise_not.test:36 | bitwise_not(-1000000000000::i64) | 999999999999::i64 | |
| arithmetic/shift_left.test:5 | shift_left(null::i32?, null::i32?) | null::i32? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:6 | shift_left(null::i64?, null::i32?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:9 | shift_left(0::i32, 5::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:10 | shift_left(1::i32, 0::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:11 | shift_left(0::i64, 10::i32) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_left.test:12 | shift_left(1::i64, 0::i32) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_left" |
| arithmetic/shift_right.test:5 | shift_right(2147483647::i32, 1::i32) | 1073741823::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:6 | shift_right(-2147483648::i32, 1::i32) | -1073741824::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:7 | shift_right(9223372036854775807::i64, 1::i32) | 4611686018427387903::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:8 | shift_right(-9223372036854775808::i64, 1::i32) | -4611686018427387904::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:9 | shift_right(2147483647::i32, 31::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:10 | shift_right(-2147483648::i32, 31::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:11 | shift_right(-128::i32, 4::i32) | -8::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:12 | shift_right(2147483647::i32, 16::i32) | 32767::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:13 | shift_right(-2147483648::i32, 16::i32) | -32768::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:14 | shift_right(9223372036854775807::i64, 32::i32) | 2147483647::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:15 | shift_right(-9223372036854775808::i64, 32::i32) | -2147483648::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:18 | shift_right(0::i32, 5::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:19 | shift_right(100::i32, 0::i32) | 100::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:20 | shift_right(0::i64, 32::i32) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:21 | shift_right(1::i32, 31::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:22 | shift_right(1::i64, 63::i32) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:26 | shift_right(1024::i64, 100::i32) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:29 | shift_right(-1::i32, 31::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:30 | shift_right(-1::i64, 63::i32) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:31 | shift_right(-1::i32, 1::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:32 | shift_right(-1::i32, 16::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:33 | shift_right(-1::i64, 1::i32) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:34 | shift_right(-1::i64, 32::i32) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right.test:35 | shift_right(-256::i64, 8::i32) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right" |
| arithmetic/shift_right_unsigned.test:5 | shift_right_unsigned(2147483647::i32, 1::i32) | 1073741823::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:6 | shift_right_unsigned(-2147483648::i32, 1::i32) | 1073741824::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:7 | shift_right_unsigned(9223372036854775807::i64, 1::i32) | 4611686018427387903::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:8 | shift_right_unsigned(-9223372036854775808::i64, 1::i32) | 4611686018427387904::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:9 | shift_right_unsigned(-1::i32, 16::i32) | 65535::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:10 | shift_right_unsigned(-1::i64, 32::i32) | 4294967295::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:11 | shift_right_unsigned(2147483647::i32, 0::i32) | 2147483647::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:12 | shift_right_unsigned(-2147483648::i32, 0::i32) | -2147483648::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:13 | shift_right_unsigned(255::i32, 31::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:14 | shift_right_unsigned(-2147483648::i32, 31::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:15 | shift_right_unsigned(-9223372036854775808::i64, 63::i32) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:16 | shift_right_unsigned(-1::i32, 1::i32) | 2147483647::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:17 | shift_right_unsigned(-1::i64, 1::i32) | 9223372036854775807::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:20 | shift_right_unsigned(null::i32?, null::i32?) | null::i32? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:21 | shift_right_unsigned(null::i64?, null::i32?) | null::i64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:24 | shift_right_unsigned(8::i32, 0::i32) | 8::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:25 | shift_right_unsigned(123456789::i64, 0::i32) | 123456789::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:26 | shift_right_unsigned(1::i32, 31::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:27 | shift_right_unsigned(1::i64, 63::i32) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:30 | shift_right_unsigned(-1::i32, 8::i32) | 16777215::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/shift_right_unsigned.test:31 | shift_right_unsigned(-1::i64, 8::i32) | 72057594037927935::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "shift_right_unsigned" |
| arithmetic/sign.test:5 | sign(5::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:6 | sign(-5::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:7 | sign(0::i32) | 0::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:8 | sign(100::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:9 | sign(-100::i64) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:12 | sign(3.14::fp64) | 1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:13 | sign(-3.14::fp64) | -1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:14 | sign(0.0::fp64) | 0::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:15 | sign(-0.0::fp64) | 0::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:18 | sign(null::i32?) | null::i32? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:19 | sign(null::fp64?) | null::fp64? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:22 | sign(5::i8) | 1::i8 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:23 | sign(-5::i8) | -1::i8 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:24 | sign(1000::i16) | 1::i16 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:25 | sign(-1000::i16) | -1::i16 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:26 | sign(3.14::fp32) | 1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:27 | sign(-3.14::fp32) | -1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:30 | sign(inf::fp64) | 1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:31 | sign(-inf::fp64) | -1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:32 | sign(nan::fp64) | nan::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:35 | sign(1e-10::fp64) | 1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:36 | sign(-1e-10::fp64) | -1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:39 | sign(-128::i8) | -1::i8 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:40 | sign(127::i8) | 1::i8 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:41 | sign(-32768::i16) | -1::i16 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:42 | sign(32767::i16) | 1::i16 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:43 | sign(-2147483648::i32) | -1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:44 | sign(2147483647::i32) | 1::i32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:45 | sign(-9223372036854775808::i64) | -1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:46 | sign(9223372036854775807::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:49 | sign(inf::fp32) | 1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:50 | sign(-inf::fp32) | -1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:51 | sign(nan::fp32) | nan::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:54 | sign(0::i64) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:55 | sign(0::i8) | 0::i8 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:56 | sign(0::i16) | 0::i16 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:57 | sign(-0.0::fp32) | 0::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:60 | sign(-1.7976931348623157e308::fp64) | -1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:61 | sign(-3.4028235e38::fp32) | -1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:64 | sign(1.7976931348623157e308::fp64) | 1::fp64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| arithmetic/sign.test:65 | sign(3.4028235e38::fp32) | 1::fp32 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sign" |
| comparison/is_finite.test:5 | is_finite(nan::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:6 | is_finite(nan::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:7 | is_finite(-inf::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:8 | is_finite(inf::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:11 | is_finite(-0.0::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:12 | is_finite(-0.0::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:13 | is_finite(-0.00001::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:16 | is_finite(1.4e-45::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:17 | is_finite(-1.4e-45::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:18 | is_finite(5e-324::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:19 | is_finite(-5e-324::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:22 | is_finite(-1.5::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:23 | is_finite(-999.999::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:24 | is_finite(-3.4028235e38::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:25 | is_finite(-1.7976931348623157e308::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:28 | is_finite(3.4028235e38::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:29 | is_finite(1.7976931348623157e308::fp64) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_finite.test:30 | is_finite(123.456::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_finite" |
| comparison/is_infinite.test:5 | is_infinite(nan::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:6 | is_infinite(nan::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:7 | is_infinite(-inf::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:8 | is_infinite(inf::fp32) | true::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:9 | is_infinite(-0.0::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:10 | is_infinite(-0.0::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:11 | is_infinite(-1.5::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:12 | is_infinite(-1000.000000000001::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:13 | is_infinite(3.4028235e38::fp32) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| comparison/is_infinite.test:14 | is_infinite(1.7976931348623157e308::fp64) | false::bool | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "is_infinite" |
| datetime/add_intervals.test:5 | add_intervals(P2147483646D::iday, P1D::iday) | P2147483647D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:6 | add_intervals(PT2147483646S::iday, PT1S::iday) | PT2147483647S::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:9 | add_intervals(P1Y::iyear, null::iyear?) | null::iyear? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:10 | add_intervals(null::iyear?, null::iyear?) | null::iyear? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:11 | add_intervals(P5D::iday, null::iday?) | null::iday? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:12 | add_intervals(null::iday?, null::iday?) | null::iday? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:15 | add_intervals(PT5H::iday, PT-3H::iday) | PT2H::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:16 | add_intervals(P10D::iday, P-3D::iday) | P7D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:17 | add_intervals(P-1D::iday, P2D::iday) | P1D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:18 | add_intervals(P5Y::iyear, P-2Y::iyear) | P3Y::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:19 | add_intervals(P1Y6M::iyear, P-6M::iyear) | P1Y::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:22 | add_intervals(P0D::iday, PT0H::iday) | P0D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:23 | add_intervals(P5D::iday, P0D::iday) | P5D::iday | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:24 | add_intervals(P0Y::iyear, P0M::iyear) | P0Y::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:25 | add_intervals(P2Y3M::iyear, P0Y::iyear) | P2Y3M::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:26 | add_intervals(P1Y::iyear, P2Y::iyear) | P3Y::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:27 | add_intervals(P1Y2M::iyear, P3M::iyear) | P1Y5M::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:28 | add_intervals(P0Y6M::iyear, P0Y8M::iyear) | P1Y2M::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:29 | add_intervals(P10Y::iyear, P5Y11M::iyear) | P15Y11M::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| datetime/add_intervals.test:30 | add_intervals(P0Y11M::iyear, P0Y3M::iyear) | P1Y2M::iyear | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "add_intervals" |
| string/regexp_count_substring.test:5 | regexp_count_substring(''::str, 'a'::str, 1::i64) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:6 | regexp_count_substring(''::str, 'a'::str) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:8 | regexp_count_substring('abcabc'::str, 'a'::str, 10::i64) | 0::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:11 | regexp_count_substring('abc'::str, ''::str, 1::i64) | 4::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:12 | regexp_count_substring(''::str, ''::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:13 | regexp_count_substring('abc'::str, ''::str) | 4::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:16 | regexp_count_substring('abcabc'::str, 'a'::str, 4::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:17 | regexp_count_substring('abcabc'::str, 'abc'::str, 2::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:18 | regexp_count_substring('AaBbCc'::str, 'a'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:19 | regexp_count_substring('AaBbCc'::str, 'A'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:20 | regexp_count_substring('HELLO hello HeLLo'::str, 'hello'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:21 | regexp_count_substring('AaBbCc'::str, '[a-z]'::str, 1::i64) | 3::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:22 | regexp_count_substring('aaa'::str, 'aa'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:23 | regexp_count_substring('aaaa'::str, 'aa'::str, 1::i64) | 2::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:24 | regexp_count_substring('ababa'::str, 'aba'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:25 | regexp_count_substring('Москва'::str, '[а-я]'::str, 1::i64) | 5::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:28 | regexp_count_substring('café'::str, 'é'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:29 | regexp_count_substring('你好世界'::str, '好'::str, 1::i64) | 1::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_count_substring.test:30 | regexp_count_substring('🎉🎊🎉'::str, '🎉'::str, 1::i64) | 2::i64 | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_count_substring" |
| string/regexp_match_substring.test:5 | regexp_match_substring('abc'::str, 'a'::str, 1::i64, 5::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:6 | regexp_match_substring('abc'::str, 'a'::str, 10::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:7 | regexp_match_substring('hello'::str, 'xyz'::str, 1::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:8 | regexp_match_substring('123'::str, '[a-z]+'::str, 1::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:9 | regexp_match_substring('hello world'::str, '^world'::str, 1::i64, 1::i64, 0::i64) | null::str? | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:12 | regexp_match_substring('foobarboopzoo'::str, 'o{1,}'::str, 1::i64, 2::i64, 0::i64) | 'oo'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:13 | regexp_match_substring('abcabcacb'::str, '[bc]'::str, 1::i64, 2::i64, 0::i64) | 'c'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:14 | regexp_match_substring('abcabcacb'::str, '[bc]'::str, 1::i64, 3::i64, 0::i64) | 'b'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:15 | regexp_match_substring('foobarboopzoo'::str, 'o{1,}'::str, 5::i64, 1::i64, 0::i64) | 'oo'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:16 | regexp_match_substring('abcabcacb'::str, 'abc'::str, 4::i64, 1::i64, 0::i64) | 'abc'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:17 | regexp_match_substring('hello world'::str, 'o'::str, 6::i64, 1::i64, 0::i64) | 'o'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:18 | regexp_match_substring(''::str, 'a*'::str, 1::i64, 1::i64, 0::i64) | ''::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:19 | regexp_match_substring(''::str, '.*'::str, 1::i64, 1::i64, 0::i64) | ''::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:20 | regexp_match_substring('abc'::str, ''::str, 1::i64, 1::i64, 0::i64) | ''::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:21 | regexp_match_substring('hello world'::str, '^hello'::str, 1::i64, 1::i64, 0::i64) | 'hello'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_match_substring.test:22 | regexp_match_substring('hello world'::str, 'world$'::str, 1::i64, 1::i64, 0::i64) | 'world'::str | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_match_substring" |
| string/regexp_string_split.test:5 | regexp_string_split(null::str?, 'pattern'::str) | null::list?<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:6 | regexp_string_split('text'::str, null::str?) | null::list?<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:7 | regexp_string_split(null::str?, null::str?) | null::list?<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:10 | regexp_string_split(''::str, 'a'::str) | ['']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:11 | regexp_string_split(''::str, ''::str) | ['']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:12 | regexp_string_split('abc'::str, 'abc'::str) | ['', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:13 | regexp_string_split('aaa'::str, 'a'::str) | ['', '', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:14 | regexp_string_split('bbbbb'::str, 'b+'::str) | ['', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:15 | regexp_string_split('aaabbbccc'::str, '[abc]'::str) | ['', '', '', '', '', '', '', '', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:18 | regexp_string_split('café'::str, 'é'::str) | ['caf', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:19 | regexp_string_split('你好世界'::str, '好'::str) | ['你', '世界']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:22 | regexp_string_split('abc'::str, 'xyz'::str) | ['abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:23 | regexp_string_split('hello world'::str, 'z+'::str) | ['hello world']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:24 | regexp_string_split('hello🌍world'::str, '🌍'::str) | ['hello', 'world']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/regexp_string_split.test:25 | regexp_string_split('AbCdEf'::str, '(?i)b'::str) | ['A', 'CdEf']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "regexp_string_split" |
| string/string_split.test:5 | string_split('banana'::str, 'a'::str) | ['b', 'n', 'n', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:8 | string_split(null::str?, ' '::str) | null::list?<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:10 | string_split(null::str?, null::str?) | null::list?<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:14 | string_split('a,,b'::str, ','::str) | ['a', '', 'b']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:15 | string_split('aaaa'::str, 'a'::str) | ['', '', '', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:16 | string_split('a b'::str, ' '::str) | ['a', '', 'b']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:17 | string_split(',a,b,'::str, ','::str) | ['', 'a', 'b', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:18 | string_split(' abc '::str, ' '::str) | ['', '', 'abc', '', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:19 | string_split(' abc'::str, ' '::str) | ['', 'abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:20 | string_split('abc '::str, ' '::str) | ['abc', '']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:23 | string_split('a::b::c'::str, '::'::str) | ['a', 'b', 'c']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:24 | string_split('hello, world, test'::str, ', '::str) | ['hello', 'world', 'test']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:25 | string_split('one||two||three'::str, '||'::str) | ['one', 'two', 'three']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:26 | string_split('abc'::str, 'xyz'::str) | ['abc']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:27 | string_split('hello world'::str, ','::str) | ['hello world']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
| string/string_split.test:28 | string_split('hello world'::str, 'o'::str) | ['hell', ' w', 'rld']::list<str> | Exception: DataFusion error: This feature is not implemented: Unsupported function name: "string_split" |
The consumer does not map these aggregate functions
Not yet reported upstream
Functions: variance (42), std_dev (35), approx_count_distinct (8)
Exception: DataFusion error: This feature is not implemented: Aggregate function approx_count_distinct:any is not supported: function anchor = 1
All 85 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| aggregate_approx/approx_count_distinct.test:5 | approx_count_distinct((1, -2, 3, -4, 5, 6)::i8) | 6::i64 | |
| aggregate_approx/approx_count_distinct.test:6 | approx_count_distinct((-32767, -20000, 30000, 5, 32767)::i16) | 5::i64 | |
| aggregate_approx/approx_count_distinct.test:7 | approx_count_distinct((-2147483648, -10000000, 30000000, 2147483647)::i32) | 4::i64 | |
| aggregate_approx/approx_count_distinct.test:8 | approx_count_distinct((-214748364800000, -1000000000, 0, 922337203685477580)::i64) | 4::i64 | |
| aggregate_approx/approx_count_distinct.test:9 | approx_count_distinct((1)::i8) | 1::i64 | |
| aggregate_approx/approx_count_distinct.test:10 | approx_count_distinct(()::i8) | 0::i64 | |
| aggregate_approx/approx_count_distinct.test:11 | approx_count_distinct((Null, Null, Null)::i8) | 0::i64 | |
| aggregate_approx/approx_count_distinct.test:12 | approx_count_distinct((Null, Null, 4, 3, Null, 922337203685477580, 12833888)::i64) | 4::i64 | |
| arithmetic/std_dev.test:5 | ((1.0), (2.0), (3.0), (4.0), (5.0)) std_dev(SAMPLE::enum, col0::fp32) | 1.5811388::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:6 | ((1.0), (2.0), (3.0), (4.0), (5.0)) std_dev(SAMPLE::enum, col0::fp64) | 1.5811388300841898::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:7 | ((1.0), (2.0), (3.0), (4.0), (5.0)) std_dev(POPULATION::enum, col0::fp32) | 1.4142135::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:8 | ((1.0), (2.0), (3.0), (4.0), (5.0)) std_dev(POPULATION::enum, col0::fp64) | 1.4142135623730951::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:11 | ((5.0), (5.0), (5.0), (5.0)) std_dev(SAMPLE::enum, col0::fp32) | 0.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:12 | ((5.0), (5.0), (5.0), (5.0)) std_dev(POPULATION::enum, col0::fp64) | 0.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:15 | ((42.0)) std_dev(SAMPLE::enum, col0::fp32) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:16 | ((42.0)) std_dev(POPULATION::enum, col0::fp64) | 0.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:19 | ((-5.0), (-3.0), (-1.0), (1.0), (3.0), (5.0)) std_dev(SAMPLE::enum, col0::fp32) | 3.7416575::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:20 | ((-5.0), (-3.0), (-1.0), (1.0), (3.0), (5.0)) std_dev(SAMPLE::enum, col0::fp64) | 3.7416573867739413::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:21 | ((-10.0), (-5.0), (0.0), (5.0), (10.0)) std_dev(POPULATION::enum, col0::fp32) | 7.0710678::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:22 | ((-10.0), (-5.0), (0.0), (5.0), (10.0)) std_dev(POPULATION::enum, col0::fp64) | 7.0710678118654755::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:25 | ((1.5), (2.5), (3.5), (4.5), (5.5)) std_dev(SAMPLE::enum, col0::fp32) | 1.5811388::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:26 | ((1.5), (2.5), (3.5), (4.5), (5.5)) std_dev(SAMPLE::enum, col0::fp64) | 1.5811388300841898::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:27 | ((0.1), (0.2), (0.3), (0.4), (0.5)) std_dev(POPULATION::enum, col0::fp64) | 0.14142135623730953::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:30 | ((1000.0), (2000.0), (3000.0), (4000.0), (5000.0)) std_dev(SAMPLE::enum, col0::fp32) | 1581.1388::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:31 | ((1000.0), (2000.0), (3000.0), (4000.0), (5000.0)) std_dev(SAMPLE::enum, col0::fp64) | 1581.1388300841898::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:34 | ((0.001), (0.002), (0.003), (0.004), (0.005)) std_dev(SAMPLE::enum, col0::fp64) | 0.0015811388300841896::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:35 | ((0.001), (0.002), (0.003), (0.004), (0.005)) std_dev(POPULATION::enum, col0::fp64) | 0.0014142135623730951::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:38 | ((Null), (Null), (Null)) std_dev(SAMPLE::enum, col0::fp32?) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:39 | (()) std_dev(SAMPLE::enum, col0::fp32) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:40 | ((1.0), (Null), (3.0), (Null), (5.0)) std_dev(SAMPLE::enum, col0::fp32?) | 2.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:41 | ((1.0), (Null), (3.0), (Null), (5.0)) std_dev(POPULATION::enum, col0::fp64?) | 1.632993161855452::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:48 | ((10.0), (20.0)) std_dev(SAMPLE::enum, col0::fp32) | 7.071068::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:49 | ((10.0), (20.0)) std_dev(POPULATION::enum, col0::fp64) | 5.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:52 | ((0.0), (100.0), (50.0), (25.0), (75.0)) std_dev(SAMPLE::enum, col0::fp32) | 39.52847::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:53 | ((0.0), (100.0), (50.0), (25.0), (75.0)) std_dev(POPULATION::enum, col0::fp64) | 35.35533905932738::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:5 | ((1.0), (2.0), (3.0), (4.0), (5.0)) variance(SAMPLE::enum, col0::fp32) | 2.5::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:6 | ((1.0), (2.0), (3.0), (4.0), (5.0)) variance(SAMPLE::enum, col0::fp64) | 2.5::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:7 | ((1.0), (2.0), (3.0), (4.0), (5.0)) variance(POPULATION::enum, col0::fp32) | 2.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:8 | ((1.0), (2.0), (3.0), (4.0), (5.0)) variance(POPULATION::enum, col0::fp64) | 2.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:11 | ((5.0), (5.0), (5.0), (5.0)) variance(SAMPLE::enum, col0::fp32) | 0.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:12 | ((5.0), (5.0), (5.0), (5.0)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:15 | ((42.0)) variance(SAMPLE::enum, col0::fp32) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:16 | ((42.0)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:19 | ((-5.0), (-3.0), (-1.0), (1.0), (3.0), (5.0)) variance(SAMPLE::enum, col0::fp32) | 14.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:20 | ((-5.0), (-3.0), (-1.0), (1.0), (3.0), (5.0)) variance(SAMPLE::enum, col0::fp64) | 14.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:21 | ((-10.0), (-5.0), (0.0), (5.0), (10.0)) variance(POPULATION::enum, col0::fp32) | 50.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:22 | ((-10.0), (-5.0), (0.0), (5.0), (10.0)) variance(POPULATION::enum, col0::fp64) | 50.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:25 | ((1.5), (2.5), (3.5), (4.5), (5.5)) variance(SAMPLE::enum, col0::fp32) | 2.5::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:26 | ((1.5), (2.5), (3.5), (4.5), (5.5)) variance(SAMPLE::enum, col0::fp64) | 2.5::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:27 | ((0.1), (0.2), (0.3), (0.4), (0.5)) variance(POPULATION::enum, col0::fp64) | 0.020000000000000004::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:30 | ((1000.0), (2000.0), (3000.0), (4000.0), (5000.0)) variance(SAMPLE::enum, col0::fp32) | 2500000.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:31 | ((1000.0), (2000.0), (3000.0), (4000.0), (5000.0)) variance(SAMPLE::enum, col0::fp64) | 2500000.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:34 | ((0.001), (0.002), (0.003), (0.004), (0.005)) variance(SAMPLE::enum, col0::fp64) | 0.0000025::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:35 | ((0.001), (0.002), (0.003), (0.004), (0.005)) variance(POPULATION::enum, col0::fp64) | 0.000002::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:38 | ((Null), (Null), (Null)) variance(SAMPLE::enum, col0::fp32?) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:39 | (()) variance(SAMPLE::enum, col0::fp32) | Null::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:40 | ((1.0), (Null), (3.0), (Null), (5.0)) variance(SAMPLE::enum, col0::fp32?) | 4.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:41 | ((1.0), (Null), (3.0), (Null), (5.0)) variance(POPULATION::enum, col0::fp64?) | 2.666666666666667::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:48 | ((10.0), (20.0)) variance(SAMPLE::enum, col0::fp32) | 50.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:49 | ((10.0), (20.0)) variance(POPULATION::enum, col0::fp64) | 25.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:52 | ((0.0), (100.0), (50.0), (25.0), (75.0)) variance(SAMPLE::enum, col0::fp32) | 1562.5::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:53 | ((0.0), (100.0), (50.0), (25.0), (75.0)) variance(POPULATION::enum, col0::fp64) | 1250.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:56 | ((-2.0), (-1.0), (0.0), (1.0), (2.0)) variance(SAMPLE::enum, col0::fp32) | 2.5::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:57 | ((-2.0), (-1.0), (0.0), (1.0), (2.0)) variance(POPULATION::enum, col0::fp64) | 2.0::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:60 | ((10.0), (20.0), (30.0)) variance(SAMPLE::enum, col0::fp32) | 100.0::fp32? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not supported: function anchor = 1 |
| arithmetic/variance.test:61 | ((10.0), (20.0), (30.0)) variance(POPULATION::enum, col0::fp64) | 66.66666666666667::fp64? | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:5 | ((2.0), (4.0), (6.0), (8.0)) std_dev(POPULATION::enum, col0::fp64) | 2.23606797749979::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:8 | ((10.0), (10.0), (10.0)) std_dev(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:11 | ((-2.5), (-1.5), (-0.5), (0.5), (1.5), (2.5)) std_dev(POPULATION::enum, col0::fp64) | 1.707825127659933::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:14 | ((3.14)) std_dev(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:17 | ((1.0), (NaN), (3.0)) std_dev(POPULATION::enum, col0::fp64) | nan::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:20 | ((0.0), (0.0), (0.0)) std_dev(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:23 | ((1e-100), (2e-100), (3e-100)) std_dev(POPULATION::enum, col0::fp64) | 8.16496580927726e-101::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/std_dev.test:24 | ((1e-50), (2e-50), (3e-50), (4e-50)) std_dev(POPULATION::enum, col0::fp64) | 1.118033988749895e-50::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:5 | ((2.0), (4.0), (6.0), (8.0)) variance(POPULATION::enum, col0::fp64) | 5.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:8 | ((10.0), (10.0), (10.0)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:11 | ((-2.5), (-1.5), (-0.5), (0.5), (1.5), (2.5)) variance(POPULATION::enum, col0::fp64) | 2.9166666666666665::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:14 | ((3.14)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:17 | ((NaN), (1.0), (2.0), (3.0)) variance(POPULATION::enum, col0::fp64) | nan::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:20 | ((5.0), (15.0)) variance(POPULATION::enum, col0::fp64) | 25.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:21 | ((0.0), (0.0)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:22 | ((1e308), (1e308), (1e308)) variance(POPULATION::enum, col0::fp64) | 0.0::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:25 | ((2.5), (-2.5), (2.5), (-2.5)) variance(POPULATION::enum, col0::fp64) | 6.25::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:28 | ((1e100), (2e100), (3e100)) variance(POPULATION::enum, col0::fp64) | 6.666666666666667e+199::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
| arithmetic/variance.test:29 | ((1e100), (-1e100), (1e100), (-1e100)) variance(POPULATION::enum, col0::fp64) | 1e+200::fp64 | Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not supported: function anchor = 1 |
Enumeration (option) arguments are not supported
Not yet reported upstream
Functions whose plans pass an enumeration argument, such as extract's component, are rejected.
Functions: extract (50)
Exception: DataFusion error: This feature is not implemented: Function argument non-Value type not supported
All 50 cases
| Case | Test | Expected |
|---|---|---|
| datetime/extract.test:5 | extract(YEAR::enum, 2016-12-31T13:30:15::pts<6>) | 2016::i64 |
| datetime/extract.test:6 | extract(ISO_YEAR::enum, 2016-01-01T13:30:15::pts<6>) | 2015::i64 |
| datetime/extract.test:7 | extract(QUARTER::enum, ONE::enum, 2016-12-31T13:30:15::pts<6>) | 4::i64 |
| datetime/extract.test:8 | extract(MONTH::enum, ONE::enum, 2016-12-31T13:30:15::pts<6>) | 12::i64 |
| datetime/extract.test:9 | extract(ISO_WEEK::enum, ONE::enum, 2016-12-31T13:30:15::pts<6>) | 52::i64 |
| datetime/extract.test:10 | extract(DAY::enum, ONE::enum, 2016-12-31T13:30:15::pts<6>) | 31::i64 |
| datetime/extract.test:11 | extract(SUNDAY_DAY_OF_WEEK::enum, ONE::enum, 2016-12-25T13:30:15::pts<6>) | 1::i64 |
| datetime/extract.test:12 | extract(MONDAY_DAY_OF_WEEK::enum, ONE::enum, 2016-12-25T13:30:15::pts<6>) | 7::i64 |
| datetime/extract.test:13 | extract(DAY_OF_YEAR::enum, ONE::enum, 2016-12-25T13:30:15::pts<6>) | 360::i64 |
| datetime/extract.test:14 | extract(HOUR::enum, 2016-12-31T13:30:15::pts<6>) | 13::i64 |
| datetime/extract.test:15 | extract(MINUTE::enum, 2016-12-31T13:30:15::pts<6>) | 30::i64 |
| datetime/extract.test:16 | extract(SECOND::enum, 2016-12-31T13:30:15::pts<6>) | 15::i64 |
| datetime/extract.test:17 | extract(MILLISECOND::enum, 2016-12-31T13:30:15::pts<6>) | 0::i64 |
| datetime/extract.test:18 | extract(MICROSECOND::enum, 2016-12-31T13:30:15.220000::pts<6>) | 0::i64 |
| datetime/extract.test:19 | extract(UNIX_TIME::enum, 2016-12-31T13:30:15::pts<6>) | 1483191015::i64 |
| datetime/extract.test:22 | extract(YEAR::enum, 2020-12-31::date) | 2020::i64 |
| datetime/extract.test:23 | extract(MONTH::enum, ONE::enum, 2020-12-31::date) | 12::i64 |
| datetime/extract.test:24 | extract(DAY::enum, ONE::enum, 2020-12-31::date) | 31::i64 |
| datetime/extract.test:27 | extract(HOUR::enum, 01:02:03::pt<6>) | 1::i64 |
| datetime/extract.test:28 | extract(MINUTE::enum, 01:02:03::pt<6>) | 2::i64 |
| datetime/extract.test:29 | extract(SECOND::enum, 01:02:03::pt<6>) | 3::i64 |
| datetime/extract.test:30 | extract(MILLISECOND::enum, 01:02:03.155::pt<6>) | 155::i64 |
| datetime/extract.test:31 | extract(MICROSECOND::enum, 01:02:03.45::pt<6>) | 0::i64 |
| datetime/extract.test:5 | extract(YEAR::enum, null::date?) | null::i64? |
| datetime/extract.test:6 | extract(MONTH::enum, ONE::enum, null::pts?<6>) | null::i64? |
| datetime/extract.test:9 | extract(ISO_YEAR::enum, 2020-01-01T00:00:00::pts<6>) | 2020::i64 |
| datetime/extract.test:10 | extract(ISO_YEAR::enum, 2021-01-01T00:00:00::pts<6>) | 2020::i64 |
| datetime/extract.test:11 | extract(HOUR::enum, 00:00:00::pt<6>) | 0::i64 |
| datetime/extract.test:12 | extract(MINUTE::enum, 00:00:00::pt<6>) | 0::i64 |
| datetime/extract.test:13 | extract(SECOND::enum, 00:00:00::pt<6>) | 0::i64 |
| datetime/extract.test:16 | extract(YEAR::enum, 0001-01-01::date) | 1::i64 |
| datetime/extract.test:17 | extract(YEAR::enum, 9999-12-31::date) | 9999::i64 |
| datetime/extract.test:18 | extract(MONTH::enum, ONE::enum, 0001-01-01::date) | 1::i64 |
| datetime/extract.test:19 | extract(DAY::enum, ONE::enum, 9999-12-31::date) | 31::i64 |
| datetime/extract.test:20 | extract(DAY::enum, ONE::enum, 2020-02-29::date) | 29::i64 |
| datetime/extract.test:21 | extract(MONTH::enum, ONE::enum, 2020-02-29::date) | 2::i64 |
| datetime/extract.test:22 | extract(DAY_OF_YEAR::enum, ONE::enum, 2020-02-29::date) | 60::i64 |
| datetime/extract.test:23 | extract(DAY_OF_YEAR::enum, ONE::enum, 2020-12-31::date) | 366::i64 |
| datetime/extract.test:24 | extract(DAY::enum, ONE::enum, 2019-02-28::date) | 28::i64 |
| datetime/extract.test:25 | extract(DAY_OF_YEAR::enum, ONE::enum, 2019-12-31::date) | 365::i64 |
| datetime/extract.test:26 | extract(QUARTER::enum, ONE::enum, 2020-01-01::date) | 1::i64 |
| datetime/extract.test:27 | extract(QUARTER::enum, ONE::enum, 2020-03-31::date) | 1::i64 |
| datetime/extract.test:28 | extract(QUARTER::enum, ONE::enum, 2020-04-01::date) | 2::i64 |
| datetime/extract.test:29 | extract(QUARTER::enum, ONE::enum, 2020-06-30::date) | 2::i64 |
| datetime/extract.test:30 | extract(QUARTER::enum, ONE::enum, 2020-07-01::date) | 3::i64 |
| datetime/extract.test:31 | extract(QUARTER::enum, ONE::enum, 2020-09-30::date) | 3::i64 |
| datetime/extract.test:32 | extract(QUARTER::enum, ONE::enum, 2020-10-01::date) | 4::i64 |
| datetime/extract.test:35 | extract(HOUR::enum, 23:59:59::pt<6>) | 23::i64 |
| datetime/extract.test:36 | extract(MINUTE::enum, 23:59:59::pt<6>) | 59::i64 |
| datetime/extract.test:37 | extract(SECOND::enum, 23:59:59::pt<6>) | 59::i64 |
Exception: DataFusion error: Error during planning: Failed to coerce arguments to satisfy a call to '…' function: coercion from UtfN, UtfN, UtfN, IntN, IntN to the signature OneOf(Uniform(N, [UtfN
Not yet reported upstream
Functions: regexp_replace (23)
Exception: DataFusion error: Error during planning: Failed to coerce arguments to satisfy a call to 'regexp_replace' function: coercion from Utf8, Utf8, Utf8, Int64, Int64 to the signature OneOf(Uniform(3, [Utf8
All 23 cases
| Case | Test | Expected |
|---|---|---|
| string/regexp_replace.test:5 | regexp_replace('test@test.com'::str, '^\S+@\S+$'::str, 'email_found'::str, 1::i64, 0::i64) | 'email_found'::str |
| string/regexp_replace.test:6 | regexp_replace('17:50'::str, '[0-9]?[0-9]:[0-9][0-9]'::str, 'TIME'::str, 1::i64, 0::i64) | 'TIME'::str |
| string/regexp_replace.test:13 | regexp_replace('Hello'::str, 'Hel+?'::str, '1'::str, 1::i64, 0::i64) | '1lo'::str |
| string/regexp_replace.test:17 | regexp_replace('Hello'::str, 'Hel+'::str, '1'::str, 1::i64, 0::i64) | '1o'::str |
| string/regexp_replace.test:18 | regexp_replace('Helo'::str, 'Hel+'::str, '1'::str, 1::i64, 0::i64) | '1o'::str |
| string/regexp_replace.test:23 | regexp_replace('Hello'::str, null::str?, '1'::str, 1::i64, 0::i64) | null::str? |
| string/regexp_replace.test:24 | regexp_replace(null::str?, ' '::str, '1'::str, 1::i64, 0::i64) | null::str? |
| string/regexp_replace.test:29 | regexp_replace('abcdefg'::str, '\Aabc'::str, '111'::str, 1::i64, 0::i64) | '111defg'::str |
| string/regexp_replace.test:30 | regexp_replace('abcdefg'::str, 'efg$'::str, '111'::str, 1::i64, 0::i64) | 'abcd111'::str |
| string/regexp_replace.test:31 | regexp_replace('catdogdog'::str, '^cat'::str, 'dog'::str, 1::i64, 0::i64) | 'dogdogdog'::str |
| string/regexp_replace.test:32 | regexp_replace('dogcatdogdog'::str, '^cat'::str, 'dog'::str, 1::i64, 0::i64) | 'dogcatdogdog'::str |
| string/regexp_replace.test:39 | regexp_replace('abc1abc'::str, '\d'::str, ''::str, 1::i64, 0::i64) | 'abcabc'::str |
| string/regexp_replace.test:40 | regexp_replace('111a111'::str, '\D'::str, ''::str, 1::i64, 0::i64) | '111111'::str |
| string/regexp_replace.test:41 | regexp_replace('abc def'::str, '\s'::str, ''::str, 1::i64, 0::i64) | 'abcdef'::str |
| string/regexp_replace.test:42 | regexp_replace('a bcdef'::str, '\S'::str, ','::str, 1::i64, 1::i64) | ', bcdef'::str |
| string/regexp_replace.test:43 | regexp_replace(' abcdef'::str, '\w'::str, '1'::str, 1::i64, 1::i64) | ' 1bcdef'::str |
| string/regexp_replace.test:44 | regexp_replace('a bcdef'::str, '\W'::str, 'a'::str, 1::i64, 0::i64) | 'aabcdef'::str |
| string/regexp_replace.test:53 | regexp_replace('abc123abc'::str, '[0-9]+'::str, 'abc'::str, 1::i64, 0::i64) | 'abcabcabc'::str |
| string/regexp_replace.test:54 | regexp_replace('abcabcabc'::str, '[bc]'::str, 'dd'::str, 1::i64, 1::i64) | 'addcabcabc'::str |
| string/regexp_replace.test:55 | regexp_replace('abc'::str, '(.*)c'::str, '\1e'::str, 1::i64, 0::i64) | 'abe'::str |
| string/regexp_replace.test:56 | regexp_replace('abbbbc'::str, '[b]{2,3}'::str, 'd'::str, 1::i64, 0::i64) | 'adbc'::str |
| string/regexp_replace.test:5 | regexp_replace('test'::str, 'e'::str, null::str?, 1::i64, 0::i64) | null::str? |
| string/regexp_replace.test:9 | regexp_replace(''::str, 'a'::str, 'b'::str, 1::i64, 0::i64) | ''::str |
varchar literals are not supported
Not yet reported upstream
Plans with a varchar literal are rejected; TPC-H plans use them for string constants.
Functions: regexp_count_substring (2), regexp_match_substring (2), regexp_replace (2)
Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "foobarboopzoo", length: 13 }))All 6 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/regexp_count_substring.test:10 | regexp_count_substring('foobarboopzoo'::vchar<13>, 'o{1,}'::vchar<5>, 1::i64) | 3::i64 | |
| string/regexp_count_substring.test:17 | regexp_count_substring('foobarboopzoo'::vchar<13>, 'o{1,}'::vchar<5>) | 3::i64 | |
| string/regexp_match_substring.test:10 | regexp_match_substring('foobarboopzoo'::vchar<13>, 'o{1,}'::vchar<5>, 1::i64, 1::i64, 0::i64) | 'oo'::vchar<13> | |
| string/regexp_match_substring.test:16 | regexp_match_substring('foobarboopzoo'::vchar<13>, 'o{1,}'::vchar<5>) | 'oo'::vchar<13> | |
| string/regexp_replace.test:7 | regexp_replace('17:50'::vchar<5>, '[0-9]?[0-9]:[0-9][0-9]'::vchar<22>, 'TIME'::vchar<4>, 1::i64, 0::i64) | 'TIME'::vchar<5> | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "17:50", length: 5 })) |
| string/regexp_replace.test:10 | regexp_replace('17:50'::vchar<5>, '[0-9]?[0-9]:[0-9][0-9]'::vchar<22>, 'TIME'::vchar<4>) | 'TIME'::vchar<5> | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "17:50", length: 5 })) |
Wrong result (got …, expected …)
Not yet reported upstream
Functions: regexp_replace (3)
got ', bcdef', expected ', ,,,,,'
All 3 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/regexp_replace.test:48 | regexp_replace('a bcdef'::str, '\S'::str, ','::str) | ', ,,,,,'::str | |
| string/regexp_replace.test:49 | regexp_replace(' abcdef'::str, '\w'::str, '1'::str) | ' 111111'::str | got ' 1bcdef', expected ' 111111' |
| string/regexp_replace.test:58 | regexp_replace('abcabcabc'::str, '[bc]'::str, 'dd'::str) | 'addddaddddadddd'::str | got 'addcabcabc', expected 'addddaddddadddd' |
Exception: DataFusion error: Substrait error: Unknown type variation reference N
Not yet reported upstream
Functions: is_not_null, is_null
Exception: DataFusion error: Substrait error: Unknown type variation reference 0
All 2 cases
| Case | Test | Expected |
|---|---|---|
| comparison/is_not_null.test:25 | is_not_null(12:30:45::pt<6>) | true::bool |
| comparison/is_null.test:44 | is_null(12:30:45::pt<6>) | false::bool |
Exception: DataFusion error: This feature is not implemented: Can't create a null scalar from data_type "…"
Not yet reported upstream
Functions: is_not_null, is_null
Exception: DataFusion error: This feature is not implemented: Can't create a null scalar from data_type "Time32(µs)"
All 2 cases
| Case | Test | Expected |
|---|---|---|
| comparison/is_not_null.test:26 | is_not_null(null::pt?<6>) | false::bool |
| comparison/is_null.test:45 | is_null(null::pt?<6>) | true::bool |
Failing queries
Query plans that fail. There is no SQL run to compare with, so the message is the guide.
varchar literals are not supported
Not yet reported upstream
Plans with a varchar literal are rejected; TPC-H plans use them for string constants.
Queries: q02, q03, q05, q07, q08, q11, q12, q16, q17, q19, q20, q21, q22
Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "EUROPE", length: 25 }))All 13 cases
| Case | Message, where it differs |
|---|---|
| q02 | |
| q03 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "BUILDING", length: 10 })) |
| q05 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "ASIA", length: 25 })) |
| q07 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "FRANCE", length: 25 })) |
| q08 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "AMERICA", length: 25 })) |
| q11 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "GERMANY", length: 25 })) |
| q12 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "MAIL", length: 10 })) |
| q16 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "Brand#45", length: 10 })) |
| q17 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "Brand#23", length: 10 })) |
| q19 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "Brand#12", length: 10 })) |
| q20 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "CANADA", length: 25 })) |
| q21 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "SAUDI ARABIA", length: 25 })) |
| q22 | Exception: DataFusion error: This feature is not implemented: Unsupported literal_type: Some(VarChar(VarChar { value: "13", length: 15 })) |
Enumeration (option) arguments are not supported
Not yet reported upstream
Functions whose plans pass an enumeration argument, such as extract's component, are rejected.
Queries: q09
Exception: DataFusion error: This feature is not implemented: Function argument non-Value type not supported
The case
| Case |
|---|
| q09 |
Engine results that differ from the Substrait definition
These cases fail in the engine's own SQL as well, so they are about the engine itself rather than its Substrait consumer.
ValueError: Error during planning: Cannot infer common type for bitwise operation …
Not yet reported upstream
Functions: bitwise_and (14), bitwise_or (14), bitwise_xor (14)
ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) & Decimal128(1, 0) [SELECT (CAST('0' AS DECIMAL(1,0)) & CAST('1' AS DECIMAL(1,0)))]All 42 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic_decimal/bitwise_and.test:5 | bitwise_and(0::dec<1, 0>, 1::dec<1, 0>) | 0::dec<1, 0> | |
| arithmetic_decimal/bitwise_and.test:6 | bitwise_and(127::dec<3, 0>, 127::dec<3, 0>) | 127::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:7 | bitwise_and(-127::dec<3, 0>, -10::dec<2, 0>) | -128::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) & Decimal128(2, 0) |
| arithmetic_decimal/bitwise_and.test:8 | bitwise_and(31766::dec<5, 0>, 900::dec<3, 0>) | 4::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:9 | bitwise_and(-31766::dec<5, 0>, 900::dec<3, 0>) | 896::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:10 | bitwise_and(2147483647::dec<10, 0>, 1234567::dec<7, 0>) | 1234567::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) & Decimal128(7, 0) |
| arithmetic_decimal/bitwise_and.test:11 | bitwise_and(-2147483647::dec<10, 0>, 1234567::dec<7, 0>) | 1::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) & Decimal128(7, 0) |
| arithmetic_decimal/bitwise_and.test:12 | bitwise_and(9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | 127::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:13 | bitwise_and(-9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | 1::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:16 | bitwise_and(99999999999999999999999999999999999999::dec<38, 0>, 99999999999999999999999999999999999999::dec<38, 0>) | 99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) & Decimal128(38, 0) |
| arithmetic_decimal/bitwise_and.test:17 | bitwise_and(99999999999999999999999999999999999999::dec<38, 0>, 00000000000000000000000000000000000000::dec<38, 0>) | 0::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) & Decimal128(38, 0) |
| arithmetic_decimal/bitwise_and.test:18 | bitwise_and(-99999999999999999999999999999999999999::dec<38, 0>, -99999999999999999999999999999999999999::dec<38, 0>) | -99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) & Decimal128(38, 0) |
| arithmetic_decimal/bitwise_and.test:21 | bitwise_and(null::dec?<1, 0>, 127::dec<3, 0>) | null::dec?<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) & Decimal128(3, 0) |
| arithmetic_decimal/bitwise_and.test:22 | bitwise_and(null::dec?<1, 0>, null::dec?<1, 0>) | null::dec?<1, 0> | |
| arithmetic_decimal/bitwise_or.test:5 | bitwise_or(0::dec<1, 0>, 1::dec<1, 0>) | 1::dec<1, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) | Decimal128(1, 0) |
| arithmetic_decimal/bitwise_or.test:6 | bitwise_or(127::dec<3, 0>, 127::dec<3, 0>) | 127::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:7 | bitwise_or(-127::dec<3, 0>, -10::dec<2, 0>) | -9::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) | Decimal128(2, 0) |
| arithmetic_decimal/bitwise_or.test:8 | bitwise_or(31766::dec<5, 0>, 900::dec<3, 0>) | 32662::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:9 | bitwise_or(-31766::dec<5, 0>, 900::dec<3, 0>) | -31762::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:10 | bitwise_or(2147483647::dec<10, 0>, 123456789::dec<9, 0>) | 2147483647::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) | Decimal128(9, 0) |
| arithmetic_decimal/bitwise_or.test:11 | bitwise_or(-2147483647::dec<10, 0>, 123456789::dec<9, 0>) | -2024026859::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) | Decimal128(9, 0) |
| arithmetic_decimal/bitwise_or.test:12 | bitwise_or(9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | 9223372036854775807::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:13 | bitwise_or(-9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | -9223372036854775681::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:16 | bitwise_or(99999999999999999999999999999999999999::dec<38, 0>, 99999999999999999999999999999999999999::dec<38, 0>) | 99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) | Decimal128(38, 0) |
| arithmetic_decimal/bitwise_or.test:17 | bitwise_or(99999999999999999999999999999999999999::dec<38, 0>, 00000000000000000000000000000000000000::dec<38, 0>) | 99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) | Decimal128(38, 0) |
| arithmetic_decimal/bitwise_or.test:18 | bitwise_or(-99999999999999999999999999999999999999::dec<38, 0>, -99999999999999999999999999999999999999::dec<38, 0>) | -99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) | Decimal128(38, 0) |
| arithmetic_decimal/bitwise_or.test:21 | bitwise_or(null::dec?<1, 0>, 127::dec<3, 0>) | null::dec?<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) | Decimal128(3, 0) |
| arithmetic_decimal/bitwise_or.test:22 | bitwise_or(null::dec?<1, 0>, null::dec?<1, 0>) | null::dec?<1, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) | Decimal128(1, 0) |
| arithmetic_decimal/bitwise_xor.test:5 | bitwise_xor(0::dec<1, 0>, 1::dec<1, 0>) | 1::dec<1, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) BIT_XOR Decimal128(1, 0) |
| arithmetic_decimal/bitwise_xor.test:6 | bitwise_xor(127::dec<3, 0>, 127::dec<3, 0>) | 0::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:7 | bitwise_xor(-127::dec<3, 0>, -10::dec<2, 0>) | 119::dec<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(3, 0) BIT_XOR Decimal128(2, 0) |
| arithmetic_decimal/bitwise_xor.test:8 | bitwise_xor(31766::dec<5, 0>, 900::dec<3, 0>) | 32658::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:9 | bitwise_xor(-31766::dec<5, 0>, 900::dec<3, 0>) | -32658::dec<5, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(5, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:10 | bitwise_xor(2147483647::dec<10, 0>, 123456789::dec<9, 0>) | 2024026858::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) BIT_XOR Decimal128(9, 0) |
| arithmetic_decimal/bitwise_xor.test:11 | bitwise_xor(-2147483647::dec<10, 0>, 123456789::dec<9, 0>) | -2024026860::dec<10, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(10, 0) BIT_XOR Decimal128(9, 0) |
| arithmetic_decimal/bitwise_xor.test:12 | bitwise_xor(9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | 9223372036854775680::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:13 | bitwise_xor(-9223372036854775807::dec<19, 0>, 127::dec<3, 0>) | -9223372036854775682::dec<19, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(19, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:16 | bitwise_xor(99999999999999999999999999999999999999::dec<38, 0>, 99999999999999999999999999999999999999::dec<38, 0>) | 0::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) BIT_XOR Decimal128(38, 0) |
| arithmetic_decimal/bitwise_xor.test:17 | bitwise_xor(99999999999999999999999999999999999999::dec<38, 0>, 00000000000000000000000000000000000000::dec<38, 0>) | 99999999999999999999999999999999999999::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) BIT_XOR Decimal128(38, 0) |
| arithmetic_decimal/bitwise_xor.test:18 | bitwise_xor(-99999999999999999999999999999999999999::dec<38, 0>, -99999999999999999999999999999999999999::dec<38, 0>) | 0::dec<38, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(38, 0) BIT_XOR Decimal128(38, 0) |
| arithmetic_decimal/bitwise_xor.test:21 | bitwise_xor(null::dec?<1, 0>, 127::dec<3, 0>) | null::dec?<3, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) BIT_XOR Decimal128(3, 0) |
| arithmetic_decimal/bitwise_xor.test:22 | bitwise_xor(null::dec?<1, 0>, null::dec?<1, 0>) | null::dec?<1, 0> | ValueError: Error during planning: Cannot infer common type for bitwise operation Decimal128(1, 0) BIT_XOR Decimal128(1, 0) |
Wrong result (got …, expected …)
Not yet reported upstream
Functions: gte (6), gt (5), lt (4), lte (4), string_split (3), shift_right (3), regexp_count_substring (2), between (2), equal (2), not_equal (2), reverse (2), rpad, round, string_agg
got 1, expected 2 [SELECT regexp_count('abcdefc', '(.*)c?')]All 38 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/regexp_count_substring.test:9 | regexp_count_substring('abcdefc'::str, '(.*)c?'::str, 1::i64) | 2::i64 | |
| string/regexp_count_substring.test:16 | regexp_count_substring('abcdefc'::str, '(.*)c?'::str) | 2::i64 | |
| string/rpad.test:10 | rpad('abcdef'::str, 4::i32, ' '::str) | 'cdef'::str | got 'abcd', expected 'cdef' |
| string/string_split.test:9 | string_split('a b c d'::str, null::str?) | ['a b c d']::list?<str> | got ['a', ' ', 'b', ' ', 'c', ' ', 'd'], expected ['a b c d'] |
| arithmetic/shift_right.test:23 | shift_right(1024::i32, 32::i32) | 0::i32 | got 1024, expected 0 |
| arithmetic/shift_right.test:24 | shift_right(1024::i32, 40::i32) | 0::i32 | got 4, expected 0 |
| arithmetic/shift_right.test:25 | shift_right(1024::i64, 64::i32) | 0::i64 | got 1024, expected 0 |
| comparison/between.test:17 | between(3.0::fp32, 1.0::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/between.test:22 | between(3.0::fp64, 1.0::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/equal.test:16 | equal(nan::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/equal.test:17 | equal(nan::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/gt.test:18 | gt(nan::fp32, 5.0::fp32) | false::bool | got True, expected False |
| comparison/gt.test:21 | gt(nan::fp32, 0.0::fp32) | false::bool | got True, expected False |
| comparison/gt.test:22 | gt(nan::fp32, -inf::fp32) | false::bool | got True, expected False |
| comparison/gt.test:24 | gt(nan::fp64, 5.0::fp64) | false::bool | got True, expected False |
| comparison/gt.test:27 | gt(nan::fp64, inf::fp64) | false::bool | got True, expected False |
| comparison/gte.test:31 | gte(nan::fp32, 1.0::fp32) | false::bool | got True, expected False |
| comparison/gte.test:33 | gte(nan::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/gte.test:34 | gte(nan::fp64, 1.0::fp64) | false::bool | got True, expected False |
| comparison/gte.test:36 | gte(nan::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/gte.test:37 | gte(nan::fp32, 0.0::fp32) | false::bool | got True, expected False |
| comparison/gte.test:38 | gte(nan::fp64, -inf::fp64) | false::bool | got True, expected False |
| comparison/lt.test:17 | lt(1.0::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/lt.test:20 | lt(-1.0::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/lt.test:22 | lt(1.0::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/lt.test:25 | lt(-inf::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/lte.test:25 | lte(5.0::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/lte.test:26 | lte(nan::fp32, nan::fp32) | false::bool | got True, expected False |
| comparison/lte.test:28 | lte(100.0::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/lte.test:29 | lte(nan::fp64, nan::fp64) | false::bool | got True, expected False |
| comparison/not_equal.test:16 | not_equal(nan::fp32, nan::fp32) | true::bool | got False, expected True |
| comparison/not_equal.test:19 | not_equal(nan::fp64, nan::fp64) | true::bool | got False, expected True |
| rounding/round.test:38 | round(123.456::fp64, 308::i32) | 123.456::fp64 | got inf, expected 123.456 |
| string/reverse.test:25 | reverse('a👨👩👧👦b'::str) | 'b👨👩👧👦a'::str | got 'b👦\u200d👧\u200d👩\u200d👨a', expected 'b👨\u200d👩\u200d👧\u200d👦a' |
| string/reverse.test:26 | reverse('🏴test'::str) | 'tset🏴'::str | got 'tset\U000e007f\U000e0067\U000e006e\U000e0065\U000e0062\U000e0067🏴', expected 'tset🏴\U000e0067\U000e0062\U000e0065\U000e006e\U000e0067\U000e007f' |
| string/string_agg.test:34 | (('a'), ('b'), ('c')) string_agg(col0::str, null::str?) | null::str? | got 'abc', expected None |
| string/string_split.test:9 | string_split('abc'::str, null::str?) | null::list?<str> | got ['a', 'b', 'c'], expected None |
| string/string_split.test:13 | string_split('abc'::str, ''::str) | ['a', 'b', 'c']::list<str> | got ['abc'], expected ['a', 'b', 'c'] |
Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: …
Not yet reported upstream
Functions: regexp_count_substring (8), regexp_match_substring (8)
Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: \d+(?= dollars) [SELECT regexp_count('100 dollars 100 dollars', '\d+(?= dollars)')]All 16 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/regexp_count_substring.test:41 | regexp_count_substring('100 dollars 100 dollars'::str, '\d+(?= dollars)'::str, 1::i64) | 2::i64 | |
| string/regexp_count_substring.test:42 | regexp_count_substring('100 dollars 100 dollars'::str, '\d+(?= dollars)'::str) | 2::i64 | |
| string/regexp_count_substring.test:45 | regexp_count_substring('100 pesos, 99 pesos, 98 pesos'::str, '\d+(?!\d| dollars)'::str, 1::i64) | 3::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: \d+(?!\d| dollars) |
| string/regexp_count_substring.test:46 | regexp_count_substring('100 pesos, 99 pesos, 98 pesos'::str, '\d+(?!\d| dollars)'::str) | 3::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: \d+(?!\d| dollars) |
| string/regexp_count_substring.test:49 | regexp_count_substring('USD100'::str, '(?<=USD)\d{3}'::str, 1::i64) | 1::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: (?<=USD)\d{3} |
| string/regexp_count_substring.test:50 | regexp_count_substring('USD100'::str, '(?<=USD)\d{3}'::str) | 1::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: (?<=USD)\d{3} |
| string/regexp_count_substring.test:53 | regexp_count_substring('JPY100JPY100'::str, '\d{3}(?<!USD\d{3})'::str, 1::i64) | 2::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: \d{3}(?<!USD\d{3}) |
| string/regexp_count_substring.test:54 | regexp_count_substring('JPY100JPY100'::str, '\d{3}(?<!USD\d{3})'::str) | 2::i64 | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: \d{3}(?<!USD\d{3}) |
| string/regexp_match_substring.test:43 | regexp_match_substring('100 dollars'::str, '\d+(?= dollars)'::str, 1::i64, 1::i64, 0::i64) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:44 | regexp_match_substring('100 dollars'::str, '\d+(?= dollars)'::str) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:47 | regexp_match_substring('100 pesos'::str, '\d+(?!\d| dollars)'::str, 1::i64, 1::i64, 0::i64) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:48 | regexp_match_substring('100 pesos'::str, '\d+(?!\d| dollars)'::str) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:51 | regexp_match_substring('USD100'::str, '(?<=USD)\d{3}'::str, 1::i64, 1::i64, 0::i64) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:52 | regexp_match_substring('USD100'::str, '(?<=USD)\d{3}'::str) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:55 | regexp_match_substring('JPY100'::str, '\d{3}(?<!USD\d{3})'::str, 1::i64, 1::i64, 0::i64) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
| string/regexp_match_substring.test:56 | regexp_match_substring('JPY100'::str, '\d{3}(?<!USD\d{3})'::str) | '100'::str | Exception: DataFusion error: Arrow error: Compute error: Regular expression did not compile: Syntax( |
Exception: DataFusion error: External error: regex parse error: …
Not yet reported upstream
Functions: regexp_replace (8)
Exception: DataFusion error: External error: regex parse error: [SELECT regexp_replace('100 dollars', '\d+(?= dollars)', 'hundred', 'g')]All 8 cases
| Case | Test | Expected |
|---|---|---|
| string/regexp_replace.test:63 | regexp_replace('100 dollars'::str, '\d+(?= dollars)'::str, 'hundred'::str, 1::i64, 0::i64) | 'hundred dollars'::str |
| string/regexp_replace.test:64 | regexp_replace('100 dollars'::str, '\d+(?= dollars)'::str, 'hundred'::str) | 'hundred dollars'::str |
| string/regexp_replace.test:67 | regexp_replace('100 pesos'::str, '\d+(?!\d| dollars)'::str, '999'::str, 1::i64, 0::i64) | '999 pesos'::str |
| string/regexp_replace.test:68 | regexp_replace('100 pesos'::str, '\d+(?!\d| dollars)'::str, '999'::str) | '999 pesos'::str |
| string/regexp_replace.test:71 | regexp_replace('USD100'::str, '(?<=USD)\d{3}'::str, '999'::str, 1::i64, 0::i64) | 'USD999'::str |
| string/regexp_replace.test:72 | regexp_replace('USD100'::str, '(?<=USD)\d{3}'::str, '999'::str) | 'USD999'::str |
| string/regexp_replace.test:75 | regexp_replace('JPY100'::str, '\d{3}(?<!USD\d{3})'::str, '999'::str, 1::i64, 0::i64) | 'JPY999'::str |
| string/regexp_replace.test:76 | regexp_replace('JPY100'::str, '\d{3}(?<!USD\d{3})'::str, '999'::str) | 'JPY999'::str |
ValueError: Error during planning: Failed to coerce arguments to satisfy a call to '…' function: coercion from DecimalN(N, N) to the signature Uniform(N, [IntN]) failed. No function matches the given
Not yet reported upstream
Functions: factorial_decimal (4)
ValueError: Error during planning: Failed to coerce arguments to satisfy a call to 'factorial' function: coercion from Decimal128(1, 0) to the signature Uniform(1, [Int64]) failed. No function matches the given n [SELECT factorial(CAST('0' AS DECIMAL(1,0)))]All 4 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic_decimal/factorial_decimal.test:5 | factorial(0::dec<1, 0>) | 1::dec<38, 0> | |
| arithmetic_decimal/factorial_decimal.test:6 | factorial(1::dec<1, 0>) | 1::dec<38, 0> | |
| arithmetic_decimal/factorial_decimal.test:7 | factorial(20::dec<2, 0>) | 2432902008176640000::dec<38, 0> | ValueError: Error during planning: Failed to coerce arguments to satisfy a call to 'factorial' function: coercion from Decimal128(2, 0) to the signature Uniform |
| arithmetic_decimal/factorial_decimal.test:17 | factorial(null::dec?<1, 0>) | null::dec?<38, 0> |
Exception: DataFusion error: Arrow error: Compute error: zero raised to a negative … is undefined
Not yet reported upstream
Functions: power (2)
Exception: DataFusion error: Arrow error: Compute error: zero raised to a negative power is undefined [SELECT power(CAST('0.0' AS DOUBLE), CAST('-1.0' AS DOUBLE))]All 2 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic/power.test:5 | power(0.0::fp64, -1.0::fp64) | inf::fp64 |
| arithmetic/power.test:6 | power(0.0::fp32, -2.0::fp32) | inf::fp32 |
Exception: DataFusion error: Optimizer rule '…' failed
Not yet reported upstream
Functions: power, power_decimal
Exception: DataFusion error: Optimizer rule 'simplify_expressions' failed [SELECT power(CAST('1.5e+10' AS DECIMAL(38,0)), CAST('1.5e+20' AS DECIMAL(38,0)))]All 2 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic_decimal/power.test:14 | power(1.5e+10::dec<38, 0>, 1.5e+20::dec<38, 0>) | inf::fp64 |
| arithmetic_decimal/power_decimal.test:14 | power(1.5e+10::dec<38, 0>, 1.5e+20::dec<38, 0>) | inf::fp64 |
Expected an error, got a result
Not yet reported upstream
Functions: factorial_decimal (2)
expected a runtime error, got ValueError: Error during planning: Failed to coerce arguments to satisfy a call to 'factorial' function: coercion from Decimal128(2, 0) to the signature Uniform(1, [Int64]) [SELECT factorial(CAST('34' AS DECIMAL(2,0)))]All 2 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic_decimal/factorial_decimal.test:10 | factorial(34::dec<2, 0>) | <!ERROR> |
| arithmetic_decimal/factorial_decimal.test:13 | factorial(-1::dec<1, 0>) | <!ERROR> |
Exception: DataFusion error: Arrow error: Compute error: Decimal overflow while applying …
Not yet reported upstream
Functions: ceil
Exception: DataFusion error: Arrow error: Compute error: Decimal overflow while applying ceil [SELECT ceil(CAST('9.9' AS DECIMAL(2,1)))]The case
| Case | Test | Expected |
|---|---|---|
| rounding_decimal/ceil.test:7 | ceil(9.9::dec<2,1>) | 10::dec<2,0> |
Exception: DataFusion error: Arrow error: Compute error: regexp_count() requires start to be N based
Not yet reported upstream
Functions: regexp_count_substring
Exception: DataFusion error: Arrow error: Compute error: regexp_count() requires start to be 1 based [SELECT regexp_count('abcabc', 'a', -1)]The case
| Case | Test | Expected |
|---|---|---|
| string/regexp_count_substring.test:7 | regexp_count_substring('abcabc'::str, 'a'::str, -1::i64) | 0::i64 |
Exception: DataFusion error: Execution error: negative count not allowed: -N
Not yet reported upstream
Functions: substring
Exception: DataFusion error: Execution error: negative count not allowed: -1 [SELECT substring('abcdefg', CAST(1 AS INTEGER), CAST(-1 AS INTEGER))]The case
| Case | Test | Expected |
|---|---|---|
| string/substring.test:17 | substring('abcdefg'::str, 1::i32, -1::i32) | ''::str |
ValueError: Error during planning: Failed to coerce arguments to satisfy a call to '…' function: coercion from DecimalN(N, N) to the signature Uniform(N, [IntN]) failed. No function matches the given
Not yet reported upstream
Functions: factorial_decimal
ValueError: Error during planning: Failed to coerce arguments to satisfy a call to 'factorial' function: coercion from Decimal128(38, 0) to the signature Uniform(1, [Int64]) failed. No function matches the given [SELECT factorial(CAST(NULL AS DECIMAL(38,0)))]
The case
| Case | Test | Expected |
|---|---|---|
| arithmetic_decimal/factorial_decimal.test:16 | factorial(null::dec?<38, 0>) | null::dec?<38, 0> |
Not tested yet: this repository's tooling
Cases this repository cannot run yet. They are skipped and say nothing about the engine.
untranslatable: DataFusion has no regexp split function
Functions: regexp_string_split (34)
untranslatable: DataFusion has no regexp split function
All 34 cases
| Case | Test | Expected |
|---|---|---|
| string/regexp_string_split.test:5 | regexp_string_split('Hello'::str, 'Hel+?'::str) | ['', 'lo']::list<str> |
| string/regexp_string_split.test:6 | regexp_string_split('Hello'::str, 'Hel+'::str) | ['', 'o']::list<str> |
| string/regexp_string_split.test:9 | regexp_string_split('HHHelloooo'::str, 'Hel+'::str) | ['HH', 'oooo']::list<str> |
| string/regexp_string_split.test:12 | regexp_string_split('abcdefg'::str, '\Aabc'::str) | ['', 'defg']::list<str> |
| string/regexp_string_split.test:13 | regexp_string_split('abcdefg'::str, 'efg$'::str) | ['abcd', '']::list<str> |
| string/regexp_string_split.test:16 | regexp_string_split('abc1abc'::str, '\d'::str) | ['abc', 'abc']::list<str> |
| string/regexp_string_split.test:17 | regexp_string_split('111a111'::str, '\D'::str) | ['111', '111']::list<str> |
| string/regexp_string_split.test:18 | regexp_string_split('abc def'::str, '\s'::str) | ['abc', 'def']::list<str> |
| string/regexp_string_split.test:19 | regexp_string_split('a bcdef'::str, '\S'::str) | ['', ' ', '', '', '', '', '']::list<str> |
| string/regexp_string_split.test:20 | regexp_string_split(' abcdef'::str, '\w'::str) | [' ', '', '', '', '', '', '']::list<str> |
| string/regexp_string_split.test:21 | regexp_string_split('a bcdef'::str, '\W'::str) | ['a', 'bcdef']::list<str> |
| string/regexp_string_split.test:24 | regexp_string_split('abc123abc'::str, '[0-9]+'::str) | ['abc', 'abc']::list<str> |
| string/regexp_string_split.test:25 | regexp_string_split('abc123abc'::str, '[bc]'::str) | ['a', '', '123a', '', '']::list<str> |
| string/regexp_string_split.test:26 | regexp_string_split('abcde'::str, '(.*)c'::str) | ['', 'de']::list<str> |
| string/regexp_string_split.test:27 | regexp_string_split('abbbbc'::str, '[b]{2,3}'::str) | ['a', 'bc']::list<str> |
| string/regexp_string_split.test:30 | regexp_string_split('100 dollars'::str, '\d+(?= dollars)'::str) | ['', ' dollars']::list<str> |
| string/regexp_string_split.test:33 | regexp_string_split('100 pesos'::str, '\d+(?!\d| dollars)'::str) | ['', ' pesos']::list<str> |
| string/regexp_string_split.test:36 | regexp_string_split('USD100'::str, '(?<=USD)\d{3}'::str) | ['USD', '']::list<str> |
| string/regexp_string_split.test:39 | regexp_string_split('JPY100'::str, '\d{3}(?<!USD\d{3})'::str) | ['JPY', '']::list<str> |
| string/regexp_string_split.test:5 | regexp_string_split(null::str?, 'pattern'::str) | null::list?<str> |
| string/regexp_string_split.test:6 | regexp_string_split('text'::str, null::str?) | null::list?<str> |
| string/regexp_string_split.test:7 | regexp_string_split(null::str?, null::str?) | null::list?<str> |
| string/regexp_string_split.test:10 | regexp_string_split(''::str, 'a'::str) | ['']::list<str> |
| string/regexp_string_split.test:11 | regexp_string_split(''::str, ''::str) | ['']::list<str> |
| string/regexp_string_split.test:12 | regexp_string_split('abc'::str, 'abc'::str) | ['', '']::list<str> |
| string/regexp_string_split.test:13 | regexp_string_split('aaa'::str, 'a'::str) | ['', '', '', '']::list<str> |
| string/regexp_string_split.test:14 | regexp_string_split('bbbbb'::str, 'b+'::str) | ['', '']::list<str> |
| string/regexp_string_split.test:15 | regexp_string_split('aaabbbccc'::str, '[abc]'::str) | ['', '', '', '', '', '', '', '', '', '']::list<str> |
| string/regexp_string_split.test:18 | regexp_string_split('café'::str, 'é'::str) | ['caf', '']::list<str> |
| string/regexp_string_split.test:19 | regexp_string_split('你好世界'::str, '好'::str) | ['你', '世界']::list<str> |
| string/regexp_string_split.test:22 | regexp_string_split('abc'::str, 'xyz'::str) | ['abc']::list<str> |
| string/regexp_string_split.test:23 | regexp_string_split('hello world'::str, 'z+'::str) | ['hello world']::list<str> |
| string/regexp_string_split.test:24 | regexp_string_split('hello🌍world'::str, '🌍'::str) | ['hello', 'world']::list<str> |
| string/regexp_string_split.test:25 | regexp_string_split('AbCdEf'::str, '(?i)b'::str) | ['A', 'CdEf']::list<str> |
The plan builder cannot build these types yet
Unsigned integers and some other types are user-defined types in Substrait; building plans with them is not implemented here yet, so these cases say nothing about the engine.
Functions: add (9), multiply (9), subtract (9), divide (6)
plan not built: user-defined type literals (u!...) are not built
All 33 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic_unsigned/add.test:5 | add(('200')::u!u8, ('50')::u!u8) | ('250')::u!u8 |
| arithmetic_unsigned/add.test:6 | add(('50000')::u!u16, ('10000')::u!u16) | ('60000')::u!u16 |
| arithmetic_unsigned/add.test:7 | add(('3000000000')::u!u32, ('1000000000')::u!u32) | ('4000000000')::u!u32 |
| arithmetic_unsigned/add.test:8 | add(('10000000000000000000')::u!u64, ('1000000000000000000')::u!u64) | ('11000000000000000000')::u!u64 |
| arithmetic_unsigned/add.test:11 | add(('200')::u!u8, ('100')::u!u8) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/add.test:12 | add(('60000')::u!u16, ('10000')::u!u16) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/add.test:13 | add(('4000000000')::u!u32, ('1000000000')::u!u32) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/add.test:14 | add(('18446744073709551615')::u!u64, ('1')::u!u64) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/add.test:15 | add(('200')::u!u8, ('100')::u!u8) [overflow:SATURATE] | ('255')::u!u8 |
| arithmetic_unsigned/divide.test:5 | divide(('250')::u!u8, ('5')::u!u8) | ('50')::u!u8 |
| arithmetic_unsigned/divide.test:6 | divide(('60000')::u!u16, ('100')::u!u16) | ('600')::u!u16 |
| arithmetic_unsigned/divide.test:7 | divide(('4000000000')::u!u32, ('200')::u!u32) | ('20000000')::u!u32 |
| arithmetic_unsigned/divide.test:8 | divide(('10000000000000000000')::u!u64, ('5000')::u!u64) | ('2000000000000000')::u!u64 |
| arithmetic_unsigned/divide.test:11 | divide(('5')::u!u8, ('0')::u!u8) [on_division_by_zero:NULL] | null::u!u8? |
| arithmetic_unsigned/divide.test:12 | divide(('5')::u!u8, ('0')::u!u8) [on_division_by_zero:ERROR] | <!ERROR> |
| arithmetic_unsigned/multiply.test:5 | multiply(('25')::u!u8, ('5')::u!u8) | ('125')::u!u8 |
| arithmetic_unsigned/multiply.test:6 | multiply(('200')::u!u16, ('100')::u!u16) | ('20000')::u!u16 |
| arithmetic_unsigned/multiply.test:7 | multiply(('300')::u!u32, ('200')::u!u32) | ('60000')::u!u32 |
| arithmetic_unsigned/multiply.test:8 | multiply(('80000')::u!u64, ('5000')::u!u64) | ('400000000')::u!u64 |
| arithmetic_unsigned/multiply.test:11 | multiply(('200')::u!u8, ('2')::u!u8) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/multiply.test:12 | multiply(('40000')::u!u16, ('2')::u!u16) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/multiply.test:13 | multiply(('3000000000')::u!u32, ('2')::u!u32) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/multiply.test:14 | multiply(('10000000000000000000')::u!u64, ('2')::u!u64) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/multiply.test:15 | multiply(('200')::u!u8, ('2')::u!u8) [overflow:SATURATE] | ('255')::u!u8 |
| arithmetic_unsigned/subtract.test:5 | subtract(('250')::u!u8, ('50')::u!u8) | ('200')::u!u8 |
| arithmetic_unsigned/subtract.test:6 | subtract(('60000')::u!u16, ('10000')::u!u16) | ('50000')::u!u16 |
| arithmetic_unsigned/subtract.test:7 | subtract(('4000000000')::u!u32, ('1000000000')::u!u32) | ('3000000000')::u!u32 |
| arithmetic_unsigned/subtract.test:8 | subtract(('11000000000000000000')::u!u64, ('1000000000000000000')::u!u64) | ('10000000000000000000')::u!u64 |
| arithmetic_unsigned/subtract.test:11 | subtract(('0')::u!u8, ('1')::u!u8) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/subtract.test:12 | subtract(('0')::u!u16, ('1')::u!u16) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/subtract.test:13 | subtract(('0')::u!u32, ('1')::u!u32) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/subtract.test:14 | subtract(('0')::u!u64, ('1')::u!u64) [overflow:ERROR] | <!ERROR> |
| arithmetic_unsigned/subtract.test:15 | subtract(('0')::u!u8, ('1')::u!u8) [overflow:SATURATE] | ('0')::u!u8 |
untranslatable: DataFusion has no bitwise NOT operator
Functions: bitwise_not (33)
untranslatable: DataFusion has no bitwise NOT operator
All 33 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic/bitwise_not.test:5 | bitwise_not(0::i8) | -1::i8 |
| arithmetic/bitwise_not.test:6 | bitwise_not(1::i8) | -2::i8 |
| arithmetic/bitwise_not.test:7 | bitwise_not(-127::i8) | 126::i8 |
| arithmetic/bitwise_not.test:8 | bitwise_not(31766::i16) | -31767::i16 |
| arithmetic/bitwise_not.test:9 | bitwise_not(-31766::i16) | 31765::i16 |
| arithmetic/bitwise_not.test:10 | bitwise_not(2147483647::i32) | -2147483648::i32 |
| arithmetic/bitwise_not.test:11 | bitwise_not(9223372036854775807::i64) | -9223372036854775808::i64 |
| arithmetic/bitwise_not.test:12 | bitwise_not(-9223372036854775807::i64) | 9223372036854775806::i64 |
| arithmetic/bitwise_not.test:13 | bitwise_not(null::i64?) | null::i64? |
| arithmetic/bitwise_not.test:5 | bitwise_not(-128::i8) | 127::i8 |
| arithmetic/bitwise_not.test:6 | bitwise_not(127::i8) | -128::i8 |
| arithmetic/bitwise_not.test:7 | bitwise_not(-32768::i16) | 32767::i16 |
| arithmetic/bitwise_not.test:8 | bitwise_not(32767::i16) | -32768::i16 |
| arithmetic/bitwise_not.test:9 | bitwise_not(-2147483648::i32) | 2147483647::i32 |
| arithmetic/bitwise_not.test:10 | bitwise_not(-9223372036854775808::i64) | 9223372036854775807::i64 |
| arithmetic/bitwise_not.test:13 | bitwise_not(null::i8?) | null::i8? |
| arithmetic/bitwise_not.test:14 | bitwise_not(null::i16?) | null::i16? |
| arithmetic/bitwise_not.test:15 | bitwise_not(null::i32?) | null::i32? |
| arithmetic/bitwise_not.test:18 | bitwise_not(0::i16) | -1::i16 |
| arithmetic/bitwise_not.test:19 | bitwise_not(0::i32) | -1::i32 |
| arithmetic/bitwise_not.test:20 | bitwise_not(0::i64) | -1::i64 |
| arithmetic/bitwise_not.test:21 | bitwise_not(-1::i8) | 0::i8 |
| arithmetic/bitwise_not.test:22 | bitwise_not(-1::i16) | 0::i16 |
| arithmetic/bitwise_not.test:23 | bitwise_not(-1::i32) | 0::i32 |
| arithmetic/bitwise_not.test:24 | bitwise_not(-1::i64) | 0::i64 |
| arithmetic/bitwise_not.test:27 | bitwise_not(42::i8) | -43::i8 |
| arithmetic/bitwise_not.test:28 | bitwise_not(-42::i8) | 41::i8 |
| arithmetic/bitwise_not.test:29 | bitwise_not(1000::i16) | -1001::i16 |
| arithmetic/bitwise_not.test:30 | bitwise_not(-1000::i16) | 999::i16 |
| arithmetic/bitwise_not.test:31 | bitwise_not(100000::i32) | -100001::i32 |
| arithmetic/bitwise_not.test:32 | bitwise_not(-100000::i32) | 99999::i32 |
| arithmetic/bitwise_not.test:35 | bitwise_not(1000000000000::i64) | -1000000000001::i64 |
| arithmetic/bitwise_not.test:36 | bitwise_not(-1000000000000::i64) | 999999999999::i64 |
The plan builder cannot build lambda arguments yet
Functions: all_match (8), any_match (8), filter (5), transform (4)
plan not built: lambda arguments are not built
All 25 cases
| Case | Test | Expected |
|---|---|---|
| list/all_match.test:6 | all_match([1, 2, 3]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:7 | all_match([5, 6, 7]::list<i32>, (x -> gt(x, 4::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:10 | all_match([1, 2, 3]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool?>) | false::bool? |
| list/all_match.test:11 | all_match([1, 2, 3]::list<i32>, (x -> lt(x, 3::i32))::func<i32 -> bool?>) | false::bool? |
| list/all_match.test:14 | all_match([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:17 | all_match(null::list?<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | null::bool? |
| list/all_match.test:23 | all_match([1, Null, 2]::list<i32?>, (x -> gt(x, 0::i32))::func<i32? -> bool?>) | Null::bool? |
| list/all_match.test:24 | all_match([1, Null, 0]::list<i32?>, (x -> gt(x, 0::i32))::func<i32? -> bool?>) | false::bool? |
| list/any_match.test:6 | any_match([1, 2, 3]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:7 | any_match([1, 2, 3]::list<i32>, (x -> lt(x, 2::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:8 | any_match([5, 6, 7]::list<i32>, (x -> gt(x, 4::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:11 | any_match([1, 2, 3]::list<i32>, (x -> gt(x, 5::i32))::func<i32 -> bool?>) | false::bool? |
| list/any_match.test:14 | any_match([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | false::bool? |
| list/any_match.test:17 | any_match(null::list?<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | null::bool? |
| list/any_match.test:23 | any_match([1, Null, 3]::list<i32?>, (x -> gt(x, 2::i32))::func<i32? -> bool?>) | true::bool? |
| list/any_match.test:24 | any_match([1, Null, 2]::list<i32?>, (x -> gt(x, 5::i32))::func<i32? -> bool?>) | Null::bool? |
| list/filter.test:6 | filter([1, 2, 3, 4, 5]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool>) | [3, 4, 5]::list<i32> |
| list/filter.test:7 | filter([1, 2, 3, 4, 5]::list<i32>, (x -> lt(x, 3::i32))::func<i32 -> bool>) | [1, 2]::list<i32> |
| list/filter.test:8 | filter([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool>) | []::list<i32> |
| list/filter.test:11 | filter([1, null, 3]::list<i32?>, (n -> gt(n, 0::i32))::func<i32 -> bool>) | [1, 3]::list<i32?> |
| list/filter.test:12 | filter([1, null, 3]::list<i32?>, (e -> is_null(e))::func<i32 -> bool>) | [null]::list<i32?> |
| list/transform.test:6 | transform([1, 2, 3]::list<i32>, (x -> multiply(x, 2::i32))::func<i32 -> i32>) | [2, 4, 6]::list<i32> |
| list/transform.test:7 | transform([5, 10, 15]::list<i32>, (x -> add(x, 1::i32))::func<i32 -> i32>) | [6, 11, 16]::list<i32> |
| list/transform.test:8 | transform([]::list<i32>, (x -> multiply(x, 2::i32))::func<i32 -> i32>) | []::list<i32> |
| list/transform.test:11 | transform([1, Null, 3]::list<i32?>, (x -> multiply(x, 2::i32))::func<i32? -> i32?>) | [2, Null, 6]::list<i32?> |
The plan builder cannot build these types yet
Unsigned integers and some other types are user-defined types in Substrait; building plans with them is not implemented here yet, so these cases say nothing about the engine.
Functions: sum (8), max (7), min (7), all_match, any_match, is_null
plan not built: type 'u!u8?' is not built (yet)
All 25 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic_unsigned/max.test:5 | max(('20', '3', '1', '10', '0', '5')::u!u8) | ('20')::u!u8? | |
| arithmetic_unsigned/max.test:6 | max(('32768', '32767', '20000', '30000')::u!u16) | ('32768')::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/max.test:7 | max(('214748648', '214748647', '21470048', '4000000')::u!u32) | ('214748648')::u!u32? | plan not built: type 'u!u32?' is not built (yet) |
| arithmetic_unsigned/max.test:8 | max(('2000000000', '3217908979', '629000000', '100000000', '0', '987654321')::u!u64) | ('3217908979')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/max.test:11 | max((Null, Null, Null)::u!u16) | Null::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/max.test:12 | max(()::u!u16) | Null::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/max.test:13 | max(('200', Null, '50', '100', Null, '5')::u!u64) | ('200')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/min.test:5 | min(('20', '3', '1', '10', '0', '5')::u!u8) | ('0')::u!u8? | |
| arithmetic_unsigned/min.test:6 | min(('32768', '32767', '20000', '30000')::u!u16) | ('20000')::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/min.test:7 | min(('214748648', '214748647', '21470048', '4000000')::u!u32) | ('4000000')::u!u32? | plan not built: type 'u!u32?' is not built (yet) |
| arithmetic_unsigned/min.test:8 | min(('2000000000', '3217908979', '629000000', '100000000', '0', '987654321')::u!u64) | ('0')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/min.test:11 | min((Null, Null, Null)::u!u16) | Null::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/min.test:12 | min(()::u!u16) | Null::u!u16? | plan not built: type 'u!u16?' is not built (yet) |
| arithmetic_unsigned/min.test:13 | min(('200', Null, '50', '100', Null, '5')::u!u64) | ('5')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:5 | sum(('0', '1', '2', '20')::u!u8) | ('23')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:6 | sum(('100', '200', '50')::u!u16) | ('350')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:7 | sum(('2000000', '3217908', '629000', '100000', '0', '987654')::u!u32) | ('6934562')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:8 | sum(('1000000000000', '2000000000000', '3000000000000')::u!u64) | ('6000000000000')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:11 | sum(('18446744073709551614', '1', '1', '1', '1', '10000000000')::u!u64) [overflow:ERROR] | <!ERROR> | plan not built: type 'u!u64' is not built (yet) |
| arithmetic_unsigned/sum.test:14 | sum((Null, Null, Null)::u!u16) | Null::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:15 | sum(()::u!u16) | Null::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| arithmetic_unsigned/sum.test:16 | sum(('200', Null, '50', '0', Null, '100')::u!u32) | ('350')::u!u64? | plan not built: type 'u!u64?' is not built (yet) |
| list/all_match.test:20 | all_match([1, 2, 3]::list<i32>, null::func?<i32 -> bool?>) | null::bool? | plan not built: type 'func?<i32->bool?>' is not built (yet) |
| list/any_match.test:20 | any_match([1, 2, 3]::list<i32>, null::func?<i32 -> bool?>) | null::bool? | plan not built: type 'func?<i32->bool?>' is not built (yet) |
| comparison/is_null.test:50 | is_null(null::fixedbinary?<10>) | true::bool | plan not built: type 'fixedbinary?<10>' is not built (yet) |
untranslatable: DataFusion has no list lambdas
Functions: all_match (8), any_match (8), filter (5), transform (4)
untranslatable: DataFusion has no list lambdas
All 25 cases
| Case | Test | Expected |
|---|---|---|
| list/all_match.test:6 | all_match([1, 2, 3]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:7 | all_match([5, 6, 7]::list<i32>, (x -> gt(x, 4::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:10 | all_match([1, 2, 3]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool?>) | false::bool? |
| list/all_match.test:11 | all_match([1, 2, 3]::list<i32>, (x -> lt(x, 3::i32))::func<i32 -> bool?>) | false::bool? |
| list/all_match.test:14 | all_match([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | true::bool? |
| list/all_match.test:17 | all_match(null::list?<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | null::bool? |
| list/all_match.test:23 | all_match([1, Null, 2]::list<i32?>, (x -> gt(x, 0::i32))::func<i32? -> bool?>) | Null::bool? |
| list/all_match.test:24 | all_match([1, Null, 0]::list<i32?>, (x -> gt(x, 0::i32))::func<i32? -> bool?>) | false::bool? |
| list/any_match.test:6 | any_match([1, 2, 3]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:7 | any_match([1, 2, 3]::list<i32>, (x -> lt(x, 2::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:8 | any_match([5, 6, 7]::list<i32>, (x -> gt(x, 4::i32))::func<i32 -> bool?>) | true::bool? |
| list/any_match.test:11 | any_match([1, 2, 3]::list<i32>, (x -> gt(x, 5::i32))::func<i32 -> bool?>) | false::bool? |
| list/any_match.test:14 | any_match([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | false::bool? |
| list/any_match.test:17 | any_match(null::list?<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool?>) | null::bool? |
| list/any_match.test:23 | any_match([1, Null, 3]::list<i32?>, (x -> gt(x, 2::i32))::func<i32? -> bool?>) | true::bool? |
| list/any_match.test:24 | any_match([1, Null, 2]::list<i32?>, (x -> gt(x, 5::i32))::func<i32? -> bool?>) | Null::bool? |
| list/filter.test:6 | filter([1, 2, 3, 4, 5]::list<i32>, (x -> gt(x, 2::i32))::func<i32 -> bool>) | [3, 4, 5]::list<i32> |
| list/filter.test:7 | filter([1, 2, 3, 4, 5]::list<i32>, (x -> lt(x, 3::i32))::func<i32 -> bool>) | [1, 2]::list<i32> |
| list/filter.test:8 | filter([]::list<i32>, (x -> gt(x, 0::i32))::func<i32 -> bool>) | []::list<i32> |
| list/filter.test:11 | filter([1, null, 3]::list<i32?>, (n -> gt(n, 0::i32))::func<i32 -> bool>) | [1, 3]::list<i32?> |
| list/filter.test:12 | filter([1, null, 3]::list<i32?>, (e -> is_null(e))::func<i32 -> bool>) | [null]::list<i32?> |
| list/transform.test:6 | transform([1, 2, 3]::list<i32>, (x -> multiply(x, 2::i32))::func<i32 -> i32>) | [2, 4, 6]::list<i32> |
| list/transform.test:7 | transform([5, 10, 15]::list<i32>, (x -> add(x, 1::i32))::func<i32 -> i32>) | [6, 11, 16]::list<i32> |
| list/transform.test:8 | transform([]::list<i32>, (x -> multiply(x, 2::i32))::func<i32 -> i32>) | []::list<i32> |
| list/transform.test:11 | transform([1, Null, 3]::list<i32?>, (x -> multiply(x, 2::i32))::func<i32? -> i32?>) | [2, Null, 6]::list<i32?> |
untranslatable: DataFusion has no isfinite function
Functions: is_finite (24)
untranslatable: DataFusion has no isfinite function
All 24 cases
| Case | Test | Expected |
|---|---|---|
| comparison/is_finite.test:5 | is_finite(0.0::fp32) | true::bool |
| comparison/is_finite.test:6 | is_finite(0.55::fp32) | true::bool |
| comparison/is_finite.test:7 | is_finite(1000.000000000001::fp64) | true::bool |
| comparison/is_finite.test:8 | is_finite(-inf::fp64) | false::bool |
| comparison/is_finite.test:9 | is_finite(inf::fp64) | false::bool |
| comparison/is_finite.test:10 | is_finite(null::fp64?) | null::bool? |
| comparison/is_finite.test:5 | is_finite(nan::fp32) | false::bool |
| comparison/is_finite.test:6 | is_finite(nan::fp64) | false::bool |
| comparison/is_finite.test:7 | is_finite(-inf::fp32) | false::bool |
| comparison/is_finite.test:8 | is_finite(inf::fp32) | false::bool |
| comparison/is_finite.test:11 | is_finite(-0.0::fp32) | true::bool |
| comparison/is_finite.test:12 | is_finite(-0.0::fp64) | true::bool |
| comparison/is_finite.test:13 | is_finite(-0.00001::fp32) | true::bool |
| comparison/is_finite.test:16 | is_finite(1.4e-45::fp32) | true::bool |
| comparison/is_finite.test:17 | is_finite(-1.4e-45::fp32) | true::bool |
| comparison/is_finite.test:18 | is_finite(5e-324::fp64) | true::bool |
| comparison/is_finite.test:19 | is_finite(-5e-324::fp64) | true::bool |
| comparison/is_finite.test:22 | is_finite(-1.5::fp32) | true::bool |
| comparison/is_finite.test:23 | is_finite(-999.999::fp64) | true::bool |
| comparison/is_finite.test:24 | is_finite(-3.4028235e38::fp32) | true::bool |
| comparison/is_finite.test:25 | is_finite(-1.7976931348623157e308::fp64) | true::bool |
| comparison/is_finite.test:28 | is_finite(3.4028235e38::fp32) | true::bool |
| comparison/is_finite.test:29 | is_finite(1.7976931348623157e308::fp64) | true::bool |
| comparison/is_finite.test:30 | is_finite(123.456::fp32) | true::bool |
untranslatable: DataFusion has no isinf function
Functions: is_infinite (16)
untranslatable: DataFusion has no isinf function
All 16 cases
| Case | Test | Expected |
|---|---|---|
| comparison/is_infinite.test:5 | is_infinite(0.0::fp32) | false::bool |
| comparison/is_infinite.test:6 | is_infinite(0.55::fp32) | false::bool |
| comparison/is_infinite.test:7 | is_infinite(1000.000000000001::fp64) | false::bool |
| comparison/is_infinite.test:8 | is_infinite(-inf::fp64) | true::bool |
| comparison/is_infinite.test:9 | is_infinite(inf::fp64) | true::bool |
| comparison/is_infinite.test:10 | is_infinite(null::fp64?) | null::bool? |
| comparison/is_infinite.test:5 | is_infinite(nan::fp32) | false::bool |
| comparison/is_infinite.test:6 | is_infinite(nan::fp64) | false::bool |
| comparison/is_infinite.test:7 | is_infinite(-inf::fp32) | true::bool |
| comparison/is_infinite.test:8 | is_infinite(inf::fp32) | true::bool |
| comparison/is_infinite.test:9 | is_infinite(-0.0::fp32) | false::bool |
| comparison/is_infinite.test:10 | is_infinite(-0.0::fp64) | false::bool |
| comparison/is_infinite.test:11 | is_infinite(-1.5::fp32) | false::bool |
| comparison/is_infinite.test:12 | is_infinite(-1000.000000000001::fp64) | false::bool |
| comparison/is_infinite.test:13 | is_infinite(3.4028235e38::fp32) | false::bool |
| comparison/is_infinite.test:14 | is_infinite(1.7976931348623157e308::fp64) | false::bool |
untranslatable: DataFusion has no integer type wider than N bits
Functions: shift_right_unsigned (15)
untranslatable: DataFusion has no integer type wider than 64 bits
All 15 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic/shift_right_unsigned.test:7 | shift_right_unsigned(301989888::i64, 3::i32) | 37748736::i64 |
| arithmetic/shift_right_unsigned.test:8 | shift_right_unsigned(301989888::i64, 16::i32) | 4608::i64 |
| arithmetic/shift_right_unsigned.test:11 | shift_right_unsigned(-3::i64, 1::i32) | 9223372036854775806::i64 |
| arithmetic/shift_right_unsigned.test:12 | shift_right_unsigned(-3::i64, 2::i32) | 4611686018427387903::i64 |
| arithmetic/shift_right_unsigned.test:13 | shift_right_unsigned(null::i64?, 2::i32) | null::i64? |
| arithmetic/shift_right_unsigned.test:14 | shift_right_unsigned(127::i64, null::i32?) | null::i64? |
| arithmetic/shift_right_unsigned.test:7 | shift_right_unsigned(9223372036854775807::i64, 1::i32) | 4611686018427387903::i64 |
| arithmetic/shift_right_unsigned.test:8 | shift_right_unsigned(-9223372036854775808::i64, 1::i32) | 4611686018427387904::i64 |
| arithmetic/shift_right_unsigned.test:10 | shift_right_unsigned(-1::i64, 32::i32) | 4294967295::i64 |
| arithmetic/shift_right_unsigned.test:15 | shift_right_unsigned(-9223372036854775808::i64, 63::i32) | 1::i64 |
| arithmetic/shift_right_unsigned.test:17 | shift_right_unsigned(-1::i64, 1::i32) | 9223372036854775807::i64 |
| arithmetic/shift_right_unsigned.test:21 | shift_right_unsigned(null::i64?, null::i32?) | null::i64? |
| arithmetic/shift_right_unsigned.test:25 | shift_right_unsigned(123456789::i64, 0::i32) | 123456789::i64 |
| arithmetic/shift_right_unsigned.test:27 | shift_right_unsigned(1::i64, 63::i32) | 0::i64 |
| arithmetic/shift_right_unsigned.test:31 | shift_right_unsigned(-1::i64, 8::i32) | 72057594037927935::i64 |
untranslatable: DataFusion regexp_match returns the first match only
Functions: regexp_match_substring (4)
untranslatable: DataFusion regexp_match returns the first match only
All 4 cases
| Case | Test | Expected |
|---|---|---|
| string/regexp_match_substring.test:5 | regexp_match_substring('abc'::str, 'a'::str, 1::i64, 5::i64, 0::i64) | null::str? |
| string/regexp_match_substring.test:12 | regexp_match_substring('foobarboopzoo'::str, 'o{1,}'::str, 1::i64, 2::i64, 0::i64) | 'oo'::str |
| string/regexp_match_substring.test:13 | regexp_match_substring('abcabcacb'::str, '[bc]'::str, 1::i64, 2::i64, 0::i64) | 'c'::str |
| string/regexp_match_substring.test:14 | regexp_match_substring('abcabcacb'::str, '[bc]'::str, 1::i64, 3::i64, 0::i64) | 'b'::str |
untranslatable: type '…' has no SQL equivalent here
Functions: all_match, any_match, is_null
untranslatable: type 'func?<i32->bool?>' has no SQL equivalent here
All 3 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| list/all_match.test:20 | all_match([1, 2, 3]::list<i32>, null::func?<i32 -> bool?>) | null::bool? | |
| list/any_match.test:20 | any_match([1, 2, 3]::list<i32>, null::func?<i32 -> bool?>) | null::bool? | |
| comparison/is_null.test:50 | is_null(null::fixedbinary?<10>) | true::bool | untranslatable: type 'fixedbinary?<10>' has no SQL equivalent here |
untranslatable: … result of N characters is too large to materialise
Functions: repeat
untranslatable: repeat result of 9223372036854775807 characters is too large to materialise
The case
| Case | Test | Expected |
|---|---|---|
| string/repeat.test:5 | repeat(''::str, 9223372036854775807::i64) | ''::str |
Option modes the engine does not claim
Cases for an option mode (overflow, rounding, ...) the engine does not implement. They are skipped: engines need to implement only one mode.
Show the 135 cases
option mode not implemented (overflow:ERROR): expected an error, got [-N]
Functions: multiply (8), add (4), subtract (4), sum
option mode not implemented (overflow:ERROR): expected an error, got [-126]
All 17 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/add.test:11 | add(120::i8, 10::i8) [overflow:ERROR] | <!ERROR> | |
| arithmetic/add.test:12 | add(30000::i16, 30000::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-5536] |
| arithmetic/add.test:13 | add(2000000000::i32, 2000000000::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-294967296] |
| arithmetic/add.test:14 | add(9223372036854775807::i64, 1::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-9223372036854775808] |
| arithmetic/multiply.test:11 | multiply(13::i8, 10::i8) [overflow:ERROR] | <!ERROR> | |
| arithmetic/multiply.test:12 | multiply(11::i16, 3000::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-32536] |
| arithmetic/multiply.test:13 | multiply(3::i32, 1000000000::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-1294967296] |
| arithmetic/multiply.test:14 | multiply(1000000000000000000::i64, 10::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-8446744073709551616] |
| arithmetic/sum.test:11 | sum((9223372036854775806, 1, 1, 1, 1, 10000000000)::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-9223372026854775806] |
| arithmetic/multiply.test:17 | multiply(-128::i8, -1::i8) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-128] |
| arithmetic/multiply.test:19 | multiply(-32768::i16, -1::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-32768] |
| arithmetic/multiply.test:21 | multiply(-2147483648::i32, -1::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-2147483648] |
| arithmetic/multiply.test:23 | multiply(-9223372036854775808::i64, -1::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-9223372036854775808] |
| arithmetic/subtract.test:13 | subtract(127::i8, -1::i8) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-128] |
| arithmetic/subtract.test:15 | subtract(32767::i16, -1::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-32768] |
| arithmetic/subtract.test:17 | subtract(2147483647::i32, -1::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-2147483648] |
| arithmetic/subtract.test:19 | subtract(9223372036854775807::i64, -1::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [-9223372036854775808] |
option mode not implemented (case_sensitivity:CASE_INSENSITIVE): got False, expected True
Functions: ends_with (7), starts_with (5), contains (3)
option mode not implemented (case_sensitivity:CASE_INSENSITIVE): got False, expected True
All 15 cases
| Case | Test | Expected |
|---|---|---|
| string/contains.test:7 | contains('abcdefg'::str, 'CdE'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/contains.test:15 | contains('😊a😊b😊😊'::str, 'A😊B'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:10 | ends_with('abcd'::str, 'CD'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:16 | ends_with('😊a😊b😊😊'::str, 'B😊😊'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/starts_with.test:10 | starts_with('abcd'::str, 'AB'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/starts_with.test:16 | starts_with('😊a😊b😊😊'::str, '😊A'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/contains.test:22 | contains('abc'::str, 'ABC'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:22 | ends_with('ABCD'::str, 'cd'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:23 | ends_with('MixedCase'::str, 'CASE'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:24 | ends_with('test123'::str, 'TEST123'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:25 | ends_with('Café'::str, 'FÉ'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/ends_with.test:26 | ends_with('HELLO😊'::str, 'hello😊'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/starts_with.test:26 | starts_with('ABC'::str, 'abc'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/starts_with.test:27 | starts_with('aBcD'::str, 'AbCd'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
| string/starts_with.test:31 | starts_with('ÄÖÜ'::str, 'ä'::str) [case_sensitivity:CASE_INSENSITIVE] | true::bool |
option mode not implemented (overflow:ERROR): expected an error, got [N]
Functions: subtract (7), add (4), sum (3), factorial
option mode not implemented (overflow:ERROR): expected an error, got [126]
All 15 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/subtract.test:11 | subtract(-120::i8, 10::i8) [overflow:ERROR] | <!ERROR> | |
| arithmetic/subtract.test:12 | subtract(-30000::i16, 30000::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [5536] |
| arithmetic/subtract.test:13 | subtract(-2000000000::i32, 2000000000::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [294967296] |
| arithmetic/subtract.test:14 | subtract(-9223372036854775808::i64, 1::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [9223372036854775807] |
| arithmetic/add.test:15 | add(-120::i8, -10::i8) [overflow:ERROR] | <!ERROR> | |
| arithmetic/add.test:16 | add(-30000::i16, -10000::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [25536] |
| arithmetic/add.test:17 | add(-2000000000::i32, -200000000::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [2094967296] |
| arithmetic/add.test:18 | add(-9223372036854775807::i64, -2::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [9223372036854775807] |
| arithmetic/factorial.test:5 | factorial(13::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [6227020800] |
| arithmetic/subtract.test:14 | subtract(-128::i8, 1::i8) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [127] |
| arithmetic/subtract.test:16 | subtract(-32768::i16, 1::i16) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [32767] |
| arithmetic/subtract.test:18 | subtract(-2147483648::i32, 1::i32) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [2147483647] |
| arithmetic/sum.test:18 | sum((-9223372036854775808, -1)::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [9223372036854775807] |
| arithmetic/sum.test:19 | sum((-9223372036854775807, -2)::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [9223372036854775807] |
| arithmetic/sum.test:20 | sum((-9223372036854775808, -1, -1, -1)::i64) [overflow:ERROR] | <!ERROR> | option mode not implemented (overflow:ERROR): expected an error, got [9223372036854775805] |
option mode not implemented (overflow:SATURATE): got -N, expected N
Functions: multiply (5), subtract (4), add
option mode not implemented (overflow:SATURATE): got -126, expected 127
All 10 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/add.test:15 | add(120::i8, 10::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/multiply.test:15 | multiply(13::i8, 10::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/subtract.test:16 | subtract(120::i8, -10::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/multiply.test:18 | multiply(-128::i8, -1::i8) [overflow:SATURATE] | 127::i8 | option mode not implemented (overflow:SATURATE): got -128, expected 127 |
| arithmetic/multiply.test:20 | multiply(-32768::i16, -1::i16) [overflow:SATURATE] | 32767::i16 | option mode not implemented (overflow:SATURATE): got -32768, expected 32767 |
| arithmetic/multiply.test:22 | multiply(-2147483648::i32, -1::i32) [overflow:SATURATE] | 2147483647::i32 | option mode not implemented (overflow:SATURATE): got -2147483648, expected 2147483647 |
| arithmetic/multiply.test:24 | multiply(-9223372036854775808::i64, -1::i64) [overflow:SATURATE] | 9223372036854775807::i64 | option mode not implemented (overflow:SATURATE): got -9223372036854775808, expected 9223372036854775807 |
| arithmetic/subtract.test:20 | subtract(127::i8, -1::i8) [overflow:SATURATE] | 127::i8 | option mode not implemented (overflow:SATURATE): got -128, expected 127 |
| arithmetic/subtract.test:22 | subtract(32767::i16, -1::i16) [overflow:SATURATE] | 32767::i16 | option mode not implemented (overflow:SATURATE): got -32768, expected 32767 |
| arithmetic/subtract.test:24 | subtract(2147483647::i32, -1::i32) [overflow:SATURATE] | 2147483647::i32 | option mode not implemented (overflow:SATURATE): got -2147483648, expected 2147483647 |
option mode not implemented (on_domain_error:ERROR): expected an error, got [nan]
Functions: acosh (5), ln, log10, log2, logb
option mode not implemented (on_domain_error:ERROR): expected an error, got [nan]
All 9 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic/acosh.test:10 | acosh(0.01::fp32) [on_domain_error:ERROR] | <!ERROR> |
| logarithmic/ln.test:10 | ln(-inf::fp64) [on_domain_error:ERROR] | <!ERROR> |
| logarithmic/log10.test:10 | log10(-inf::fp64) [on_domain_error:ERROR] | <!ERROR> |
| logarithmic/log2.test:11 | log2(-inf::fp64) [on_domain_error:ERROR] | <!ERROR> |
| logarithmic/logb.test:11 | logb(-inf::fp64, 10::fp64) [on_domain_error:ERROR] | <!ERROR> |
| arithmetic/acosh.test:17 | acosh(-1.0::fp64) [on_domain_error:ERROR] | <!ERROR> |
| arithmetic/acosh.test:18 | acosh(-1.0::fp32) [on_domain_error:ERROR] | <!ERROR> |
| arithmetic/acosh.test:19 | acosh(0.99::fp64) [on_domain_error:ERROR] | <!ERROR> |
| arithmetic/acosh.test:20 | acosh(0.99::fp32) [on_domain_error:ERROR] | <!ERROR> |
option mode not implemented (on_domain_error:NAN): Exception: DataFusion error: Arrow error: Compute error: Execution error: cannot take square root of a negative number
Functions: sqrt (8)
option mode not implemented (on_domain_error:NAN): Exception: DataFusion error: Arrow error: Compute error: Execution error: cannot take square root of a negative number
All 8 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic/sqrt.test:7 | sqrt(-1::i64) [on_domain_error:NAN] | nan::fp64 |
| arithmetic/sqrt.test:8 | sqrt(-9223372036854775800::i64) [on_domain_error:NAN] | nan::fp64 |
| arithmetic/sqrt.test:8 | sqrt(-1.0::fp32) [on_domain_error:NAN] | nan::fp32 |
| arithmetic/sqrt.test:9 | sqrt(-1.0::fp64) [on_domain_error:NAN] | nan::fp64 |
| arithmetic/sqrt.test:10 | sqrt(-100.0::fp32) [on_domain_error:NAN] | nan::fp32 |
| arithmetic/sqrt.test:11 | sqrt(-2.5::fp64) [on_domain_error:NAN] | nan::fp64 |
| arithmetic/sqrt.test:14 | sqrt(-inf::fp32) [on_domain_error:NAN] | nan::fp32 |
| arithmetic/sqrt.test:15 | sqrt(-inf::fp64) [on_domain_error:NAN] | nan::fp64 |
option mode not implemented (overflow:SATURATE): got N, expected -N
Functions: subtract (4), add (2), multiply
option mode not implemented (overflow:SATURATE): got 126, expected -128
All 7 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/add.test:16 | add(-120::i8, -10::i8) [overflow:SATURATE] | -128::i8 | |
| arithmetic/subtract.test:15 | subtract(-120::i8, 10::i8) [overflow:SATURATE] | -128::i8 | |
| arithmetic/add.test:19 | add(-30000::i16, -10000::i16) [overflow:SATURATE] | -32768::i16 | option mode not implemented (overflow:SATURATE): got 25536, expected -32768 |
| arithmetic/multiply.test:25 | multiply(-13::i8, 10::i8) [overflow:SATURATE] | -128::i8 | |
| arithmetic/subtract.test:21 | subtract(-128::i8, 1::i8) [overflow:SATURATE] | -128::i8 | option mode not implemented (overflow:SATURATE): got 127, expected -128 |
| arithmetic/subtract.test:23 | subtract(-32768::i16, 1::i16) [overflow:SATURATE] | -32768::i16 | option mode not implemented (overflow:SATURATE): got 32767, expected -32768 |
| arithmetic/subtract.test:25 | subtract(-2147483648::i32, 1::i32) [overflow:SATURATE] | -2147483648::i32 | option mode not implemented (overflow:SATURATE): got 2147483647, expected -2147483648 |
option mode not implemented (direction:ASC_NULLS_LAST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "…"
Functions: sort (6)
option mode not implemented (direction:ASC_NULLS_LAST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sort"
All 6 cases
| Case | Test | Expected |
|---|---|---|
| list/sort.test:5 | sort([3, 1, 2]::list<i32>) [direction:ASC_NULLS_LAST] | [1, 2, 3]::list<i32> |
| list/sort.test:6 | sort([3, Null, 1]::list<i32?>) [direction:ASC_NULLS_LAST] | [1, 3, Null]::list<i32?> |
| list/sort.test:7 | sort([Null, 2, Null, 1]::list<i32?>) [direction:ASC_NULLS_LAST] | [1, 2, Null, Null]::list<i32?> |
| list/sort.test:21 | sort([]::list<i32>) [direction:ASC_NULLS_LAST] | []::list<i32> |
| list/sort.test:24 | sort([42]::list<i32>) [direction:ASC_NULLS_LAST] | [42]::list<i32> |
| list/sort.test:27 | sort(['c', 'a', 'b']::list<string>) [direction:ASC_NULLS_LAST] | ['a', 'b', 'c']::list<string> |
option mode not implemented (null_handling:ACCEPT_NULLS): got '…', expected None
Functions: concat (5)
option mode not implemented (null_handling:ACCEPT_NULLS): got 'abcd', expected None
All 5 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/concat.test:8 | concat('abcd'::str, null::str?) [null_handling:ACCEPT_NULLS] | null::str? | |
| string/concat.test:10 | concat(null::str?, 'abcd'::str) [null_handling:ACCEPT_NULLS] | null::str? | |
| string/concat.test:12 | concat(null::str?, null::str?) [null_handling:ACCEPT_NULLS] | null::str? | option mode not implemented (null_handling:ACCEPT_NULLS): got '', expected None |
| string/concat.test:7 | concat(''::str, null::str?) [null_handling:ACCEPT_NULLS] | null::str? | option mode not implemented (null_handling:ACCEPT_NULLS): got '', expected None |
| string/concat.test:9 | concat('a'::str, null::str?, 'b'::str) [null_handling:ACCEPT_NULLS] | null::str? | option mode not implemented (null_handling:ACCEPT_NULLS): got 'ab', expected None |
option mode not implemented (negative_start:WRAP_FROM_END): got '…', expected '…'
Functions: substring (4)
option mode not implemented (negative_start:WRAP_FROM_END): got '', expected 'g'
All 4 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| string/substring.test:14 | substring('abcdefg'::str, -1::i32, 2::i32) [negative_start:WRAP_FROM_END] | 'g'::str | |
| string/substring.test:15 | substring('abcdefg'::str, -2::i32, 1::i32) [negative_start:WRAP_FROM_END] | 'f'::str | option mode not implemented (negative_start:WRAP_FROM_END): got '', expected 'f' |
| string/substring.test:21 | substring('abcdefg'::str, -7::i32, 3::i32) [negative_start:WRAP_FROM_END] | 'abc'::str | option mode not implemented (negative_start:WRAP_FROM_END): got '', expected 'abc' |
| string/substring.test:22 | substring('abcdefg'::str, -3::i32, 2::i32) [negative_start:WRAP_FROM_END] | 'ef'::str | option mode not implemented (negative_start:WRAP_FROM_END): got '', expected 'ef' |
option mode not implemented (on_domain_error:NULL): got nan, expected None
Functions: ln, log10, log2, logb
option mode not implemented (on_domain_error:NULL): got nan, expected None
All 4 cases
| Case | Test | Expected |
|---|---|---|
| logarithmic/ln.test:12 | ln(-inf::fp64) [on_domain_error:NULL] | null::fp64? |
| logarithmic/log10.test:12 | log10(-inf::fp64) [on_domain_error:NULL] | null::fp64? |
| logarithmic/log2.test:13 | log2(-inf::fp64) [on_domain_error:NULL] | null::fp64? |
| logarithmic/logb.test:13 | logb(-inf::fp64, 10::fp64) [on_domain_error:NULL] | null::fp64? |
option mode not implemented (on_log_zero:ERROR): expected an error, got [-inf]
Functions: ln, log10, log2, logb
option mode not implemented (on_log_zero:ERROR): expected an error, got [-inf]
All 4 cases
| Case | Test | Expected |
|---|---|---|
| logarithmic/ln.test:16 | ln(0.0::fp64) [on_log_zero:ERROR] | <!ERROR> |
| logarithmic/log10.test:16 | log10(0.0::fp64) [on_log_zero:ERROR] | <!ERROR> |
| logarithmic/log2.test:17 | log2(0.0::fp64) [on_log_zero:ERROR] | <!ERROR> |
| logarithmic/logb.test:16 | logb(0.0::fp64, 2.0::fp64) [on_log_zero:ERROR] | <!ERROR> |
option mode not implemented (on_log_zero:NAN): got -inf, expected nan
Functions: ln, log10, log2, logb
option mode not implemented (on_log_zero:NAN): got -inf, expected nan
All 4 cases
| Case | Test | Expected |
|---|---|---|
| logarithmic/ln.test:17 | ln(0.0::fp64) [on_log_zero:NAN] | nan::fp64 |
| logarithmic/log10.test:17 | log10(0.0::fp64) [on_log_zero:NAN] | nan::fp64 |
| logarithmic/log2.test:18 | log2(0.0::fp64) [on_log_zero:NAN] | nan::fp64 |
| logarithmic/logb.test:17 | logb(0.0::fp64, 2.0::fp64) [on_log_zero:NAN] | nan::fp64 |
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: - -N
Functions: negate (4)
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: - -128
All 4 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/negate.test:18 | negate(-128::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/negate.test:12 | negate(-32768::i16) [overflow:SATURATE] | 32767::i16 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: - -32768 |
| arithmetic/negate.test:15 | negate(-2147483648::i32) [overflow:SATURATE] | 2147483647::i32 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: - -2147483648 |
| arithmetic/negate.test:18 | negate(-9223372036854775808::i64) [overflow:SATURATE] | 9223372036854775807::i64 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: - -9223372036854775808 |
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Compute error: IntNArray overflow on …(-N)
Functions: abs (4)
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Compute error: Int8Array overflow on abs(-128)
All 4 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/abs.test:17 | abs(-128::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/abs.test:16 | abs(-32768::i16) [overflow:SATURATE] | 32767::i16 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Compute error: Int16Array overflow on abs(-32768) |
| arithmetic/abs.test:19 | abs(-2147483648::i32) [overflow:SATURATE] | 2147483647::i32 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Compute error: Int32Array overflow on abs(-2147483648) |
| arithmetic/abs.test:22 | abs(-9223372036854775808::i64) [overflow:SATURATE] | 9223372036854775807::i64 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Compute error: Int64Array overflow on abs(-9223372036854775808) |
option mode not implemented (direction:DESC_NULLS_LAST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "…"
Functions: sort (3)
option mode not implemented (direction:DESC_NULLS_LAST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sort"
All 3 cases
| Case | Test | Expected |
|---|---|---|
| list/sort.test:14 | sort([3, 1, 2]::list<i32>) [direction:DESC_NULLS_LAST] | [3, 2, 1]::list<i32> |
| list/sort.test:15 | sort([3, Null, 1]::list<i32?>) [direction:DESC_NULLS_LAST] | [3, 1, Null]::list<i32?> |
| list/sort.test:28 | sort(['c', 'a', 'b']::list<string>) [direction:DESC_NULLS_LAST] | ['c', 'b', 'a']::list<string> |
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: -N / -N
Functions: divide (3)
option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: -128 / -1
All 3 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/divide.test:15 | divide(-128::i8, -1::i8) [overflow:SATURATE] | 127::i8 | |
| arithmetic/divide.test:6 | divide(-32768::i16, -1::i16) [overflow:SATURATE] | 32767::i16 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: -32768 / -1 |
| arithmetic/divide.test:8 | divide(-2147483648::i32, -1::i32) [overflow:SATURATE] | 2147483647::i32 | option mode not implemented (overflow:SATURATE): Exception: DataFusion error: Arrow error: Arithmetic overflow: Overflow happened on: -2147483648 / -1 |
option mode not implemented (complex_number_result:ERROR): expected an error, got [nan]
Functions: power, power_decimal
option mode not implemented (complex_number_result:ERROR): expected an error, got [nan]
All 2 cases
| Case | Test | Expected |
|---|---|---|
| arithmetic_decimal/power.test:19 | power(-1::dec<1, 0>, 0.5::dec<38, 1>) [complex_number_result:ERROR] | <!ERROR> |
| arithmetic_decimal/power_decimal.test:19 | power(-1::dec<1, 0>, 0.5::dec<38, 1>) [complex_number_result:ERROR] | <!ERROR> |
option mode not implemented (direction:ASC_NULLS_FIRST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "…"
Functions: sort (2)
option mode not implemented (direction:ASC_NULLS_FIRST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sort"
All 2 cases
| Case | Test | Expected |
|---|---|---|
| list/sort.test:10 | sort([3, Null, 1]::list<i32?>) [direction:ASC_NULLS_FIRST] | [Null, 1, 3]::list<i32?> |
| list/sort.test:11 | sort([Null, 2, Null, 1]::list<i32?>) [direction:ASC_NULLS_FIRST] | [Null, Null, 1, 2]::list<i32?> |
option mode not implemented (rounding:TIE_TO_EVEN): Exception: DataFusion error: This feature is not implemented: Aggregate function … is not supported: function anchor = N
Functions: std_dev, variance
option mode not implemented (rounding:TIE_TO_EVEN): Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp32 is not supported: function anchor = 1
All 2 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/std_dev.test:44 | ((1.1), (2.2), (3.3), (4.4), (5.5)) std_dev(SAMPLE::enum, col0::fp32) [rounding:TIE_TO_EVEN] | 1.7392527::fp32? | |
| arithmetic/variance.test:44 | ((1.1), (2.2), (3.3), (4.4), (5.5)) variance(SAMPLE::enum, col0::fp32) [rounding:TIE_TO_EVEN] | 3.025::fp32? | option mode not implemented (rounding:TIE_TO_EVEN): Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp32 is not su |
option mode not implemented (rounding:TRUNCATE): Exception: DataFusion error: This feature is not implemented: Aggregate function … is not supported: function anchor = N
Functions: std_dev, variance
option mode not implemented (rounding:TRUNCATE): Exception: DataFusion error: This feature is not implemented: Aggregate function std_dev:req_fp64 is not supported: function anchor = 1
All 2 cases
| Case | Test | Expected | Message, where it differs |
|---|---|---|---|
| arithmetic/std_dev.test:45 | ((1.1), (2.2), (3.3), (4.4), (5.5)) std_dev(SAMPLE::enum, col0::fp64) [rounding:TRUNCATE] | 1.7392527130926085::fp64? | |
| arithmetic/variance.test:45 | ((1.1), (2.2), (3.3), (4.4), (5.5)) variance(SAMPLE::enum, col0::fp64) [rounding:TRUNCATE] | 3.025::fp64? | option mode not implemented (rounding:TRUNCATE): Exception: DataFusion error: This feature is not implemented: Aggregate function variance:req_fp64 is not suppo |
option mode not implemented (direction:DESC_NULLS_FIRST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "…"
Functions: sort
option mode not implemented (direction:DESC_NULLS_FIRST): Exception: DataFusion error: This feature is not implemented: Unsupported function name: "sort"
The case
| Case | Test | Expected |
|---|---|---|
| list/sort.test:18 | sort([3, Null, 1]::list<i32?>) [direction:DESC_NULLS_FIRST] | [Null, 3, 1]::list<i32?> |
option mode not implemented (on_domain_error:NULL): Exception: DataFusion error: Arrow error: Divide by zero error
Functions: modulus
option mode not implemented (on_domain_error:NULL): Exception: DataFusion error: Arrow error: Divide by zero error
The case
| Case | Test | Expected |
|---|---|---|
| arithmetic/modulus.test:15 | modulus(5::i8, 0::i8) [on_domain_error:NULL] | null::i8? |
option mode not implemented (overflow:ERROR): expected an error, got [Decimal('…')]
Functions: sum_decimal
option mode not implemented (overflow:ERROR): expected an error, got [Decimal('-140282366920938463463374607431768211454')]The case
| Case | Test | Expected |
|---|---|---|
| arithmetic_decimal/sum_decimal.test:11 | sum((99999999999999999999999999999999999999, 1, 1, 1, 1, 99999999999999999999999999999999999999)::dec<38, 0>) [overflow:ERROR] | <!ERROR> |
option mode not implemented (overflow:SATURATE): got -N, expected -N
Functions: multiply
option mode not implemented (overflow:SATURATE): got -126, expected -128
The case
| Case | Test | Expected |
|---|---|---|
| arithmetic/multiply.test:16 | multiply(-13::i8, -10::i8) [overflow:SATURATE] | -128::i8 |
unsupported option division_type:FLOOR (engine implements division_type:TRUNCATE)
Functions: modulus
unsupported option division_type:FLOOR (engine implements division_type:TRUNCATE)
The case
| Case | Test | Expected |
|---|---|---|
| arithmetic/modulus.test:20 | modulus(8::i8, -3::i8) [division_type:FLOOR] | -1::i8 |
Detail
Functions
| Run | Upstream cases | Extended cases |
|---|---|---|
| As Substrait plans | 71.2% (820/1152) | 85.5% (1889/2209) |
| As the engine's own SQL | 93.2% (1089/1169) | 98.2% (2101/2139) |
| Consumer gap (plans − SQL) | −22.0 pts | −12.7 pts |
Upstream cases are the Substrait project's own function tests and are scored; extended cases are converted from the legacy suite and shown for detail. Consumer gap = plans − SQL: what the engine can do in SQL but not through its Substrait consumer.
Queries
| Suite | Passed | Pass rate |
|---|---|---|
| TPC-H (scored) | 8/22 | 36.4% |
| TPC-H, 0.81 encoding | 8/22 | 36.4% |
Only the current plan encoding is scored; other encodings show whether plans from older producers still run.
Functions by extension
Upstream cases by extension. A low plan rate next to a high SQL rate points at the consumer.
| Extension | As plans | As SQL |
|---|---|---|
| aggregate_approx | 0.0% | 100.0% |
| aggregate_generic | 100.0% | 100.0% |
| arithmetic | 67.9% | 100.0% |
| arithmetic_decimal | 60.8% | 59.2% |
| arithmetic_unsigned | all skipped | 100.0% |
| boolean | 100.0% | 100.0% |
| comparison | 93.4% | 100.0% |
| datetime | 73.3% | 100.0% |
| list | 100.0% | 100.0% |
| logarithmic | 100.0% | 100.0% |
| rounding | 100.0% | 100.0% |
| rounding_decimal | 90.0% | 90.0% |
| string | 55.9% | 90.7% |
| window | 100.0% | 100.0% |
Reports
Every case's result is in the reports of its run (GitHub keeps them for a limited time). This page's data: datafusion.json.
How scoring works How the pass rate is calculated Suites at a glance Add your engine Data (JSON)