Years are seen wrong by date picker

[liviuconcioiu]

Describe the bug

0000-01-01 is seen as 2000-01-01
0025-01-01 is seen as 2025-01-01
0035-01-01 is seen as 1935-01-01

To Reproduce

Steps to reproduce the behavior:

1. Create a table with a date column
2. Insert a row (paste 0000-01-01 and modify the year for the other years)
3. See error

Expected behavior

Dates should be seen correctly.

Screenshots

13.10.2022_02.22.12_REC.mp4

Server configuration

• Operating system: Linux
• Web server: nginx/1.14.2
• Database version: 8.0.18 - MySQL Community Server - GPL
• PHP version: 7.4.29
• phpMyAdmin version: 5.2.1-dev

Client configuration

• Browser: Firefox/Chrome
• Operating system: Windows

Additional context

Add any other context about the bug here.

[liviuconcioiu]

Also, the max year should be limited to 9999.

13.10.2022_02.26.28_REC.mp4

[liviuconcioiu]

Another issue with date picker. When clicking a date for the first time is seen correctly. All further clicks on other dates are seen as the first date.

23.10.2022_14.40.30_REC.mp4

[liviuconcioiu]

I will add another issue, sometimes years are going negative. Theoretically should be OK, but negative years aren't allowed.

https://dev.mysql.com/doc/refman/5.6/en/datetime.html

[williamdes]

Thank, I think it should get fixed for 5.2.1, it's not a very good UI behavior