[
https://issues.apache.org/jira/browse/ASTERIXDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15523424#comment-15523424
]
ASF subversion and git services commented on ASTERIXDB-1539:
------------------------------------------------------------
Commit 635d70375fc03c1c03feae0d1ee4e241fd895782 in asterixdb's branch
refs/heads/master from [~buyingyi]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=635d703 ]
ASTERIXDB-1539: add function mapping for AQL.
- allow all SQL++/AQL functions to be "_"-based;
- still accept "-"-based functions.
Change-Id: I6ab87a02c8c270535059bdec8281c72801418551
Reviewed-on: https://asterix-gerrit.ics.uci.edu/1210
Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Till Westmann <ti...@apache.org>
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
> 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 (deprecated) -> TINYINT
> Int16 (deprecated) -> SMALLINT
> Int32 (deprecated) -> INT
> Int64 (deprecated) -> BIGINT
> Float -> FLOAT
> Double -> DOUBLE
> Double -> DOUBLE PRECISION
> String -> STRING
> Binary -> BINARY
> Point -> POINT
> Line -> LINE
> Rectangle -> Rectangle
> Circle -> CIRCLE
> Polygon -> POLYGON
> Date -> DATE
> Time -> TIME
> Datetime -> TIMESTAMP
> Duration/Year-month-duration (deprecated) /Day-time-duration
> (deprecated) -> 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)
