fluent / fluent/fluent-plugin-sql

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

Open
#95 8 comments 0 reactions 0 assignees View on GitHub
bug needs-investigation
Dominant language
Ruby
Stars
112
Forks
58
PR merge metrics
No merged PRs in 30d

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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.