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