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