You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Yingyi Bu (JIRA)" <ji...@apache.org> on 2016/07/20 18:49:20 UTC
[jira] [Created] (ASTERIXDB-1539) Create aliases for builtin types
in SQL++
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)