duckdb / duckdb/duckdb-spatial

Point2D type does not work with IMPORT/EXPORT DATABASE

Open
#433 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
708
Forks
96
Avg merge
1d 21h
Merged PRs (30d)
5

Description

Steps to reproduce:

```
LOAD SPATIAL;
CREATE TABLE test (p POINT_2D);
INSERT INTO test (p) VALUES (ST_Point2d(0,0));
EXPORT DATABASE 'test';
DROP TABLE test;
IMPORT DATABASE 'test';
```

The final line produces the following error, and the data is not imported:

```
Conversion Error: CSV Error on Line: 2
Original Line: POINT (0 0)
Error when converting column "p". Could not convert string "POINT (0 0)" to 'POINT_2D'
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.