Bug #47405 Impossible to properly view/edit DECIMAL column values in query result set

• Submitted: 17 Sep 2009 9:57
• Modified: 8 Oct 2009 16:51
• Reporter: Sergei Tkachenko
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.2.3
• OS: Any
• Assigned to: Sergei Tkachenko
• CPU Architecture: Any
• Tags: resultset decimal column

[17 Sep 2009 9:57] Sergei Tkachenko

Description:
Decimal column value appears in result set as integer value disregarding to precision/scale settings. Fractional part is just discarded. It's also impossible to add fractional part during editing.

How to repeat:
1) create table with decimal column, e.g.: create table `test_table` (id decimal(5,1));
2) add some data to the table: insert into `test_table` values (1234.5);
3) open table for edit in Query Editor by running query: edit `test_table`;

Outcome: Result set contains a single cell with value 1234.

Suggested fix:
Fix visualization/editing of decimal values in result set.

[2 Oct 2009 17:48] Johannes Taxacher

has been fixed. fix will be included in 5.2.4

[8 Oct 2009 16:51] Tony Bedford

An entry was added to the 5.2.4 changelog:

When a table was opened for editing in the Query Editor, the DECIMAL column values appeared in the result set as integer values, disregarding precision and scale settings. The fractional part of the number was discarded. It was also not possible to add the fractional part of the number during editing.