Postgres Operator Coverage — Legend SQL (LegendSql)

Reference: PostgreSQL 16 Functions and Operators

Summary

Error Categories

Category Summary

Logical Operators (9.1)

Reference: PostgreSQL 16 docs

Comparison Operators (9.2)

Reference: PostgreSQL 16 docs

Mathematical Operators (9.3)

Reference: PostgreSQL 16 docs

String Operators (9.4)

Reference: PostgreSQL 16 docs

Bit String Operators (9.6)

Reference: PostgreSQL 16 docs

Array Operators (9.19)

Reference: PostgreSQL 16 docs

Range/Multirange Operators (9.19)

Reference: PostgreSQL 16 docs

JSON/JSONB Operators (9.16)

Reference: PostgreSQL 16 docs

Network Address Operators (9.12)

Reference: PostgreSQL 16 docs

Geometric Operators (9.11)

Reference: PostgreSQL 16 docs

Full Text Search Operators (9.13)

Reference: PostgreSQL 16 docs

Other Operators

Error Details

RESULT_MISMATCH (23 tests)

and__false_null

🔴 Failed in both TDS and Relation

Input SQL:

SELECT (false AND CAST(NULL AS BOOLEAN)) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT (false AND CAST(NULL AS BOOLEAN)) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT (false AND CAST(NULL AS BOOLEAN)) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

null

or__true_null

🔴 Failed in both TDS and Relation

Input SQL:

SELECT (true OR CAST(NULL AS BOOLEAN)) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT (true OR CAST(NULL AS BOOLEAN)) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT (true OR CAST(NULL AS BOOLEAN)) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

null

lt__int__null

📗 Relation Path

Input SQL:

SELECT id, int_val < 100 AS result FROM numbers WHERE id = 5

Legend SQL:

SELECT id, int_val < 100 AS result FROM func('e2e::rel_numbers') WHERE id = 5

Error:

null

neq__int__null

🔴 Failed in both TDS and Relation

Input SQL:

SELECT id, int_val <> 42 AS result FROM numbers WHERE id = 5

Legend SQL (TDS):

SELECT id, int_val <> 42 AS result FROM func('e2e::tds_numbers') WHERE id = 5

Legend SQL (Relation):

SELECT id, int_val <> 42 AS result FROM func('e2e::rel_numbers') WHERE id = 5

Error:

null

neq__filter__int

🔴 Failed in both TDS and Relation

Input SQL:

SELECT id, name FROM persons WHERE age <> 30 ORDER BY id

Legend SQL (TDS):

SELECT id, name FROM func('e2e::tds_persons') WHERE age <> 30 ORDER BY id

Legend SQL (Relation):

SELECT id, name FROM func('e2e::rel_persons') WHERE age <> 30 ORDER BY id

Error:

null

gt__int__null

📗 Relation Path

Input SQL:

SELECT id, int_val > 10 AS result FROM numbers WHERE id = 5

Legend SQL:

SELECT id, int_val > 10 AS result FROM func('e2e::rel_numbers') WHERE id = 5

Error:

null

op_mod__negative__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT id, int_val % 3 AS result FROM numbers WHERE id = 2

Legend SQL (TDS):

SELECT id, int_val % 3 AS result FROM func('e2e::tds_numbers') WHERE id = 2

Legend SQL (Relation):

SELECT id, int_val % 3 AS result FROM func('e2e::rel_numbers') WHERE id = 2

Error:

null

op_mod__numeric__basic

📘 TDS Path

Input SQL:

SELECT id, numeric_val % 3 AS result FROM numbers WHERE id = 1

Legend SQL:

SELECT id, numeric_val % 3 AS result FROM func('e2e::tds_numbers') WHERE id = 1

Error:

null

op_add__date_plus_int_days

🔴 Failed in both TDS and Relation

Input SQL:

SELECT d + 5 AS result FROM dates WHERE id = 1

Legend SQL (TDS):

SELECT d + 5 AS result FROM func('e2e::tds_dates') WHERE id = 1

Legend SQL (Relation):

SELECT d + 5 AS result FROM func('e2e::rel_dates') WHERE id = 1

Error:

