---------------------------------------------------------------------- ELOQUENCE B.08.20 - patch PE82-1707310 ---------------------------------------------------------------------- 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-1707310: BUG FIX Superseded patches: PE82-1707270: BUG FIX PE82-1511170: BUG FIX For more information on QUERY3K, please refer to the Eloquence web site http://eloquence.marxmeier.com/support/B0810/doc/query3k/index.html Patch PE82-1707310 ------------------ Platforms: All * Fixed query3k limitations accessing tables with a size of more than 2 billion records. * Fixed a problem evaluating boolean operators when searching on a keyword index (FTS). * The QUERY3K version number was changed to B.08.20.04 (20170731). 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-1707310-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-1707310-hpux.tar.gz | tar xf - Files: bin/query3k lib/nls/C/QSMSG000.cat share/doc/PE82-1707310-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-1707310-linux.tar.gz Files: bin/query3k lib/nls/C/QSMSG000.cat share/doc/PE82-1707310-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-1707310-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-1707310-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 QSMSG000.cat file into the Eloquence lib\nls directory. (Default location: C:\Program Files\Eloquence\8.2\lib\nls) * Please copy the PE82-1707310-README.txt file into the Eloquence share\doc directory. (Default location: C:\Program Files\Eloquence\8.2\share\doc) Files: query3k.exe QSMSG000.cat PE82-1707310-README.txt