db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1602449 - /db/derby/docs/trunk/src/ref/rrefsql9241891.dita
Date Fri, 13 Jun 2014 14:49:05 GMT
Author: chaase3
Date: Fri Jun 13 14:49:04 2014
New Revision: 1602449

URL: http://svn.apache.org/r1602449
Log:
DERBY-6605  "Derby support for SQL-92 features" topic in Reference Manual needs updating

Modified 1 Reference Manual topic.

Patch: DERBY-6605-2.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefsql9241891.dita

Modified: db/derby/docs/trunk/src/ref/rrefsql9241891.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsql9241891.dita?rev=1602449&r1=1602448&r2=1602449&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsql9241891.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsql9241891.dita Fri Jun 13 14:49:04 2014
@@ -18,13 +18,17 @@ See the License for the specific languag
 limitations under the License.
 -->
 <reference id="rrefsql9241891" xml:lang="en-us">
-<title>Derby support for SQL-92 features </title>
+<title><ph conref="../conrefs.dita#prod/productshortname"></ph> support
for
+SQL-92 features </title>
+<shortdesc>There are four levels of SQL-92 support.</shortdesc>
 <prolog><metadata>
-<keywords><indexterm>SQL-92<indexterm>features supported by Derby</indexterm><indexterm>features
-not supported by Derby</indexterm></indexterm></keywords>
+<keywords>
+<indexterm>SQL-92<indexterm>features supported by Derby</indexterm></indexterm>
+<indexterm>SQL-92<indexterm>features not supported by Derby</indexterm></indexterm>
+</keywords>
 </metadata></prolog>
 <refbody>
-<section><p> There are four levels of SQL-92 support:   <ul>
+<section><p> <ul>
 <li>SQL92E   <p>Entry</p></li>
 <li>SQL92T   <p>Transitional, a level defined by NIST in a publication called
 FIPS 127-2</p></li>
@@ -244,8 +248,8 @@ FIPS 127-2</p></li>
 </tgroup>
 </table>
 <table>
-<title>Support for SQL-92 features: constraints (non-deferrable)</title>
-<desc>This table shows Derby support for SQL-92 constraints (non-deferrable).</desc>
+<title>Support for SQL-92 features: Constraints</title>
+<desc>This table shows Derby support for SQL-92 constraints.</desc>
 <tgroup cols="3" colsep="1" rowsep="1">
 <colspec colname="col1" colnum="1" colwidth="40*"/>
 <colspec colname="col2" colnum="2" colwidth="30*"/>
@@ -283,6 +287,12 @@ FIPS 127-2</p></li>
 <entry colname="col2">SQL92E</entry>
 <entry colname="col3">No, views cannot be updated</entry>
 </row>
+<row>
+<entry colname="col1">Deferrable constraints</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Partial (deferrable NOT NULL constraints are not
+supported)</entry>
+</row>
 </tbody>
 </tgroup>
 </table>
@@ -450,9 +460,9 @@ cursor</entry>
 <entry colname="col3">Yes</entry>
 </row>
 <row>
-<entry colname="col1">natural join</entry>
+<entry colname="col1">NATURAL JOIN</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">No</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">LEFT, RIGHT OUTER JOIN</entry>
@@ -469,6 +479,11 @@ cursor</entry>
 <entry colname="col2">SQL92T</entry>
 <entry colname="col3">Yes</entry>
 </row>
+<row>
+<entry colname="col1">CROSS JOIN</entry>
+<entry colname="col2">SQL92F</entry>
+<entry colname="col3">Yes</entry>
+</row>
 </tbody>
 </tgroup>
 </table>
@@ -500,7 +515,8 @@ cursor</entry>
 <row>
 <entry colname="col1">datetime math</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">Yes, with Java methods</entry>
+<entry colname="col3">No, but see <xref href="rrefjdbc88908.dita"/> for JDBC
+escape functions that implement datetime math</entry>
 </row>
 <row>
 <entry colname="col1">datetime comparisons</entry>
@@ -510,7 +526,7 @@ cursor</entry>
 <row>
 <entry colname="col1">predicates: OVERLAPS</entry>
 <entry colname="col2">SQL92T</entry>
-<entry colname="col3">Yes, with Java methods</entry>
+<entry colname="col3">No</entry>
 </row>
 </tbody>
 </tgroup>
@@ -996,7 +1012,7 @@ cursor</entry>
 <row>
 <entry colname="col1">CASE expression</entry>
 <entry colname="col2">SQL92I</entry>
-<entry colname="col3">Partial support</entry>
+<entry colname="col3">Yes</entry>
 </row>
 <row>
 <entry colname="col1">Compound character string constants</entry>
@@ -1058,7 +1074,7 @@ tables</entry>
 <entry colname="col1">Scrolled cursors</entry>
 <entry colname="col2">SQL92I</entry>
 <entry colname="col3">Partial support (scrollable insensitive result sets
-through JDBC 2.0)</entry>
+through JDBC)</entry>
 </row>
 <row>
 <entry colname="col1">Intermediate set function support</entry>
@@ -1183,7 +1199,7 @@ through JDBC 2.0)</entry>
 <row>
 <entry colname="col1">ALTER domain</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">nNo</entry>
+<entry colname="col3">No</entry>
 </row>
 <row>
 <entry colname="col1">INSERT column privileges</entry>
@@ -1218,7 +1234,7 @@ through JDBC 2.0)</entry>
 <row>
 <entry colname="col1">Insensitive cursors</entry>
 <entry colname="col2">SQL92F</entry>
-<entry colname="col3">Yes through JDBC 2.0</entry>
+<entry colname="col3">Yes (through JDBC)</entry>
 </row>
 <row>
 <entry colname="col1">Full set function</entry>



Mime
View raw message