null

op_sub__date_minus_int_days

🔴 Failed in both TDS and Relation

Input SQL:

SELECT d - 5 AS result FROM dates WHERE id = 1

Legend SQL (TDS):

SELECT d - 5 AS result FROM func('e2e::tds_dates') WHERE id = 1

Legend SQL (Relation):

SELECT d - 5 AS result FROM func('e2e::rel_dates') WHERE id = 1

Error:

null

op_div__int__truncates_toward_zero

🔴 Failed in both TDS and Relation

Input SQL:

SELECT id, int_val / 5 AS result FROM numbers WHERE id = 9

Legend SQL (TDS):

SELECT id, int_val / 5 AS result FROM func('e2e::tds_numbers') WHERE id = 9

Legend SQL (Relation):

SELECT id, int_val / 5 AS result FROM func('e2e::rel_numbers') WHERE id = 9

Error:

null

op_div__negative__truncates_toward_zero

🔴 Failed in both TDS and Relation

Input SQL:

SELECT id, int_val / 3 AS result FROM numbers WHERE id = 2

Legend SQL (TDS):

SELECT id, int_val / 3 AS result FROM func('e2e::tds_numbers') WHERE id = 2

Legend SQL (Relation):

SELECT id, int_val / 3 AS result FROM func('e2e::rel_numbers') WHERE id = 2

Error:

null

concat_op__txt_txt__from_table

📘 TDS Path

Input SQL:

SELECT val || '-' || nullable_val AS result FROM strings ORDER BY 1

Legend SQL:

SELECT val || '-' || nullable_val AS result FROM func('e2e::tds_strings') ORDER BY 1

Error:

null

array_gt

📘 TDS Path

Input SQL:

SELECT ARRAY[1,3] > ARRAY[1,2] AS result FROM persons WHERE id = 1

Legend SQL:

SELECT ARRAY[1, 3] > ARRAY[1, 2] AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

json_arrow_get_index

📗 Relation Path

Input SQL:

SELECT json_arr -> 0 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_arr -> 0 AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

null

json_arrow_get_field

📗 Relation Path

Input SQL:

SELECT json_val -> 'a' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_val -> 'a' AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

null

jsonb_arrow_get_index

📗 Relation Path

Input SQL:

SELECT jsonb_arr -> 1 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_arr -> 1 AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

null

jsonb_arrow_get_field

📗 Relation Path

Input SQL:

SELECT jsonb_val -> 'b' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val -> 'b' AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

null

anycompatible_concat_scalar_array

📘 TDS Path

Input SQL:

SELECT 4 || ARRAY[1,2,3] AS result FROM persons WHERE id = 1

Legend SQL:

SELECT 4 || ARRAY[1, 2, 3] AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

anycompatible_concat_array_scalar

📘 TDS Path

Input SQL:

SELECT ARRAY[1,2,3] || 4 AS result FROM persons WHERE id = 1

Legend SQL:

SELECT ARRAY[1, 2, 3] || 4 AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

anycompatible_concat_array_array

📘 TDS Path

Input SQL:

SELECT ARRAY[1,2] || ARRAY[3,4] AS result FROM persons WHERE id = 1

Legend SQL:

SELECT ARRAY[1, 2] || ARRAY[3, 4] AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

concat_op__mixed_types__null_handling

📘 TDS Path

Input SQL:

SELECT 'val=' || NULL || '-' || 42 AS result FROM persons WHERE id = 1

Legend SQL:

SELECT 'val=' || NULL || '-' || 42 AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

eq__null_null

📘 TDS Path

Input SQL:

SELECT NULL = NULL AS result FROM persons WHERE id = 1

Legend SQL:

SELECT NULL = NULL AS result FROM func('e2e::tds_persons') WHERE id = 1

Error:

null

TYPE_ERROR (202 tests)

neq__xid_vs_numeric

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('1' AS xid) <> 2 AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('1' AS xid) <> 2 AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('1' AS xid) <> 2 AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for XID

eq__xid_vs_numeric

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('1' AS xid) = 1 AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('1' AS xid) = 1 AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('1' AS xid) = 1 AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for XID

