Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.34, 10.0.7
-
None
-
None
Description
Server reports the progress for "copy to tmp table" step of the ALTER TABLE as "number of records copied" / "total number of records as reported by the engine".
In some engines this second number (total number of records) is only an estimation and may be less than the actual number of records. In this case the progress report will go over 100%. This is confusing for users and might break tools that don't expect that.
As we cannot fix the estimation in engines, the server should limit the reported progress value never to be larger than 100%.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Fix Version/s | 10.0.8 [ 14200 ] | |
Fix Version/s | 5.5.35 [ 14000 ] | |
Description |
Server reports the progress for "copy to tmp table" step of the ALTER TABLE as "number of records copied" / "total number of records as reported by the engine". In some engines this second number (total number of records) is only an estimation and may be less than the actual number of records. In this case the progress report will go over 100%. This is confusing for users and might break tools that don't expect that. As we cannot fix the estimation in engines, the server should limit the reported progress value never to be larger than 100%. |
Assignee | Sergei Golubchik [ serg ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Workflow | defaullt [ 33742 ] | MariaDB v2 [ 42816 ] |
Workflow | MariaDB v2 [ 42816 ] | MariaDB v3 [ 61834 ] |
Workflow | MariaDB v3 [ 61834 ] | MariaDB v4 [ 147437 ] |