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 2006/09/06 07:31:10 UTC
[Db-derby Wiki] Update of "SQLvsDerbyFeatures" by MamtaSatoor
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 MamtaSatoor:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
------------------------------------------------------------------------------
||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-01||SELECT privilege at the table level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-01||SELECT privilege at the table level||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-02||DELETE privilege||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-02||DELETE privilege||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-03||INSERT privilege at the table level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-03||INSERT privilege at the table level||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-04||UPDATE privilege at the table level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-04||UPDATE privilege at the table level||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-05||UPDATE privilege at the column level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-05||UPDATE privilege at the column level||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-06||REFERENCES privilege at the table level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-06||REFERENCES privilege at the table level||<#FF0000>Yes||<#FF0000>Yes|| ||
- ||E081-07||REFERENCES privilege at the column level||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-07||REFERENCES privilege at the column level||<#FF0000>Yes||<#FF0000>Yes|| ||
||E081-08||WITH GRANT OPTION||<#FF0000>No||<#FF0000>No|| ||
||E081-09||USAGE privilege||<#FF0000>No||<#FF0000>No|| ||
- ||E081-10||EXECUTE privilege||<#FF0000>No||<#FF0000>No|| ||
+ ||E081-10||EXECUTE privilege||<#FF0000>Yes||<#FF0000>Yes|| ||
||'''E091'''||'''Set functions'''||<#00FF00>Yes||<#00FF00>Yes|| ||
||E091-01||AVG||<#00FF00>Yes||<#00FF00>Yes|| ||
||E091-02||COUNT||<#00FF00>Yes||<#00FF00>Yes|| ||