----------------------------------------------------------------------

ELOQUENCE B.08.20 - patch PE82-1511170

----------------------------------------------------------------------

This patch enhances or fixes defects of the QUERY3K utility as
released with Eloquence B.08.20. This patch will be integrated
in the Eloquence B.08.20 release.

Eloquence B.08.20 must be installed before applying this patch.

Severity:
 PE82-1511170: BUG FIX

Superseded patches:
 none

For more information on QUERY3K, please refer to the Eloquence
web site
http://eloquence.marxmeier.com/support/B0810/doc/query3k/index.html


Patch PE82-1511170
------------------

Platforms: All

* Fixed a problem with searching on keyword indexes (FTS).
  Previous query3k versions did not support keyword indexes.

  A FIND ALL item where item is an FTS index failed with an IMAGE
  subsystem error.

  >FIND ALL SOMETHING
  BAD ITEM REFERENCE OR BAD LIST (SUBSYSTEM ERROR)

  This was caused by an undocumented feature where the query3k
  FIND ALL command calls a TPI DBFIND mode 100 on the index field
  to obtain the records in index order. However, FTS indexes may
  not be used with a TPI DBFIND mode 100.
  Query3k was changed to use sequential mode for a FIND ALL on
  FTS indexes.

  Searching FTS indexes could fail with arbitrary syntax errors
  as FTS searches must use a string argument that is terminated
  with a semicolon or NUL character.

  >FIND item=4000052
  Invalid search argument (syntax error) [-54:4]

  Searching on numeric FTS indexes failed with a systax error as
  query3k was converting the input into a binary format.

  >FIND price=123
  Invalid search argument (bad number) [-54:8]

  query3k was changed to use a string argument with FTS searches.

  Please note that FTS searches must use an equal condition.
  Any other condition must be specified in the search term.

  >FIND price=">123"

* The QUERY3K version number was changed to B.08.20.01 (20151117).


Installation:
-------------

Please download the patch archive that corresponds with the installed
release.  The patch files follow the conventions below:

   PE82-1511170-hpux-ia64.tar.gz
        ^       ^    ^
        |       |    Architecture / OS specific build
        |       Operating system
        Patch ID


HP-UX:

In order to install this patch, you need to unpack it with gzip and tar.
Gzip is included with HP-UX. Installation requires root privileges.

cd /opt/eloquence/8.2
gzip -dc /path/to/PE82-1511170-hpux.tar.gz | tar xf -

Files:

   bin/query3k
   share/doc/PE82-1511170-README


Linux:

In order to install this patch, you need to unpack it with tar.
Installation requires root privileges.

cd /opt/eloquence/8.2
tar xzf /path/to/PE82-1511170-linux.tar.gz

Files:

   bin/query3k
   share/doc/PE82-1511170-README


Windows:

Two options are available for patch installation. The patch is
available as self extracting archive for automatic installation
and as a zip archive for manual installation. Both patches are
equivalent. Installation requires administrative capabilities.

For automatic installation of this patch, please download the patch
file PE82-1511170-win32.exe. Installation does not require a reboot
unless the patched files were active.

For a manual installation of the patch, please download the patch
file PE82-1511170-win32.zip and unpack its contents. Then perform
the following steps:

* Please copy the query3k.exe file into the Eloquence bin directory.
  (Default location: C:\Program Files\Eloquence\8.2\bin)

* Please copy the PE82-1511170-README.txt file into the Eloquence
  share\doc directory.
  (Default location: C:\Program Files\Eloquence\8.2\share\doc)

Files:

   query3k.exe
   PE82-1511170-README.txt