Changes for zSQLgate, version 1.05

Changes between versions 1.03 [sic] and 1.05 (Sat Jun 14 03:01:44 BST 2014):

• Books example expanded to use three-level inner join, using correct configuration syntax with each auxiliary table specified separately.
• Restructure directories.
• Revert to using implicit join unless explicitly requested to do so. New per-database configuration-file directive join="outer" will cause left outer joins to be used, as was the default in 1.03.
• Access-point specifiers may take an uppercase modifier as well as or instead of fulltext. When present, terms used in searches against that access point are mapped to upper-case. This can be used to simulate case-blind searching in dumb RDBMSs such as Oracle that don't support it out of the box, so long as that database schema includes an all-uppercase version of the field to be searched.
• Better quoting of search terms in the generated SQL, so that embedded apostrophes don't break things.
• Only apply defaultattrs when no attributes are explicitly provided.
• Add -n command-line option (and corresponding DBIServer constructor) to invoke no-op mode, in which the backend database is never connected to, and dummy responses are provided.
• Hashes in the configuration file do not introduce comments if immediately preceded by a backslash, but become simple hashes. This provides a means of embedded hashes in strings.
• Add fulltext support for Oracle, using CONTAINS.
• NOTE INCOMPATIBLE CHANGE: fulltext searching is now used only when attribute 3=3 (position=any position in field) is supplied.
• Add make-pdf.sh to generate zSQLgate-manual.pdf
• New configuraton-file directive: option NAME = VALUE", can be used so set for example option "mysql_enable_utf8" = 1

Feedback to <mike@sql.z3950.org> is welcome!