Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL connectors writes TIMESTAMPS as datetime(0) in CREATE TABLE AS ... #6909

Closed
hashhar opened this issue Feb 16, 2021 · 0 comments
Closed

MySQL connectors writes TIMESTAMPS as datetime(0) in CREATE TABLE AS ... #6909

hashhar opened this issue Feb 16, 2021 · 0 comments
Assignees
@hashhar @jirassimok
Labels
bug Something isn't working
Milestone
354

Comments

@hashhar
Copy link
Member

hashhar commented Feb 16, 2021

Trino is writing TIMESTAMPs as datetime(0) to MySQL causing a loss of precision.

Easy to observe using a CREATE TABLE test_ts AS SELECT TIMESTAMP '2020-01-01 01:01:01.123'.

SELECT * FROM test_ts returns 2020-01-01 01:01:01.
@hashhar hashhar added the bug Something isn't working label Feb 16, 2021
@hashhar hashhar self-assigned this Feb 16, 2021
@findepi findepi changed the title MySQL connectors writes TIMESTAMPS as datetime(0) MySQL connectors writes TIMESTAMPS as datetime(0) in CREATE TABLE AS ... Feb 16, 2021
@jirassimok jirassimok self-assigned this Mar 4, 2021
@jirassimok jirassimok mentioned this issue Mar 5, 2021
Merged
@findepi findepi closed this as completed Mar 8, 2021
@findepi findepi mentioned this issue Mar 8, 2021
Closed
10 tasks
@findepi findepi added this to the 354 milestone Mar 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hashhar hashhar

@jirassimok jirassimok

Labels
bug Something isn't working
Milestone
354
Development

No branches or pull requests
3 participants
@findepi @hashhar @jirassimok