× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
vaibhavladdha271(*) reported 2014-11-18T08:38:39Z  · tariqrahiman last modified 2014-12-16T20:47:20Z

Vertica 7:Newly added column does not get added in create flex table script,if generated through Script object to window as->Create


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Script Object
Version Future

Product: Aqua Data Studio
Version: 16.0.0-dev-39
Build #: 41109
Build Date: 2014-Nov-17 06:11:40 PM

Operating Environment: Linux (3.13.0-39-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072;  Total=595,066,880;  Free=196,404,928;  CPUs=8

Database: Vertica 7.0.2

Steps to reproduce:
Create a flex table using below script:
Create flex table test(a int , b int)
GO

After creating flex table Go to Tables node & expand it.Expand Columns node
Right click on single column
You will observe that Script object to window as options are not present for Single column
The options are provided when user selects multiple columns & right clicks on them

Select Multiple columns & right click on it,Select Script object to window as->Create
Add another column to the table through create script generated for columns
Refresh columns node
You will observe that Column gets created & gets added to Columns node
Right click on created flex table & select Script object to window as->Create
You will observe that newly added column does not get added to generated create table script

Please refer attached screenshot(16.0_vertica_flextable.png)

Also if user creates a primary key on a,drops the primary key & again creates primary key on a,b & if column definition of b is changed to "not null" then column b does not get added to create table script generated by option script object to window as->Create i.e if column definition of any column present in flex table changes then that column does not get scripted in create table script
This only happens in case of flex tables

1 attachment

Issue #12780

Closed
 
 
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