Legend SQL — Coverage Summary

Function Coverage

Coverage of Postgres built-in functions in Legend SQL. See full details for per-function results.

Metric	TDS	Relation
Total signatures	709	709
Unique function names	346	346
Supported functions (PASS/PARTIAL)	147 (42.5%)	153 (44.2%)
Total tests	882	882
⚪ UNSUPPORTED	62	62
✅ PASS	235	252
⚠️ PARTIAL	67	67
❌ FAIL	6	6
💥 ERROR	265	248
❓ UNTESTED	74	74
Full pass rate	36.3%	38.9%
Pass + partial rate	46.7%	49.3%

Percentages exclude unsupported functions from the denominator.

Failed tests:

Operator Coverage

Coverage of Postgres built-in operators in Legend SQL. See full details for per-operator results.

Metric	TDS	Relation
Total operators	548	548
⚪ UNSUPPORTED	0	0
✅ PASS	72	77
⚠️ PARTIAL	7	10
❌ FAIL	7	5
💥 ERROR	456	450
❓ UNTESTED	6	6
Full pass rate	13.1%	14.1%

Structural Parity

Coverage of SQL structural features (joins, subqueries, aggregations, etc.). See full details for per-feature results.

Metric	TDS	Relation
Total features	612	612
Total tests	691	691
⚪ UNSUPPORTED	211	47
✅ PASS	305	432
⚠️ PARTIAL	3	3
❌ FAIL	10	11
💥 ERROR	83	119
❓ UNTESTED	0	0
Full pass rate	76.1%	76.5%
Pass + partial rate	76.8%	77.0%

Percentages exclude unsupported features from the denominator.

Failed tests:

Format Token Coverage

Coverage of to_char template patterns and EXTRACT/date_part field keywords. See full details for per-token results.

Metric	TDS	Relation
Total tokens	80	80
✅ PASS	33	36
Pass rate	41.3%	45.0%

Coverage vs. Postgres Docs

Fraction of cataloged functions/operators with any test at all — independent of pass/fail — showing where there is a testing gap vs. a behavioral gap.

Doc Section	Tested	Total	Tested %
Mathematical Functions and Operators (9.3)	72	72	100.0%
String Functions and Operators (9.4)	107	107	100.0%
Binary String Functions (9.5)	9	9	100.0%
Pattern Matching (9.7)	12	19	63.2%
Data Type Formatting (9.8)	10	10	100.0%
Date/Time Functions and Operators (9.9)	41	41	100.0%
Conditional Expressions (9.18)	7	7	100.0%
JSON Functions and Operators (9.16)	49	94	52.1%
Array Functions and Operators (9.19)	21	21	100.0%
Aggregate Functions (9.21)	157	157	100.0%
Window Functions (9.22)	15	15	100.0%
Network Address Functions (9.12)	21	21	100.0%
System Information Functions (9.26)	41	41	100.0%
Sequence Manipulation Functions (9.17)	5	5	100.0%
Set Returning Functions (9.25)	11	11	100.0%
Cryptographic Functions (pgcrypto)	1	23	4.3%
Other Functions	56	56	100.0%
Logical Operators (9.1)	3	3	100.0%
Comparison Operators (9.2)	26	26	100.0%
Mathematical Operators (9.3)	26	26	100.0%
String Operators (9.4)	37	37	100.0%
Bit String Operators (9.6)	19	19	100.0%
Array Operators (9.19)	20	20	100.0%
Range/Multirange Operators (9.19)	54	54	100.0%
JSON/JSONB Operators (9.16)	22	22	100.0%
Network Address Operators (9.12)	36	36	100.0%
Geometric Operators (9.11)	157	157	100.0%
Full Text Search Operators (9.13)	24	24	100.0%
Other Operators	118	124	95.2%

Overall

Combined pass rate across function coverage and structural parity.

Path	Pass	Tested	Pass Rate
TDS	645	1676	38.5%
Relation	797	1840	43.3%
Combined	1442	3436	42.0%