The following, as expected, produces an error in all versions:
However, the above runs without error in Oracle and the SQL standard suggests that non-deferrable uniqueness constraints should be checked only at the end of the statement. PostgreSQL, MySQL, Firebird all behave as MariaDB does. DB2 behaves as Oracle does. Should this be changed for Oracle mode?