op_add__numeric_plus_pg_lsn

🔴 Failed in both TDS and Relation

Input SQL:

SELECT 16 + CAST('0/1' AS pg_lsn) AS result FROM dates WHERE id = 1

Legend SQL (TDS):

SELECT 16 + CAST('0/1' AS pg_lsn) AS result FROM func('e2e::tds_dates') WHERE id = 1

Legend SQL (Relation):

SELECT 16 + CAST('0/1' AS pg_lsn) AS result FROM func('e2e::rel_dates') WHERE id = 1

Error:

No value found for PG_LSN, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

op_add__pg_lsn_plus_numeric

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('0/1' AS pg_lsn) + 16 AS result FROM dates WHERE id = 1

Legend SQL (TDS):

SELECT CAST('0/1' AS pg_lsn) + 16 AS result FROM func('e2e::tds_dates') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('0/1' AS pg_lsn) + 16 AS result FROM func('e2e::rel_dates') WHERE id = 1

Error:

No value found for PG_LSN, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

op_sub__pg_lsn_minus_numeric

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('0/10' AS pg_lsn) - 16 AS result FROM dates WHERE id = 1

Legend SQL (TDS):

SELECT CAST('0/10' AS pg_lsn) - 16 AS result FROM func('e2e::tds_dates') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('0/10' AS pg_lsn) - 16 AS result FROM func('e2e::rel_dates') WHERE id = 1

Error:

No value found for PG_LSN, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

regex_not_match__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) !~ '^hello$' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) !~ '^hello$' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) !~ '^hello$' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

regex_not_match_ci__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) !~* '^HELLO$' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) !~* '^HELLO$' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) !~* '^HELLO$' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

not_like__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) !~~ 'zzz%' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) !~~ 'zzz%' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) !~~ 'zzz%' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

not_ilike__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) !~~* 'ZZZ%' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) !~~* 'ZZZ%' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) !~~* 'ZZZ%' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

regex_match__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) ~ '^hello$' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) ~ '^hello$' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) ~ '^hello$' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

regex_match_ci__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) ~* '^HELLO$' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) ~* '^HELLO$' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) ~* '^HELLO$' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

like__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) ~~ 'hel%' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) ~~ 'hel%' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) ~~ 'hel%' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

ilike__name__basic

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(val AS name) ~~* 'HEL%' AS result FROM strings WHERE id = 1

Legend SQL (TDS):

SELECT CAST(val AS name) ~~* 'HEL%' AS result FROM func('e2e::tds_strings') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(val AS name) ~~* 'HEL%' AS result FROM func('e2e::rel_strings') WHERE id = 1

Error:

No value found for NAME

bit_xor

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(B'1010' AS bit(4))

Legend SQL:

SELECT CAST(B'1010' AS bit(4))

Error:

ERROR: java.lang.ClassCastException: class org.postgresql.util.PGobject cannot be cast to class java.lang.Boolean (org.postgresql.util.PGobject is in unnamed module of loader 'app'; java.lang.Boolean is in module java.base of loader 'bootstrap')

aclitem_array_append

🔴 Failed in both TDS and Relation

Input SQL:

SELECT ARRAY['foo=r/bar'::aclitem] + 'baz=w/bar'::aclitem AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT ARRAY['foo=r/bar'::aclitem] + 'baz=w/bar'::aclitem AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT ARRAY['foo=r/bar'::aclitem] + 'baz=w/bar'::aclitem AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for ACLITEM, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

aclitem_array_remove

🔴 Failed in both TDS and Relation

Input SQL:

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] - 'baz=w/bar'::aclitem AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] - 'baz=w/bar'::aclitem AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] - 'baz=w/bar'::aclitem AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for ACLITEM, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

jsonb_delete_keys

📘 TDS Path

Input SQL:

SELECT jsonb_val - array['a','c'] AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val - ARRAY['a', 'c'] AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_exists_all

📘 TDS Path

Input SQL:

SELECT jsonb_val ?& array['a','b'] AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val ?& ARRAY['a', 'b'] AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

aclitem_array_contains

🔴 Failed in both TDS and Relation

