fluent-plugin-sql icon indicating copy to clipboard operation
fluent-plugin-sql copied to clipboard

Record ID written to state file as string

Open untsakas opened this issue 2 years ago • 1 comments

I have two tables selected from Oracle database. For one of these ID column value for last record is written back to state file as text

---
last_records:
  app.application_log_vw:
    id: '163431515.0'

Next run fails for this reason with

OCIError: ORA-01722: invalid number

Only difference between the two tables is in ID having little different datatype declaration. One having NUMBER(38) and the problematic one only NUMBER.

Ruby gem versions

ruby-oci8-2.2.11
activerecord-oracle_enhanced-adapter-6.1.6
activerecord-6.1.4.6
activesupport-6.1.4.6
activerecord-oracle_enhanced-adapter-6.1.6
fluent-plugin-sql-2.3.0

untsakas avatar Mar 03 '22 10:03 untsakas

I can now confirm, that adding size to datatype declaration fixes the issue.

untsakas avatar Mar 08 '22 18:03 untsakas