× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
VikramPacharne(*) reported 2014-01-06T07:41:30Z  · tomconrad last modified 2018-03-08T23:32:44Z

In Netezza: "Distribution Column" option should be disable when we check "Distribute Random" check box


PM
Priority Low
Complexity Unknown
Component DB - Netezza
Version Future
Aqua Data Studio 15.0.0-dev-63 
Build #: 35415 
Built on: 2014-Jan-03 09:09:58 AM
Database : Netezza
O.S. : Windows 8.1
 
Issue : 

 "Distribution Column" option should be disable when we check "Distribute Random" check box

 
 
Steps to Reproduce : 
 
1]Connect and Expand tree node of Netezza database.
2]Expand Database tree node.
3]Expand any database.
4]Right click on Tables tree node and select Create Table option.
5]Create Table window opens, enter table named "test_table" with columns c1,c2,c3,c4 all of datatype varchar.
6]Switch to Storage tab, Check Distribute Random checkbox.
7]Add the columns (c2,c3) in Distribution column option.
8]Switch to Preview SQL tab.
 
Here it is observed that, Create table script is generated with "DISTRIBUTE ON RANDOM". Here "Distribution Column" option should be disable when we check "Distribute Random" check box in Storage tab.
 
1 attachment

Issue #11264

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017