Input SQL:

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] @> 'baz=w/bar'::aclitem AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] @> 'baz=w/bar'::aclitem AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT ARRAY['foo=r/bar'::aclitem, 'baz=w/bar'::aclitem] @> 'baz=w/bar'::aclitem AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for ACLITEM

jsonb_delete_index

📘 TDS Path

Input SQL:

SELECT jsonb_arr - 0 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_arr - 0 AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_delete_key_column

📘 TDS Path

Input SQL:

SELECT jsonb_val - 'c' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val - 'c' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

json_arrow_get_index

📘 TDS Path

Input SQL:

SELECT json_arr -> 0 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_arr -> 0 AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

json_arrow_get_field

📘 TDS Path

Input SQL:

SELECT json_val -> 'a' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_val -> 'a' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

json_arrow_null

📘 TDS Path

Input SQL:

SELECT json_val -> 'a' AS result FROM json_data WHERE id = 5

Legend SQL:

SELECT json_val -> 'a' AS result FROM func('e2e::tds_json_data') WHERE id = 5

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_arrow_get_index

📘 TDS Path

Input SQL:

SELECT jsonb_arr -> 1 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_arr -> 1 AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_arrow_get_field

📘 TDS Path

Input SQL:

SELECT jsonb_val -> 'b' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val -> 'b' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_arrow_null

📘 TDS Path

Input SQL:

SELECT jsonb_val -> 'a' AS result FROM json_data WHERE id = 5

Legend SQL:

SELECT jsonb_val -> 'a' AS result FROM func('e2e::tds_json_data') WHERE id = 5

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

json_arrow_text_get_index

📘 TDS Path

Input SQL:

SELECT json_arr ->> 0 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_arr ->> 0 AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

json_arrow_text_get_field

📘 TDS Path

Input SQL:

SELECT json_val ->> 'b' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT json_val ->> 'b' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_arrow_text_get_index

📘 TDS Path

Input SQL:

SELECT jsonb_arr ->> 1 AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_arr ->> 1 AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_arrow_text_get_field

📘 TDS Path

Input SQL:

SELECT jsonb_val ->> 'b' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val ->> 'b' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_lt

📘 TDS Path

Input SQL:

SELECT jsonb_val < '{"z":9}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val < '{"z":9}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_lte

📘 TDS Path

Input SQL:

SELECT jsonb_val <= '{"z":9}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val <= '{"z":9}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_neq

📘 TDS Path

Input SQL:

SELECT jsonb_val <> '{"a":1}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val <> '{"a":1}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_contained_by_column

📘 TDS Path

Input SQL:

SELECT '{"a":1}' <@ jsonb_val AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT '{"a":1}' <@ jsonb_val AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_eq

📘 TDS Path

Input SQL:

SELECT jsonb_val = '{"a":1,"b":"hello","c":null}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val = '{"a":1,"b":"hello","c":null}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_gt

📘 TDS Path

Input SQL:

SELECT jsonb_val > '{"a":0}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val > '{"a":0}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_gte

📘 TDS Path

Input SQL:

SELECT jsonb_val >= '{"a":0}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val >= '{"a":0}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

jsonb_contains

📘 TDS Path

Input SQL:

SELECT jsonb_val @> '{"a":1}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @> '{"a":1}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

📗 Relation Path

Input SQL:

SELECT jsonb_val @> '{"a":1}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @> '{"a":1}' AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

No value found for JSONB_CONTAIN_RIGHT

jsonb_path_exists_op

📘 TDS Path

Input SQL:

SELECT jsonb_val @? '$.a' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @? '$.a' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

📗 Relation Path

Input SQL:

SELECT jsonb_val @? '$.a' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @? '$.a' AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

No value found for JSONB_PATH_CONTAIN_ANY_VALUE

jsonb_path_match_op

📘 TDS Path

Input SQL:

SELECT jsonb_val @@ '$.a == 1' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @@ '$.a == 1' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

📗 Relation Path

Input SQL:

SELECT jsonb_val @@ '$.a == 1' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val @@ '$.a == 1' AS result FROM func('e2e::rel_json_data') WHERE id = 1

Error:

