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 Wed, 06 Sep 2006 06:57:31 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-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||   ||
+ ||'''E081'''||'''Basic Privileges'''||<#FFFF00>Partial (10.2)||<#FFFF00>Partial
(10.2)||   ||
- ||E081-01||SELECT privilege at the table level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-01||SELECT privilege at the table level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
- ||E081-02||DELETE privilege||<#FF0000>Yes||<#FF0000>Yes||   ||
+ ||E081-02||DELETE privilege||<#00FF00>Yes (10.2)||<#00FF00>Yes (10.2)||   ||
- ||E081-03||INSERT privilege at the table level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-03||INSERT privilege at the table level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
- ||E081-04||UPDATE privilege at the table level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-04||UPDATE privilege at the table level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
- ||E081-05||UPDATE privilege at the column level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-05||UPDATE privilege at the column level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
- ||E081-06||REFERENCES privilege at the table level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-06||REFERENCES privilege at the table level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
- ||E081-07||REFERENCES privilege at the column level||<#FF0000>Yes||<#FF0000>Yes||
  ||
+ ||E081-07||REFERENCES privilege at the column level||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
  ||E081-08||WITH GRANT OPTION||<#FF0000>No||<#FF0000>No||   ||
  ||E081-09||USAGE privilege||<#FF0000>No||<#FF0000>No||   ||
- ||E081-10||EXECUTE privilege||<#FF0000>Yes||<#FF0000>Yes||   ||
+ ||E081-10||EXECUTE privilege||<#00FF00>Yes (10.2)||<#00FF00>Yes (10.2)||   ||
  ||'''E091'''||'''Set functions'''||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E091-01||AVG||<#00FF00>Yes||<#00FF00>Yes||   ||
  ||E091-02||COUNT||<#00FF00>Yes||<#00FF00>Yes||   ||
@@ -135, +135 @@

  ||'''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>Yes||<#FF0000>Yes||   ||
+ ||F031-03||GRANT statement||<#00FF00>Yes (10.2)||<#00FF00>Yes (10.2)||   ||
  ||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>Yes||<#FF0000>Yes|| 
 ||
+ ||F031-19||REVOKE statement: RESTRICT clause||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)||   ||
  ||'''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||   ||
@@ -177, +177 @@

  ||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>Yes||<#FF0000>Yes||   ||
+ ||F311-05||GRANT statement||<#00FF00>Yes (10.2)||<#00FF00>Yes (10.2)||   ||
  ||'''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||   ||
@@ -408, +408 @@

  ||T211-04||FOR EACH ROW triggers||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||T211-05||Ability to specify a search condition that shall be True before the trigger is
invoked.||<#FF0000>No||<#FF0000>No|| ||
  ||T211-06||Support for run-time rules for the interaction of triggers and constraints.||
|| || ||
- ||T211-07||TRIGGER privilege||<#FF0000>Yes||<#FF0000>Yes|| ||
+ ||T211-07||TRIGGER privilege||<#00FF00>Yes (10.2)||<#00FF00>Yes (10.2)|| ||
  ||T211-08||Multiple triggers for the same event are executed in the order in which they
were created in the catalog.||<#00FF00>Yes||<#00FF00>Yes||I think....||
  ||'''T212'''||'''Enhanced trigger capability'''|| || || ||
  ||'''T231'''||'''Sensitive cursors'''||<#FF0000>No||<#FF0000>No|| ||
@@ -417, +417 @@

  ||'''T261'''||'''Chained transactions'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T271'''||'''Savepoints'''||<#00FF00>Yes||<#00FF00>Yes|| ||
  ||'''T272'''||'''Enhanced savepoint management'''||N/A||<#FF0000>No|| ||
- ||'''T281'''||'''SELECT privilege with column granularity'''||<#FF0000>Yes||<#FF0000>Yes||
||
+ ||'''T281'''||'''SELECT privilege with column granularity'''||<#00FF00>Yes (10.2)||<#00FF00>Yes
(10.2)|| ||
  ||'''T301'''||'''Functional dependencies'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T312'''||'''OVERLAY function'''||<#FF0000>No||<#FF0000>No|| ||
  ||'''T322'''||'''Overloading of SQL-invoked functions and procedures'''|| || || ||

Mime
View raw message