Skip to content

Releases: rasifr/IvorySQL_old

Initial Release of IvorySQL 1.0

10 Dec 12:31
@rasifr rasifr
Ivory_REL_1_0
f970d52

Choose a tag to compare

View all tags
Initial Release of IvorySQL 1.0 Latest
Latest

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