db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "SQLvsDerbyFeatures" by DanDebrunner
Date Fri, 14 Oct 2005 16:26:44 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DanDebrunner:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

------------------------------------------------------------------------------
  ||E141-04||Basic FOREIGN KEY constraint with the NO ACTION default||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||E141-06||CHECK constraints||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E141-07||Column defaults||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E141-08||NOT NULL inferred on PRIMARY KEY||<#FF0000>No||<#FF0000>No||Implemented
from 10.1. [http://issues.apache.org/jira/browse/DERBY-158 Issue DERBY-158]  ||
+ ||E141-08||NOT NULL inferred on PRIMARY KEY||<#00FF00>Yes (10.1)||<#00FF00>Yes
(10.1)||Implemented from 10.1. [http://issues.apache.org/jira/browse/DERBY-158 Issue DERBY-158]
 ||
  ||E141-10||Names in a foreign key can be specified in any order||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||'''E151'''||'''Transaction support'''||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E151-01||COMMIT statement||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E151-02||ROLLBACK statement||<#00FF00>Yes||<#00FF00>Yes||   ||
+ ||E151-01||COMMIT statement||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC
Connection.commit, ij supports COMMIT statement||
+ ||E151-02||ROLLBACK statement||<#FFFF00>Sort of||<#FFFF00>Sort of||Through JDBC
Connection.rollback, ij supports ROLLBACK statement||
  ||'''E152'''||'''Basic SET TRANSACTION statement'''||<#FFFF00>Sort of.||<#FFFF00>Sort
of.||Se below.  ||
  ||E152-01||SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause||<#FFFF00>Sort
of||<#FFFF00>Sort of||SET [CURRENT] ISOLATION SERIALIZABLE. Connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE)
is according to JDBC specification.  ||
  ||E152-02||SET TRANSACTION statement: READ ONLY and READ WRITE clauses||<#FFFF00>Sort
of||<#FFFF00>Sort of||No SQL syntax. Connection.setReadWrite() is according to JDBC
specification.  ||

Mime
View raw message