DatAdmin

Hello dear forum,

when copy tables the target table gets wrong numeric scales and digits that are available in the source table are truncated (occurs in versions 3.4.5 and 3.4.6).

Example:
-Copy source table with decimal column per drag-and-drop(!), DDE tab shows the following create statement for source table:
CREATE TABLE `db_test`.` table_source` (
`real_col` double(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

-Created target table, DDE tab shows the following create statement for table (see data format, precision):
CREATE TABLE `db_test`.` table_target` (
`real_col` double(10,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Observations:
- In summary view (columns tab) source table shows correct data format in (DATA_TYPE: double, NUMERIC_PRECICION: 10, NUMERIC_SCALE: 2)
- In tree view source tab shows incorrect data format: real_col (real(10,0), null)
- In summary view (columns tab) tarbet table shows INcorrect data format in (DATA_TYPE: double, NUMERIC_PRECICION: 10, NUMERIC_SCALE: 0)
- In tree view source tab shows incorrect(?) data format: real_col (real(10,0), null)
--> Numeric scale was changed during copy via drag-and-drop
--> Values copied from source to target table have no digits any more!

Any help is highly appreciated since this causes serious trouble.
Thanks,
Carsten