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 Fri, 18 Nov 2011 10:35:42 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:
http://wiki.apache.org/db-derby/SQLvsDerbyFeatures?action=diff&rev1=61&rev2=62

  ||'''T173'''||'''Extended LIKE clause in table definition'''||N/A||<#FF0000>No|| ||
  ||'''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||<#FF0000>No || ||
- ||'''T176'''||'''Sequence generator support'''||N/A||<#FF0000>No || ||
+ ||'''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'''|| || || ||
  ||'''T201'''||'''Comparable data types for referential constraints'''|| || || ||
  ||'''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||

Mime
View raw message