embulk / embulk/embulk-input-jdbc

【MYSQL】date issue with 0001-01-01

Open
#157 6 comments 1 reaction 0 assignees View on GitHub
Dominant language
Java
Stars
106
Forks
76
PR merge metrics
No merged PRs in 30d

Description

I create one table and test.yaml to try using embulk run.

|id|date|datetime|
|:---|:---|:---|
|1|0001-01-01|0001-01-01 00:00:00|

```
in:
type: mysql
host: localhost
user: user
password: password
database: db
query: |
SELECT date,datetime FROM one WHERE id = 1

out:
type: stdout
```

Then, use embulk run
```
$ embulk run test.yml
```

Result
```
0000-12-29,0000-12-30 00:00:00
````

I think result is not correct. Do you have any solution or idea ?

I would not like to use column_options if possible.
```
column_options:
date: {type: string, value_type: string}
datetime: {type: string, value_type: string}
```

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.