X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fappendix.xml;h=ad2f4ef8961a2e7f48dca30f8f0663a58fe5c8a3;hb=f7a356bb4c11d062eeeb5d4aaf4e187a3cb15a27;hp=2e63360a121d729a3c168c53c8b5b851e46d06ef;hpb=2ff7a0762e0f1d4b1622e4edd7b00995c7652945;p=clsql.git
diff --git a/doc/appendix.xml b/doc/appendix.xml
index 2e63360..ad2f4ef 100644
--- a/doc/appendix.xml
+++ b/doc/appendix.xml
@@ -102,6 +102,9 @@
+ Notes
+ None.
+
@@ -203,6 +206,9 @@
+ Notes
+ None.
+
@@ -274,8 +280,85 @@
+ Notes
+ FDDL
+
+
+
+ drop-index
+ requires a table to be specified with the
+ :on keyword parameter.
+
+
+
+
+ views are not
+ supported by &mysql;.
+
+
+
+
+ The :transactions keyword argument to
+ create-table
+ controls whether or not the created table is an InnoDB
+ table which supports transactions.
+
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+ FDML
+
+
+
+ Prior to version 4.1, &mysql; does not support nested
+ subqueries in calls to select.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &mysql; does not support the ||
+ concatenation operator. Use concat
+ instead.
+
+
+
+
+ &mysql; does not support the substr
+ operator. Use substring instead.
+
+
+
+
+ &mysql; does not support the
+ intersect and
+ except set operations.
+
+
+
+
+ &mysql; (version 4.0 and later) does not support string
+ table aliases unless the server is started with
+ ANSI_QUOTES enabled.
+
+
+
+
+
-
+
&odbc;
@@ -337,6 +420,18 @@
+ Notes
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+
@@ -393,6 +488,11 @@
+ Notes
+
+ None.
+
+
@@ -432,6 +532,55 @@
+ Notes
+ Connection
+
+
+
+ Passing filename a value of
+ :memory: will create a database in
+ physical memory instead of using a file on disk.
+
+
+
+
+ Some operations will be many times faster if database
+ integrity checking is disabled by setting the SYNCHRONOUS
+ flag to OFF (see the SQLITE manual for details).
+
+
+
+
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+ The :column-list keyword argument to
+ create-view
+ is not supported by &sqlite;.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &sqlite; does not support the all,
+ some, any and
+ exists subquery operations.
+
+
+
+
+
@@ -470,7 +619,7 @@
global-name
- String representing the global name of the Orace database.
+ String representing the global name of the Oracle database.
This is looked up through the tnsnames.ora file.
@@ -491,6 +640,44 @@
+ Notes
+ Symbolic SQL Syntax
+
+
+
+ The userenv operator is &oracle; specific.
+
+
+
+
+ &oracle; does not support the except
+ operator. Use minus instead.
+
+
+
+
+ &oracle; does not support the all,
+ some, any
+ subquery operations.
+
+
+
+
+ Transactions
+
+
+
+ By default, &clsql; starts in transaction AUTOCOMMIT mode
+ (see set-autocommit).
+ To begin a transaction in autocommit mode, start-transaction
+ has to be called explicitly.
+
+
+
+
+