Skip to content

0.11 Snapshot: Cannot create a list of types STRUCT(t VARCHAR, len INTEGER) and STRUCT(VARCHAR, INTEGER) #11467

@manticore-projects

Description

@manticore-projects

What happens?

Generating Lists from STRUCT suddenly fails with version 0.11-Snapshot

To Reproduce

-- works with 0.10.0
select Unnest([
  { t:'abc', len:5 }::STRUCT(t VARCHAR, len integer),
   ('abc', 2),
], recursive => true);

Fails with 0.11-Snapshot

select Unnest([
  { t:'abc', len:5 }::STRUCT(t VARCHAR, len integer),
   ('abc', 2),
], recursive => true);
Binder Error: Cannot create a list of types STRUCT(t VARCHAR, len INTEGER) and STRUCT(VARCHAR, INTEGER) - an explicit cast is required LINE 3:    ('abc', 2),

OS:

Linux

DuckDB Version:

0.11-Snapshot

DuckDB Client:

Java

Full Name:

Andreas Reichel

Affiliation:

manticore-projects.com

Have you tried this on the latest nightly build?

I have tested with a nightly build

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

  • Yes, I have

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions