Skip to content

Duckdb bug: aliased column in where is folded with aliased name to vortex #8632

Description

@myrrc
EXPLAIN
WITH cte AS (SELECT col AS other FROM '$__TEST_DIR__/cte-alias.vortex')
SELECT * FROM cte WHERE other IS NOT NULL ORDER BY other;

   physical_plan ┌───────────────────────────┐
   │          ORDER_BY         │
   │    ────────────────────   │
   │       cte.other ASC       │
   └─────────────┬─────────────┘
   ┌─────────────┴─────────────┐
   │        READ_VORTEX        │
   │    ────────────────────   │
   │   Function: Vortex Scan   │
   │          Filters:         │
   │    is_not_null($.other)   │
   │      Projections: col     │
   └───────────────────────────┘

This is a duckdb bug since it should request an original
column's name when pushing CTE through Vortex.

#8327

Metadata

Metadata

Assignees

Labels

ext/duckdbRelates to the DuckDB integration

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions