R - support UUID type

[james-atkins]

What happens?

R does not support the UUID type.

To Reproduce

SELECT uuid()

fails with: Error: duckdb_prepare_R: Unknown column type for prepare: UUID

Environment (please complete the following information):

• OS: Windows 10
• DuckDB Version: 0.3.2
• DuckDB Client: R 4.1.2

Before Submitting

• Have you tried this on the latest master branch?

• Python: pip install duckdb --upgrade --pre
• R: install.packages("https://github.com/duckdb/duckdb/releases/download/master-builds/duckdb_r_src.tar.gz", repos = NULL)
• Other Platforms: You can find binaries here or compile from source.

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

[Alex-Monahan]

As a temporary workaround, have you tried casting it to a varchar?

Select uuid()::varchar

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.