fluent / fluent/fluent-plugin-sql

Non-provided columns filled with NULL, conflicts with default UUID

Ouverte
#95 8 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
bug needs-investigation
Langage dominant
Ruby
Étoiles
112
Forks
58
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

I have a field `pkey` which defaults to a generated uuid as follows:

`pkey UUID NOT NULL DEFAULT uuid_generate_v1(),`

I think the plugin is autofilling any missing column with NULL:

```
2020-08-07 17:14:28 -0400 [error]: #0 Got deterministic error again. Dump a record error_class=ActiveRecord::NotNullViolation error="PG::NotNullViolation: ERROR: null value in column \"pkey\" violates not-null constraint\nDETAIL: Failing row contains (null, 2016-06-22 19:10:25, [\"a\", 3], cool_model, 2.0, 0.5).\n: INSERT INTO \"fluentd_test\" (\"pkey\",\"my_datetime\",\"model_data\",\"ml_model_name\",\"model_version\",\"score\") VALUES (NULL,'2016-06-22 19:10:25','[\"a\",3]','cool_model','2.0',0.5)" record=#
```

The INSERT statement could omit the pkey field and the NULL statement and the database would auto-fill with `uuid_generate_v1()`, so the message would not have to contain uuid.

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Piste de recherche

The issue names no source file or test. Start by tracing the SQL output plugin's ActiveRecord INSERT path and reproducing issue #95 with a PostgreSQL UUID default; done means an omitted pkey allows the database default to populate it, with a regression test covering the behavior.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Évaluation

Stack technique
postgresql, ruby, sql
Domaine
databases
Type d'issue
Bug
Difficulté
3/5
Temps estimé
1-2 jours
Activité
À l'abandon
Clarté
Plutôt claire
Accessibilité débutants
45/100

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.