X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=doc%2Fappendix.xml;h=c8ce4bb3e0b85ca44a4ee444dcc8baac741a0bd0;hp=2e63360a121d729a3c168c53c8b5b851e46d06ef;hb=55f590bf6f5298e59aae30f02c958388f483da02;hpb=aee3ea30595ebee301ccb1532062053c3c580e19
diff --git a/doc/appendix.xml b/doc/appendix.xml
index 2e63360..c8ce4bb 100644
--- a/doc/appendix.xml
+++ b/doc/appendix.xml
@@ -102,6 +102,9 @@
+ Notes
+ None.
+
@@ -203,6 +206,9 @@
+ Notes
+ None.
+
@@ -234,7 +240,7 @@
Connection SpecificationSyntax of connection-spec
- (hostdbuserpassword)
+ (hostdbuserpassword &optional port)Description of connection-spec
@@ -271,11 +277,95 @@
field.
+
+ port
+
+ String representing the port to use for
+ communication with the MySQL server.
+
+
+ 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 +427,18 @@
+ Notes
+ FDDL
+
+
+
+ The :owner keyword argument to the FDDL functions
+ for listing and testing for database objects is ignored.
+
+
+
+
+
@@ -393,6 +495,11 @@
+ Notes
+
+ None.
+
+
@@ -432,6 +539,167 @@
+ 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.
+
+
+
+
+
+
+
+
+ &sqlite3;
+
+ LibrariesThe &sqlite3; back-end requires
+ the &sqlite3; shared library file. Its default file name is
+ /usr/lib/libsqlite3.so.
+
+
+ Initialization
+
+ Use
+
+(asdf:operate 'asdf:load-op 'clsql-sqlite3)
+
+ to load the &sqlite3; back-end. The database type for the &sqlite3;
+ back-end is :sqlite3.
+
+
+
+ Connection Specification
+
+ Syntax of connection-spec
+ (filename &optional init-function)
+
+
+ Description of connection-spec
+
+
+ filename
+
+ String representing the filename of the &sqlite3;
+ database file.
+
+
+
+ init-function
+
+
+ A function designator.
+ init-function takes a
+ single argument of type
+ sqlite3:sqlite3-db, a foreign pointer to
+ the C descriptor of the newly opened database.
+ init-function is called by
+ the back-end immediately after &sqlite3;
+ sqlite3_open library function,
+ and can be used to perform optional database
+ initializations by calling foreign functions in the
+ &sqlite3; library.
+
+
+ An example of an initialization function which
+ defines a new collating sequence for text columns is
+ provided in
+ ./examples/sqlite3/init-func/.
+
+
+
+
+
+
+ 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 &sqlite3;.
+
+
+
+
+ Symbolic SQL Syntax
+
+
+
+ &sqlite3; does not support the all,
+ some, any and
+ exists subquery operations.
+
+
+
+
+
@@ -442,9 +710,23 @@
library. (libclntsh.so). The location of
this library is specified relative to the
ORACLE_HOME value in the operating system
- environment. &clsql; has tested sucessfully using the client
- library from Oracle 9i and Oracle 10g server installations as
- well as Oracle's 10g Instant Client library.
+ environment.
+
+
+
+ Library Versions
+
+ &clsql; has tested sucessfully using the client library from
+ Oracle 9i and Oracle 10g server installations as well as
+ Oracle's 10g Instant Client library. For Oracle 8 and earlier
+ versions, there is vestigial support by pushing the symbol
+ :oci7 onto cl:*features*
+ prior to loading the clsql-oracle &asdf;
+ system.
+
+ (push :oci7 cl:*features*)
+ (asdf:operate 'asdf:load-op 'clsql-oracle)
+
@@ -470,7 +752,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 +773,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.
+
+
+
+
+