[ 
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 (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.



  was:
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.




> 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)

Reply via email to