duckdb / duckdb/duckdb-spatial
Unimplemented type for cast (MULTIPOLYGON WKB_BLOB -> POLYGON_2D)
- Dominant language
- C
- Stars
- 708
- Forks
- 96
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 5
Description
Is there a timeline for when casts like the following will be supported?
```sql
SELECT ST_GEOMFROMWKB(a.geom) geom2, b.*
FROM st_read('geom_xaa.gpkg') a
LEFT JOIN us_geom b
ON ST_WITHIN(ST_Centroid(ST_GEOMFROMWKB(a.geom))::POINT_2D,
b.geom::POLYGON_2D)
limit 1;
```
```
Error: Conversion Error: Unimplemented type for cast (WKB_BLOB -> POLYGON_2D)
```
```sql
SELECT ST_GEOMFROMWKB(a.geom) geom2, b.*
FROM st_read('geom_xaa.gpkg') a
LEFT JOIN us_geom b ON ST_WITHIN(ST_Centroid(ST_GEOMFROMWKB(a.geom)),
ST_GEOMFROMWKB(b.geom))
limit 1;
```
```
Error: Not implemented Error: Geometry type not supported
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.