× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
vaibhavladdha271(*) reported 2014-11-13T11:22:36Z  · tariqrahiman last modified 2014-12-16T22:40:05Z

Precision value does not get assigned for interval datatype through create table editor window

  Duplicates #12039
Priority Low
Complexity Unknown
Component DB - Vertica
Version 16.0

Product: Aqua Data Studio
Version: 16.0.0-dev-35
Build #: 41045
Build Date: 2014-Nov-12 05:18:16 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=329,777,152;  Free=138,007,952;  CPUs=8

Open create table editor window
In create table editor window Enter test in Table name field
Enter precision values for those interval datatypes for which precision field is enabled
Now switch to Preview sql tab
You will observe that Precision value does not get assigned for following interval datatypes:interval,interval minute,interval month,interval year,interval hour,interval day
Also precision field is not enabled for all interval datatypes
Also interval day to second is displayed as interval datatype in Table properties window
Please refer attached screenshot(16.0_vertica_interval datatype.png)

Also in ER Modeler Precision  & scale fields are not present for interval datatype

1 attachment

Issue #12733

Closed
Duplicate
Resolved 2014-12-16T22:40:05Z
 
 
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