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)