embulk / embulk/embulk-input-jdbc

date type between mssql and mysql not working.

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

Description

# env
embulk v0.9.23
java openjdk version "1.8.0_252"

# situation
(MSSQL)
nullable *date* type
->
(MYSQL)
nullable date type

# issue
destination date columns are filled with NULL value.
even all the source columns have values.

``` yaml
in:
type: sqlserver
host: ***
user: ***
password: ***
database: ***
query: |-
SELECT
[sdate],
***
FROM *** WITH (NOLOCK)
out:
type: mysql
host: ***
user: ***
password:***
database: ***
table: ***
mode: merge_direct
options: {useUnicode: true, characterEncoding: UTF-8}
column_options:
sdate: {type: date null}

```

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.