fluent/fluent-plugin-sql

Record ID written to state file as string

untsakas opened this issue · 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

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