You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2005/10/14 18:26:44 UTC
[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by DanDebrunner
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. ||