rill icon indicating copy to clipboard operation
rill copied to clipboard

Missing data types in `duckdb-data-types.ts`

Open bcolloran opened this issue 3 years ago • 0 comments

Describe the bug there are a few data types described on the Dutch DB website that are not accounted for in our duck DB data type mapping code.

see src\lib\duckdb-data-types.ts and https://duckdb.org/docs/sql/data_types/overview

there are some data types that we don't handle and and that we probably shouldn't really work on for the foreseeable future, such as BLOB and the nested data types, but in that case perhaps we need to introduce a top level invalid concept (to go along with the concepts we already have of categorical, numeric, and timestamp )

there are also a couple of other data types that are not included in the mapping that arguably we might wish to include, for example UUID, enum, real, and perhaps a couple others (I haven't done an exhaustive survey of all of the types, I just noticed this while looking at the duck DB docs— doing the exhaustive survey would be part of addressing this issue)

bcolloran avatar Aug 15 '22 20:08 bcolloran