ydb_fdw compat-prog results.db summary (companion to ydb-platform/ydb-pg-extension#230)

results-summary.md

results.db summary

Runs

id	started	channel	mode	pg_version	fdw_commit
1	2026-05-26T14:59:38Z	nightly	pg_regress	16.9	unknown
2	2026-05-26T15:04:11Z	nightly	sqlglot	16.9	unknown
3	2026-05-26T15:40:56Z	nightly	ef	16.9	9c3af7c-local
4	2026-05-26T15:42:06Z	nightly	oss	16.9	9c3af7c-local
5	2026-05-26T15:44:20Z	nightly	oss	16.9	9c3af7c-local
6	2026-05-26T15:47:52Z	nightly	oss	16.9	9c3af7c-local
7	2026-05-26T15:48:40Z	nightly	oss	16.9	9c3af7c-local
8	2026-05-26T15:59:35Z	nightly	oss	16.9	9c3af7c-local
9	2026-05-26T16:01:46Z	nightly	oss	16.9	9c3af7c-local
10	2026-05-26T16:02:54Z	nightly	oss	16.9	9c3af7c-local
11	2026-05-26T16:16:03Z	nightly	oss-v3	16.9	9c3af7c-local
12	2026-05-26T16:28:29Z	nightly	oss-direct	16.9	9c3af7c-local
13	2026-05-26T17:33:02Z	nightly	big-prog	16.9	9c3af7c-local
14	2026-05-26T17:39:37Z	nightly	ef-northwind	16.9	9c3af7c-local
15	2026-05-26T17:43:13Z	nightly	ef-northwind	16.9	9c3af7c-local
16	2026-05-26T17:51:36Z	nightly	ef-nw-bypass	16.9	9c3af7c-local
17	2026-05-26T18:10:58Z	nightly	oss-direct	16.9	9c3af7c-local
18	2026-05-26T18:19:44Z	nightly	oss-all	16.9	9c3af7c+3patches
19	2026-05-26T18:22:25Z	nightly	big-patched	16.9	9c3af7c+4patches

Statements per run

run	total	pass	fail_error	fail_diff
1	42974	18209	24753	12
2	1382	1379	0	3
3	2569	2569	0	0
5	24	24	0	0
7	1	0	0	1
12	150	65	85	0
13	29777	29763	11	3
14	231	231	0	0
15	281	182	99	0
16	280	237	43	0
17	410	236	174	0
18	2648	1359	1289	0
19	72751	43094	29649	8

Top FDW error categories (across all runs)

   76518  InterfaceError: connection already closed
    1511  UndefinedTable: relation "root" does not exist
LINE 1: SELECT VALUE c FROM root 
     840  SyntaxError: syntax error at or near "["
LINE 1: SELECT [l].[Id], [l].[Date], [l
     795  SyntaxError: syntax error at or near "["
LINE 1: SELECT [c].[CustomerID], [c].[A
     774  SyntaxError: syntax error at or near "["
LINE 1: SELECT [g].[Nickname], [g].[Squ
     750  SyntaxError: syntax error at or near "["
LINE 1: SELECT [e].[Id] FROM [Entities1
     702  SyntaxError: syntax error at or near "["
LINE 1: SELECT [b].[Id], [b].[Bool], [b
     460  InFailedSqlTransaction: current transaction is aborted, commands ignored until e
     456  UndefinedTable: relation "BasicTypesEntities" does not exist
LINE 1: ..."b"."Str
     432  SyntaxError: syntax error at or near "["
LINE 1: SELECT [p].[Id], [p].[Bool], [p
     360  SyntaxError: syntax error at or near "["
LINE 1: SELECT [o].[OrderID], [o].[Cust
     334  SyntaxError: syntax error at or near "["
LINE 1: SELECT [r].[Id], [r].[Name], [r
     316  UndefinedTable: relation "Entities1" does not exist
LINE 1: SELECT "e"."Id" FROM
     298  SyntaxError: syntax error at or near "["
LINE 1: SELECT [e].[Id], [e].[Collectio
     286  SyntaxError: syntax error at or near "["
LINE 1: SELECT TOP(2) [j].[Id], [j].[Te
     271  UndefinedTable: relation "BasicTypesEntities" does not exist
LINE 1: ...ort", b.
     256  SyntaxError: syntax error at or near "["
LINE 1: SELECT [u].[Nickname], [u].[Squ
     236  UndefinedTable: relation "PrimitiveCollectionsEntity" does not exist
LINE 1: ...
     202  SyntaxError: syntax error at or near "["
LINE 1: SELECT [t].[Id], [t].[GearNickN
     200  SyntaxError: syntax error at or near "["
LINE 1: SELECT [o].[OrderID], [o].[Prod
     186  SyntaxError: syntax error at or near "["
LINE 1: UPDATE [j] SET [j].[JsonContain
     186  SyntaxError: syntax error at or near "["
LINE 1: UPDATE [j] SET [JsonContainer].
     186  SyntaxError: syntax error at or near "["
LINE 1: SELECT [e].[Id], CASE     WHEN 
     180  SyntaxError: syntax error at or near "["
LINE 1: SELECT [a].[Id], [a].[CountryId
     154  SyntaxError: syntax error at or near "["
LINE 1: SELECT [e].[Key1], [e].[Key2], 
     142  FeatureNotSupported: foreign key constraints are not supported on foreign tables
     136  SyntaxError: syntax error at or near "["
LINE 1: SELECT [j].[Id], [j].[TestBoole
     134  SyntaxError: syntax error at or near "["
LINE 1: SELECT [l0].[Id], [l0].[Date], 
     128  SyntaxError: syntax error at or near "["
LINE 1: SELECT [u].[Id], [u].[Name], [u
     120  SyntaxError: syntax error at or near "["
LINE 1: SELECT [w].[Id], [w].[Ammunitio