[jira] [Created] (ASTERIXDB-1539) Create aliases for builtin types in SQL++

[Yingyi Bu (JIRA)]

Yingyi Bu created ASTERIXDB-1539:
------------------------------------

             Summary: 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


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)