Vitaly Stoyan

https://github.com/ydb-platform/ydb/issues/1722

next query after select version is $3 = SELECT db.oid as did, db.datname, db.datallowconn, pg_encoding_to_char(db.encoding) AS serverencoding, has_database_privilege(db.oid, 'CREATE') as cancreate, datistemplate FROM pg_catalog.pg_database db WHERE db.datname = current_database()

current_database() crash

next query SELECT roles.oid as id, roles.rolname as name, roles.rolsuper as is_superuser, CASE WHEN roles.rolsuper THEN true ELSE roles.rolcreaterole END as can_create_role, CASE WHEN roles.rolsuper THEN true ELSE roles.rolcreatedb END...

@adameat How can we get application_name from pgwire layer?

with compat hack for AEXPR_OP_ANY -> false, the query is working --!syntax_pg set ApplicationName="pgAdmin"; SELECT roles.oid as id, roles.rolname as name, roles.rolsuper as is_superuser, CASE WHEN roles.rolsuper THEN true ELSE...

properties of tablespaces/roles don't work yet Status: GENERIC_ERROR Issues: : Error: Type annotation, code: 1030 :1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem :5:5:...

properties of databases Status: INTERNAL_ERROR Issues: : Fatal: Optimization, code: 1070 :8:9: Fatal: ydb/library/yql/core/common_opt/yql_co_pgselect.cpp:2974 JoinOuter(): requirement outerInputs.size() == finalExtTypes->Tail().ChildrenSize() failed, code: 1 :1:1: Fatal: ydb/library/yql/core/common_opt/yql_co_pgselect.cpp:704 RewriteSubLinksPartial(): requirement status.Level != IGraphTransformer::TStatus::Error...

a background query --!syntax_pg /*pga4dash*/ SELECT 'session_stats' AS chart_name, pg_catalog.row_to_json(t) AS chart_data FROM (SELECT (SELECT count(*) FROM pg_catalog.pg_stat_activity WHERE datname = (SELECT datname FROM pg_catalog.pg_database WHERE oid = 3)) AS...

another query to describe a role SELECT pg_catalog.array_to_string(array_agg(sql), E'\n\n') AS sql FROM (SELECT '-- Role: ' || pg_catalog.quote_ident(rolname) || E'\n-- DROP ROLE IF EXISTS ' || pg_catalog.quote_ident(rolname) || E';\n\nCREATE ROLE...