Skip to main content

IvorySQL Release - 1.0

Download​

Release Notes​

[Release Date: December 15, 2021]

Overview​

IvorySQL 1.0 is based on PostgreSQL 14 and mainly adds Oracle compatibility features on top of PostgreSQL. The release ensures that it is 100% compatible with PostgreSQL 14 and you can refer to the Official PostgreSQL 14 documentation and release notes for detailed lists of PostgreSQL features and functions.

What's Changed​

  • Oracle Compatible Data Types

    • DATE
    • VARCHAR2
    • NVARCHAR2

  • Various Oracle Compatible Functions

    • NANVL
    • GREATEST
    • LEAST date time functions
    • TO_DATE
    • ADD_MONTHS AND MONTHS_BETWEEN
    • TRUNC AND ROUND
    • NEXT_DAY AND LAST_DAY
    • NEW_TIME
    • ADD_DAYS_TO_TIMESTAMP
    • SUBTRACT
    • DAYS_BETWEEN
    • DAYS_BETWEEN_TMTZ
    • SYS_EXTRACT_UTC
    • SESSIONTIMEZONE
    • DBTIMEZONE
    • SYSTIMESTAMP
    • SYSDATE
    • NUMTODSINTERVAL
    • NUMTOYMINTER
    • FROM_TZ

  • Conversion Functions

    • TO_MULTI_BYTE
    • TO_SINGLE_BYTE
    • TO_YMINTERVAL
    • TO_DSINTERVAL
    • INTERVAL_TO_SECONDS
    • TO_TIMESTAMP
    • TO_TIMESTAMP_TZ
    • TO_NUMBER
    • HEX_TO_DECIMAL
    • TO_BINARY_DOUBLE
    • TO_BINARY_FLOAT
    • BIN_TO_NUM
    • TO_CHAR

  • Oracle Compatible Syntax Support for various DDL and DML

    • ALTER TABLE using Oracle Syntax
    • DELETE FROM TABLE using Oracle Syntax
    • UPDATE TABLE using Oracle Syntax
    • NEXTVAL and CURRVAL keywords support for sequences

  • Oracle Compatible Operator support

    • MINUS
    • UNION
    • q'' Escape operator

  • Support Oracle behavior for GROUPBY

  • Support for Oracle style Packages

  • PL/iSQL procedural language to support PL/SQL

  • Oracle Compatible CREATE FUNCTION support

  • compatibility_mode GUC to switch between Oracle and PostgreSQL compatible output for function that behaves differently on Oracle and PostgreSQL

  • compatible-mode switch to initdb to select between Oracle andPostgreSQL compatibility modes right from start

  • Support for NLS_LENGTH_SEMANTICS for VARCHAR2 andNVARCHAR2 types

  • Builtin Oraface package support

Contributors​

The following individuals have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

  • Asif Rehman
  • Bing Ao

Complete Changelog