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
4k stars 565 forks source link

Support columns with duplicated names #3553

Closed rekby closed 2 months ago

rekby commented 7 months ago
  1. Run local YDB https://github.com/ydb-platform/ydb/wiki/Local-run-postgres-tests
➤ echo "select 1 as a, 2 as a" | psql postgres://root:1234@localhost:5432/local

Error:

Status: GENERIC_ERROR
Issues:
<main>: Error: Type annotation, code: 1030
    <main>:1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem
        <main>:1:1: Error: Duplicated member: a

Expected behavior:

 a | a
---+---
 1 | 2
(1 row)
rekby commented 6 months ago

Additionally need support duplicated columns names in SDKs: https://github.com/ydb-platform/ydb/issues/3885