Record ID written to state file as string
untsakas opened this issue · 1 comments
untsakas commented
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 commented
I can now confirm, that adding size to datatype declaration fixes the issue.