No value found for JSONB_PATH_PREDICATE_CHECK

jsonb_concat

📘 TDS Path

Input SQL:

SELECT jsonb_val || '{"d":4}' AS result FROM json_data WHERE id = 1

Legend SQL:

SELECT jsonb_val || '{"d":4}' AS result FROM func('e2e::tds_json_data') WHERE id = 1

Error:

Execution error at (resource:/core_relational/relational/functions/tableToTDS.pure line:48 column:108), "Cast exception: Class cannot be cast to DataType"

inet_and

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.5' AS inet) & CAST('0.0.0.255' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.5' AS inet) & CAST('0.0.0.255' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.5' AS inet) & CAST('0.0.0.255' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

macaddr_and

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03' AS macaddr) & CAST('ff:ff:ff:00:00:00' AS macaddr) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) & CAST('ff:ff:ff:00:00:00' AS macaddr) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) & CAST('ff:ff:ff:00:00:00' AS macaddr) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

macaddr8_and

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) & CAST('ff:ff:ff:00:00:00:00:00' AS macaddr8) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) & CAST('ff:ff:ff:00:00:00:00:00' AS macaddr8) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) & CAST('ff:ff:ff:00:00:00:00:00' AS macaddr8) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR8, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

inet_plus_bigint

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.5' AS inet) + CAST(10 AS bigint) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.5' AS inet) + CAST(10 AS bigint) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.5' AS inet) + CAST(10 AS bigint) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

bigint_plus_inet

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST(10 AS bigint) + CAST('192.168.1.5' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST(10 AS bigint) + CAST('192.168.1.5' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST(10 AS bigint) + CAST('192.168.1.5' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

inet_minus_inet

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.15' AS inet) - CAST('192.168.1.5' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.15' AS inet) - CAST('192.168.1.5' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.15' AS inet) - CAST('192.168.1.5' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

inet_minus_bigint

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.15' AS inet) - CAST(10 AS bigint) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.15' AS inet) - CAST(10 AS bigint) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.15' AS inet) - CAST(10 AS bigint) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

inet_lt

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.5' AS inet) < CAST('192.168.1.6' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.5' AS inet) < CAST('192.168.1.6' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.5' AS inet) < CAST('192.168.1.6' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET

macaddr_lt

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03' AS macaddr) < CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) < CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) < CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR

macaddr8_lt

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) < CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) < CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) < CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR8

inet_subnet_or_eq

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.0/24' AS inet) << CAST('192.168.0.0/16' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.0/24' AS inet) << CAST('192.168.0.0/16' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.0/24' AS inet) << CAST('192.168.0.0/16' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET, expected one of [BIGINT,BOOLEAN,DATE,DECIMAL,DOUBLE PRECISION,FLOAT8,INTEGER,JSON,NUMERIC,SMALLINT,TEXT,TIMESTAMP,VARCHAR]

inet_lte

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.5' AS inet) <= CAST('192.168.1.6' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.5' AS inet) <= CAST('192.168.1.6' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.5' AS inet) <= CAST('192.168.1.6' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET

macaddr_lte

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <= CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <= CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <= CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR

macaddr8_lte

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) <= CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) <= CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03:04:05' AS macaddr8) <= CAST('08:00:2b:01:02:03:04:06' AS macaddr8) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR8

inet_neq

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('192.168.1.5' AS inet) <> CAST('192.168.1.6' AS inet) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('192.168.1.5' AS inet) <> CAST('192.168.1.6' AS inet) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('192.168.1.5' AS inet) <> CAST('192.168.1.6' AS inet) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for INET

macaddr_neq

🔴 Failed in both TDS and Relation

Input SQL:

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <> CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM persons WHERE id = 1

Legend SQL (TDS):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <> CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::tds_persons') WHERE id = 1

Legend SQL (Relation):

SELECT CAST('08:00:2b:01:02:03' AS macaddr) <> CAST('08:00:2b:01:02:04' AS macaddr) AS result FROM func('e2e::rel_persons') WHERE id = 1

Error:

No value found for MACADDR

macaddr8_neq

🔴 Failed in both TDS and Relation