Skip to content

bug: oracledb source plugin incorrectly tries and fails to cast float column to integer #11538

@niclasgrahm

Description

@niclasgrahm

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

When trying to sync a table using the v1.2.2 plugin I get the following error:

Starting sync for: oracledb (v1.2.2) -> [file_destination]
| Syncing resources... (33/-, 585 resources/s) [0s] Error: failed to sync v1 source oracledb: rpc error: code = Unknown desc = failed to sync resources: failed to sync unmanaged client: failed to read from table REDACTED: sql: Scan error on column index 6, name "REDACTED": converting driver.Value type string ("2367.362") to a int: invalid syntax

The column that fails has the data type NUMERIC(20, 4).

Expected Behavior

The table to sync to my destination

CloudQuery (redacted) config

kind: source
spec:
  name: "oracledb"
  path: "cloudquery/oracledb"
  version: "v1.2.2"
  tables: ["REDACTED"]
  destinations: ["file_destination"]
  spec:
   
    connection_string: "oracle://xx:[email protected]:1521/xx.xx.xx"

Steps To Reproduce

  • Windows machine
  • cloudquery v3.5.1
  • oracledb plugin 1.2.2
  • cloudquery sync ./my_config

CloudQuery (redacted) logs

see above

CloudQuery version

3.5.1

Additional Context

No response

Pull request (optional)

  • I can submit a pull request

Metadata

Metadata

Assignees

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