embulk / embulk/embulk-input-jdbc

space character in field is ignored

Open
#162 4 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
106
Forks
76
PR merge metrics
No merged PRs in 30d

Description

```
in:
...
type: mysql
query: |-
SELECT metaID, metaName, metaDesc, createDate FROM A

out:
...
type: mysql
create_table_constraint: primary key (metaID), UNIQUE KEY `unique_index` (`metaName`)
mode: merge
options: {useUnicode: true, characterEncoding: UTF-8}
column_options:
...
```

*metaName* column is already unique key in source db.
but error is caused by unique key
error message is
```
Duplicate entry 'somevalue?' for key 'unique_index'
```

i think the reason is...

| metaName |
|--------------|
| 'somevalue' |
| 'somevalue ' |

(with space at the end)

i think embulk input plugin ignore a space.
is there any solution?

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.