Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
Date: Mon, 12 Sep 2016 23:42:20 +0000 (UTC)
From: "Michael J. Carey (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.12991209.1469040537000.553959.1473723740469@Atlassian.JIRA>
In-Reply-To: <JIRA.12991209.1469040537000@Atlassian.JIRA>
References: <JIRA.12991209.1469040537000@Atlassian.JIRA> <JIRA.12991209.1469040537116@arcas>
Subject: [jira] [Comment Edited] (ASTERIXDB-1539) Create aliases for builtin
 types in SQL++
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Mon, 12 Sep 2016 23:42:25 -0000


    [ https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=3Dcom.atlas=
sian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D=
15485646#comment-15485646 ]=20

Michael J. Carey edited comment on ASTERIXDB-1539 at 9/12/16 11:42 PM:
-----------------------------------------------------------------------

Q:  Do we really need this for DP?  This seems like syntactic sugar, as I t=
hink more carefully about it? (Since we're not exposing CREATE TYPE or CREA=
TE DATASET - and when we do, I doubt we'd be trying to 'hide' the existing =
AQL names?)


was (Author: dtabass):
Q:  Do we really need this for DP?  This seems like syntactic sugar, as I t=
hink more carefully about it?

> 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_MONT=
H_DURATION/DAY_TIME_DURATION
>      Interval -> INTERVAL
>      UUID -> UUID
>      Record -> RECORD
>      OrderedList   =E2=80=94> 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)