#13652: Precision and scale options should be disabled in Alter table window.

Diksha.kushwah(*) reported 2015-08-11T05:02:59Z · last modified 2015-08-17T18:52:00Z

Precision and scale options should be disabled in Alter table window.

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	DB - Sap Hana
Version	17.0

Version: 17.0.0-alpha-9

Build #: 45149

Build Date: 2015-Aug-08 09:33:50 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_40-b26

Memory: Max=704,643,072; Total=519,045,120; Free=371,041,280; CPUs=8

Steps to reproduce:

Connect to SAPHANA

Create following table:

CREATE TABLE "Diksha"."decimal_type" (

"c1" DECIMAL(12,10)

)

UNLOAD PRIORITY 5

Go to table decimal_type in tree node and right click

Click on Alter Table

Go to Column c1 properties pane and try to change Precision and scale value

Actual Result: Error message " SAP DBTech JDBC: [7] (at 43): feature not supported: cannot change the field length: c1: line 1 col 44 (at pos 43)" displayed.

Expected Result: Precision and scale options should be disabled in Alter table window.

1 attachment

Precision_scale.png

2015-08-11T05:02:59Z

101 KB

All Comments (3) Change History

ivangron 2015-08-12T17:37:27Z

Decimal will no longer allow for precision /scale to be modified

Diksha.kushwah(*) 2015-08-13T05:39:49Z

Verified in v17.0.0-alpha-15

tariqrahiman 2015-08-17T18:52:00Z

Verified in ADS v17.0.0-alpha-18

Search Tips

Aqua Data Studio / nhilam

Precision and scale options should be disabled in Alter table window.

1 attachment

Issue #13652

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Precision and scale options should be disabled in Alter table window.

1 attachment

Issue #13652

Completion