Skip to main content

IvorySQL Release - 1.0

Downolad

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