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 KnutAndersHatlen
Date Mon, 16 Jun 2014 13:44:07 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "SQLvsDerbyFeatures" page has been changed by KnutAndersHatlen:
https://wiki.apache.org/db-derby/SQLvsDerbyFeatures?action=diff&rev1=75&rev2=76

  ||F231-02 ||COLUMN_PRIVILEGES view ||<#FF0000>No ||<#FF0000>No || ||
  ||F231-03 ||USAGE_PRIVILEGES view ||<#FF0000>No ||<#FF0000>No || ||
  ||'''F251''' ||'''Domain support''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F262''' ||'''Extended CASE expression''' ||N/A || <#00FF00>Yes || From 10.11
||
+ ||'''F262''' ||'''Extended CASE expression''' ||N/A ||<#00FF00>Yes || From 10.11 ||
  ||'''F271''' ||'''Compound character literals''' ||<#FF0000>No ||<#FF0000>No
|| ||
  ||'''F281''' ||'''LIKE enhancements''' ||<#00FF00>Yes (10.3) ||<#00FF00>Yes
(10.3) ||In earlier versions (10-0 - 10.2): The <escape character> had to be a <value
specification> ||
  ||'''F291''' ||'''UNIQUE predicate''' ||<#FF0000>No ||<#FF0000>No || ||
@@ -305, +305 @@

  ||'''F641''' ||'''Row and table constructors''' ||<#00FF00>Yes ||<#00FF00>Yes
|| ||
  ||'''F651''' ||'''Catalog name qualifiers''' ||<#FF0000>No ||<#FF0000>No ||
||
  ||'''F661''' ||'''Simple tables''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F671''' ||'''Subqueries in CHECK''' || <#FF0000>No || <#FF0000>No || ||
+ ||'''F671''' ||'''Subqueries in CHECK''' ||<#FF0000>No ||<#FF0000>No || ||
- ||'''F672''' ||'''Retrospective check constraints''' ||N/A || <#FF0000>No || ||
+ ||'''F672''' ||'''Retrospective check constraints''' ||N/A ||<#FF0000>No || ||
  ||'''F691''' ||'''Collation and translation''' ||<#FFFF00>Partial ||<#FFFF00>Partial
||DERBY-1478 Starting Derby 10.3, user can create a database with territory based collation
||
  ||'''F692''' ||'''Enhanced collation support''' ||N/A ||<#FF0000>No || ||
  ||'''F693''' ||'''SQL-session and client module collations''' ||N/A ||<#FF0000>No
|| ||
@@ -399, +399 @@

  ||'''T174''' ||'''Identity columns''' ||N/A ||<#FFFF00>Yes* ||MAXVALUE and CYCLE not
supported. Deviation from standard: A comma (",") is required before INCREMENT. ||
  ||'''T175''' ||'''Generated columns''' ||N/A ||<#00FF00>Yes ||Since 10.5 ||
  ||'''T176''' ||'''Sequence generator support''' ||N/A ||<#FFFF00>Yes* ||ALTER SEQUENCE
not supported. Only one NEXT VALUE FOR clause per sequence in each statement ([[https://issues.apache.org/jira/browse/DERBY-4513|DERBY-4513]]).
||
- ||'''T191''' ||'''Referential action RESTRICT''' || <#00FF00>Yes || <#00FF00>Yes
|| ||
+ ||'''T191''' ||'''Referential action RESTRICT''' ||<#00FF00>Yes ||<#00FF00>Yes
|| ||
- ||'''T201''' ||'''Comparable data types for referential constraints''' || <#FF0000>No
|| <#FF0000>No || ||
+ ||'''T201''' ||'''Comparable data types for referential constraints''' ||<#FF0000>No
||<#FF0000>No || ||
  ||'''T211''' ||'''Basic trigger capability''' ||<#FFFF00>Yes* ||<#FFFF00>Yes*
||10.2 and earlier: Need to specify non standard MODE DB2SQL (see [[http://issues.apache.org/jira/browse/DERBY-1770|DERBY-1770]]).
Also, the REFERENCING part is not quite compliant. The optional ROW keyword is not allowed,
and NEW TABLE/OLD TABLE must be written NEW_TABLE/OLD_TABLE ||
  ||T211-01 ||Triggers activated on UPDATE, INSERT, or DELETE of one base table. ||<#00FF00>Yes
||<#00FF00>Yes || ||
  ||T211-02 ||BEFORE triggers ||<#FFFF00>Yes* ||<#FFFF00>Yes* ||Need to specify
non-standard ON CASCADE BEFORE. Before triggers cannot have INSERT, UPDATE or DELETE statements
as their action. ||

Mime
View raw message