fluent / fluent/fluent-plugin-sql
Record ID written to state file as string
- Langage dominant
- Ruby
- Étoiles
- 112
- Forks
- 58
- Métriques de merge des PR
- Aucune PR mergée en 30 j
Description
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
```
Guide de contribution
Aucun guide de contribution indexé pour ce dépôt
Piste de recherche
Reproduce the state-file write and next-run failure with Oracle columns declared as NUMBER(38) and NUMBER. Trace how the selected record ID is converted before it is written to the state file, then verify that the persisted value remains usable by the next query and no longer causes ORA-01722.
Rédigé par le modèle d'indexation à partir du texte de l'issue.
Évaluation
- Stack technique
- ruby, sql
- Domaine
- databases
- Type d'issue
- Bug
- Difficulté
- 3/5
- Temps estimé
- 1-2 jours
- Activité
- Calme
- Clarté
- Plutôt claire
- Accessibilité débutants
- 45/100