[
https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu updated ASTERIXDB-1539:
-
Description:
Create SQL standard aliases for builtin types:
Boolean
Int8 -> TINYINT
Int16 -> SMALLINT
Int32 -> INT
Int64 -> BIGINT
Float -> REAL
Double -> DOUBLE
String -> STRING
Binary -> BINARY
Point -> POINT
Line -> LINE
Rectangle -> BOX
Circle -> CIRCLE
Polygon -> POLYGON
Date -> DATE
Time -> TIME
Datetime -> TIMESTAMP
Duration/Year-month-duration/Day-time-duration ->
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.
was:
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.
> 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 -> DOUBLE
> String -> STRING
> Binary -> BINARY
> Point -> POINT
> Line -> LINE
> Rectangle -> BOX
> Circle -> CIRCLE
> Polygon -> POLYGON
> Date -> DATE
> Time -> TIME
> Datetime -> TIMESTAMP
> Duration/Year-month-duration/Day-time-duration ->
> 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)