asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1539) Create aliases for builtin types in SQL++
Date Mon, 12 Sep 2016 23:52:20 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15485675#comment-15485675
] 

Yingyi Bu commented on ASTERIXDB-1539:
--------------------------------------

[~dtabass], 

>> This seems like syntactic sugar, as I think more carefully about it? 
You're right.

Let me know if you find any type name for SQL++ is not appropriate.

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

Mime
View raw message