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 BerntJohnsen
Date Tue, 08 Nov 2005 10:22:38 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 BerntJohnsen:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures

------------------------------------------------------------------------------
  ||'''F031'''||'''Basic schema manipulation'''||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F031-01||CREATE TABLE statement to create persistent base tables||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F031-02||CREATE VIEW statement||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||F031-03||GRANT statement||<#FF0000>No||<#FF0000>No||See http://issues.apache.org/jira/browse/DERBY-464||
+ ||F031-03||GRANT statement||<#FF0000>No||<#FF0000>No||See [http://issues.apache.org/jira/browse/DERBY-464
Issue DERBY-464]||
  ||F031-04||ALTER TABLE statement: ADD COLUMN clause||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F031-13||DROP TABLE statement: RESTRICT clause||<#00FF00>Yes (Implicit)||<#00FF00>Yes
(Implicit)||   ||
  ||F031-16||DROP VIEW statement: RESTRICT clause||<#00FF00>Yes (Implicit)||<#00FF00>Yes
(Implicit)||   ||
- ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>No||<#FF0000>No|| http://issues.apache.org/jira/browse/DERBY-464||
+ ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464
Issue DERBY-464]||
  ||'''F041'''||'''Basic joined tables'''||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||F041-01||Inner join (but not necessarily the INNER keyword)||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F041-02||INNER keyword||<#00FF00>Yes||<#00FF00>Yes||   ||
@@ -164, +164 @@

  ||F311-02||CREATE TABLE for persistent base tables||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||F311-03||CREATE VIEW||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||F311-04||CREATE VIEW: WITH CHECK OPTION||<#FF0000>No||<#FF0000>No||   ||
- ||F311-05||GRANT statement||<#FF0000>No||<#FF0000>No||http://issues.apache.org/jira/browse/DERBY-464||
+ ||F311-05||GRANT statement||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464
Issue DERBY-464]||
  ||'''F471'''||'''Scalar subquery values'''||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||'''F481'''||'''Expanded NULL predicate'''||<#00FF00>Yes||<#00FF00>Yes||  
||
  ||'''F501'''||'''Features and conformance views'''||<#FF0000>No||N/A||   ||
@@ -217, +217 @@

  ||B126||Routine language Pascal||N/A||<#FF0000>No|| ||
  ||B127||Routine language PL/I||N/A||<#FF0000>No|| ||
  ||B128||Routine language SQL||N/A||<#FF0000>No|| ||
- ||F032||CASCADE drop behavior|| || || ||
+ ||F032||CASCADE drop behavior||<#FF0000>No||<#FF0000>No|| ||
  ||F033||ALTER TABLE statement: DROP COLUMN clause||<#FF0000>No||<#FF0000>No||
||
- ||F034||Extended REVOKE statement||<#FF0000>No||<#FF0000>No||http://issues.apache.org/jira/browse/DERBY-464||
+ ||F034||Extended REVOKE statement||<#FF0000>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464
Issue DERBY-464]||
  ||F034-01||REVOKE statement performed by other than the owner of a schema object||<#FF0000>No||<#FF0000>No||
||
  ||F034-02||REVOKE statement: GRANT OPTION FOR clause ||<#FF0000>No||<#FF0000>No||
||
  ||F034-03||REVOKE statement to revoke a privilege that the grantee has WITH GRANT OPTION||<#FF0000>No||<#FF0000>No||
||
  ||F052||Intervals and datetime arithmetic|| || || ||
- ||F053||OVERLAPS predicate||N/A|| || ||
+ ||F053||OVERLAPS predicate||N/A||<#FF0000>No|| ||
  ||F111||Isolation levels other than SERIALIZABLE||<#00FF00>Yes||<#00FF00>Yes||
||
  ||F111-01||READ UNCOMMITTED isolation level||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||F111-02||READ COMMITTED isolation level||<#00FF00>Yes||<#00FF00>Yes|| ||

Mime
View raw message