× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2014-05-03T13:07:45Z  · tariqrahiman last modified 2014-12-16T22:39:33Z

Precision script is missing in preview sql tab for Interval Datatype & in ER Modular Precision Scale field is enable only for Interval Datatype


Priority Low
Complexity Unknown
Component DB - Vertica
Version 16.0
Product: Aqua Data Studio
Version: 15.0.0-dev-263
Build #: 37662
Build Date: 2014-May-01 05:25:32 PM
 
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_21-b11
Memory: Max=704,643,072;  Total=353,566,720;  Free=132,609,664;  CPUs=8
 
Steps to Reproduce:
 
1. Connect to  Vertica Database.
 
2. Create the following table
    
CREATE TABLE "public"."test_int"  ( 
"col1" varchar(80),
"col2" interval 
)
Go
 
Go to preview sql tab,here it observed that Precision script is missing for interval datatype.
Please refer to screenshot precision_sql_tab.jpeg
 
Case2: In Column Parameters Pane in Create Table Window Precsion scale field is enable for the following datatype:
             1)Interval Day
              2)Interval day to second
              3)Interval hour
               4)Interval hour to second
               5)Interval minute
                6)Interval minute to second
                 7)Interval Month
                 8)Interval Second and Interval Year
 When we compare it with ER-Modular ,in ER-Modular Precision Scale field is enable only for Interval Datatype for all other interval datatype Precision option is not available in Column Parameter Pane.
 
  
2 attachments

Issue #12039

Closed
Fixed
Resolved 2014-12-16T22:39:33Z
 
 
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