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
------------------------------------------------------------------------------
||'''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
Issue DERBY-464]||
+ ||F031-03||GRANT statement||<#FF0000>Yes||<#FF0000>Yes|| ||
||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
Issue DERBY-464]||
+ ||F031-19||REVOKE statement: RESTRICT clause||<#FF0000>Yes||<#FF0000>Yes||
||
||'''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>No||<#FF0000>No||[http://issues.apache.org/jira/browse/DERBY-464
Issue DERBY-464]||
+ ||F311-05||GRANT statement||<#FF0000>Yes||<#FF0000>Yes|| ||
||'''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|| ||
|