[
https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu closed ASTERIXDB-1539.
--------------------------------
Resolution: Fixed
> Create aliases for builtin types in SQL++
> -----------------------------------------
>
> Key: ASTERIXDB-1539
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1539
> Project: Apache AsterixDB
> Issue Type: Improvement
> Components: AsterixDB
> Reporter: Yingyi Bu
> Assignee: Yingyi Bu
> Labels: soon
>
> Create SQL standard aliases for builtin types:
> Boolean
> Int8 (deprecated) -> TINYINT
> Int16 (deprecated) -> SMALLINT
> Int32 (deprecated) -> INT
> Int64 (deprecated) -> BIGINT
> Float -> FLOAT
> Double -> DOUBLE
> Double -> DOUBLE PRECISION
> String -> STRING
> Binary -> BINARY
> Point -> POINT
> Line -> LINE
> Rectangle -> Rectangle
> Circle -> CIRCLE
> Polygon -> POLYGON
> Date -> DATE
> Time -> TIME
> Datetime -> TIMESTAMP
> Duration/Year-month-duration (deprecated) /Day-time-duration
> (deprecated) -> DURATION/YEAR_MONTH_DURATION/DAY_TIME_DURATION
> Interval -> INTERVAL
> UUID -> UUID
> Record -> RECORD
> OrderedList —> ARRAY
> UnorderedList --> MULTISET
> Here is the PostgreSQL reference:
> https://www.postgresql.org/docs/9.5/static/datatype.html
> Sub-tasks:
> 1. Check the difference between SQL array and JSON array;
> 2. Think about suitable aliases for
> Duration/Year-month-duration/Day-time-duration.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
