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.

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

MySQL type Year incorrect display #2866

Closed
juliardi opened this Issue Jan 25, 2018 · 4 comments

Comments

Projects
None yet
3 participants
@juliardi
Copy link
Contributor

juliardi commented Jan 25, 2018

I have a column with 'year' as its data type in MySQL database :
screenshot_20180125_114354

However it displayed incorrectly in data view :
screenshot_20180125_114410
It should be displayed as '2017' or '2016', but the table shows '2017-01-01' and '2016-01-01'. It also happened when I want to update or insert new row.

@juliardi

This comment has been minimized.

Copy link
Contributor

juliardi commented Feb 10, 2018

Is it possible to change the way Dbeaver display type 'year' data?

@juliardi

This comment has been minimized.

Copy link
Contributor

juliardi commented Aug 2, 2018

@serge-rider can you look at this issue?
Also recently I found another problem with Export Table Data feature which is related to this issue. When I want to export data from source table to another database, the Export Table Data will create a year_column with timestamp data type in the newly created destination table, even though when I look at the source table the data type is stated as year(4).
Source Table :

Column Name Data Type
year_column year(4)
another_column ................

Destination Table :

Column Name Data Type
year_column timestamp
another_column ................

@juliardi juliardi changed the title Wrong display in column when data type is Year MySQL type `Year` wrong column display Sep 18, 2018

@juliardi juliardi changed the title MySQL type `Year` wrong column display MySQL type Year wrong column display Sep 18, 2018

@juliardi juliardi changed the title MySQL type Year wrong column display MySQL type Year incorrect display Sep 18, 2018

@serge-rider serge-rider added this to the 5.3.3 milestone Jan 11, 2019

serge-rider added a commit that referenced this issue Jan 11, 2019

@serge-rider

This comment has been minimized.

Copy link
Member

serge-rider commented Jan 11, 2019

This will be fixed in 5.3.3. Sorry for so long delay

@juliardi

This comment has been minimized.

Copy link
Contributor

juliardi commented Jan 14, 2019

No problem, thank you for addressing this issue

@uslss uslss removed the ready for qa label Jan 15, 2019

@uslss uslss closed this Jan 15, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment