Skip to content

Releases: rasifr/IvorySQL_old

Release list

Initial Release of IvorySQL 1.0

Initial Release of IvorySQL 1.0 Latest
Latest

Choose a tag to compare

View all tags
@rasifr rasifr released this 10 Dec 12:31
Ivory_REL_1_0
f970d52

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 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

    • Date Time Functions: TO_DATE, ADD_MONTHS, MONTHS_BETWEEN, NEXT_DAY, LAST_DAY, NEW_TIME
      DAYS_BETWEEN, DAYS_BETWEEN_TMTZ, ADD_DAYS_TO_TIMESTAMP, SESSIONTIMEZONE, DBTIMEZONE
      SYSTIMESTAMP, SYSDATE, FROM_TZ
    • NANVL, GREATEST, LEAST, TRUNC, ROUND, SUBTRACT
    • SYS_EXTRACT_UTC, NUMTODSINTERVAL, NUMTOYMINTER

  • 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 and PostgreSQL compatibility modes right from start

  • Support for NLS_LENGTH_SEMANTICS for VARCHAR2 and NVARCHAR2 types

  • Builtin Oraface package support

Contributors

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

  • @rasifr (Asif Rehman)
  • @BingAo-Office (Bing Ao)

Full Changelog: https://github.com/IvorySQL/IvorySQL/commits/Ivory_REL_1_0

Contributors

richaubin and rasifr
Assets 2
Loading