Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | App - Visual Editing |
| Version | 15.0 |
Database version: Netezza 7.0
Aqua Data Studio 14.0.3
Build #: 34446
Built on: 2013-Oct-16 12:54:43 PM
Windows 7: 64 bit
Step 1: Connect to Netezza 7.0
Step 2: Create table -> Provide table name and column names -> Go to Storage tab -> Distribution -> select any column for distribution(column will appear in “selected columns” panel, in “select columns window” ) Go to Preview SQL tab. (Refer image_1.jpg)
Query will be like as given follow:
CREATE TABLE "table_1" (
"c1" VARCHAR(25) NULL,
"c2" VARCHAR(25) NULL,
"c3" VARCHAR(25) NULL )
DISTRIBUTE ON ("c2")
Step 3: Go to Storage tab again -> distribution -> deselect column from “selected column “ panel.(Now, selected column panel is empty). Go to Preview SQL tab. (Refer image_2.jpg)
CREATE TABLE "table_1" (
"c1" VARCHAR(25) NULL,
"c2" VARCHAR(25) NULL,
"c3" VARCHAR(25) NULL )
DISTRIBUTE ON ("")
Step 4 : Here, ‘Distribute on ()’ clause with zero length string is still present, even though we have deselected all columns from select distribution panel.
moreover, if we click on create,it gives error: “ zero-length delimited identifier”.
|
|
405 KB
|
|
330 KB
This can occur in DB2 UDB, Netezza, ORacle storage and many other places. Also need to check in the ER Modeler.
This is a bug for netezza and I have fixed it for netezza. DB2 has a different approach that is currently as designed. I am not sure what the issue with oracle spoken of is? perhaps file a bug for each individually and we can take a look at one at a time.
This is a bug for netezza and I have fixed it for netezza. DB2 has a different approach that is currently as designed. I am not sure what the issue with oracle spoken of is? perhaps file a bug for each individually and we can take a look at one at a time.
Verified in 15.0.0-dev-39. Will check UDB and log new issues if present.
Verified in 15.0.0-dev-39. Will check UDB and log new issues if present.
Issue #10539 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
This can occur in DB2 UDB, Netezza, ORacle storage and many other places. Also need to check in the ER Modeler.