New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Point2D type does not work with IMPORT/EXPORT DATABASE #433

Open

ammojamo opened this issue Oct 18, 2024 · 1 comment

ammojamo commented Oct 18, 2024

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'

The text was updated successfully, but these errors were encountered:

Author

ammojamo commented Oct 18, 2024

DuckDB Version: v1.1.2 f680b7d08f
MacOS 14.4.1
Installed via Homebrew

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment