Random millisecond value wen editing time in the webinterface
#19,620 建立於 2025年3月5日
倉庫指標
- Star
- (6,886 star)
- PR 合併指標
- (平均合併 2天 17小時) (30 天內合併 11 個 PR)
描述
Describe the bug
Wen i try to edit the decimal places of a time value of a database entry in the phpMyAdmin webUI the decimal places value gets changed to a seemingly random value.
To Reproduce
Steps to reproduce the behavior:
- Go to a table containing a time [not time(0) ]
- Doubleclick on the a time value to edit it
- Change the decimal places using the text field
- Press enter to set new value
- See that the value was not changed to the value typed into the textfield
- The displayed SQL query already contains a seemingly random value for the millisecond part
- even if you try to type the same decimal places value over and over again the decimal places will always be different
Expected behavior
I would expect that the value i type is taken as new value (potentaly to many digist shloud be cut of). Wen i use the millisecond slider it works as expected despite that slider "typing" in a value in the text field.
Screenshots
If applicable, add screenshots to help explain the bug.
Server configuration
The server is just a rented wordpress installation
- Operating system: Ubuntu 22.04 (?)
- Web server: Apache
- Database version: 10.6.20-MariaDB-ubu2204
- PHP version: 8.0.30
- phpMyAdmin version: 5.2.2
Client configuration
- Browser: Firefox & Chromium
- Operating system: Kubuntu 24.10
Additional context
I used time(2) and manly tested with that because i need precision to 1/100 of a second but the behavior was similar wen using other values for the size of the time field.