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 Mon, 07 Nov 2005 14:53:11 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

------------------------------------------------------------------------------
  ||'''E071'''||'''Basic query expressions'''||<#00FF00>Yes||<#00FF00>Yes||  
||
  ||E071-01||UNION DISTINCT table operator||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E071-02||UNION ALL table operator||<#00FF00>Yes||<#00FF00>Yes||   ||
- ||E071-03||EXCEPT DISTINCT table operator||<#FF0000>No||<#FF0000>No||From 10.1
 ||
+ ||E071-03||EXCEPT DISTINCT table operator||<#00FF00>Yes (10.1)||<#00FF00>Yes
(10.1)||From 10.1  ||
  ||E071-05||Columns combined via table operators need not have exactly the same data type||<#00FF00>Yes||<#00FF00>Yes||
  ||
  ||E071-06||Table operators in subqueries||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||'''E081'''||'''Basic Privileges'''||<#FF0000>No||<#FF0000>No||   ||
@@ -122, +122 @@

  ||'''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||   ||
+ ||F031-03||GRANT statement||<#FF0000>No||<#FF0000>No||See http://issues.apache.org/jira/browse/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||   ||
+ ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>No||<#FF0000>No|| http://issues.apache.org/jira/browse/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||   ||
+ ||F311-05||GRANT statement||<#FF0000>No||<#FF0000>No||http://issues.apache.org/jira/browse/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||   ||
@@ -218, +218 @@

  ||B127||Routine language PL/I||N/A||<#FF0000>No|| ||
  ||B128||Routine language SQL||N/A||<#FF0000>No|| ||
  ||F032||CASCADE drop behavior|| || || ||
- ||F033||ALTER TABLE statement: DROP COLUMN clause|| || || ||
+ ||F033||ALTER TABLE statement: DROP COLUMN clause||<#FF0000>No||<#FF0000>No||
||
- ||F034||Extended REVOKE statement|| || || ||
+ ||F034||Extended REVOKE statement||<#FF0000>No||<#FF0000>No||http://issues.apache.org/jira/browse/DERBY-464||
- ||F034-01||REVOKE statement performed by other than the owner of a schema object|| || ||
||
+ ||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 || || || ||
+ ||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||
|| || ||
+ ||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|| || ||
  ||F111||Isolation levels other than SERIALIZABLE||<#00FF00>Yes||<#00FF00>Yes||
||

Mime
View raw message