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)	145 (41.9%)	151 (43.6%)
Total tests	882	882
⚪ UNSUPPORTED	62	62
✅ PASS	233	250
⚠️ PARTIAL	68	68
❌ FAIL	8	8
💥 ERROR	264	247
❓ UNTESTED	74	74
Full pass rate	36.0%	38.6%
Pass + partial rate	46.5%	49.1%

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	71	74
⚠️ PARTIAL	7	10
❌ FAIL	8	4
💥 ERROR	456	454
❓ UNTESTED	6	6
Full pass rate	13.0%	13.5%

Structural Parity

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

Metric	TDS	Relation
Total features	583	583
Total tests	660	660
⚪ UNSUPPORTED	187	65
✅ PASS	300	404
⚠️ PARTIAL	3	3
❌ FAIL	10	11
💥 ERROR	83	100
❓ UNTESTED	0	0
Full pass rate	75.8%	78.0%
Pass + partial rate	76.5%	78.6%

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	76	76
Pass rate	95.0%	95.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	680	1671	40.7%
Relation	804	1793	44.8%
Combined	1484	3384	43.9%