Skip to content

JDBC.coltypes chooses the wrong type for NUMBER(10,0) columns on Oracle 11g database #53

@metanoid

Description

@metanoid

I have an Oracle 11g database, where EVENT ID's (integers) have been stored as the Oracle data type NUMBER(10,0). This indicates 10 digits of precision, at a scale of 0 (i.e. 10^0). The scale value being non-negative means that this value will always be integer, but when I look at the result of JDBC.coltypes(JDBC.Source(csr)) the column has been assigned the DataType of Float64.
This is also happening if I look at Tables.schema(JDBC.Source(csr)).

It's possible to convert these columns to Int, but I worry that if I had very large precision integers, and JDBC.jl treated them as Float64, then I might lose precision, which on ID's is a major problem.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions