#13020: Mysql 5.7: Precision and Scale Values options are disabled in create table window for float and double datatype

Diksha.kushwah(*) reported 2015-01-06T13:07:26Z · last modified 2017-06-19T18:26:26Z

Mysql 5.7: Precision and Scale Values options are disabled in create table window for float and double datatype

Dev	tomconrad
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - MySQL
Version	18.0

Version: 16.0.0-dev-88

Build #: 41652

Build Date: 2014-Dec-31 05:11:18 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_60-b19

Memory: Max=954,728,448; Total=446,169,088; Free=171,904,512; CPUs=8

Database : Mysql 5.7

Steps to reproduce:

Connect to Mysql 5.7

Go to any created Database and Right click on Tables Node

Click on create Table

Enter the name of table

Add column C1 with float datatype and Go to Column properties Tab

Precision and Scale options are disabled.

We can create table with float datatype using precision and scale values Execute following query:

CREATE TABLE `test` (

`c1` float(10,5) NULL

)

Refresh the table tree node and expand table test

Expand columns node

Scale and precision is displayed

Right click on Table test,select Table Properties and check the precision and scale properties

Right click on Table test,select script object to window As-> Create

Actual Result: Precision and Scale Values does not displayed in Table Properties window and when we generate the script Precision and scale values does not display in script.

Observation: Precision and Scale also not working for "Double" datatype.

Expected Result: Precision and Scale options should be enabled for float and double datatypes.

4 attachments

mysql.png

2015-01-06T13:07:26Z

81 KB
CreateTable.png

2017-05-09T19:53:36Z

94 KB
CreateTablePreview.png

2017-05-09T19:53:52Z

87 KB
verify_13020.png

2017-05-16T09:13:49Z

253 KB

All Comments (8) Change History

tomconrad 2017-05-09T19:57:17Z

No code changes.

Hi QA Team,

This looks like it was fixed already. See here and here. Please retest.

Thanks, Tom

niru3235(*) 2017-05-16T09:19:18Z

Verified in ADS 19.0.0-alpha-8
Please refer the attachment:-verify_13020.png

Verified :- Precision and scale value can be assigned to Float/Double data type in create table UI.
- Precision and scale value can be seen in sql script generated in Preview SQL tab.
- Precision and scale value can be seen in Table Properties tab for Float/Double data type.

tariqrahiman 2017-05-17T22:10:07Z

Verified in ADS v19.0.0-alpha-8

SachinPrakash 2017-06-15T15:42:51Z

This fix should be back ported to ADS v18

tomconrad 2017-06-15T22:45:51Z · (edited)

svn #54728 to fix decimal and #54742 to fix float, real and double - Retrofit fix to V18.

tariqrahiman 2017-06-15T22:01:58Z · (edited)

It is still disabled for float & double in 18.0.14-4

tariqrahiman 2017-06-16T16:48:08Z

Verified in ADS v18.0.14-6

tariqrahiman 2017-06-19T18:26:26Z

Verified in ADS v19.0.0-alpha-47

Search Tips

Aqua Data Studio / nhilam

Mysql 5.7: Precision and Scale Values options are disabled in create table window for float and double datatype

4 attachments

Issue #13020

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Mysql 5.7: Precision and Scale Values options are disabled in create table window for float and double datatype

4 attachments

Issue #13020

Completion