Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1539

Create aliases for builtin types in SQL++

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: *DB - AsterixDB
    • Labels:

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              buyingyi Yingyi Bu
              Reporter:
              buyingyi Yingyi Bu
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: