Skip to content

Please standardize file access and basic capabilities #729

@quillaja

Description

@quillaja

Various file formats should be able to be opened using the same syntax. Also ST_Read_Meta fails in various ways on different formats.

System:

  • using cli: DuckDB v1.4.3 (Andium) d1dc88f950; Windows 11 amd64/x64
  • using api: DuckDB.NET v1.4.3 on .NET 10

(geo)parquet - ST_Read_Meta crashes

FROM 'some_data.parquet'; -- works
FROM ST_Read('some_data.parquet'); -- does NOT work, error
FROM read_parquet('some_data.parquet'); -- works

geopackage - ST_Read_Meta works

FROM 'some_data.gpkg'; -- works
FROM ST_Read('some_data.gpkg'); -- works

geodatabase - ST_Read_Meta does not crash but does return 0 rows

FROM 'some_data.gdb'; -- does NOT work, error
FROM ST_Read('some_data.gdb'); -- works

shapefile - ST_Read_Meta works

FROM 'some_data.shp'; -- works
FROM ST_Read('some_data.shp'); -- works

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions