[
https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Till updated ASTERIXDB-1539:
----------------------------
Labels: soon (was: )
> 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 -> TINYINT
> Int16 -> SMALLINT
> Int32 -> INT
> Int64 -> BIGINT
> Float -> REAL
> Double
> String
> Binary
> Point
> Line
> Rectangle -> BOX
> Circle
> Polygon
> Date
> Time
> Datetime -> TIMESTAMP
> Duration/Year-month-duration/Day-time-duration
> Interval
> UUID
> 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)
