search

ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
3.68k stars 501 forks source link

[pg] Support DBeaver #1731

Open rekby opened 4 months ago

rekby commented 4 months ago
MrLolthe1st commented 3 months ago

после nullif всё еще упираемся в duplicated member -stdin-:

: Error: Type annotation

-stdin-:<main>:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem
    --!syntax_pg
    ^
    -stdin-:<main>:1:1: Error: Duplicated member: oid
            --!syntax_pg

SELECT t.oid,t.*,c.relkind,format_type(nullif(t.typbasetype, 0), t.typtypmod) as base_type_name, d.description FROM pg_catalog.pg_type t LEFT OUTER JOIN pg_catalog.pg_type et ON et.oid=t.typelem LEFT OUTER JOIN pg_catalog.pg_class c ON c.oid=t.typrelid LEFT OUTER JOIN pg_catalog.pg_description d ON t.oid=d.objoid WHERE t.typname IS NOT NULL AND (c.relkind IS NULL OR c.relkind = 'c') AND (et.typcategory IS NULL OR et.typcategory <> 'C')

rekby commented 2 months ago

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

rekby commented 3 weeks ago

Set OLAP label because DBEaver is popular internal tool for OLAP queries