aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorvvvv <vvvv@ydb.tech>2023-12-14 16:09:58 +0300
committervvvv <vvvv@ydb.tech>2023-12-14 16:48:11 +0300
commit5e8b52b61ada37d1422b4e47a6378225d92acc5f (patch)
treebc1f9f3ce00966d39eaaf9f4760f6e69d59898a0
parentb87f9725966f7ba60f51c1efb78408b14f622b4e (diff)
downloadydb-5e8b52b61ada37d1422b4e47a6378225d92acc5f.tar.gz
YQL-17353 YQL-17355 YQL-17357 YQL-17358 YQL-17360 YQL-17361 YQL-17362 more tables (mostly empty)
-rw-r--r--ydb/library/yql/parser/pg_wrapper/comp_factory.cpp19
-rw-r--r--ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp61
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json22
-rw-r--r--ydb/library/yql/tests/sql/sql2yql/canondata/result.json49
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql6
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql5
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql18
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql9
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql6
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql6
-rw-r--r--ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql6
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json21
-rw-r--r--ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json21
24 files changed, 486 insertions, 0 deletions
diff --git a/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp b/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
index bd69c6ca75..84f03a737d 100644
--- a/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
+++ b/ydb/library/yql/parser/pg_wrapper/comp_factory.cpp
@@ -20,6 +20,7 @@
#include <ydb/library/yql/utils/fp_bits.h>
#include <library/cpp/yson/detail.h>
#include <util/string/split.h>
+#include <util/system/getpid.h>
#define TypeName PG_TypeName
#define SortBy PG_SortBy
@@ -311,6 +312,14 @@ public:
};
ApplyFillers(AllPgShDescriptionFillers, Y_ARRAY_SIZE(AllPgShDescriptionFillers), PgShDescriptionFillers_);
+ } else if (Table_ == "pg_stat_gssapi") {
+ static const std::pair<const char*, TPgStatGssapiFiller> AllPgStatGssapiFillers[] = {
+ {"encrypted", []() { return ScalarDatumToPod(BoolGetDatum(false)); }},
+ {"gss_authenticated", []() { return ScalarDatumToPod(BoolGetDatum(false)); }},
+ {"pid", []() { return ScalarDatumToPod(Int32GetDatum(GetPID())); }}
+ };
+
+ ApplyFillers(AllPgStatGssapiFillers, Y_ARRAY_SIZE(AllPgStatGssapiFillers), PgStatGssapiFillers_);
}
}
@@ -371,6 +380,14 @@ public:
rows.emplace_back(row);
}
+ } else if (Table_ == "pg_stat_gssapi") {
+ NUdf::TUnboxedValue* items;
+ auto row = compCtx.HolderFactory.CreateDirectArrayHolder(PgStatGssapiFillers_.size(), items);
+ for (ui32 i = 0; i < PgStatGssapiFillers_.size(); ++i) {
+ items[i] = PgStatGssapiFillers_[i]();
+ }
+
+ rows.emplace_back(row);
}
return compCtx.HolderFactory.VectorAsVectorHolder(std::move(rows));
@@ -392,6 +409,8 @@ private:
TVector<TPgTablespaceFiller> PgTablespaceFillers_;
using TPgShDescriptionFiller = NUdf::TUnboxedValuePod(*)(ui32 index);
TVector<TPgShDescriptionFiller> PgShDescriptionFillers_;
+ using TPgStatGssapiFiller = NUdf::TUnboxedValuePod(*)();
+ TVector<TPgStatGssapiFiller> PgStatGssapiFillers_;
};
class TFunctionCallInfo {
diff --git a/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp b/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
index 3df838928d..6e59c49d8c 100644
--- a/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
+++ b/ydb/library/yql/providers/pg/provider/yql_pg_datasource_type_ann.cpp
@@ -115,6 +115,20 @@ public:
FillPgTablespaceSchema(items, ctx);
} else if (tableName == "pg_shdescription") {
FillPgShDescriptionSchema(items, ctx);
+ } else if (tableName == "pg_trigger") {
+ FillPgTriggerSchema(items, ctx);
+ } else if (tableName == "pg_locks") {
+ FillPgLocksSchema(items, ctx);
+ } else if (tableName == "pg_stat_gssapi") {
+ FillPgStatGssapiSchema(items, ctx);
+ } else if (tableName == "pg_inherits") {
+ FillPgInheritsSchema(items, ctx);
+ } else if (tableName == "pg_stat_activity") {
+ FillPgStatActivitySchema(items, ctx);
+ } else if (tableName == "pg_timezone_names") {
+ FillPgTimezoneNamesSchema(items, ctx);
+ } else if (tableName == "pg_timezone_abbrevs") {
+ FillPgTimezoneAbbrevsSchema(items, ctx);
} else {
ctx.AddError(TIssue(ctx.GetPosition(input->Child(TPgReadTable::idx_Table)->Pos()), TStringBuilder() << "Unsupported table: " << tableName));
return TStatus::Error;
@@ -174,6 +188,53 @@ private:
AddColumn(items, ctx, "description", "text");
}
+ void FillPgTriggerSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "tgrelid", "oid");
+ AddColumn(items, ctx, "tgenabled", "char");
+ }
+
+ void FillPgLocksSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "transactionid", "xid");
+ }
+
+ void FillPgStatGssapiSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "encrypted", "bool");
+ AddColumn(items, ctx, "gss_authenticated", "bool");
+ AddColumn(items, ctx, "pid", "int4");
+ }
+
+ void FillPgInheritsSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "inhrelid", "oid");
+ AddColumn(items, ctx, "inhparent", "oid");
+ }
+
+ void FillPgStatActivitySchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "application_name", "text");
+ AddColumn(items, ctx, "backend_start", "timestamptz");
+ AddColumn(items, ctx, "backend_type", "text");
+ AddColumn(items, ctx, "client_addr", "inet");
+ AddColumn(items, ctx, "datname", "name");
+ AddColumn(items, ctx, "pid", "int4");
+ AddColumn(items, ctx, "query", "text");
+ AddColumn(items, ctx, "query_start", "timestamptz");
+ AddColumn(items, ctx, "state", "text");
+ AddColumn(items, ctx, "state_change", "timestamptz");
+ AddColumn(items, ctx, "usename", "name");
+ AddColumn(items, ctx, "wait_event", "text");
+ AddColumn(items, ctx, "wait_event_type", "text");
+ AddColumn(items, ctx, "xact_start", "timestamptz");
+ }
+
+ void FillPgTimezoneNamesSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "name", "text");
+ AddColumn(items, ctx, "is_dst", "bool");
+ }
+
+ void FillPgTimezoneAbbrevsSchema(TVector<const TItemExprType*>& items, TExprContext& ctx) {
+ AddColumn(items, ctx, "abbrev", "text");
+ AddColumn(items, ctx, "is_dst", "bool");
+ }
+
void AddColumn(TVector<const TItemExprType*>& items, TExprContext& ctx, const TString& name, const TString& type) {
items.push_back(ctx.MakeType<TItemExprType>(name, ctx.MakeType<TPgExprType>(NPg::LookupType(type).TypeId)));
}
diff --git a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
index 77e7c93f82..3a0c982bbb 100644
--- a/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part0/canondata/result.json
@@ -2437,6 +2437,28 @@
}
],
"test.test[pg_catalog-pg_database-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Debug]": [
+ {
+ "checksum": "5972890f7bfdda603cf4be92af2923c1",
+ "size": 2475,
+ "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/81dfcdf279dd45758cc7cc418c3fe9b12f2e6066/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Results]": [],
"test.test[produce-discard_process_with_lambda-default.txt-Analyze]": [
{
"checksum": "3bffa2a18b9b81cc1f89280482f926dc",
diff --git a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
index 642ea2cfe8..abd77fb386 100644
--- a/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part12/canondata/result.json
@@ -2484,6 +2484,28 @@
}
],
"test.test[pg-tpch-q16-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Debug]": [
+ {
+ "checksum": "1c21cdfaefd86779f137aa70b1d0a294",
+ "size": 427,
+ "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/253d2e760c7825837b0d53337823dd5ebf4d6d89/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Results]": [],
"test.test[produce-native_desc_reduce_with_presort--Analyze]": [
{
"checksum": "189853c55f2d9e624f216a137a95ae15",
diff --git a/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
index 2ab59d9f5f..770eb93730 100644
--- a/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part14/canondata/result.json
@@ -2369,6 +2369,28 @@
}
],
"test.test[pg-tpch-q21-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Debug]": [
+ {
+ "checksum": "e67d1f86d8fbe71065c2dd2113ffa254",
+ "size": 609,
+ "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/43a9b27bd71c75014ae789d65d577314e37262fc/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Results]": [],
"test.test[sampling-mapjoin_right_sample-default.txt-Analyze]": [
{
"checksum": "87b97895afd9ac6a3350f69a77811ed1",
diff --git a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
index 8d39e8f9b9..6de618ad86 100644
--- a/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part17/canondata/result.json
@@ -2047,6 +2047,28 @@
}
],
"test.test[pg-wide_top_sort--Results]": [],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Debug]": [
+ {
+ "checksum": "e2533b4d21ac0d1b5ff40de375f82edb",
+ "size": 423,
+ "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1880306/c56e2bb8307f2239f8acf535a621c40b5a08a363/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Results]": [],
"test.test[pragma-classic_division-default.txt-Analyze]": [
{
"checksum": "a48ccc9922567dfee1170d2c2df45b6e",
diff --git a/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
index a63a133381..6e6018b751 100644
--- a/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part18/canondata/result.json
@@ -2147,6 +2147,28 @@
}
],
"test.test[pg-tpcds-q89-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_trigger-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_trigger-default.txt-Debug]": [
+ {
+ "checksum": "a9343f2f2090854546fd4e0631d01829",
+ "size": 422,
+ "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_trigger-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1936947/d814cd457b003ee9da1e09ee0877a39078a61012/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_trigger-default.txt-Results]": [],
"test.test[produce-discard_reduce_lambda-default.txt-Analyze]": [
{
"checksum": "c87ac713fed1eacadd4720a18695a0fc",
diff --git a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
index 53f543ac44..b709e15356 100644
--- a/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part19/canondata/result.json
@@ -2288,6 +2288,28 @@
}
],
"test.test[pg-type_aliases-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_inherits-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_inherits-default.txt-Debug]": [
+ {
+ "checksum": "156e0c70e953deb093778c2ee37a139c",
+ "size": 424,
+ "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_inherits-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1937429/82c91013a516db34237d53cdad4ae5a77a3c568b/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_inherits-default.txt-Results]": [],
"test.test[pg_catalog-pg_tablespace-default.txt-Analyze]": [
{
"checksum": "c1f2d837c3623c81dd596a9877913fb8",
diff --git a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
index 2344ae1ad7..ca216ca53b 100644
--- a/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/dq_file/part8/canondata/result.json
@@ -2507,6 +2507,28 @@
}
],
"test.test[pg-tpch-q01-default.txt-Results]": [],
+ "test.test[pg_catalog-pg_locks-default.txt-Analyze]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Analyze_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_locks-default.txt-Debug]": [
+ {
+ "checksum": "cf4254fa5a235519234177b99bda9228",
+ "size": 413,
+ "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Debug_/opt.yql_patched"
+ }
+ ],
+ "test.test[pg_catalog-pg_locks-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1942525/795fb6df3f52b9e4c9442c13b6e21f3c55c8e287/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_locks-default.txt-Results]": [],
"test.test[sampling-bind_expr-default.txt-Analyze]": [
{
"checksum": "48c500323490b6c607e4a54b8382169a",
diff --git a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
index ec2735de86..d17a95167c 100644
--- a/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
+++ b/ydb/library/yql/tests/sql/sql2yql/canondata/result.json
@@ -13068,6 +13068,20 @@
"uri": "https://{canondata_backend}/1942525/b1770d18f4fe73123c8ba7b8888beae32aa4e70b/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_database_/sql.yql"
}
],
+ "test_sql2yql.test[pg_catalog-pg_inherits]": [
+ {
+ "checksum": "9e2b5f69bd2bc691faba1a97058d4358",
+ "size": 718,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_inherits_/sql.yql"
+ }
+ ],
+ "test_sql2yql.test[pg_catalog-pg_locks]": [
+ {
+ "checksum": "4e58e80b4fb31d4bbfb3a1e777cf8d0b",
+ "size": 647,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_locks_/sql.yql"
+ }
+ ],
"test_sql2yql.test[pg_catalog-pg_shdescription]": [
{
"checksum": "3c2389e9a1d831db2944939e11919590",
@@ -13075,6 +13089,20 @@
"uri": "https://{canondata_backend}/1937424/e8964bf325e3789f68bbeb40e42daa75bf189e76/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_shdescription_/sql.yql"
}
],
+ "test_sql2yql.test[pg_catalog-pg_stat_activity]": [
+ {
+ "checksum": "817fe9904a476a06a4f8ac70719863c5",
+ "size": 1652,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_activity_/sql.yql"
+ }
+ ],
+ "test_sql2yql.test[pg_catalog-pg_stat_gssapi]": [
+ {
+ "checksum": "618acd0a4c833faffdb13606ed680142",
+ "size": 1241,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_stat_gssapi_/sql.yql"
+ }
+ ],
"test_sql2yql.test[pg_catalog-pg_tablespace]": [
{
"checksum": "755687f11614cdbe84381134ddba275c",
@@ -13082,6 +13110,27 @@
"uri": "https://{canondata_backend}/1777230/5b7a099a288bb49a0012caf8ab53daf90cc81178/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_tablespace_/sql.yql"
}
],
+ "test_sql2yql.test[pg_catalog-pg_timezone_abbrevs]": [
+ {
+ "checksum": "819b8051c278e97b81db1eb14bd8e77a",
+ "size": 724,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_timezone_abbrevs_/sql.yql"
+ }
+ ],
+ "test_sql2yql.test[pg_catalog-pg_timezone_names]": [
+ {
+ "checksum": "c92b180256ced2b5c782f04cffbf0034",
+ "size": 716,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_timezone_names_/sql.yql"
+ }
+ ],
+ "test_sql2yql.test[pg_catalog-pg_trigger]": [
+ {
+ "checksum": "7e442f9f1b41a976a45c4f7cea2ca500",
+ "size": 714,
+ "uri": "https://{canondata_backend}/1773845/118c740ff9ea824c1b2998c5bad993b2a2276f6e/resource.tar.gz#test_sql2yql.test_pg_catalog-pg_trigger_/sql.yql"
+ }
+ ],
"test_sql2yql.test[pg_catalog-pg_type_syntax_pg]": [
{
"checksum": "46b77fc59cdf4578c9766bb551960a56",
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql
new file mode 100644
index 0000000000..28e7c1c6ef
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_inherits.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+inhrelid,
+inhparent
+from
+pg_catalog.pg_inherits \ No newline at end of file
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql
new file mode 100644
index 0000000000..b827421b7c
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_locks.sql
@@ -0,0 +1,5 @@
+--!syntax_pg
+select
+transactionid
+from
+pg_catalog.pg_locks
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql
new file mode 100644
index 0000000000..04ddde2e1d
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_activity.sql
@@ -0,0 +1,18 @@
+--!syntax_pg
+select
+application_name,
+backend_start,
+backend_type,
+client_addr,
+datname,
+pid,
+query,
+query_start,
+state,
+state_change,
+usename,
+wait_event,
+wait_event_type,
+xact_start
+from
+pg_catalog.pg_stat_activity
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql
new file mode 100644
index 0000000000..a25e2f09e7
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_stat_gssapi.sql
@@ -0,0 +1,9 @@
+--!syntax_pg
+select count(*),min(encrypted::text),min(gss_authenticated::text) from (
+select
+encrypted,
+gss_authenticated,
+pid
+from
+pg_catalog.pg_stat_gssapi
+) a
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql
new file mode 100644
index 0000000000..08348b1a26
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_abbrevs.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+abbrev,
+is_dst
+from
+pg_catalog.pg_timezone_abbrevs
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql
new file mode 100644
index 0000000000..1fc53cfa1c
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_timezone_names.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+name,
+is_dst
+from
+pg_catalog.pg_timezone_names
diff --git a/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql
new file mode 100644
index 0000000000..26a3c4eeb3
--- /dev/null
+++ b/ydb/library/yql/tests/sql/suites/pg_catalog/pg_trigger.sql
@@ -0,0 +1,6 @@
+--!syntax_pg
+select
+tgrelid,
+tgenabled
+from
+pg_catalog.pg_trigger
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
index d708c3e233..696ea5ee80 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part0/canondata/result.json
@@ -2162,6 +2162,27 @@
"uri": "https://{canondata_backend}/1942671/52a125a1bb7634ddba0f986b6cf8177f5b9c01df/resource.tar.gz#test.test_pg_catalog-pg_database-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Debug]": [
+ {
+ "checksum": "5f0ef35ef92a98a0cf2883b9073a790d",
+ "size": 2413,
+ "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_gssapi-default.txt-Results]": [
+ {
+ "checksum": "1ec59fb2239388502a1fb8ac236ec631",
+ "size": 1250,
+ "uri": "https://{canondata_backend}/1880306/5bf16e2167c9f8e2e17b8a7f36952412023a8f4c/resource.tar.gz#test.test_pg_catalog-pg_stat_gssapi-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[produce-discard_process_with_lambda-default.txt-Debug]": [
{
"checksum": "27942941f86ed34cf249b81dea07228c",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
index 7e0b61d477..b884533ad8 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part12/canondata/result.json
@@ -2325,6 +2325,27 @@
"uri": "https://{canondata_backend}/1942415/14c2050022adcb6379d90c4a2a09abf0847e7643/resource.tar.gz#test.test_pg-tpch-q16-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Debug]": [
+ {
+ "checksum": "e983e9f6127c869fa931803e046a636b",
+ "size": 371,
+ "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_abbrevs-default.txt-Results]": [
+ {
+ "checksum": "05b66aa78dd526e74f646515a24a7f76",
+ "size": 832,
+ "uri": "https://{canondata_backend}/1784117/6c74bc79d1e176324c55e10f093a69211469bf8f/resource.tar.gz#test.test_pg_catalog-pg_timezone_abbrevs-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[pragma-release_temp_data_chain_pull_fail--Debug]": [],
"test.test[pragma-release_temp_data_chain_pull_fail--Plan]": [],
"test.test[pragma-release_temp_data_chain_pull_fail--Results]": [],
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
index 2dc63fd06d..bb2f8284f0 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json
@@ -2307,6 +2307,27 @@
"uri": "https://{canondata_backend}/1923547/5154c8bd8ef9ead4f609771f831f20c15e795571/resource.tar.gz#test.test_pg-tpch-q21-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Debug]": [
+ {
+ "checksum": "b59897b13cb9d2ae72ae4b532c4d110e",
+ "size": 553,
+ "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_stat_activity-default.txt-Results]": [
+ {
+ "checksum": "3a28eeeb833c250eb13c14d612d57c3e",
+ "size": 4033,
+ "uri": "https://{canondata_backend}/1880306/1ee788a2569716571a36649ae2ceeb626ced8876/resource.tar.gz#test.test_pg_catalog-pg_stat_activity-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[produce-process_rows_sorted_desc_multi_out--Debug]": [
{
"checksum": "202fbb809a2ada2cd5905af79fdf20b0",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
index 49037d9e6f..bf55549e6f 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part17/canondata/result.json
@@ -1737,6 +1737,27 @@
"uri": "https://{canondata_backend}/1923547/68f2fa8e051f31489bd496c183d28c4abddf9f68/resource.tar.gz#test.test_pg-wide_top_sort--Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Debug]": [
+ {
+ "checksum": "9556fc60b3df570c33b659d305caabb8",
+ "size": 367,
+ "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_timezone_names-default.txt-Results]": [
+ {
+ "checksum": "7f3512f1840d703239beb47aac672601",
+ "size": 830,
+ "uri": "https://{canondata_backend}/1773845/62fef1198b24b563ccf204edcd5c1495d1dd9b02/resource.tar.gz#test.test_pg_catalog-pg_timezone_names-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[pragma-classic_division-default.txt-Debug]": [
{
"checksum": "1bb9103519440102fad6e4a51ff73fa5",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
index e36b60e964..bc2a1e0654 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part18/canondata/result.json
@@ -1821,6 +1821,27 @@
"uri": "https://{canondata_backend}/1937027/67f47e98bc150e7387e3e30adedc957caafe9c32/resource.tar.gz#test.test_pg-tpcds-q89-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_trigger-default.txt-Debug]": [
+ {
+ "checksum": "0dba33788a6b6bef7fb67c22841aad2d",
+ "size": 366,
+ "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_trigger-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_trigger-default.txt-Results]": [
+ {
+ "checksum": "4aa02cda56dad43828e73fc66f8775ea",
+ "size": 835,
+ "uri": "https://{canondata_backend}/1775319/059e812ace6b1d28f72605b86d16778e7d38747a/resource.tar.gz#test.test_pg_catalog-pg_trigger-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[produce-discard_reduce_lambda-default.txt-Debug]": [
{
"checksum": "776f33da0611fa0335effb3dc55b0563",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
index 21eede358b..876f6ad966 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part19/canondata/result.json
@@ -2020,6 +2020,27 @@
"uri": "https://{canondata_backend}/1937027/16b7289b1b8f5fdff728155d836fa2b238949b2d/resource.tar.gz#test.test_pg-type_aliases-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_inherits-default.txt-Debug]": [
+ {
+ "checksum": "04b3f618fafbd2d61b06703d4c961238",
+ "size": 368,
+ "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_inherits-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_inherits-default.txt-Results]": [
+ {
+ "checksum": "dc5a6d27d606a4c9ca0b88781855e5bc",
+ "size": 835,
+ "uri": "https://{canondata_backend}/1880306/1b2ed13cc159ed80cf548a266f7c691ac03de80a/resource.tar.gz#test.test_pg_catalog-pg_inherits-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[pg_catalog-pg_tablespace-default.txt-Debug]": [
{
"checksum": "50b49b7d45a6d6b53f4dc30d689a3ea9",
diff --git a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
index c345b6fc1c..597bea026b 100644
--- a/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
+++ b/ydb/library/yql/tests/sql/yt_native_file/part8/canondata/result.json
@@ -2233,6 +2233,27 @@
"uri": "https://{canondata_backend}/937458/6ac3198834a310678c10f517fcfbcfc2838fc3af/resource.tar.gz#test.test_pg-tpch-q01-default.txt-Results_/results.txt"
}
],
+ "test.test[pg_catalog-pg_locks-default.txt-Debug]": [
+ {
+ "checksum": "0990fef4d925f5683cc1e368a81ba936",
+ "size": 357,
+ "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Debug_/opt.yql"
+ }
+ ],
+ "test.test[pg_catalog-pg_locks-default.txt-Plan]": [
+ {
+ "checksum": "c1f2d837c3623c81dd596a9877913fb8",
+ "size": 948,
+ "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Plan_/plan.txt"
+ }
+ ],
+ "test.test[pg_catalog-pg_locks-default.txt-Results]": [
+ {
+ "checksum": "67cdcb90b5e7a0d243a7d5e660b9ce71",
+ "size": 578,
+ "uri": "https://{canondata_backend}/1936947/a37065cef418c774590fd5acbf7693d8c77bccaa/resource.tar.gz#test.test_pg_catalog-pg_locks-default.txt-Results_/results.txt"
+ }
+ ],
"test.test[pragma-release_temp_data_chain_pull_single_thread--Debug]": [
{
"checksum": "280c47bff6a833450a7b1d127fb06423",