GoogleCloudPlatform / GoogleCloudPlatform/DataflowTemplates

[Feature Request]: Support correct YYYY-MM-DD formatting when migrating MySQL DATE to Spanner GoogleSQL STRING

Open
#3,893 2 comments 0 reactions 1 assignee Claimed by @sm745052 View on GitHub
jules
Dominant language
Java
Stars
1.3k
Forks
1.1k
Avg merge
2d 20h
Merged PRs (30d)
60

Description

### Related Template(s)

sourcedb-to-spanner

### What feature(s) are you requesting?

When migrating MySQL `DATE` columns to Spanner GoogleSQL `STRING(MAX)` in the bulk migration template (`sourcedb-to-spanner`), values are serialized with a full timestamp component (`YYYY-MM-DDTHH:mm:SSZ`, e.g., `2012-09-17T00:00:00Z`) instead of standard date strings (`YYYY-MM-DD`).

As noted in PR #3046, the validation check in `MySQLDataTypesIT.java` (`date_to_string`) was commented out to avoid failing the test suite.

This issue tracks fixing the underlying serialization format for Spanner GoogleSQL databases and re-enabling the test case in `MySQLDataTypesIT`.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.