× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
nhilam reported 2012-11-30T19:40:31Z  · tariqrahiman last modified 2013-02-11T17:28:19Z

ER Modeler Conversion - Vertica


Priority Major
Complexity Unknown
Component Tools - ER Modeler
Version 13.0

Some issues observed in the ER Modeler conversion:

  1. EDatabaseVertica.convert
    • BINARY is converted to DDesc.BINARY(BINARY_LIMIT, BINARY_LIMIT, true). Note that the original length info is lost, and it's changed to variable. (fixed)
    • CHARACTER_VARYING is converted to DDesc.STRING(length, length, true, false, false). Note that it's been changed to a fixed string. (fixed)
    • TIMESTAMPTZ is converted to DDesc.DATETIME(). Note that timezone is lost. (fixed)
    • MONEY is converted to DDesc.NUMBER(precision, scale). Note that the money attribute is lost.  (Money is just an alias to numeric)
  2. EDatabaseVertica.createColumn
    • DATETIME is created as TIMESTAMP column, but losing the timezone info. (fixed)
    • BINARY is created as BINARY column, even though it may be variable. (fixed)

 

Issue #7991

Closed
Fixed
Resolved 2012-12-05T20:52:38Z
 
 
Completion
No due date
Fixed Build 13.0-rc-4
No time estimate

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